| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | BELNR | Accounting Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | BUZEI | Document Item in Invoice Document | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | POSTYP | Evaluated Item Categories | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | decimal | 5 | 0 | | | | |
| 7 | BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | decimal | 5 | 0 | | | | |
| 8 | NETWR | Net order value in document currency | decimal | 13 | 2 | | | | |
| 9 | BSMNG | Quantity Ordered Against this Purchase Requisition | decimal | 13 | 3 | | | | |
| 10 | WEMNG | Quantity of Goods Received | decimal | 13 | 3 | | | | |
| 11 | REMNG | Quantity invoiced | decimal | 13 | 3 | | | | |
| 12 | NORELE | Non-Relevance of a Document Item | char | 1 | 0 | | | | Allow NULL? |
| 13 | VALID | Validation | char | 1 | 0 | | | | Allow NULL? |
| 14 | TEXT | Reason for Validation or Non-Relevance | nvarchar | 29 | 0 | | | | Allow NULL? |
| 15 | FAULT | Type of Error (Vendor/Own Error) | char | 1 | 0 | | | | Allow NULL? |