| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | BUZEI | Number of Line Item Within Accounting Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | BSTAT | Document Status | char | 1 | 0 | | | | Allow NULL? |
| 7 | INVSUMPAYER | Invoice Summary Payer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | PIGRUNIT | Payer Invoice Grouping Unit | nvarchar | 20 | 0 | | | | Allow NULL? |
| 9 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 10 | INVSUMRECIP | Invoice Summary Recipient | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | GRUNIT | Grouping Unit | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | CLOSDATE | Closing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | NETDT | Due Date for Net Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | MINR | Monthly Invoice Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | NOTINCL | Not Included In The Monthly Invoice | char | 1 | 0 | | | | Allow NULL? |
| 16 | MIBLOCK | Monthly Invoice Block | char | 1 | 0 | | | | Allow NULL? |
| 17 | NETAMNT | Current Invoiced Net Amount | decimal | 13 | 2 | | | | |
| 18 | TAXAMNT | Current Invoiced Tax Amount | decimal | 13 | 2 | | | | |
| 19 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | CREAUSER | Created By User | nvarchar | 12 | 0 | | | | Allow NULL? |
| 21 | CREADATE | Creation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | CREATIME | Creation Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | CHANUSER | Changed By User | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | CHANDATE | Changing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | CHANTIME | Changing Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 26 | ITEMCAT | Item category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | CLEARDATE | Clearing Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | NETAMNT1 | Net amount 1 for multiple tax code breakdown | decimal | 13 | 2 | | | | |
| 29 | TAXAMNT1 | Tax amount 1 for multiple tax code breakdown | decimal | 13 | 2 | | | | |
| 30 | MWSK1 | Tax Code for Distribution | nvarchar | 2 | 0 | | | | Allow NULL? |
| 31 | NETAMNT2 | Net amount 2 formultiple tax code breakdown | decimal | 13 | 2 | | | | |
| 32 | TAXAMNT2 | Tax amount 2 for multiple tax code breakdown | decimal | 13 | 2 | | | | |
| 33 | MWSK2 | Tax Code for Distribution | nvarchar | 2 | 0 | | | | Allow NULL? |
| 34 | NETAMNT3 | Net amount 3 for multiple tax code breakdown | decimal | 13 | 2 | | | | |
| 35 | TAXAMNT3 | Tax amount 3 for multiple tax code breakdown | decimal | 13 | 2 | | | | |
| 36 | MWSK3 | Tax Code for Distribution | nvarchar | 2 | 0 | | | | Allow NULL? |
