| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | EBELN | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | EBELP | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DOC_SEQ | PO History Document Sequence Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | SYNC_FLAG | Flag to indicate if this record is sync with outside db | char | 1 | 0 | | | | Allow NULL? |
| 6 | PO_NO | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | PO_LINE | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | SEQ_NO | Sequential Number of Account Assignment | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | DOC_YEAR | Material Document Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | DOC_NO | Number of Material Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | DOC_LINE | Item in Material Document | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | DOC_DATE | Document Date in Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | PO_HIST_CAT | PO history category | char | 1 | 0 | | | | Allow NULL? |
| 14 | POST_DATE | Posting Date in the Document | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | UOM | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | UNIT_PRICE | Vendor Portal Unit Price | decimal | 23 | 6 | | | | |
| 17 | QUANTITY | Quantity | decimal | 13 | 3 | | | | |
| 18 | AMOUNT | Amount in document currency | decimal | 13 | 2 | | | | |
| 19 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 20 | SIGN | Sign for positive (+) or negative(-) number | char | 1 | 0 | | | | Allow NULL? |
| 21 | VENDOR_REF | Reference Document Number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 22 | GR_INVOICED | Flag to indicate whether invoice has been created for the GR | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | STATUS | Status Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | STATUS_PARA1 | Status Parameter 1 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 25 | STATUS_PARA2 | Status Parameter 2 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 26 | STATUS_PARA3 | Status Parameter 3 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 27 | STATUS_PARA4 | Status Parameter 4 | nvarchar | 80 | 0 | | | | Allow NULL? |
| 28 | STATUS_ADDINFO | Status Additional Info | nvarchar | 132 | 0 | | | | Allow NULL? |
| 29 | DELETED | Deleted flag | char | 1 | 0 | | | | Allow NULL? |
| 30 | DELIVERY_NOTE | Number of External Delivery Note | nvarchar | 16 | 0 | | | | Allow NULL? |
