| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | PSOKPF | MANDT | Allow NULL? |
| 2 | LOTKZ | Lot Number for Documents | nvarchar | 10 | 0 | CHAR | (N' ') | No | | LOTKZ | Allow NULL? |
| 3 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 4 | ITABKEY | Internal key of internal table | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | FM_ITABKEY | Allow NULL? |
| 5 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 6 | BZKEY | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 7 | AUSBK | Source Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | AUSBK | Allow NULL? |
| 8 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 9 | BSCHL | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BSCHL | Allow NULL? |
| 10 | UMSKZ | Special G/L Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | UMSKZ | Allow NULL? |
| 11 | UMSKS | Special G/L Transaction Type | char | 1 | 0 | CHAR | (N' ') | Yes | | UMSKS | Allow NULL? |
| 12 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 13 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 14 | PARGB | Trading partner's business area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PARGB | Allow NULL? |
| 15 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 16 | DMBTR | Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBTR | |
| 17 | DMBE2 | Amount in Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE2 | |
| 18 | DMBE3 | Amount in Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE3 | |
| 19 | WRBTR | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 20 | HWMET | Method with Which the Local Currency Amount Was Determined | char | 1 | 0 | CHAR | (N' ') | Yes | | HWMET | Allow NULL? |
| 21 | MWSTS | Tax Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MWSTS | |
| 22 | MWST2 | Tax Amount in Second Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MWST2 | |
| 23 | MWST3 | Tax Amount in Third Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | MWST3 | |
| 24 | WMWST | Tax amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WMWST | |
| 25 | HWBAS | Tax Base Amount in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | HWBAS | |
| 26 | FWBAS | Tax Base Amount in Document Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | FWBAS | |
| 27 | MWART | Tax Type | char | 1 | 0 | CHAR | (N' ') | Yes | | MWART | Allow NULL? |
| 28 | QSSKZ | Withholding Tax Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | QSSKZ | Allow NULL? |
| 29 | QSSHB | Withholding Tax Base Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | QSSHB | |
| 30 | QSZNR | Certificate Number of the Withholding Tax Exemption | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | QSZNR | Allow NULL? |
| 31 | QBSHB | Withholding Tax Amount (in Document Currency) | decimal | 13 | 2 | CURR | ((0)) | Yes | | QBSHB | |
| 32 | QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | decimal | 13 | 2 | CURR | ((0)) | Yes | | QSFBT | |
| 33 | KURSR | Hedged Exchange Rate | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSR | |
| 34 | GBETR | Hedged Amount in Foreign Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | GBETR | |
| 35 | VALUT | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALUT | Allow NULL? |
| 36 | ZUONR | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 37 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 38 | ZINKZ | Exempted from interest calculation | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DZINKZ | Allow NULL? |
| 39 | FDLEV | Planning level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FDLEV | Allow NULL? |
| 40 | FDGRP | Planning Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FDGRP | Allow NULL? |
| 41 | FDWBT | Planning amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | FDWBT | |
| 42 | FDTAG | Planning date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FDTAG | Allow NULL? |
| 43 | GEBER | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | BP_GEBER | Allow NULL? |
| 44 | FISTL | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 45 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | JV_NAME | Allow NULL? |
| 46 | EGRUP | Equity group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | JV_EGROUP | Allow NULL? |
| 47 | BTYPE | Payroll Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | JV_BILIND | Allow NULL? |
| 48 | XUMSW | Indicator: Sales-related item ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XUMSW | Allow NULL? |
| 49 | XCPDD | Indicator: Address and bank data set individually | char | 1 | 0 | CHAR | (N' ') | Yes | | XCPDD | Allow NULL? |
| 50 | XZEMP | Indicator: Alternative payee in document allowed ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XZEMP | Allow NULL? |
| 51 | XINVE | Indicator: Capital Goods Affected? | char | 1 | 0 | CHAR | (N' ') | Yes | | XINVE | Allow NULL? |
| 52 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 53 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LIFNR | Allow NULL? |
| 54 | FILKD | Account Number of the Branch | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FILKD | Allow NULL? |
| 55 | HZUON | Assignment Number for Special G/L Accounts | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | HZUON | Allow NULL? |
| 56 | ZFBDT | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZFBDT | Allow NULL? |
| 57 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 58 | ZBD1T | Cash discount days 1 | decimal | 3 | 0 | DEC | ((0)) | Yes | | DZBD1T | |
| 59 | ZBD2T | Cash discount days 2 | decimal | 3 | 0 | DEC | ((0)) | Yes | | DZBD2T | |
| 60 | ZBD3T | Net Payment Terms Period | decimal | 3 | 0 | DEC | ((0)) | Yes | | DZBD3T | |
| 61 | ZBD1P | Cash Discount Percentage 1 | decimal | 5 | 3 | DEC | ((0)) | Yes | | DZBD1P | |
| 62 | ZBD2P | Cash Discount Percentage 2 | decimal | 5 | 3 | DEC | ((0)) | Yes | | DZBD2P | |
| 63 | XSKFB | Indicator: Calculate amounts qualifying for cash discount ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSKFB | Allow NULL? |
| 64 | SKFBT | Amount Eligible for Cash Discount in Document Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKFBT | |
| 65 | SKNTO | Cash discount amount in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKNTO | |
| 66 | WSKTO | Cash discount amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WSKTO | |
| 67 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | * | SCHZW_BSEG | Allow NULL? |
| 68 | ZLSPR | Payment Block Key | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSPR | Allow NULL? |
| 69 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UZAWE | Allow NULL? |
| 70 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HBKID | Allow NULL? |
| 71 | BVTYP | Partner Bank Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BVTYP | Allow NULL? |
| 72 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REBZG | Allow NULL? |
| 73 | REBZJ | Fiscal Year of the Relevant Invoice (for Credit Memo) | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | REBZJ | Allow NULL? |
| 74 | REBZZ | Line Item in the Relevant Invoice | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | REBZZ | Allow NULL? |
| 75 | REBZT | Follow-On Document Type | char | 1 | 0 | CHAR | (N' ') | Yes | | REBZT | Allow NULL? |
| 76 | ZOLLT | Customs Tariff Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | DZOLLT | Allow NULL? |
| 77 | ZOLLD | Customs Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZOLLD | Allow NULL? |
| 78 | LZBKZ | State Central Bank Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LZBKZ | Allow NULL? |
| 79 | LANDL | Supplying Country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LANDL | Allow NULL? |
| 80 | DIEKZ | Service Indicator (Foreign Payment) | char | 1 | 0 | CHAR | (N' ') | Yes | | DIEKZ | Allow NULL? |
| 81 | VRSKZ | Insurance indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VRSKZ | Allow NULL? |
| 82 | VRSDT | Insurance date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VRSDT | Allow NULL? |
| 83 | BLNBT | Base Amount for Determining the Preference Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | BLNBT | |
| 84 | BLNKZ | Subsidy indicator for determining the reduction rates | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLNKZ | Allow NULL? |
| 85 | BLNPZ | Preference Percentage Rate | decimal | 7 | 2 | DEC | ((0)) | Yes | | BLNPZ | |
| 86 | MSCHL | Dunning key | char | 1 | 0 | CHAR | (N' ') | Yes | * | MSCHL | Allow NULL? |
| 87 | MANSP | Dunning block | char | 1 | 0 | CHAR | (N' ') | Yes | * | MANSP | Allow NULL? |
| 88 | MABER | Dunning Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MABER | Allow NULL? |
| 89 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | ESRNR | Allow NULL? |
| 90 | ESRRE | ISR Reference Number | nvarchar | 27 | 0 | CHAR | (N' ') | Yes | | ESRRE | Allow NULL? |
| 91 | ESRPZ | ISR Check Digit | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ESRPZ | Allow NULL? |
| 92 | REWRT | Invoice Value Entered (in Local Currency) | decimal | 13 | 2 | CURR | ((0)) | Yes | | REEWR | |
| 93 | REWWR | Invoice value in foreign currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | REFWR | |
| 94 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | STCEG | Allow NULL? |
| 95 | XHKOM | Indicator: G/L account assigned manually ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XHKOM | Allow NULL? |
| 96 | VERTT | Contract Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RANTYP | Allow NULL? |
| 97 | VERTN | Contract Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RANL | Allow NULL? |
| 98 | VBEWA | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SBEWART | Allow NULL? |
| 99 | DABRZ | Reference Date for Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DABRBEZ | Allow NULL? |
| 100 | XEGDR | Indicator: Triangular deal within the EU ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XEGDR | Allow NULL? |
| 101 | FIPOS | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 102 | ZBFIX | Fixed Payment Terms | char | 1 | 0 | CHAR | (N' ') | Yes | | DZBFIX | Allow NULL? |
| 103 | REPRF | Check Flag for Double Invoices or Credit Memos | char | 1 | 0 | CHAR | (N' ') | Yes | | REPRF | Allow NULL? |
| 104 | SWAER | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 105 | MADAT | Last dunned on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MADAT | Allow NULL? |
| 106 | MANST | Dunning level | char | 1 | 0 | NUMC | (N'0') | Yes | | MAHNS_D | Allow NULL? |
| 107 | XREF1 | Business partner reference key | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XREF1 | Allow NULL? |
| 108 | XREF2 | Business partner reference key | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XREF2 | Allow NULL? |
| 109 | XZANF | Indicator: Payment demand | char | 1 | 0 | CHAR | (N' ') | Yes | | XZANF | Allow NULL? |
| 110 | XFDIS | Indicator: Cash Management activated? | char | 1 | 0 | CHAR | (N' ') | Yes | | XFDIS | Allow NULL? |
| 111 | RSTGR | Reason Code for Payments | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T053R | RSTGR | Allow NULL? |
| 112 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | XREF3 | Allow NULL? |
| 113 | DTWS1 | Instruction key 1 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT16 | Allow NULL? |
| 114 | DTWS2 | Instruction key 2 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT17 | Allow NULL? |
| 115 | DTWS3 | Instruction key 3 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT18 | Allow NULL? |
| 116 | DTWS4 | Instruction key 4 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT19 | Allow NULL? |
| 117 | EMPFB | Payee/Payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EMPFB | Allow NULL? |
| 118 | KIDNO | Payment Reference | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KIDNO | Allow NULL? |
| 119 | IDXSP | Inflation Index | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | J_1AINFT20 | J_1AINDXSP | Allow NULL? |
| 120 | CHWRB | Document Parking: Amount not Modifiable | char | 1 | 0 | CHAR | (N' ') | Yes | | CHWRB | Allow NULL? |
