| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPCustomer Master |
| 1 | CRMKTOKD | Assign Classification and Grouping R/3 Account Groups | 5 | EXT_RANGE | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
| TOPVendor Master |
| 2 | CRMKTOKK | Role Cat. and Grouping of R/3 Acct Group Assgmnt (for Later) | 5 | EXT_RANGE | Internal (' ') or external ('X') number range flag | nvarchar | 1 | 0 | | |
| TOPWork Clearance Management |
| 3 | WCCLV | WCM: Lineup | 7 | EXT_RANGE | Number Range for External Number Assignment | nvarchar | 2 | 0 | | |
| 4 | WCCO | WCM: WCM Object | 16 | EXT_RANGE | Number Range for External Number Assignment | nvarchar | 2 | 0 | | |
| 5 | WCCU | WCM: Use of Work Clearance Document | 21 | EXT_RANGE | Number Range for External Number Assignment | nvarchar | 2 | 0 | | |
| 6 | WCCX | WCM: Use of Work Approval | 6 | EXT_RANGE | Number Range for External Number Assignment | nvarchar | 2 | 0 | | |
| 7 | WCCY | WCM: Use of Application | 11 | EXT_RANGE | Number Range for External Number Assignment | nvarchar | 2 | 0 | | |
