| 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 | * | MANDT | Allow NULL? |
| 2 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | OPBEL_KK | Allow NULL? |
| 3 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | OPUPK_KK | Allow NULL? |
| 4 | GPART | Business Partner Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | GPART_KK | Allow NULL? |
| 5 | VINFO | Detailing Assignment In Tax Report | nvarchar | 20 | 0 | CHAR | (N' ') | No | | VINFO_KK | Allow NULL? |
| 6 | TZAHL | Counter For Identifying Respective Partial Payment Item | nvarchar | 3 | 0 | NUMC | (N'000') | No | | TZAHL_KK | Allow NULL? |
| 7 | APPLK | Application area | char | 1 | 0 | CHAR | (N' ') | Yes | | APPLK_KK | Allow NULL? |
| 8 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 9 | BUPLA | Business Place | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUPLA | Allow NULL? |
| 10 | HKONT | General ledger account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | HKONT_KK | Allow NULL? |
| 11 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | MWSKZ | Allow NULL? |
| 12 | STRKZ | Tax Code for Other Taxes | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | STRKZ_KK | Allow NULL? |
| 13 | STPRZ | Tax rate | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | STPRZ_KK | Allow NULL? |
| 14 | XREFS | Reference To Other Taxes | char | 1 | 0 | CHAR | (N' ') | Yes | | XREFS_KK | Allow NULL? |
| 15 | SBASH | Amount Subject to Tax in Local Currency (Tax Base Amount) | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBASH_KK | |
| 16 | SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBASW_KK | |
| 17 | SBETH | Tax Amount in Local Currency With +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBETH_KK | |
| 18 | SBETW | Tax Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | SBETW_KK | |
| 19 | GEBTH | Total Amount Per Tax Code In Local Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | GEBTH_KK | |
| 20 | GEBTW | Total Amount Per Tax Code In Transaction Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | GEBTW_KK | |
| 21 | AUGBO | Clearing Amount in Open Item Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBO_KK | |
| 22 | AUGBH | Clearing amount in local currency with +/- sign | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBH_KK | |
| 23 | AUGBW | Clearing Amount in Transaction Currency (With +/- Sign) | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUGBW_KK | |
| 24 | HWAER | Local Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAER_KK | Allow NULL? |
| 25 | TWAER | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | TWAER | Allow NULL? |
| 26 | TBDAT | Posting Date Trigger Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TBDAT_KK | Allow NULL? |
| 27 | TLDAT | Document Date For Trigger Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TLDAT_KK | Allow NULL? |
| 28 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FAEDN_KK | Allow NULL? |
| 29 | VMDAT | Planned Report Date For Tax Item | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VMDAT_KK | Allow NULL? |
| 30 | SDATA | Additional Data For Tax Report | nvarchar | 140 | 0 | CHAR | (N' ') | Yes | | SDATA_KK | Allow NULL? |
| 31 | XBLNR | Official Document Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | EXBEL_KK | Allow NULL? |
| 32 | KTOSL | Transaction key for account determination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | KTOSL_KK | Allow NULL? |
| 33 | KSCHL | Type of Tax Item for Other Tax Codes | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | KSCHL_STRKZ_KK | Allow NULL? |
| 34 | TXJCD | Tax Jurisdiction | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCD | Allow NULL? |
| 35 | TXJCO | Tax Jurisdiction Code (Entered value) | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | TXJCO_KK | Allow NULL? |
| 36 | AUBEL | Document Number Of Document To Be Triggered | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUBEL_KK | Allow NULL? |
| 37 | XSATZ | Record Triggered In Reporting Table | char | 1 | 0 | CHAR | (N' ') | Yes | | XSATZ_KK | Allow NULL? |
| 38 | REFNR | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | OPBEL_KK | Allow NULL? |
| 39 | XSTOR | Document Has Been Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | XSTOR_KK | Allow NULL? |
| 40 | AUGRD | Clearing Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | AUGRD_KK | Allow NULL? |
| 41 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CPUDT | Allow NULL? |
| 42 | CPUTM | Time of Entry | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CPUTM | Allow NULL? |
| 43 | EXBEL_BETRH | Total amount for an official document in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | EXBEL_BETRH | |
| 44 | EXBEL_BETRW | Total amount of an official document in transaction currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | EXBEL_BETRW | |
| 45 | ORI_OPBEL | Tax Reporting: Document Number of Transferred Document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | ORI_OPBEL_KK | Allow NULL? |
| 46 | ORI_OPUPK | Tax Reporting: Item Number of Transferred Tax Item | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | ORI_OPUPK_KK | Allow NULL? |
| 47 | TRA_OPBEL | Document for Transferring Deferred Tax | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | DFTAX_TRA_OPBEL_KK | Allow NULL? |
