| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID_LEGCUS | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 3 | POBJT | Type of Preceding Object | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | GUID_POBJ | Primary Key of Preceding Object | varbinary | 16 | 0 | | | | |
| 5 | LGREG | Legal Regulation | nvarchar | 5 | 0 | | | | Allow NULL? |
| 6 | CUPRO | Place into a Customs Status (Procedure) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | CSSTA | Customs Status of Good | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | TXSTA | Tax Status of Good | char | 1 | 0 | | | | Allow NULL? |
| 9 | DPAIP | Reserve Field | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | COLOC | Location of Goods / Place of Introduction | nvarchar | 35 | 0 | | | | Allow NULL? |
| 11 | PCLOC | Holding Location Key | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | PTCFL | Confirmation of Presentation to Customs | char | 1 | 0 | | | | Allow NULL? |
| 13 | SUSFL | Suppress Safekeeping Notification | char | 1 | 0 | | | | Allow NULL? |
| 14 | ERLTY | Completion Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | ADPRO | Additional Procedure | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | CCAFA | Concession Requested | nvarchar | 5 | 0 | | | | Allow NULL? |
| 17 | PCADR | Address Number of Entry in Address File | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | QUANT_FLT | Quantity as Floating Point Field | float | 15 | 16 | | | | |
| 19 | QUAUM | Unit of Measurement of a Dimension | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | CUBVAL_FLT | Customs Assement Base as Floating Point Field | float | 15 | 16 | | | | |
| 21 | CUAVAL_FLT | Customs Duty as Floating Point Field | float | 15 | 16 | | | | |
| 22 | CUCUR | Currency of a Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | EUBVAL_FLT | Assessment Base for EU Tax as Floating Point Field | float | 15 | 16 | | | | |
| 24 | EUAVAL_FLT | Duty - EU Tax as Floating Point Field | float | 15 | 16 | | | | |
| 25 | EUCUR | Currency of a Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 26 | STAVAL_FLT | Statistical Value as Floating Point Value | float | 15 | 16 | | | | |
| 27 | STCUR | Currency of a Value | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | QUADU_FLT | Customs Duty Quantity as Floating Point Field | float | 15 | 16 | | | | |
| 29 | CNVNF | Conversion Factor for Mapping External Unit of Measure | decimal | 7 | 0 | | | | |
| 30 | DIMDU | Unit of Measurement of a Dimension | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | CNVBA | Basis for Conversion of External Unit of Measure | nvarchar | 6 | 0 | | | | Allow NULL? |
| 32 | CTSUOM | Supplementary Unit / Qualifier | nvarchar | 12 | 0 | | | | Allow NULL? |
| 33 | CCNA1 | Additional Code 1 for Commodity Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | CCNA2 | Additional Code 2 for Commodity Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 35 | DANGO | Indicator for Goods Considered Dangerous | char | 1 | 0 | | | | Allow NULL? |
| 36 | DANNO | UNDG Dangerous Goods Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 37 | PYTRP | Payment Method for Transport Costs | char | 1 | 0 | | | | Allow NULL? |
| 38 | FLRET | Return Indicator | char | 1 | 0 | | | | Allow NULL? |
| 39 | FLANN | Instruction Indicator | char | 1 | 0 | | | | Allow NULL? |
| 40 | FLDSP | Release Indicator | char | 1 | 0 | | | | Allow NULL? |
| 41 | FLREC | Acceptance Indicator | char | 1 | 0 | | | | Allow NULL? |
| 42 | ERLTX | Completion Indicator (Tax Assessment) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 43 | FLSCD | Control Settings: Periodic Supplementary Customs Declaration | char | 1 | 0 | | | | Allow NULL? |
| 44 | VIDNO | Vehicle Identification Number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 45 | VATCAT | VAT Rate | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | WECMB | Constellation of Consignee | char | 1 | 0 | | | | Allow NULL? |
| 47 | FDACS | FDA Freight Storage Status | char | 1 | 0 | | | | Allow NULL? |
| 48 | FDATN | FDA Brand Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 49 | FDACP | FDA Country of Manufacture | nvarchar | 3 | 0 | | | | Allow NULL? |
| 50 | FDAQ1 | FDA Number of Packages | int | 10 | 0 | | | | Allow NULL? |
| 51 | FDAU1 | FDA Package Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | FDAQ2 | FDA Number of Packages | int | 10 | 0 | | | | Allow NULL? |
| 53 | FDAU2 | FDA Package Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 54 | FDAQ3 | FDA Number of Packages | int | 10 | 0 | | | | Allow NULL? |
| 55 | FDAU3 | FDA Package Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 56 | FDAQ4 | FDA Number of Packages | int | 10 | 0 | | | | Allow NULL? |
| 57 | FDAU4 | FDA Package Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | FDAQ5 | FDA Number of Packages | int | 10 | 0 | | | | Allow NULL? |
| 59 | FDAU5 | FDA Package Type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 60 | FDAQU | FDA Quantity | decimal | 19 | 3 | | | | |
| 61 | FDAUM | FDA Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 62 | FCCTN | FCC Brand Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 63 | FCCCN | FCC Import Condition | nvarchar | 2 | 0 | | | | Allow NULL? |
| 64 | FCCCA | FCC Import Condition: Quantity Allowance | char | 1 | 0 | | | | Allow NULL? |
| 65 | FCCID | FCC Identification | nvarchar | 20 | 0 | | | | Allow NULL? |
| 66 | FCCMN | FCC Type Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 67 | FCCWI | FCC Non-Publishing | char | 1 | 0 | | | | Allow NULL? |
| 68 | DOTCC | DOT Product Group | char | 1 | 0 | | | | Allow NULL? |
| 69 | DOTTN | DOT Brand Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 70 | DOTMO | DOT Model Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 71 | DOTVE | DOT Number of Certificate of Suitability | nvarchar | 20 | 0 | | | | Allow NULL? |
| 72 | DOTMV | DOT Manufacturer Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 73 | DOTYR | DOT Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 74 | MOBJT | Type of Main Object | char | 1 | 0 | | | | Allow NULL? |
| 75 | GUID_MOBJ | Primary Key of Main Object | varbinary | 16 | 0 | | | | |
| 76 | GUID_CUIT_REF | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | | | | |
| 77 | ADDDA0 | Additional Data for Unrestricted Use | char | 1 | 0 | | | | Allow NULL? |
