| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | SEQNUMB | Sequence Number for Tax Report Data for a Payment Document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | GRPLINE | Grouping Key for Entries Belonging to a Line | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | REPLINE | Item Number In Sales/Purchase Tax Report List | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | REPLISTREF | Tax Reporting List Identification | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | CORRLINE | Line Number for Corrected Tax Line | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | CORRLISTREF | Tax Reporting List Identification | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | CORRIND | Correction Line Category | char | 1 | 0 | | | | Allow NULL? |
| 10 | VMDAT | Planned Report Date For Tax Item | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | GPART | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | VTREF | Reference Specifications from Contract | nvarchar | 20 | 0 | | | | Allow NULL? |
| 14 | INSTAXS | Insurance Tax Schedule | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | INSTAXPOS | Insurance Tax Category (Classification for Tax Reporting) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | STRKZ | Tax Code for Other Taxes | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | STPRZ | Tax rate | nvarchar | 6 | 0 | | | | Allow NULL? |
| 18 | SBASH | Amount Subject to Tax in Local Currency (Tax Base Amount) | decimal | 13 | 2 | | | | |
| 19 | SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | decimal | 13 | 2 | | | | |
| 20 | HWAER | Local Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 21 | TWAER | Transaction Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | SBETH | Tax Amount in Local Currency With +/- Sign | decimal | 13 | 2 | | | | |
| 23 | SBETW | Tax Amount in Transaction Currency with +/- Sign | decimal | 13 | 2 | | | | |
| 24 | FAEDN | Due date for net payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | ABRZU | Lower Limit of Settlement Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | ABRZO | Upper Limit of the Billing Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | PRGRP | Product Group | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | BROKER | Business Partner Number for Reporting Broker | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | BROOBJ | Broker Contract, Insurance Object for the Reporting Broker | nvarchar | 20 | 0 | | | | Allow NULL? |
| 31 | COLLDATE | Broker Collections: Date of Collection | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | CPUDT | Day On Which Accounting Document Was Entered | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | CPUTM | Time of Entry | nvarchar | 6 | 0 | | | | Allow NULL? |