| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdvertising Management |
| 1 | JHAGVZ | IS-M/AM: Order Sales Agent Assignment | 28 | VANR | IS-M: Extra commission/exclusion | nvarchar | 5 | 0 | | |
| 2 | JJTVA | Incl/Exclusive Sales Agt Requirements for Entire Sales Area | 5 | VANR | IS-M: Extra commission/exclusion | nvarchar | 5 | 0 | | |
| TOPBasic Data |
| 3 | NC00 | IS-HCM Dispatch Log File | 9 | VANR | IS-HCM: Dispatch Order Number | nvarchar | 8 | 0 | | |
| 4 | NC01 | IS-HCM Dispatch Orders to HCM | 3 | VANR | IS-HCM: Dispatch Message Number | nvarchar | 10 | 0 | | |
| 5 | NC02 | IS-HCM Messages Ready-to-Send | 8 | VANR | IS-HCM: Dispatch Order Number | nvarchar | 8 | 0 | | |
