| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | STAGDOCNO | IDOC staging table document number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | INT_XMNO | DRM internal transmission number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 4 | TRANSM_NO | EDI transmission number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 5 | IDOCNO | IDoc number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 6 | IDOC_TYPE | Message Type | nvarchar | 30 | 0 | | | | Allow NULL? |
| 7 | EFF_DATE | EDI transmission effective date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | DIST_CHNL | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | DIVISION | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | TRANSM_DATE | EDI transmission date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | XN_CODE | DRM relevant transaction code | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | EDIXNCODE | EDI transaction code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | PROC_CODE | DRM relevant processing code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | TRACK_PARTNER | Tracking partner | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | PARTNER | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | MS_DR_IND | Indicates manufacturer/supplier or distributor/reseller lot | char | 1 | 0 | | | | Allow NULL? |
| 18 | MSBOOKPARTNO | Manufacturer book part number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 19 | MATERIAL | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 20 | DR_MATERIAL | Material as maintained in DRM partner's system | nvarchar | 35 | 0 | | | | Allow NULL? |
| 21 | LOTTYPE | DRM lot type | char | 1 | 0 | | | | Allow NULL? |
| 22 | SELLTHRUQT | Reported material quantity in base unit | decimal | 15 | 3 | | | | |
| 23 | QTY_UNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | DR_STQTY | Quantity as reported by distributor/ reseller | decimal | 15 | 3 | | | | |
| 25 | DR_QTY_UNIT | Unit of measure for reported quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | DR_QTY_EDI_UNIT | Reported Unit of measure in IDoc (ISO Format) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | ALT_STQTY | Reported quantity in alternative unit | decimal | 15 | 3 | | | | |
| 28 | ALT_QTY_UNIT | Alternative unit of measure for reported quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | SALES_REP | Business Partner Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | END_CUST | DRM end customer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | DR_END_CUST | Resale customer as reported by distributor/ reseller | nvarchar | 20 | 0 | | | | Allow NULL? |
| 32 | EXT_REFNO | Resale customer external reference number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 33 | ECPARTFN | Qualifier for partner function | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | IM_END_CUST | DRM end customer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | DR_IM_END_CUST | Resale customer as reported by distributor/ reseller | nvarchar | 20 | 0 | | | | Allow NULL? |
| 36 | IM_EXT_REFNO | Resale customer external reference number | nvarchar | 11 | 0 | | | | Allow NULL? |
| 37 | IM_ECPARTFN | Qualifier for partner function | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | EC_INV_NO | End customer invoice number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 39 | EC_INV_ITM | Resale invoice item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 40 | EC_CM_NO | End customer return credit memo number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 41 | EC_CM_ITM | End customer return credit memo item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 42 | RESALEPRC | Resale price | decimal | 11 | 2 | | | | |
| 43 | EDIRESLPRC | Reported resale rate in EDI | nvarchar | 15 | 0 | | | | Allow NULL? |
| 44 | RESALECURR | Resale price currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 45 | EDIRESLCURR | Resale currency in EDI | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | RESL_PRC_UNIT | Pricing quantity for resale price | decimal | 5 | 0 | | | | |
| 47 | RESL_PRC_UOM | Unit of measure for pricing quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 48 | EDIRESLPRCUOM | Resale unit of measurement in EDI item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 49 | RESL_CON_NUM | Numerator for coversion to base unit | decimal | 5 | 0 | | | | |
| 50 | RESL_CON_DEN | Denominator for conversion to base unit of material | decimal | 5 | 0 | | | | |
| 51 | EC_INV_DT | Resale invoice date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | EC_SHP_DT | Resale shipping date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | PROC_STATUS | Processing status of staging record | char | 1 | 0 | | | | Allow NULL? |
| 54 | COST | Cost price of material | decimal | 11 | 2 | | | | |
| 55 | EDICOSTPRC | Reported cost price in EDI line item | nvarchar | 15 | 0 | | | | Allow NULL? |
| 56 | COST_CURR | Inventory cost currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 57 | EDICOSTCURR | Reported cost currency in EDI line item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | COST_PRC_UNIT | Inventory pricing unit | decimal | 5 | 0 | | | | |
| 59 | PRC_UOM | Unit of measure for inventory cost pricing quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 60 | EDICOSTPRCUOM | Cost Unit of measurement in EDI | nvarchar | 3 | 0 | | | | Allow NULL? |
| 61 | COST_CON_NUM | Numerator for coversion to base unit | decimal | 5 | 0 | | | | |
| 62 | COST_CON_DEN | Denominator for conversion to base unit of material | decimal | 5 | 0 | | | | |
| 63 | INT_BRANCH | Manufacturer/ supplier's code for reseller unit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 64 | BRANCH | Distributor/ reseller's code for reseller unit | nvarchar | 20 | 0 | | | | Allow NULL? |
| 65 | STOCK_LOC | Stocking location | nvarchar | 10 | 0 | | | | Allow NULL? |
| 66 | LOGHANDLE | Application Log: Log Handle | nvarchar | 22 | 0 | | | | Allow NULL? |
| 67 | ERRORCODE | Error Code for storing errors in a record | nvarchar | 100 | 0 | | | | Allow NULL? |
| 68 | REROUTEFLAG | Reroute flag | char | 1 | 0 | | | | Allow NULL? |
| 69 | ENDCSTADRNO | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 70 | IM_ENDCSTADRNO | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 71 | BRADRNO | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 72 | TRANS_DATE | Reported date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 73 | VAL_MNCUR | Sum of values in the transmission in main currency | decimal | 15 | 2 | | | | |
| 74 | MN_CURR | Manufacturer/ supplier's currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 75 | CUS_REF_FLD | Ship-and-debit claim reference number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 76 | SD_AGR_NO | Ship-and-debit agreement number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 77 | SD_AGR_ITM | Ship-and-debit agreement item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 78 | SD_AGR_RATE | Ship-and-debit agreement rate | decimal | 11 | 2 | | | | |
| 79 | SD_AGR_CURR | Ship-and-debit agreement rate currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 80 | PRIC_UNIT | Ship-and-debit agreement pricing unit | decimal | 5 | 0 | | | | |
| 81 | SD_AGR_UOM | Unit of measure for SD Agreement | nvarchar | 3 | 0 | | | | Allow NULL? |
| 82 | AGRM_CON_NUM | Numerator for coversion to base unit | decimal | 5 | 0 | | | | |
| 83 | AGRM_CON_DEN | Denominator for conversion to base unit of material | decimal | 5 | 0 | | | | |
| 84 | REP_AGR_RATE | Ship-and-debit agreement rate reported by distributor | decimal | 11 | 2 | | | | |
| 85 | EDI_AGR_RATE | Reported agreement rate in EDI | nvarchar | 15 | 0 | | | | Allow NULL? |
| 86 | REP_AGR_CURR | Currency of reported ship-and-debit agreement rate | nvarchar | 5 | 0 | | | | Allow NULL? |
| 87 | EDI_AGR_CURR | Agreement currency in EDI | nvarchar | 3 | 0 | | | | Allow NULL? |
| 88 | REP_PRIC_UNIT | Pricing unit for reported ship-and-debit agreement price | decimal | 5 | 0 | | | | |
| 89 | REP_PRC_UOM | Unit of measure for pricing quantity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 90 | EDI_PRC_UOM | Reported agreement unit of measure in EDI | nvarchar | 3 | 0 | | | | Allow NULL? |
| 91 | AGR_CON_NUM | Numerator for coversion to base unit | decimal | 5 | 0 | | | | |
| 92 | AGR_CON_DEN | Denominator for conversion to base unit of material | decimal | 5 | 0 | | | | |
| 93 | REP_CLAIM_AMOUNT | Reported ship-and-debit claim amount | decimal | 15 | 2 | | | | |
| 94 | EDI_CLAIM_AMOUNT | Reported claim amount in EDI | nvarchar | 18 | 0 | | | | Allow NULL? |
| 95 | REP_CLAIM_CURR | Reported ship-and-debit claim amount currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 96 | EDI_CLAIM_CURR | Claim currency in EDI | nvarchar | 3 | 0 | | | | Allow NULL? |
| 97 | INV_DOCNO | Credit/ debit memo number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 98 | INV_DOCITM | Credit/ debit memo item number | nvarchar | 6 | 0 | | | | Allow NULL? |
| 99 | RES_IDOCNO | Response IDoc number | nvarchar | 16 | 0 | | | | Allow NULL? |
| 100 | DESIGN_REG_NO | Design registration number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 101 | CREATED_BY | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 102 | CREATED_DT | Created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 103 | CREATED_TM | Time created | nvarchar | 6 | 0 | | | | Allow NULL? |
| 104 | LASTCHGDBY | Last Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 105 | LASTCHGDDT | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 106 | CHANGED_TM | Last changed at | nvarchar | 6 | 0 | | | | Allow NULL? |
| 107 | DUMMY_1 | Dummy function in length 1 | char | 1 | 0 | | | | Allow NULL? |
