| 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 | TRMNO_INT | Transfer Number (Internal) | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | TRNSM | TRMNO_INT | Allow NULL? |
| 3 | DOCNUM | IDoc number | nvarchar | 16 | 0 | NUMC | (N'0000000000000000') | No | | EDI_DOCNUM | Allow NULL? |
| 4 | DOCSPLIT | Splitting Counter if IDoc Contains Several Deliveries | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | DOCSPLIT | Allow NULL? |
| 5 | ORGDAT | Original Data From the Transfer | char | 1 | 0 | CHAR | (N' ') | No | | ORGDATA | Allow NULL? |
| 6 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 7 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 8 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 9 | AEZET | Time last change was made | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AEZET | Allow NULL? |
| 10 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 11 | KUNAG_T | Transferred Sold-To Party Number | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | KUNAG_T | Allow NULL? |
| 12 | LIFNR_T | Vendor number at customer location | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | LIFNR_ED1 | Allow NULL? |
| 13 | KNREF_T | Transferred Customer Plant | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | KNREF_T | Allow NULL? |
| 14 | ABLAD_T | Customer's Transferred Unloading Point | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | | ABLAD_T | Allow NULL? |
| 15 | PRCTYPH_T | Transferred Transaction Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | PRCTYPH_T | Allow NULL? |
| 16 | DELNOQ_T | Transferred Category for Delivery Determination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DELNOQ_T | Allow NULL? |
| 17 | DELNO_T | Transferred Number for Delivery Determination | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | DELNO_T | Allow NULL? |
| 18 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 19 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP | Allow NULL? |
| 20 | KUNAG | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNAG | Allow NULL? |
| 21 | KUNRG | Payer | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNRG | Allow NULL? |
| 22 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 23 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 24 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 25 | MREFSRC | Type/Origin of Main Reference | char | 1 | 0 | CHAR | (N' ') | Yes | | MREFSRC | Allow NULL? |
| 26 | COMNUM | Combination Number | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | COMNUM | Allow NULL? |
| 27 | KUNAG_CUST | Sold-To Party for Customizing Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | KNA1 | KUNAG_CUST | Allow NULL? |
| 28 | DELCOM | Group Deliveries | char | 1 | 0 | CHAR | (N' ') | Yes | | DELCOM | Allow NULL? |
| 29 | PARPAY | Subsets Can Be Displayed | char | 1 | 0 | CHAR | (N' ') | Yes | | PARPAY | Allow NULL? |
| 30 | SBTGRP | Tolerance group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SBTGRP | Allow NULL? |
| 31 | KSCHL | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KSCHL | Allow NULL? |
| 32 | DDELNO | Delivery Note Number to Determine Sales Document | char | 1 | 0 | CHAR | (N' ') | Yes | | DDELNO | Allow NULL? |
| 33 | DXONO | External Order Number to Determine Sales Document | char | 1 | 0 | CHAR | (N' ') | Yes | | DXONO | Allow NULL? |
| 34 | DXDELNO | External Delivery Note Number to Determine Sales Document | char | 1 | 0 | CHAR | (N' ') | Yes | | DXDELNO | Allow NULL? |
| 35 | DBDJIT | Billing Doc. for Delivery Confirmation to Determ. Sales Doc. | char | 1 | 0 | CHAR | (N' ') | Yes | | DBDJIT | Allow NULL? |
| 36 | DXRELNO | Ext. Release No. (sumJC) for Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | DXRELNO | Allow NULL? |
| 37 | MREFNO | Main Reference | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | MREFNO1 | Allow NULL? |
| 38 | CURCY | SD Document Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERK | Allow NULL? |
| 39 | CURCY_T | Transferred Currency Converted | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CURCY_T | Allow NULL? |
| 40 | CURISO_T | Transferred Currency (ISO Code) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CURISO_T | Allow NULL? |
| 41 | CURCYRL_T | Converted Transferred Original Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CURCYRL_T | Allow NULL? |
| 42 | ERRCNT | No. of Messages in Verification Step (Header and Item Level) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ERRCNT | Allow NULL? |
| 43 | ORGREC | Original Data Record is Available for Current Record | char | 1 | 0 | CHAR | (N' ') | No | | ORGREC | Allow NULL? |
| 44 | DEACT | Deactivation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | DEACT | Allow NULL? |
| 45 | CONEXIST | Records Exist for Conditions to Be Transferred | char | 1 | 0 | CHAR | (N' ') | Yes | | CONEXIST | Allow NULL? |
| 46 | REFEXIST | Records available for transferred reference numbers | char | 1 | 0 | CHAR | (N' ') | Yes | | REFEXIST | Allow NULL? |
| 47 | DATEXIST | Transferred Dates Exist for Records | char | 1 | 0 | CHAR | (N' ') | Yes | | DATEXIST | Allow NULL? |
