| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 3 | TRK_PRNR | Tracking partner | nvarchar | 10 | 0 | CHAR | (N' ') | No | BUT000 | TRK_PRNR | Allow NULL? |
| 4 | IDOC_TYPE | IDoc Type | nvarchar | 8 | 0 | CHAR | (N' ') | No | | EDI_DOCTYP | Allow NULL? |
| 5 | TRANSM_NO | Transmission number | nvarchar | 20 | 0 | CHAR | (N' ') | No | | TRANSM_NO | Allow NULL? |
| 6 | INT_XMNO | Internal transmission number | nvarchar | 20 | 0 | CHAR | (N' ') | No | | INTXMNO | Allow NULL? |
| 7 | TRAN_TYPE | DRM relevant processing code | nvarchar | 2 | 0 | CHAR | (N' ') | No | | PROCCODE | Allow NULL? |
| 8 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 9 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 10 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 11 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 12 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 13 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | PERIV | Allow NULL? |
| 14 | VWDAT | Pointer to administrative data | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | VWDAT | Allow NULL? |
| 15 | MAIN_CURR | Manufacturer/ supplier's currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | MAIN_CURR | Allow NULL? |
| 16 | TXMN_CURR | Currency in which transmission data has been reported | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | TXMN_CURR | Allow NULL? |
| 17 | STATUS | Transmission status | char | 1 | 0 | CHAR | (N' ') | Yes | | XM_STATUS | Allow NULL? |
| 18 | DUPL_STAT | Duplicate feed indicator for EDI transmission | char | 1 | 0 | CHAR | (N' ') | Yes | | DUPL_FD | Allow NULL? |
| 19 | TRANSM_DT | Date of EDI transmission | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TRANSM_DT | Allow NULL? |
| 20 | EFF_DATE | Effective date of EDI transmission | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EFF_DATE | Allow NULL? |
| 21 | MN_CURR | Manufacturer/ supplier's currency | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | MN_CURR | Allow NULL? |
| 22 | TX_CURR | Currency in which transmission data has been reported | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | TX_CURR | Allow NULL? |
| 23 | VAL_MNCUR | Sum of values in the transmission in main currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | VAL_MNCUR | |
| 24 | VAL_TXCUR | Sum of values in EDI transmission in transmission currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | VAL_TXCUR | |
| 25 | TOT_LINES | Total number of lines in EDI transmission | decimal | 8 | 0 | DEC | ((0)) | Yes | | TOT_LN | |
| 26 | TOT_ERLN | Total number of errored lines in EDI transmission | decimal | 8 | 0 | DEC | ((0)) | Yes | | TOT_ERLN | |
| 27 | VAL_ERLN | Sum of values in errored lines in main currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | VAL_ERLN | |
| 28 | TOT_DLLN | Total number of deleted lines in EDI transmission | decimal | 8 | 0 | DEC | ((0)) | Yes | | TOT_DLLN | |
| 29 | VAL_DLLN | Sum of values in deleted lines in main currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | VAL_DLLN | |
