| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPMedia Sales and Distribution |
1 | /NAM/TJKAPPL_OFR | Application Access for Renewal Offers | 9 | RATE_CODE | IS-M/SD: Rate Code | nvarchar | 4 | 0 | | |
2 | /NAM/TJKOFF_DATA | Renewal Offer Code Data | 6 | RATE_CODE | IS-M/SD: Rate Code | nvarchar | 4 | 0 | | |
TOPPeriodical Sales and Distribution |
3 | JITCIRCBOOK | IS-M/SD: Circulation Book with Delivery Quantities | 16 | RATE_CODE | IS-M/SD: Rate Code | nvarchar | 4 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
4 | TFMCA_PT_TAXCOND | Customizing for Tax Conditions (Property Tax) | 5 | RATE_CODE | Rate Code | nvarchar | 4 | 0 | | |
5 | TFMCA_PT_TAXRATE | Customizing of Tax Rates (Property Tax) | 2 | RATE_CODE | Rate Code | nvarchar | 4 | 0 | | |
6 | TFMCA_PT_TAXR_T | Customizing of Tax Rates (text) | 3 | RATE_CODE | Rate Code | nvarchar | 4 | 0 | | |
TOPTax Reporting |
7 | OIUX6_WY_GTAXSTG | Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
8 | OIUX6_WY_GTAXTXN | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
9 | OIUX6_WY_RATE_CD | Tax 2.0 - Wyoming Rate Codes | 1 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
10 | OIUX6_WY_SOOSHST | Tax 2.0 - Wyoming Out Of Statute Severance Trans History | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
11 | OIUX6_WY_SOOSTXN | Tax 2.0 - Wyoming Out Of Statute Severance Transactions | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
12 | OIUX6_WY_SPRDT | Tax 2.0 - Wyoming Severance Tax PRA Detail Transactions | 63 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
13 | OIUX6_WY_SRPDT | Tax 2.0 - Wyoming Severance Tax Report Detail | 7 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
14 | OIUX6_WY_SRPDTDT | Tax 2.0 - Wyoming Severance Tax Report Detail Detail | 7 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
15 | OIUX6_WY_SRPDT_H | Tax 2.0 - Wyoming Severance Tax Report Detail | 7 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
16 | OIUX6_WY_STAXHST | Tax 2.0 - Wyoming Severance Tax Transactions History | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
17 | OIUX6_WY_STAXSTG | Tax 2.0 - Wyoming Severance Tax Transactions Staging | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
18 | OIUX6_WY_STAXTXN | Tax 2.0 - Wyoming Severance Tax Transactions | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
19 | OIUX6_WY_STAX_RT | Tax 2.0 - Wyoming Severance Rate Codes | 2 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
20 | OIUX6_WY_TXCLRC | Tax 2.0 - Wyoming Tax Class Rate Code XRef | 3 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
21 | OIUX6_WY_ZVOL | Tax 2.0 - Wyoming Zero Volume Reporting Master | 5 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
22 | OIUX7_WY_GTAX | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 61 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
23 | OIUX7_WY_GTAXHST | Tax 2.0 - Wyoming Gross Prod Tax Transactions History | 60 | RATE_CODE | Tax 2.0 - Wyoming Rate Code | nvarchar | 3 | 0 | | |
TOPTravel Planning |
24 | FTPT_CAR | Travel Request Item - Car Rental Service | 29 | RATE_CODE | Rental Car Rate Key (Provider-Dependent) | nvarchar | 12 | 0 | | |
25 | FTPT_HOTEL | Travel Request Item - Hotel Service | 24 | RATE_CODE | Hotel Rate Category | nvarchar | 3 | 0 | | |
26 | FTPT_QT_CAR | Quicktrip Travel Request Item - Flight Service | 19 | RATE_CODE | | nvarchar | 20 | 0 | | |
27 | FTPT_QT_HOTEL | Quicktrip Travel Request Item - Flight Service | 16 | RATE_CODE | Hotel Rate Category | nvarchar | 3 | 0 | | |