| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PROCESS_ID | Process ID | nvarchar | 34 | 0 | | | | Allow NULL? |
| 3 | GUID | Globally Unique Identifier | varbinary | 16 | 0 | | | | |
| 4 | INVOICE_DOC_ITEM | Item Number in Invoice Document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | PO_NUMBER | Purchase Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | PO_ITEM | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 7 | REF_DOC | Document Number of a Reference Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | REF_DOC_YEAR | Fiscal Year of Current Period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | REF_DOC_IT | Item of a Reference Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | DE_CRE_IND | Indicator: Subsequent debit | char | 1 | 0 | | | | Allow NULL? |
| 11 | TAX_CODE | Sales Tax Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | TAXJURCODE | Tax Jurisdiction | nvarchar | 15 | 0 | | | | Allow NULL? |
| 13 | ITEM_AMOUNT | Amount in document currency | decimal | 23 | 4 | | | | |
| 14 | QUANTITY | Quantity | decimal | 13 | 3 | | | | |
| 15 | PO_UNIT | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | PO_UNIT_ISO | Order unit in ISO code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | PO_PR_QNT | Quantity in order price unit | decimal | 13 | 3 | | | | |
| 18 | PO_PR_UOM | Purchase Order Price Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | PO_PR_UOM_ISO | Purchase order price unit in ISO code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | COND_TYPE | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | COND_ST_NO | Level no. | nvarchar | 3 | 0 | | | | Allow NULL? |
| 22 | COND_COUNT | Condition counter | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | SHEET_NO | Service Entry Sheet Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | ITEM_TEXT | Item Text | nvarchar | 50 | 0 | | | | Allow NULL? |
| 25 | FINAL_INV | Final invoice indicator | char | 1 | 0 | | | | Allow NULL? |
| 26 | SHEET_ITEM | Line Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 27 | GRIR_CLEAR_SRV | Clearing indicator for GR/IR posting for services | char | 1 | 0 | | | | Allow NULL? |
| 28 | FREIGHT_VEN | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | CSHDIS_IND | Indicator: Line item not liable to cash discount? | char | 1 | 0 | | | | Allow NULL? |
| 30 | MARK | Checkbox | char | 1 | 0 | | | | Allow NULL? |
