| 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 | DPCNR | Down Payment Chain Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | DCPNR | Transaction Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | DPNRB | Sequence Number of Accounting Document in Transaction | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | DPVTP | Transaction Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | DPCDT | Document Cat. of Accounting Document in Down Payment Chain | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | DOC_STAT | Document Status | char | 1 | 0 | | | | Allow NULL? |
| 9 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | PSTNG_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | TRANS_DATE | Translation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | FISC_YEAR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | FIS_PERIOD | Fiscal Period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | REF_DOC_NO | Reference Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 16 | STGRD | Reason for Reversal | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | STONR | Sequence Number of Reversed Document | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | FI_DCPNR | Final Invoice Transaction Number (Reason for Reversal) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | FI_DPNRB | Final Invoice Document Number (Reason for Reversal) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | RES_DOC | Document number for which a residual item was created | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | OBJ_TYPE | Reference Transaction | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | OBJ_KEY | Reference Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 23 | OBJ_SYS | Logical system of source document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | CRNAME | User name of administrator who entered object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | CRDATE | Date on which the object was created | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | CHNAME | User name of processer who made change to object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 27 | CHDATE | Date of last change to object | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | TAX_CHANGE | Indicator for Tax Rate Change | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | VATDATE | Tax Reporting Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | BOE_DUEDATE | Bill of Exchange Due Date | nvarchar | 8 | 0 | | | | Allow NULL? |
