Spreadsheet: louise_kitchen__22589__0401 Capital Book  entries
Sheet: PGE upload

Fields Required | Required | Invoice [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
DO NOT add or delete columns | TCODE | BLDAT | BLART | BUKRS | BUDAT | MONAT | WAERS | KURSF | BELNR | WWERT | XBLNR | BVORG | BKTXT | PARGB | AUGLV | VBUND | XMWST | DOCID | BARCD | STODT | BRNCH | NUMPG | SENDE | STYPE | TBNAM | [NAME] | DUMMY | NEWUM | NEWBK | WRBTR | DMBTR | WMWST | MWSTS | MWSKZ | XSKRL | FWZUZ | [NAME] | GSBER | KOSTL | DUMMY4 | AUFNR | EBELN | EBELP | PROJN | MATNR | [NAME] | MENGE | [NAME] | [NAME] | POSN2 | ETEN2 | PERNR | BEWAR | VALUT | ZFBDT | [NAME] | [NAME] | FKONT | XAABG | [NAME] | BLNKZ | BLNBT | BLNPZ | MABER | [NAME] | WSKTO | ZTERM | [NAME] | [NAME] | ZBD2T | ZBD2P | ZBD3T | [NAME] | REBZG | [NAME] | REBZZ | ZLSCH | SAMNR | ZBFIX | QSSKZ | QSSHB | QSFBT | ESRNR | ESRPZ | ESRRE | FDTAG | FDLEV | ANLN1 | ANLN2 | BZDAT | ANBWA | ABPER | GBETR | KURSR | MANSP | MSCHL | HBKID | BVTYP | ANFBN | ANFBU | ANFBJ | LZBKZ | LANDL | DIEKZ | ZOLLD | ZOLLT | VRSDT | VRSKZ | HZUON | REGUL | NAME1 | [NAME] | NAME3 | NAME4 | STRAS | ORT01 | PSTLZ | LAND1 | REGIO | BANKL | BANKS | BANKN | [NAME] | STCD1 | STCD2 | MADAT | MANST | EGMLD | DUMMY2 | STCEG | STKZA | STKZU | PFACH | PSTL2 | SPRAS | XINVE | NEWKO | NEWBW | KNRZE | HKONT | PRCTR | VERTN | VERTT | VBEWA | HWBAS | FWBAS | FIPOS | VNAME | EGRUP | BTYPE | PAOBJNR | KSTRG | IMKEY | DUMMY3 | VPTNR | NPLNR | VORNR | XEGDR | RECID | PPRCT | PROJK | UZAWE | TXJCD | FISTL | GEBER | DMBE2 | DMBE3 | PARGB | XREF1 | XREF2 | KBLNR | KBLPOS | WDATE | WGBKZ | XAKTZ | WNAME | WORT1 | WBZOG | WORT2 | WBANK | WLZBP | DISKP | DISKT | WINFW | WINHW | WEVWV | WSTAT | WMWKZ | WSTKZ | [NAME] | RKE_BONUS | RKE_BRSCH | RKE_BUKRS | RKE_BZIRK | RKE_EFORM | RKE_FKART | RKE_GEBIE | RKE_GSBER | RKE_KAUFN | RKE_KDGRP | RKE_KDPOS | RKE_KNDNR | [NAME] | RKE_KSTRG | RKE_LAND1 | RKE_MAABC | RKE_MATKL | RKE_PRCTR | [NAME] | RKE_RKAUFNR | RKE_SPART | RKE_VKBUR | RKE_VKGRP | RKE_VKORG | RKE_VTWEG | RKE_WERKS | VBUND | FKBER
Record type Header = 1 Details = 2 | Transaction code | Document  Date | Document  type | Company Code | Posting Date | Posting Period | Currency | Exchange Rate | Document Number | Translation date | Reference | Cross-co. code no. | Document Header Text | Trading partner | Clearing procedure | Trading partner | Calculate tax | Doc. type | Archive doc. ID | Date | Branch no. | Number of Pages | Record end indicator | Record Type | Table name | Posting Key | Account | Special G/L indicator | New company code | Amount | Amount loc.curr. | Tax amount | LC tax amount | Tax code | W/o cash disc. | Add. tax | Add. tax in LC | Bus. area | Cost center | Controlling area | Internal order |  |  |  | Material | Plant | Quantity | Base unit of measure | Sales document | Sales document item | Schedule line | Personnel Number | Transact. type | Date | Bline Date | Interest block | Allocation | Financial budget | Asst retirement | Text | Subsidy indic. | Preference amount | Pref.percentage rate | Dunning area | Discount base | Cash discount amount | Payment terms | Days | Cash discount rate 1 | Days | Cash discount rate 2 | Days | Payment block | Invoice reference | Fiscal year | Item | Payment method | Collective invoice | Fixed | Withholding tax code | Withhold.tax base | Wthld.tax-exempt amt | PBC/POR number | Check digit | POR reference number | Date | Planning level | Asset | Sub-number |  |  | Settlement period (batch input field) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Profit Center |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WBS Project account assignment (PS_PSP_PNR batch input field) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Company ID of trading partner | Functional Area
1 | FBV1 | 20010504 | SA | 0364 | 20010430 | 4 | USD |  |  |  |  |  | Capital Book
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 42000000 |  |  | 169459 |  |  |  |  |  |  |  |  |  |  | 700003697 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Michigan Cons V48817 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11803
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 25100300 |  |  | 169459 |  |  |  |  |  |  |  |  |  |  | 700003697 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Michigan Cons V48817 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27115
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | 42000000 |  |  | 289118 |  |  |  |  |  |  |  |  |  |  | 700003697 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NUI Corp V09140 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11847
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 25100300 |  |  | 289118 |  |  |  |  |  |  |  |  |  |  | 700003697 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NUI Corp V09140 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27115