| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | INVOICE_TYPE | Invoice Type | nvarchar | 5 | 0 | | | | Allow NULL? |
| 3 | INVOICE_KEY | Invoice Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | char | 1 | 0 | | | | Allow NULL? |
| 5 | INV_NO | Document Number of an Invoice Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | INV_TYPE | Invoice Type | char | 1 | 0 | | | | Allow NULL? |
| 7 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | INV_DATE | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | TOTAL_AMT | Net Value in Document Currency | decimal | 15 | 2 | | | | |
| 10 | SIGN | Sign for positive (+) or negative(-) number | char | 1 | 0 | | | | Allow NULL? |
| 11 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 12 | TAX | Tax amount in document currency | decimal | 13 | 2 | | | | |
| 13 | VENDOR_REF | Reference Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 14 | PAYMENT_DUE | Due Date for Net Payment | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | PAYMENT_DATE | Probable Payment Date (Cash Discount 1 Due) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | BASELINE_DATE | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | VENDOR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | REF_VENDOR | Account Number of the Branch | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | INV_STATUS | Invoice Status | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | INV_PARA1 | Status Parameter 1 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 23 | INV_PARA2 | Status Parameter 2 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 24 | INV_PARA3 | Status Parameter 3 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 25 | INV_PARA4 | Status Parameter 4 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 26 | INV_ADD_INFO | Invoice Status Additional Info | nvarchar | 132 | 0 | | | | Allow NULL? |
| 27 | PAYMENTSTATUS | Payment Status | nvarchar | 4 | 0 | | | | Allow NULL? |
| 28 | PAYMENT_PARA1 | Payment Status Parameter 1 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 29 | PAYMENT_PARA2 | Payment Status Parameter 2 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 30 | PAYMENT_PARA3 | Payment Status Parameter 3 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 31 | PAYMENT_PARA4 | Payment Status Parameter 4 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 32 | PAY_ADD_INFO | Payment Status Additional Info | nvarchar | 132 | 0 | | | | Allow NULL? |
| 33 | DELETED | Deleted flag | char | 1 | 0 | | | | Allow NULL? |
