| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /MRE/RSC_ORD_DET | Sales Order Profile Details | 3 | TRAN_TYPE | Sales Document Type | nvarchar | 4 | 0 | | |
| 2 | J_3RF_TP_LIST1B | Information of Notification. List 1B | 9 | TRAN_TYPE | Type of Transaction Subject (020) | nvarchar | 1 | 0 | | |
| 3 | PIQDB_GB_SEQ_EX | UCAS: Student extract information from sequence files | 4 | TRAN_TYPE | UCAS: Transaction type | nvarchar | 2 | 0 | | |
| TOPDistributor-Reseller-Management |
| 4 | S495 | Transmission Report | 7 | TRAN_TYPE | DRM relevant processing code | nvarchar | 2 | 0 | | |
| 5 | S495E | S495 - Structural information | 7 | TRAN_TYPE | DRM relevant processing code | nvarchar | 2 | 0 | | |
| TOPLocalization |
| 6 | TRAN_TYPE_IT | Assign Transaction Type | 6 | TRAN_TYPE | Transaction type (Sales/Purchase) | nvarchar | 1 | 0 | | |
| TOPTariffs, Duties and Permits |
| 7 | OIH_J1B_SSTAD | Brazil tax: Determines Accounts for posting Split of S. T. | 3 | TRAN_TYPE | Transaction type (sales, purchase, transf. in, transf. out) | nvarchar | 2 | 0 | | |
| TOPTransaction Manager |
| 8 | IDCFM_BST_HIST | History table for balance sheet transfer for Brazil | 10 | TRAN_TYPE | Type of Balance Sheet Transfer: principal, valuation | nvarchar | 1 | 0 | | |
| 9 | TRXT_WT_ASSIGN | TRM Withholding Tax Information Assignment | 5 | TRAN_TYPE | Financial Transaction Type | nvarchar | 3 | 0 | | |
