| 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 | EXNUM | Number of foreign trade data in MM and SD documents | nvarchar | 10 | 0 | CHAR | (N' ') | No | | EXNUM | Allow NULL? |
| 3 | ALAND | Delivering country | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | HLAND | Allow NULL? |
| 4 | EXPVZ | Mode of Transport for Foreign Trade | char | 1 | 0 | CHAR | (N' ') | Yes | T618 | EXPVZ | Allow NULL? |
| 5 | ZOLLA | Customs Office: Office of Exit/Entry for Foreign Trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLLS | Allow NULL? |
| 6 | ZOLLB | Customs office: Office of destination for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLLB | Allow NULL? |
| 7 | ZOLL1 | Customs office: Customs office 1 for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLL1 | Allow NULL? |
| 8 | ZOLL2 | Customs office: Customs office 2 for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLL2 | Allow NULL? |
| 9 | ZOLL3 | Customs office: Customs office 3 for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLL3 | Allow NULL? |
| 10 | ZOLL4 | Customs office: Customs office 4 for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLL4 | Allow NULL? |
| 11 | ZOLL5 | Customs office: Customs office 5 for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLL5 | Allow NULL? |
| 12 | ZOLL6 | Customs office: Customs office 6 for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | DZOLL6 | Allow NULL? |
| 13 | KZGBE | Indicator for means of transport crossing the border | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KZGBE | Allow NULL? |
| 14 | KZABE | Indicator for the means of transport at departure | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KZABE | Allow NULL? |
| 15 | STGBE | Origin of Means of Transport when Crossing the Border | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | STGBE | Allow NULL? |
| 16 | STABE | Country of Origin of the Means of Transport at Departure | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | STABE | Allow NULL? |
| 17 | CONTA | ID: Goods cross border in a container | char | 1 | 0 | CHAR | (N' ') | Yes | | CONTA | Allow NULL? |
| 18 | GRWCU | Currency of statistical values for foreign trade | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | GRWCU | Allow NULL? |
| 19 | IEVER | Domestic Mode of Transport for Foreign Trade | char | 1 | 0 | CHAR | (N' ') | Yes | T618 | IEVER | Allow NULL? |
| 20 | SEGAL | Exclusion/Inclusion indicator for declara. to authorities | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T609A | SEGAL | Allow NULL? |
| 21 | WZOCU | Currency of customs values for import procg in foreign trade | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WZOCU | Allow NULL? |
| 22 | PRONU | Invoice: Number of invoice document for import processing | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PRONU | Allow NULL? |
| 23 | PRODA | Invoice: Date of invoice document for import processing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRODA | Allow NULL? |
| 24 | VORPA | Preliminary document: Document type for foreign trade procg | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610VA | VORPA | Allow NULL? |
| 25 | VORDA | Preliminary document: Date of preliminary doc.f.import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VORDA | Allow NULL? |
| 26 | VORNU | Preliminary document: No. of preliminary doc.f.import procg | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | VORNU | Allow NULL? |
| 27 | BEHOE | Preliminary doc.: Issuing authority of relevant prelim.doc. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | VOHOE | Allow NULL? |
| 28 | KENNU | Preliminary document: Customs office/ID number for import | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | KENNU | Allow NULL? |
| 29 | VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | VOISO | Allow NULL? |
| 30 | PREFPACOD | Preference code for foreign trade (decl.to author., import) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T604C | PREFPACOD | Allow NULL? |
| 31 | PREFA | Preference: Preference type for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610PA | PREFA | Allow NULL? |
| 32 | PREFN | Preference: Official number of preference document - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PREFN | Allow NULL? |
| 33 | PREDU | Preference: Date of preference document for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PREDU | Allow NULL? |
| 34 | PRISO | Preference: ISO code of country issuing the preference doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PRISO | Allow NULL? |
| 35 | PRHOE | Preference: Issuing authoritiy for relevant preference doc. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | PRHOE | Allow NULL? |
| 36 | PRUEL | Preference: Validity date of preference document for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRUEL | Allow NULL? |
| 37 | NACAR | Verification documents: Type of certificate for import | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610NA | NACAR | Allow NULL? |
| 38 | NACNU | Verification docs: Official no. of verific. doc. - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | NACNU | Allow NULL? |
| 39 | NACDA | Verification documents: Date of verif.doc. for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NACDA | Allow NULL? |
| 40 | NAISO | Verification doc: ISO code of ctry supplying verific.doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NAISO | Allow NULL? |
| 41 | NAHOE | Verification documents: Issuing authority for relev. verif. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | NAHOE | Allow NULL? |
| 42 | NAUEL | Verification docs: Validity date of verific.doc. for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NAUEL | Allow NULL? |
| 43 | TEXT1 | Comments: Text for foreign trade processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXTFT | Allow NULL? |
| 44 | TEXT2 | Comments: Text for foreign trade processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXTFT | Allow NULL? |
| 45 | TEXT3 | Comments: Text for foreign trade processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXTFT | Allow NULL? |
| 46 | EXDAR | Export document: Export document type for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610VA | EXDAR | Allow NULL? |
| 47 | EXDAA | Export document: Official number of export document | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDAA | Allow NULL? |
| 48 | EXDAB | Export document: Valid-to number of export document | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDAB | Allow NULL? |
| 49 | EXDTA | T document: Type of T document for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610VA | EXDTA | Allow NULL? |
| 50 | EXDT2 | T document: Official number of T document for foreign trade | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDT2 | Allow NULL? |
| 51 | EXDTB | T doc.: Official no. for next page of T doc. f.foreign trade | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDTB | Allow NULL? |
| 52 | EXDPA | Preference: Preference type for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610PA | EXDPA | Allow NULL? |
| 53 | EXPRE | Preference: Official number of preference document - Export | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXPRE | Allow NULL? |
| 54 | EXDT5 | CAP: Official number of T5 document for foreign trade | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDT5 | Allow NULL? |
| 55 | LADEL | Place of loading/unloading for foreign trade | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | LADEL | Allow NULL? |
| 56 | AUSFU | Exporter for import processing in foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | AUSFU | Allow NULL? |
| 57 | EIOKW | Status: Complete document data in foreign trade (user) | char | 1 | 0 | CHAR | (N' ') | Yes | | EIOKW | Allow NULL? |
| 58 | AUSOK | Status: Document data in foreign trade complete (system) | char | 1 | 0 | CHAR | (N' ') | Yes | | AUSOK | Allow NULL? |
| 59 | LAZL1 | Customs office: Country of customs office for foreign trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAZLS | Allow NULL? |
| 60 | LAZL2 | Customs office: Country of customs office for foreign trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAZLS | Allow NULL? |
| 61 | LAZL3 | Customs office: Country of customs office for foreign trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAZLS | Allow NULL? |
| 62 | LAZL4 | Customs office: Country of customs office for foreign trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAZLS | Allow NULL? |
| 63 | LAZL5 | Customs office: Country of customs office for foreign trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAZLS | Allow NULL? |
| 64 | LAZL6 | Customs office: Country of customs office for foreign trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAZLS | Allow NULL? |
| 65 | AZOLL | Customs office: Export customs office for foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T615 | AZOLL | Allow NULL? |
| 66 | AHBAS | Basis document category for foreign trade processing | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | AHBAS | Allow NULL? |
| 67 | REFNR | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELN | Allow NULL? |
| 68 | MABSD | Selection date for periodic declarations | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | MABSD | Allow NULL? |
| 69 | BFMAR | Foreign Trade: Type of means of transport | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T612B | BFMAR | Allow NULL? |
| 70 | CUDCL | Customs declaration type for customs processing in FT | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CUDCL | Allow NULL? |
