| 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 | INVOICE_LINE | Invoice Line item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | char | 1 | 0 | | | | Allow NULL? |
| 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | INV_NO | Document Number of an Invoice Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | INV_LIN | Document Item in Invoice Document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | MATERIAL | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 11 | GL_ACCT | G/L Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | UOM | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | UNIT_PRICE | Vendor Portal Unit Price | decimal | 23 | 6 | | | | |
| 14 | SIGN | Sign for positive (+) or negative(-) number | char | 1 | 0 | | | | Allow NULL? |
| 15 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | QUANTITY | Quantity in Purchase Order Price Unit | decimal | 13 | 3 | | | | |
| 17 | AMOUNT | Amount in document currency | decimal | 13 | 2 | | | | |
| 18 | TAX | Tax amount in document currency | decimal | 13 | 2 | | | | |
| 19 | TOTAL_AMOUNT | Net Value in Document Currency | decimal | 15 | 2 | | | | |
| 20 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | PO_LIN | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 22 | PAYMENT_DATE | Probable Payment Date (Cash Discount 1 Due) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | PAYMENT_DOC | Document Number of the Clearing Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | PAID_AMOUNT | Amount in document currency | decimal | 13 | 2 | | | | |
| 25 | LINE_STATUS | Invoice Status | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | LINE_PARA1 | Status Parameter 1 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 27 | LINE_PARA2 | Status Parameter 2 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 28 | LINE_PARA3 | Status Parameter 3 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 29 | LINE_PARA4 | Status Parameter 4 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 30 | LINE_ADD_INFO | Invoice Status Additional Info | nvarchar | 132 | 0 | | | | Allow NULL? |
| 31 | DELETED | Deleted flag | char | 1 | 0 | | | | Allow NULL? |
