| 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 | EIKP | EXNUM | Allow NULL? |
| 3 | EXPOS | Internal item number for foreign trade data in MM and SD | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | EXPOS | Allow NULL? |
| 4 | STAWN | Commodity Code/Import Code Number for Foreign Trade | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | T604 | STAWN | Allow NULL? |
| 5 | EXPRF | Export/Import Procedure for Foreign Trade | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T616 | EXPRF | Allow NULL? |
| 6 | EXART | Business Transaction Type for Foreign Trade | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T605 | EXART | Allow NULL? |
| 7 | HERKL | Country of origin of the material | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | HERKL | Allow NULL? |
| 8 | HERKR | Region of origin of material (non-preferential origin) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | HERKR | Allow NULL? |
| 9 | GRWRT | Statistical value for foreign trade | decimal | 13 | 2 | CURR | ((0)) | Yes | | GRWRT | |
| 10 | PREFPACOD | Preference code for foreign trade (decl.to author., import) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T604C | PREFPACOD | Allow NULL? |
| 11 | SEGAL | Exclusion/Inclusion indicator for declara. to authorities | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T609A | SEGAL | Allow NULL? |
| 12 | MOWNR | CAP: Number of CAP products list | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | T618M | MOWNR | Allow NULL? |
| 13 | MOGRU | Common Agricultural Policy: CAP products group-Foreign Trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T618G | MOGRU | Allow NULL? |
| 14 | GPNUM | Production statistics: PRODCOM number for foreign trade | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | T609G | GPNUM | Allow NULL? |
| 15 | CASNR | CAS number for pharmaceutical products in foreign trade | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | T610C | CASNR | Allow NULL? |
| 16 | STEUC | Control code for consumption taxes in foreign trade | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | T604F | STEUC | Allow NULL? |
| 17 | WZOLL | Customs val. in doc.currency in imp.procg for foreign trade | decimal | 13 | 2 | CURR | ((0)) | Yes | | WZOLL | |
| 18 | VERLD | Country of dispatch for Foreign Trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | VERLD | Allow NULL? |
| 19 | HANLD | Trading country for foreign trade | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | HANLD | Allow NULL? |
| 20 | TEXT1 | Comments: Text for foreign trade processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXTFT | Allow NULL? |
| 21 | TEXT2 | Comments: Text for foreign trade processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXTFT | Allow NULL? |
| 22 | TEXT3 | Comments: Text for foreign trade processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | TXTFT | Allow NULL? |
| 23 | COKON | Customs quota code for import processing in foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T610K | COKON | Allow NULL? |
| 24 | COPHA | Pharmaceutical products code (Foreign Trade) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T610D | COPHA | Allow NULL? |
| 25 | COADI | Anti-dumping code for import processing in foreign trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T610A | COADI | Allow NULL? |
| 26 | PRONU | Invoice: Number of invoice document for import processing | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PRONU | Allow NULL? |
| 27 | PRODA | Invoice: Date of invoice document for import processing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRODA | Allow NULL? |
| 28 | VORPA | Preliminary document: Document type for foreign trade procg | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610VA | VORPA | Allow NULL? |
| 29 | VORNU | Preliminary document: No. of preliminary doc.f.import procg | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | VORNU | Allow NULL? |
| 30 | VORDA | Preliminary document: Date of preliminary doc.f.import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VORDA | Allow NULL? |
| 31 | BEHOE | Preliminary doc.: Issuing authority of relevant prelim.doc. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | VOHOE | Allow NULL? |
| 32 | KENNU | Preliminary document: Customs office/ID number for import | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | KENNU | Allow NULL? |
| 33 | VOISO | Prelim. doc.: ISO code of ctry issuing the preliminary doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | VOISO | Allow NULL? |
| 34 | PREFA | Preference: Preference type for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610PA | PREFA | Allow NULL? |
| 35 | PREFN | Preference: Official number of preference document - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | PREFN | Allow NULL? |
| 36 | PREDU | Preference: Date of preference document for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PREDU | Allow NULL? |
| 37 | PRISO | Preference: ISO code of country issuing the preference doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PRISO | Allow NULL? |
| 38 | PRHOE | Preference: Issuing authoritiy for relevant preference doc. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | PRHOE | Allow NULL? |
| 39 | PRUEL | Preference: Validity date of preference document for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRUEL | Allow NULL? |
| 40 | NACAR | Verification documents: Type of certificate for import | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610NA | NACAR | Allow NULL? |
| 41 | NACNU | Verification docs: Official no. of verific. doc. - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | NACNU | Allow NULL? |
| 42 | NACDA | Verification documents: Date of verif.doc. for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NACDA | Allow NULL? |
| 43 | NAISO | Verification doc: ISO code of ctry supplying verific.doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NAISO | Allow NULL? |
| 44 | NAHOE | Verification documents: Issuing authority for relev. verif. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | NAHOE | Allow NULL? |
| 45 | NAUEL | Verification docs: Validity date of verific.doc. for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NAUEL | Allow NULL? |
| 46 | NACA2 | Verification documents: Type of certificate for import | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610NA | NACAR | Allow NULL? |
| 47 | NACN2 | Verification docs: Official no. of verific. doc. - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | NACNU | Allow NULL? |
| 48 | NACD2 | Verification documents: Date of verif.doc. for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NACDA | Allow NULL? |
| 49 | NAIS2 | Verification doc: ISO code of ctry supplying verific.doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NAISO | Allow NULL? |
| 50 | NAHO2 | Verification documents: Issuing authority for relev. verif. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | NAHOE | Allow NULL? |
| 51 | NAUE2 | Verification docs: Validity date of verific.doc. for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NAUEL | Allow NULL? |
| 52 | NACA3 | Verification documents: Type of certificate for import | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610NA | NACAR | Allow NULL? |
| 53 | NACN3 | Verification docs: Official no. of verific. doc. - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | NACNU | Allow NULL? |
| 54 | NACD3 | Verification documents: Date of verif.doc. for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NACDA | Allow NULL? |
| 55 | NAIS3 | Verification doc: ISO code of ctry supplying verific.doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NAISO | Allow NULL? |
| 56 | NAHO3 | Verification documents: Issuing authority for relev. verif. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | NAHOE | Allow NULL? |
| 57 | NAUE3 | Verification docs: Validity date of verific.doc. for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NAUEL | Allow NULL? |
| 58 | NACA4 | Verification documents: Type of certificate for import | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610NA | NACAR | Allow NULL? |
| 59 | NACN4 | Verification docs: Official no. of verific. doc. - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | NACNU | Allow NULL? |
| 60 | NACD4 | Verification documents: Date of verif.doc. for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NACDA | Allow NULL? |
| 61 | NAIS4 | Verification doc: ISO code of ctry supplying verific.doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NAISO | Allow NULL? |
| 62 | NAHO4 | Verification documents: Issuing authority for relev. verif. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | NAHOE | Allow NULL? |
| 63 | NAUE4 | Verification docs: Validity date of verific.doc. for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NAUEL | Allow NULL? |
| 64 | NACA5 | Verification documents: Type of certificate for import | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610NA | NACAR | Allow NULL? |
| 65 | NACN5 | Verification docs: Official no. of verific. doc. - Import | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | NACNU | Allow NULL? |
| 66 | NACD5 | Verification documents: Date of verif.doc. for import procg | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NACDA | Allow NULL? |
| 67 | NAIS5 | Verification doc: ISO code of ctry supplying verific.doc. | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NAISO | Allow NULL? |
| 68 | NAHO5 | Verification documents: Issuing authority for relev. verif. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610O | NAHOE | Allow NULL? |
| 69 | NAUE5 | Verification docs: Validity date of verific.doc. for import | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | NAUEL | Allow NULL? |
| 70 | EXDAR | Export document: Export document type for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610VA | EXDAR | Allow NULL? |
| 71 | EXDAA | Export document: Official number of export document | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDAA | Allow NULL? |
| 72 | EXDAB | Export document: Valid-to number of export document | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDAB | Allow NULL? |
| 73 | EXDTA | T document: Type of T document for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610VA | EXDTA | Allow NULL? |
| 74 | EXDT2 | T document: Official number of T document for foreign trade | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDT2 | Allow NULL? |
| 75 | EXDTB | T doc.: Official no. for next page of T doc. f.foreign trade | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDTB | Allow NULL? |
| 76 | EXDPA | Preference: Preference type for foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610PA | EXDPA | Allow NULL? |
| 77 | EXPRE | Preference: Official number of preference document - Export | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXPRE | Allow NULL? |
| 78 | EXDT5 | CAP: Official number of T5 document for foreign trade | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | EXDT5 | Allow NULL? |
| 79 | AUSOK | Status: Document data in foreign trade complete (system) | char | 1 | 0 | CHAR | (N' ') | Yes | | AUSOK | Allow NULL? |
| 80 | COIMP | Code number for import processing in foreign trade | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | T604 | COIMP | Allow NULL? |
| 81 | HERSE | Manufacturer number for import processing in foreign trade | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | HERSE | Allow NULL? |
| 82 | COBLD | Import code no. in destination country for foreign trade | nvarchar | 17 | 0 | CHAR | (N' ') | Yes | T604 | COBLD | Allow NULL? |
| 83 | EIOKW | Status: Complete document data in foreign trade (user) | char | 1 | 0 | CHAR | (N' ') | Yes | | EIOKW | Allow NULL? |
| 84 | EIOKA | EDI: Export/Import customs tariff number for foreign trade | char | 1 | 0 | CHAR | (N' ') | Yes | | EIOKA | Allow NULL? |
| 85 | GBNUM | Foreign Trade:Customs declaration list no. for Foreign Trade | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | GB_NR | Allow NULL? |
| 86 | RGNNR | Registration number for import processing in foreign trade | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RG_NR | Allow NULL? |
| 87 | PRENC | Exemption certificate: Indicator for legal control | char | 1 | 0 | CHAR | (N' ') | Yes | | PRENC | Allow NULL? |
| 88 | PRENO | Exemption certificate number for legal control | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PRENN | Allow NULL? |
| 89 | PREND | Exemption certificate: Issue date of exemption certificate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PREND | Allow NULL? |
| 90 | KTNUM | Quota or Ceiling Number for Import Processing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610KP | KTPLN | Allow NULL? |
| 91 | PLNUM | Quota or Ceiling Number for Import Processing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T610KP | KTPLN | Allow NULL? |
| 92 | POSAR | Item type | char | 1 | 0 | CHAR | (N' ') | Yes | | POSAR | Allow NULL? |
| 93 | PSTYV | Sales document item category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PSTYV | Allow NULL? |
