| 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_LEGCULCR | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | No | | /SAPSLL/GUID_16 | |
| 3 | GUID_CUHDR | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | /SAPSLL/CUHDR | /SAPSLL/GUID_16 | |
| 4 | GUID_LEGCULC | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | Yes | /SAPSLL/LEGCULC | /SAPSLL/GUID_16 | |
| 5 | TLC_AART | Type of Duty for Customs Processing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | /SAPSLL/TLC_AART | Allow NULL? |
| 6 | VALTY | Type of Value for Customs Declaration | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/VALTY | Allow NULL? |
| 7 | TLC_AATY | Duty Category for Customs Processing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/TLC_AATY | Allow NULL? |
| 8 | AMNT_ORI | Amount in Original Currency | decimal | 16 | 2 | CURR | ((0)) | Yes | | /SAPSLL/AMNT_ORI | |
| 9 | CUR_ORI | Currency of a Value | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPSLL/AMCUR | Allow NULL? |
| 10 | AMNT_CUS | Amount in Customs Currency | decimal | 16 | 2 | CURR | ((0)) | Yes | | /SAPSLL/AMNT_CUS | |
| 11 | CUR_CUS | Currency of a Value | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPSLL/AMCUR | Allow NULL? |
| 12 | AMNT_CUR | Currency amount | decimal | 16 | 2 | CURR | ((0)) | Yes | | /SAPSLL/AMNT_CUR | |
| 13 | AMCUR | Currency of a Value | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | /SAPSLL/AMCUR | Allow NULL? |
| 14 | PUNIT | Price Unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | /SAPSLL/PUNIT | |
| 15 | PROZ | Percentage (5 Places, 3 Decimal Places, No +/- Sign) | decimal | 8 | 3 | DEC | ((0)) | Yes | | /SAPSLL/PROZ | |
| 16 | CTSUOM | Supplementary Unit / Qualifier | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /SAPSLL/CTSUOM | Allow NULL? |
| 17 | CRULE | Calculation Rule for Customs Duty Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CRULE | Allow NULL? |