| 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 | T000 | MANDT | Allow NULL? |
| 2 | EXTRT | Extract name | nvarchar | 12 | 0 | CHAR | (N' ') | No | J_3RFTAX_EXTRH | J_3RF_TAX_EXTRACT | Allow NULL? |
| 3 | BUKRS1 | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 4 | BELNR1 | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | BELNR_D | Allow NULL? |
| 5 | GJAHR1 | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 6 | BUZEI1 | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | No | | BUZEI | Allow NULL? |
| 7 | ACTIV | List Level in which the Line Item is Active | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ACTIV | Allow NULL? |
| 8 | ANLN1 | Main Asset Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ANLN1 | Allow NULL? |
| 9 | ANLN2 | New asset subnumber, 4 characters | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ANLN2_4 | Allow NULL? |
| 10 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 11 | AUGBL | Document Number of the Clearing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AUGBL | Allow NULL? |
| 12 | AUGDT | Clearing Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AUGDT | Allow NULL? |
| 13 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BELNR_D | Allow NULL? |
| 14 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T003 | BLART | Allow NULL? |
| 15 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 16 | BSCHL | Posting Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TBSL | BSCHL | Allow NULL? |
| 17 | BSTAT | Document Status | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTAT_D | Allow NULL? |
| 18 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 19 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 20 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BUZEI | Allow NULL? |
| 21 | BWWRT | Amount Valuated in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | BWWRT | |
| 22 | BWWR2 | Amount Valuated in Local Currency 2 | decimal | 13 | 2 | CURR | ((0)) | Yes | | BWWR2 | |
| 23 | BWWR3 | Amount Valuated in Local Currency 3 | decimal | 13 | 2 | CURR | ((0)) | Yes | | BWWR3 | |
| 24 | DMSHB | Amount in Local Currency with +/- Signs | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMSHB | |
| 25 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 26 | DMBE2 | Amount in Second Local Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE2_VZ | |
| 27 | HWAE2 | Currency Key of Second Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAE2 | Allow NULL? |
| 28 | DMBE3 | Amount in Third Local Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | DMBE3_VZ | |
| 29 | HWAE3 | Currency Key of Third Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAE3 | Allow NULL? |
| 30 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EBELN | Allow NULL? |
| 31 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | * | EBELP | Allow NULL? |
| 32 | ETEN2 | Delivery Schedule Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | ETENR | Allow NULL? |
| 33 | FAEDT | Net Due Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDT_FPOS | Allow NULL? |
| 34 | FILKD | Account Number of the Branch | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FILKD | Allow NULL? |
| 35 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 36 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 37 | JAMON | Fiscal Year/Posting Period from Posting Date | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | JAMON_XPO | Allow NULL? |
| 38 | KOART | Account Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KOART | Allow NULL? |
| 39 | KONTO | Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KTONR_AV | Allow NULL? |
| 40 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 41 | MABER | Dunning Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MABER | Allow NULL? |
| 42 | MADAT | Last dunned on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MADAT | Allow NULL? |
| 43 | MANSP | Dunning block | char | 1 | 0 | CHAR | (N' ') | Yes | T040S | MANSP | Allow NULL? |
| 44 | MANST | Dunning level | char | 1 | 0 | NUMC | (N'0') | Yes | | MAHNS_D | Allow NULL? |
| 45 | MONAT | Fiscal Period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | MONAT | Allow NULL? |
| 46 | MSCHL | Dunning key | char | 1 | 0 | CHAR | (N' ') | Yes | T040 | MSCHL | Allow NULL? |
| 47 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 48 | POSN2 | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNR_VA | Allow NULL? |
| 49 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 50 | QBSHB | Withholding Tax Amount (in Doc. Currency) with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | QBSHB_VZ | |
| 51 | QSFBT | Amount Free of Withhld.Tax (in Doc.Curr.) with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | QSFBT_VZ | |
| 52 | QSSHB | Withholding Tax Base Amount with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | QSSHB_VZ | |
| 53 | REBZG | Number of the Invoice the Transaction Belongs to | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | REBZG | Allow NULL? |
| 54 | SAMNR | Invoice List Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | SAMNR | Allow NULL? |
| 55 | SGTXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 56 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 57 | SKFBT | Amount Subject to Discount in Document Curr. with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKFBT_VZ | |
| 58 | SKNTO | Cash Discount Amount (+/-) in Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKNTO_VZ | |
| 59 | STAKZ | Indicator: Statistical document ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSTKZ | Allow NULL? |
| 60 | UMSKS | Special G/L Transaction Type | char | 1 | 0 | CHAR | (N' ') | Yes | | UMSKS | Allow NULL? |
| 61 | UMSKZ | Special G/L Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | * | UMSKZ | Allow NULL? |
| 62 | UZAWE | Payment Method Supplement | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | UZAWE | Allow NULL? |
| 63 | VALUT | Value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALUT | Allow NULL? |
| 64 | VBEL2 | Sales Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VA | Allow NULL? |
| 65 | VBELN | Billing Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN_VF | Allow NULL? |
| 66 | VBEWA | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SBEWART | Allow NULL? |
| 67 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | RASSC | Allow NULL? |
| 68 | VERTN | Contract Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RANL | Allow NULL? |
| 69 | VERTT | Contract Type | char | 1 | 0 | CHAR | (N' ') | Yes | | RANTYP | Allow NULL? |
| 70 | VERZ1 | Days in Arrears for Cash Discount Terms 1 | decimal | 5 | 0 | DEC | ((0)) | Yes | | VERZ1 | |
| 71 | VERZN | Days in Arrears by Net Due Date | decimal | 5 | 0 | DEC | ((0)) | Yes | | VERZN | |
| 72 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 73 | WRSHB | Foreign Currency Amount with Signs (+/-) | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRSHB | |
| 74 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 75 | WSKTO | Cash discount amount in document currency with +/- sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | WSKTO_VZ | |
| 76 | WVERW | Bill of exchange usage type | char | 1 | 0 | CHAR | (N' ') | Yes | | WVERW | Allow NULL? |
| 77 | XBLNR | Reference Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XBLNR1 | Allow NULL? |
| 78 | XSTRP | Indicator: Disputed item? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSTRP | Allow NULL? |
| 79 | XZAHL | Indicator: Is the posting key used in a payment transaction? | char | 1 | 0 | CHAR | (N' ') | Yes | | XZAHL | Allow NULL? |
| 80 | ZALDT | Probable Payment Date (Cash Discount 1 Due) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZALDT | Allow NULL? |
| 81 | ZBD1P | Cash Discount Percentage 1 | decimal | 5 | 3 | DEC | ((0)) | Yes | | DZBD1P | |
| 82 | ZBD1T | Cash discount days 1 | decimal | 3 | 0 | DEC | ((0)) | Yes | | DZBD1T | |
| 83 | ZBD2P | Cash Discount Percentage 2 | decimal | 5 | 3 | DEC | ((0)) | Yes | | DZBD2P | |
| 84 | ZBD2T | Cash discount days 2 | decimal | 3 | 0 | DEC | ((0)) | Yes | | DZBD2T | |
| 85 | ZBD3T | Net Payment Terms Period | decimal | 3 | 0 | DEC | ((0)) | Yes | | DZBD3T | |
| 86 | ZFBDT | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZFBDT | Allow NULL? |
| 87 | ZINSZ | Interest Calculation Numerator (Days in Arrears * Amount) | decimal | 15 | 2 | CURR | ((0)) | Yes | | DZINSZ | |
| 88 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | DZLSCH | Allow NULL? |
| 89 | ZLSPR | Payment Block Key | char | 1 | 0 | CHAR | (N' ') | Yes | * | DZLSPR | Allow NULL? |
| 90 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 91 | ZUONR | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 92 | XREF1 | Business partner reference key | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XREF1 | Allow NULL? |
| 93 | XREF2 | Business partner reference key | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | XREF2 | Allow NULL? |
| 94 | XARCH | Indicator: Document already archived ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XARCH | Allow NULL? |
| 95 | RSTGR | Reason Code for Payments | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | RSTGR | Allow NULL? |
| 96 | ASKTO | Current Cash Disc. Amount in Document Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | ASKTO_VZ | |
| 97 | KURSE | Effective Exchange Rate in the Line Item | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSE | |
| 98 | REBZT | Follow-On Document Type | char | 1 | 0 | CHAR | (N' ') | Yes | | REBZT | Allow NULL? |
| 99 | PSWSL | Update Currency for General Ledger Transaction Figures | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | PSWSL | Allow NULL? |
| 100 | PSWBT | Amount for Updating in General Ledger | decimal | 13 | 2 | CURR | ((0)) | Yes | | PSWBT | |
| 101 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT | Allow NULL? |
| 102 | XNEGP | Indicator: Negative posting | char | 1 | 0 | CHAR | (N' ') | Yes | | XNEGP | Allow NULL? |
| 103 | ZBFIX | Fixed Payment Terms | char | 1 | 0 | CHAR | (N' ') | Yes | | DZBFIX | Allow NULL? |
| 104 | RFZEI | Payment Card Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RFZEI_CC | Allow NULL? |
| 105 | CCBTC | Payment cards: Settlement run | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CCBTC | Allow NULL? |
| 106 | KKBER | Credit control area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T014 | KKBER | Allow NULL? |
| 107 | XREF3 | Reference key for line item | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | XREF3 | Allow NULL? |
| 108 | DTWS1 | Instruction key 1 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT16 | Allow NULL? |
| 109 | DTWS2 | Instruction key 2 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT17 | Allow NULL? |
| 110 | DTWS3 | Instruction key 3 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT18 | Allow NULL? |
| 111 | DTWS4 | Instruction key 4 | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | DTAT19 | Allow NULL? |
| 112 | ABSBT | Credit management: Hedged amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | ABSBT | |
| 113 | KKBWR | Currency of Credit Control Area | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | KKBWR | Allow NULL? |
| 114 | PROJK | Individual Structural Element (WBS Element) in Ext. Format | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PROJK_EXT | Allow NULL? |
| 115 | XPYPR | Indicator: Items from Payment Program Blocked | char | 1 | 0 | CHAR | (N' ') | Yes | | XPYPR | Allow NULL? |
| 116 | KIDNO | Payment Reference | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KIDNO | Allow NULL? |
| 117 | XAUGP | Indicator: Item has been cleared? | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUGP | Allow NULL? |
| 118 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUPLA | Allow NULL? |
| 119 | SECCO | Section Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | SECCO | Allow NULL? |
| 120 | GKART | Offsetting Account Type | char | 1 | 0 | CHAR | (N' ') | Yes | | GKART | Allow NULL? |
| 121 | GKONT | Offsetting Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | GKONT | Allow NULL? |
| 122 | PYCUR | Currency for Automatic Payment | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | PYCUR | Allow NULL? |
| 123 | PYAMT | Amount in Payment Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | PYAMT | |
| 124 | PYORD | Payment Order | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PYORD | Allow NULL? |
| 125 | XTEXT | Indicator: Texts exist ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XTEXT_F02L | Allow NULL? |
| 126 | TDID | Text ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | TDID | Allow NULL? |
| 127 | XDUEN | Indicator: Item is due net? | char | 1 | 0 | CHAR | (N' ') | Yes | | XDUEN | Allow NULL? |
| 128 | XDUE1 | Indicator: Cash discount term 1 is due on item? | char | 1 | 0 | CHAR | (N' ') | Yes | | XDUE1 | Allow NULL? |
| 129 | XRAGL | Indicator: Clearing was Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | XRAGL | Allow NULL? |
| 130 | XSELP | Item selected (selected, chosen, ...) | char | 1 | 0 | CHAR | (N' ') | Yes | | XSELP | Allow NULL? |
| 131 | CESSION_KZ | Accounts Receivable Pledging Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | CESSION_KZ | Allow NULL? |
| 132 | BUZID | Identification of the Line Item | char | 1 | 0 | CHAR | (N' ') | Yes | | BUZID | Allow NULL? |
| 133 | AUGGJ | Fiscal Year of Clearing Document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | AUGGJ | Allow NULL? |
| 134 | AGZEI | Clearing Item | decimal | 5 | 0 | DEC | ((0)) | Yes | | AGZEI | |
| 135 | VNAME | Joint Venture | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T8JV | JV_NAME | Allow NULL? |
| 136 | EGRUP | Equity group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T8JF | JV_EGROUP | Allow NULL? |
| 137 | BTYPE | Payroll Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JA | JV_BILIND | Allow NULL? |
| 138 | VORGN | Transaction Type for General Ledger | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VORGN | Allow NULL? |
