| 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_CUSB2 | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | No | | /SAPSLL/GUID_16 | |
| 3 | TLC_AART | Type of Duty for Customs Processing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLC_AAR | /SAPSLL/TLC_AART | Allow NULL? |
| 4 | LGREG | Legal Regulation | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | /SAPSLL/T606G | /SAPSLL/LGREG | Allow NULL? |
| 5 | GUID_HTSNUM | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/GUID_16 | |
| 6 | CTYGR_OO | Country of Origin Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/CTYGP | /SAPSLL/CTYGR_OO | Allow NULL? |
| 7 | CUCOO | Custom Product's Country of Origin | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | /SAPSLL/CUCOO | Allow NULL? |
| 8 | PRFNW | Type of Preference Document for Customs Processing | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/PRFNW | Allow NULL? |
| 9 | MNMID | ID Number (External) for Customs Processing Measure | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MNMID20 | Allow NULL? |
| 10 | DATBI | "Valid To" Date for SAP GTS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPSLL/DATBI | Allow NULL? |
| 11 | DATAB | "Valid From" Date for SAP GTS | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /SAPSLL/DATAB | Allow NULL? |
| 12 | TLC_CUSBB | Calculation Base for Determination of Customs Tolls | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TLC_CUSBB | Allow NULL? |
| 13 | AMNT_CUR | Currency amount | decimal | 16 | 2 | CURR | ((0)) | Yes | | /SAPSLL/AMNT_CUR | |
| 14 | AMCUR | Currency of a Value | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | /SAPSLL/AMCUR | Allow NULL? |
| 15 | PUNIT | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPSLL/PUNIT | |
| 16 | DIMUM | Unit of Measurement of a Dimension | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | /SAPSLL/DIMUM | Allow NULL? |
| 17 | PROZ | Percentage (5 Places, 3 Decimal Places, No +/- Sign) | decimal | 8 | 3 | DEC | ((0)) | Yes | | /SAPSLL/PROZ | |
| 18 | CTSUOM | Supplementary Unit / Qualifier | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /SAPSLL/CTSUOM | Allow NULL? |
| 19 | STCTS | Numbering Scheme for Customs Tariff System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TCOTS | /SAPSLL/STCTS | Allow NULL? |
| 20 | CTYEX | Indicator: Country Exclusions Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CTYEX | Allow NULL? |
| 21 | CUSCX | Complex Toll Rate Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CUSCX | Allow NULL? |
| 22 | CRUL_EX | Customs Value Calculation: Calculation Rule for Customs Duty | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TLC_CRUL | /SAPSLL/CUSCODE | Allow NULL? |
| 23 | CRULE | Calculation Rule for Customs Duty Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CRULE | Allow NULL? |
| 24 | TLC_AATY | Duty Category for Customs Processing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TLC_AATY | Allow NULL? |
| 25 | TLC_CUSADD | Tare Addition | decimal | 5 | 2 | DEC | ((0)) | Yes | | /SAPSLL/TLC_CUSADD | |
| 26 | TEXT1 | Text 60 Characters Long | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TEXT60 | Allow NULL? |
| 27 | TEXT2 | Text 60 Characters Long | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TEXT60 | Allow NULL? |
| 28 | TEXT3 | Text 60 Characters Long | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TEXT60 | Allow NULL? |
| 29 | ERNAM | Name of User Who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | /SAPSLL/ERNAM | Allow NULL? |
| 30 | CRTSP | UTC Time Stamp When Object Was Added | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPSLL/CRTSP | |
| 31 | AENAM | Name of User Who Changed the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | /SAPSLL/AENAM | Allow NULL? |
| 32 | CHTSP | UTC Time Stamp When Object Was Changed | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPSLL/CHTSP | |
