| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /FLDQ/AD_CHKSTAT | Table to temporarily hold the check status values | 60 | COUNTY | County | nvarchar | 40 | 0 | | |
2 | /FLDQ/HNACLNSOUT | DQM for SAP output table for transactional cleanse TASK | 61 | COUNTY | County | nvarchar | 40 | 0 | | |
3 | /FLDQ/HNACLNSTSK | DQM for SAP input table for transactional cleanse TASK | 61 | COUNTY | County | nvarchar | 40 | 0 | | |
4 | ADRCOUNTYT | County (long texts) | 6 | COUNTY | County | nvarchar | 40 | 0 | | |
5 | BBP_PCPOS | Procurement Card Statement: Position Data | 77 | COUNTY | County | nvarchar | 40 | 0 | | |
6 | BBP_TMP_ZA_ASP | Temporary: Request 'Bidder', Contact Addresses | 60 | COUNTY | County | nvarchar | 40 | 0 | | |
7 | BBP_TMP_ZA_ORG | Temporary: Request 'Bidder', Company Address | 60 | COUNTY | County | nvarchar | 40 | 0 | | |
8 | HRP1660 | DB Table for Infotype 1660 | 21 | COUNTY | Duty Station County | nvarchar | 3 | 0 | | |
9 | OIUX3_TX_LEASE_D | Tax Reporting - Texas Lease Description | 3 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
10 | PIQDB_DE_TRH | Transcript Header | 5 | COUNTY | County Code | nvarchar | 3 | 0 | | |
11 | T7PIQ_DE_COUNTY | Value Table for Counties | 4 | COUNTY | County Code | nvarchar | 3 | 0 | | |
12 | T7PIQ_DE_COUNTYT | Text Table for Counties | 5 | COUNTY | County Code | nvarchar | 3 | 0 | | |
13 | T7PIQ_DE_MTCNTPC | Mapping Table County to Postal Code | 3 | COUNTY | County Code | nvarchar | 3 | 0 | | |
14 | PIQDB_NL_ADDR | Maintain GBA Address | 62 | COUNTY | County | nvarchar | 40 | 0 | | |
15 | T7PIQ_GB_COUNTYM | GB: Mapping table SAP country & county codes to UCAS/HESA | 3 | COUNTY | Region (State, Province, County) | nvarchar | 3 | 0 | | |
16 | T7PIQ_GB_SCHOOL | UCAS: Schools | 31 | COUNTY | Description | nvarchar | 20 | 0 | | |
TOPAddress ManagementBusiness Address |
17 | ADRC | Addresses (Business Address Services) | 94 | COUNTY | County | nvarchar | 40 | 0 | | |
18 | ADRCS | Shadow Table: Addresses (Business Address Services) | 95 | COUNTY | County | nvarchar | 40 | 0 | | |
19 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 93 | COUNTY | County | nvarchar | 40 | 0 | | |
20 | SADR | Address Management: Company Data | 51 | COUNTY | County | nvarchar | 40 | 0 | | |
TOPClaims Management |
21 | ICLCCEVENTR | Claim Bundle - Region - Assignment | 6 | COUNTY | County Code | nvarchar | 3 | 0 | | |
22 | ICLLITITEM | Litigation Level | 19 | COUNTY | Venue: County | nvarchar | 3 | 0 | | |
23 | ICSCCEVENTR | Claim Bundle - Region - Assignment | 6 | COUNTY | County Code | nvarchar | 3 | 0 | | |
24 | ICSLITITEM | Litigation Levels | 19 | COUNTY | Venue: County | nvarchar | 3 | 0 | | |
TOPContract Accounts Receivable and Payable |
25 | FKKVKP | Contract Account Partner-Specific | 70 | COUNTY | County Code | nvarchar | 3 | 0 | | |
TOPGlobal Trade Services |
26 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 75 | COUNTY | County | nvarchar | 40 | 0 | | |
27 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 108 | COUNTY | County | nvarchar | 40 | 0 | | |
TOPLocalization |
28 | J_1BNFCPD | Nota Fiscal one-time accounts | 88 | COUNTY | County | nvarchar | 40 | 0 | | |
TOPMaster Data |
29 | EFISEL | Field Selection Control for Address Data | 70 | COUNTY | District (US: County) | nvarchar | 1 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
30 | TFICA_DEF | Samples for Contract Account Types | 45 | COUNTY | County Code | nvarchar | 3 | 0 | | |
TOPSales Promotions |
31 | SADLSTRECB | Dynamic Part of Address List (Record Body) | 49 | COUNTY | County | nvarchar | 40 | 0 | | |
TOPTax Reporting |
32 | OIUX3Y_TX_MASTER | Tax Reporting - Texas Master Data PPN | 13 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
33 | OIUX3_TX_CNTXRF | Tax Reporting - Texas County XRef | 1 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
34 | OIUX3_TX_MASTER | Tax Reporting - Texas Master Data | 12 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
35 | OIUX3_TX_OOSHST | Tax Reporting - Texas Out Of Statute Transaction History | 37 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
36 | OIUX3_TX_OOSTXN | Tax Reporting - Texas Out Of Statute Transactions | 37 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
37 | OIUX3_TX_PRDTB | Tax Reporting - Texas PRA Detail Txns-Tier Tax Below | 38 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
38 | OIUX3_TX_PRDTI | Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental | 38 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
39 | OIUX3_TX_PRDTN | Tax Reporting - Texas PRA Detail Txns - No Tier Tax | 38 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
40 | OIUX3_TX_RPGDT | Tax Reporting - Texas Gas Report Details | 7 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
41 | OIUX3_TX_RPGDTE | Tax Reporting - Texas Gas Report Details Errors | 7 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
42 | OIUX3_TX_RPODT | Tax Reporting - Texas Oil Report Details | 6 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
43 | OIUX3_TX_RPODTE | Tax Reporting - Texas Oil Report Details Errors | 6 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
44 | OIUX3_TX_TAXHST | Tax Reporting - Texas Tax History Transactions | 37 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
45 | OIUX3_TX_TAXSTG | Tax Reporting - Texas Tax Transaction Staging | 37 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
46 | OIUX3_TX_TAXTXN | Tax Reporting - Texas Tax Transactions | 37 | COUNTY | Texas County Identifier | nvarchar | 3 | 0 | | |
47 | OIUX5Y_OK_MASTER | Tax 2.0 - Oklahoma Master Data PPN | 15 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
48 | OIUX5_OK_CONFL | Tax 2.0 - Oklahoma Exempt Decimal Conflict | 6 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
49 | OIUX5_OK_MASTER | Tax 2.0 - Oklahoma Master Data | 14 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
50 | OIUX5_OK_OOSHST | Tax 2.0 - Oklahoma Out Of Statute Transactions History | 58 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
51 | OIUX5_OK_OOSTXN | Tax 2.0 - Oklahoma Out Of Statute Transactions | 58 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
52 | OIUX5_OK_PRDT | Tax 2.0 - Oklahoma PRA Detail Tax Transactions | 60 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
53 | OIUX5_OK_PRDTC | Tax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count | 62 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
54 | OIUX5_OK_RPDT | Tax 2.0 - Oklahoma Gross Prod Report Detail | 6 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
55 | OIUX5_OK_RPSM | Tax 2.0 - Oklahoma Gross Prod Report Summary | 6 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
56 | OIUX5_OK_TAXHST | Tax 2.0 - Oklahoma Tax Transactions History | 58 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
57 | OIUX5_OK_TAXHSTC | Tax 2.0 - Oklahoma Tax Transactions History Multi-Counties | 60 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
58 | OIUX5_OK_TAXSTG | Tax 2.0 - Oklahoma Tax Transactions Staging | 58 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
59 | OIUX5_OK_TAXTXN | Tax 2.0 - Oklahoma Tax Transactions | 58 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
60 | OIUX5_OK_TAXTXNC | Tax 2.0 - Oklahoma Tax Transactions Multiple Counties | 60 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
61 | OIUX5_OK_ZVOL | Tax 2.0 - Oklahoma Zero Volume Reporting Master | 5 | COUNTY | Tax 2.0 - Oklahoma County | nvarchar | 3 | 0 | | |
62 | OIUX6Y_WY_MASTER | Tax 2.0 - Wyoming Master Data PPN | 12 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
63 | OIUX6_WY_COOSHST | Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist | 30 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
64 | OIUX6_WY_COOSTXN | Tax 2.0 - Wyoming Out Of Statute Conservation Transactions | 30 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
65 | OIUX6_WY_CPRDT | Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions | 32 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
66 | OIUX6_WY_CTAXHST | Tax 2.0 - Wyoming Conservation Tax Transactions History | 30 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
67 | OIUX6_WY_CTAXSTG | Tax 2.0 - Wyoming Conservation Tax Transactions Staging | 30 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
68 | OIUX6_WY_CTAXTXN | Tax 2.0 - Wyoming Conservation Tax Transactions | 30 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
69 | OIUX6_WY_GTAXSTG | Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
70 | OIUX6_WY_GTAXTXN | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
71 | OIUX6_WY_MASTER | Tax 2.0 - Wyoming Master Data | 11 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
72 | OIUX6_WY_SOOSHST | Tax 2.0 - Wyoming Out Of Statute Severance Trans History | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
73 | OIUX6_WY_SOOSTXN | Tax 2.0 - Wyoming Out Of Statute Severance Transactions | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
74 | OIUX6_WY_SPRDT | Tax 2.0 - Wyoming Severance Tax PRA Detail Transactions | 52 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
75 | OIUX6_WY_SRPDTDT | Tax 2.0 - Wyoming Severance Tax Report Detail Detail | 8 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
76 | OIUX6_WY_STAXHST | Tax 2.0 - Wyoming Severance Tax Transactions History | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
77 | OIUX6_WY_STAXSTG | Tax 2.0 - Wyoming Severance Tax Transactions Staging | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
78 | OIUX6_WY_STAXTXN | Tax 2.0 - Wyoming Severance Tax Transactions | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
79 | OIUX7_WY_GTAX | Tax 2.0 - Wyoming Gross Prod Tax Transactions | 50 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
80 | OIUX7_WY_GTAXHST | Tax 2.0 - Wyoming Gross Prod Tax Transactions History | 49 | COUNTY | Tax 2.0 - Wyoming County Identifier | nvarchar | 3 | 0 | | |
TOPTransaction Tax Engine |
81 | TTED_ACQUISI_COM | Acquisition | 11 | COUNTY | County | nvarchar | 30 | 0 | | |
82 | TTED_PARTNER_COM | Partner | 17 | COUNTY | County | nvarchar | 30 | 0 | | |
83 | TTED_PARTN_O_COM | Partner in OutputDocument | 17 | COUNTY | County | nvarchar | 30 | 0 | | |
84 | TTEPD3_PARTNER | Partner | 16 | COUNTY | County | nvarchar | 30 | 0 | | |
85 | TTEPDT_ITEMPART | Persistency TTE Document item partner | 8 | COUNTY | County | nvarchar | 30 | 0 | | |
86 | TTEPDT_PARTNER | Persistency TTE Document business partner | 6 | COUNTY | County | nvarchar | 30 | 0 | | |
87 | TTESDT_ITEMPART | Document item partner | 8 | COUNTY | County | nvarchar | 30 | 0 | | |
88 | TTESDT_PARTNER | Document business partner | 6 | COUNTY | County | nvarchar | 30 | 0 | | |
TOPWaste Management |
89 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 70 | COUNTY | District (US: County) | nvarchar | 1 | 0 | | |
90 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 70 | COUNTY | District (US: County) | nvarchar | 1 | 0 | | |