| 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 | GUID_LC_CUSMN | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | No | | /SAPSLL/GUID_16 | |
| 3 | GUID_LC_CUSB | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 4 | LAUNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | /SAPSLL/LAUNR | Allow NULL? |
| 5 | DATAB | "Valid From" Date for SAP GTS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPSLL/DATAB | Allow NULL? |
| 6 | MNMID | ID Number (External) for Customs Processing Measure | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MNMID | Allow NULL? |
| 7 | TLC_CUSBB | Calculation Base for Determination of Customs Tolls | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TLC_CUSBB | Allow NULL? |
| 8 | AMNT_CUR | Currency amount | decimal | 16 | 2 | CURR | ((0)) | Yes | | /SAPSLL/AMNT_CUR | |
| 9 | AMCUR | Currency of a Value | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | /SAPSLL/AMCUR | Allow NULL? |
| 10 | PUNIT | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPSLL/PUNIT | |
| 11 | DIMUM | Unit of Measurement of a Dimension | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | /SAPSLL/DIMUM | Allow NULL? |
| 12 | PROZ | Percentage (5 Places, 3 Decimal Places, No +/- Sign) | decimal | 8 | 3 | DEC | ((0)) | Yes | | /SAPSLL/PROZ | |
| 13 | CTSUOM | Supplementary Unit / Qualifier | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /SAPSLL/CTSUOM | Allow NULL? |
| 14 | STCTS | Numbering Scheme for Customs Tariff System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TCOTS | /SAPSLL/STCTS | Allow NULL? |
| 15 | CTYEX | Indicator: Country Exclusions Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CTYEX | Allow NULL? |
| 16 | CUSCX | Complex Toll Rate Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CUSCX | Allow NULL? |
| 17 | CRUL_EX | Customs Value Calculation: Calculation Rule for Customs Duty | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLC_CRUL | /SAPSLL/CUSCODE | Allow NULL? |
| 18 | CRULE | Calculation Rule for Customs Duty Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CRULE | Allow NULL? |
| 19 | TLC_AATY | Duty Category for Customs Processing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TLC_AATY | Allow NULL? |
| 20 | TLC_CUSADD | Tare Addition | decimal | 5 | 2 | DEC | ((0)) | Yes | | /SAPSLL/TLC_CUSADD | |
| 21 | TEXT1 | Text 60 Characters Long | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TEXT60 | Allow NULL? |
| 22 | TEXT2 | Text 60 Characters Long | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TEXT60 | Allow NULL? |
| 23 | TEXT3 | Text 60 Characters Long | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TEXT60 | Allow NULL? |
