| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBusiness Package for Manager Self-Service FI |
1 | FPB_LP_ITEM_T | Text for Reports | 5 | VER_NO | Business Document Service: Document version number | nvarchar | 8 | 0 | | |
TOPCheck Input |
2 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 177 | VER_NO | Version Number | decimal | 5 | 0 | | |
3 | OIUCI_PDX | Purchaser DOI Cross Reference | 24 | VER_NO | Version No | decimal | 5 | 0 | | |
TOPRevenue |
4 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 178 | VER_NO | Version Number | decimal | 5 | 0 | | |
5 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 176 | VER_NO | Version Number | decimal | 5 | 0 | | |
6 | OIUH_RV_JEINTF | PRA Journal Entries | 177 | VER_NO | Version Number | decimal | 5 | 0 | | |
TOPRoyalty Reporting |
7 | OIUREP_ADJ_DTLA | MMS OGOR A Adjustment Detail Record | 9 | VER_NO | Version Number | int | 10 | 0 | | |
8 | OIUREP_ADJ_DTLB | MMS OGOR B Adjustment Detail Record | 9 | VER_NO | Version Number | int | 10 | 0 | | |
9 | OIUREP_ADJ_DTLC | MMS OGOR C Adjustment Detail Record | 9 | VER_NO | Version Number | int | 10 | 0 | | |
10 | OIUREP_ADJ_HDR | Adjustment Header for MMS OGOR | 17 | VER_NO | Version Number | int | 10 | 0 | | |
11 | OIUREP_ADJ_PASR | MMS PASR Adjustment Detail Record | 9 | VER_NO | Version Number | int | 10 | 0 | | |
12 | OIUREP_ADJ_PASRH | MMS PASR Adjustment Header Record | 10 | VER_NO | Version Number | int | 10 | 0 | | |
13 | OIUREP_RWC | WCs that have been changed since previous report run | 11 | VER_NO | Version Number | int | 10 | 0 | | |
TOPSales |
14 | /CBAD/CONTRACT_H | Advanced Order Processing and Billing: Header Data | 3 | VER_NO | Version Number | nvarchar | 6 | 0 | | |
15 | /CBAD/CONTRACT_I | Advanced Order Processing and Billing: Item Data | 4 | VER_NO | Version Number | nvarchar | 6 | 0 | | |
16 | /CBAD/CON_DBS | Advanced Order Processing and Billing: DBS Item Data | 5 | VER_NO | Version Number | nvarchar | 6 | 0 | | |
17 | /CBAD/CON_FUND_H | Advanced Order Processing and Billing: Fund Header Data | 4 | VER_NO | Version Number | nvarchar | 6 | 0 | | |
TOPSAP Records Management |
18 | SRMALVER | GDMA SP AL - Version and Variant Management | 7 | VER_NO | | nvarchar | 8 | 0 | | |
TOPValuation |
19 | OIURV_CRH_HST | Combined Run Header History | 121 | VER_NO | OIUH_DEC5 | decimal | 5 | 0 | | |
20 | OIURV_DOC_COT | VL Document Chain Of Title | 25 | VER_NO | OIUH_DEC5 | decimal | 5 | 0 | | |
21 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 179 | VER_NO | Version Number | decimal | 5 | 0 | | |
22 | OIURV_DOC_MMSPOP | Dual Accounting MMS/POP | 14 | VER_NO | OIUH_DEC5 | decimal | 5 | 0 | | |
23 | OIURV_DOC_OOBJE | Out Of Balance JEs | 25 | VER_NO | OIUH_DEC5 | decimal | 5 | 0 | | |
24 | OIURV_DUAL_COMP | Dual Accounting Compare | 16 | VER_NO | OIUH_DEC5 | decimal | 5 | 0 | | |
25 | OIURV_DUAL_JEBR | Dual Accounting JE Backout / Rebook | 23 | VER_NO | OIUH_DEC5 | decimal | 5 | 0 | | |