| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | LS_DOC_NO | Logical System of the SAP Transaction Document | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | DOC_TYP | Transaction Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | DOC_NO | Transaction Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | DOC_ITM | Transaction Document Item Number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | DOC_YEAR | Transaction Document Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | REF_DOC_TYP | Reference document type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 9 | REF_DOC_NO | Reference document number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | REF_DOC_ITM | Reference document item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 11 | REF_DOC_YEAR | Reference document year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | ABGRU | Reason for rejection of quotations and sales orders | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | ORDER_NO | Order number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 14 | ORDER_ITM | Order item | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | PO_ORDER_TYPE | Purchasing Document Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | INV_DOC_TYPE | Billing Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | MATDOCNO | Goods Issue/ Goods receipt number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | MATDOCITEM | Goods Issue/ Goods receipt item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | MATDOCYR | Goods Issue/ Goods receipt document year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | DS_ORD_NO | Drop-ship sales order number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | DS_ORD_ITM | Drop-ship sales order item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 22 | DOC_QTY | Document quantity | decimal | 15 | 3 | | | | |
| 23 | MATCHED_QTY | Matched quantity | decimal | 15 | 3 | | | | |
| 24 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | PRIC_UNIT | Pricing unit for price protectable price | decimal | 5 | 0 | | | | |
| 26 | COND_RATE | Price protectable price condition rate | decimal | 11 | 2 | | | | |
| 27 | COND_CURR | Price protectable price currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | COND_NUMER | Numerator for converting price protectable price | decimal | 5 | 0 | | | | |
| 29 | COND_DENOM | Denominator for conversion to base unit | decimal | 5 | 0 | | | | |
| 30 | COND_UOM | Pricing unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | DOC_VALUE | Net value of the order item in document currency | decimal | 15 | 2 | | | | |
| 32 | DOC_VALUE_CURR | SD Document Currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 33 | DOC_DATE | Document creation date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | MSBOOKPARTNO | Manufacturer book part number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 35 | MATERIAL | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 36 | TRACK_PARTNER | Tracking partner | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | LOTTYPE | DRM lot type | char | 1 | 0 | | | | Allow NULL? |
| 39 | END_CUST | DRM end customer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | RESALEPRC | Resale price | decimal | 11 | 2 | | | | |
| 41 | RESALECURR | Resale price currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 42 | RESL_PRC_UNIT | Pricing quantity for resale price | decimal | 5 | 0 | | | | |
| 43 | RESL_PRC_UOM | Unit of measure for pricing quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 44 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 45 | DIST_CHNL | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | DIVISION | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 47 | PURCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 48 | PLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 49 | PPTYPE | Price protection type | char | 1 | 0 | | | | Allow NULL? |
| 50 | RB_LOTNO | Reconciliation bucket lot number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 51 | CUS_REF_FLD | Ship-and-debit claim reference number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 52 | IND_ATO_MTS | Object ID | char | 1 | 0 | | | | Allow NULL? |
| 53 | PROD_ORD_NO | Order Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 54 | XN_CODE | DRM relevant transaction code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 55 | PROC_CODE | DRM relevant processing code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 56 | MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | char | 1 | 0 | | | | Allow NULL? |
| 57 | PROC_STATUS | Status of transactions | char | 1 | 0 | | | | Allow NULL? |
| 58 | LOGHANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | | | | Allow NULL? |
| 59 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 60 | CREATED_DT | Created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | CREATED_TM | Time created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 62 | LASTCHGDBY | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 63 | LASTCHGDDT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 64 | CHANGED_TM | Last changed at | nvarchar | 6 | 0 | | | | Allow NULL? |
