| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIUX8_NM_OOSWO | Tax 2.0 - New Mexico Out Of Statute Write Off | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
2 | OIUY3_TX_INTSTG | Royalty 2.0 - TX GLO - Royalty Trans Interface Staging | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
3 | OIUY3_TX_INTTXN | Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
4 | OIUY3_TX_OOSWO | Royalty 2.0 - Texas GLO Out Of Statute Write Off | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
5 | OIUY6_WY_INTSTG | Royalty 2.0 - WY - Royalty Transaction Interface (Staging) | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
6 | OIUY6_WY_INTTXN | Royalty 2.0 - WY - Royalty Transaction Interface | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
7 | OIUY6_WY_OOSWO | Royalty 2.0 - Wyoming Out Of Statute Write Off | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
TOPCheck Input |
8 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
TOPCheck Write |
9 | OIUCW_EXTD | Extended Details from Payment Run | 14 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
TOPFinancial Supply Chain Management |
10 | BNK_XSTAT_TX | Status: Transaction Information | 13 | BTCH_NO | Batch Identification Number | nvarchar | 10 | 0 | | |
TOPRevenue |
11 | OIUE1_LSSL_SUM | Legal Suspense Summary | 16 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
12 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 17 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
13 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 17 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
14 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 17 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
15 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
16 | OIUE2_RUN_JE | Proc 2.0 - Process Run JE Batch Info | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
17 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
18 | OIUH_RV_JEINTF | PRA Journal Entries | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
19 | OIU_RV_CMKT | Check Detail Marketing Deductions | 4 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
TOPTax Reporting |
20 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
21 | OIUX3_RUN_JE | Tax Reporting - Report Run JE Batch Info | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
22 | OIUX3_TX_OOSWO | Tax Reporting - Texas Out Of Statute Write Off | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
23 | OIUX5_OOSWO | Tax 2.0 - Out Of Statute Write Off | 7 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
24 | OIUX6_WY_OOSWO | Tax 2.0 - Wyoming Out Of Statute Write Off | 5 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
TOPValuation |
25 | OIURV_DOC_BCN | Revenue Document Concept - Batch Control Number | 8 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |
26 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 6 | BTCH_NO | Batch ID | nvarchar | 4 | 0 | | |