| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinancial Accounting |
1 | FERC_L1 | Message log | 4 | RUN_NO | Number of runs of regulatory procedure | nvarchar | 3 | 0 | | |
TOPInventory Accounting |
2 | UAINVREVCOH | Header Table for Tracking the Revaluation Runs | 2 | RUN_NO | Number of Revaluation Run | nvarchar | 20 | 0 | | |
TOPMaster Data |
3 | BKKOVR_ACCNT | Item Table: Accounts with Tolerated Overdraft | 2 | RUN_NO | Number of the Monitoring Run for Tolerated Overdraft | nvarchar | 8 | 0 | | |
4 | BKKOVR_HD | Header Table Administration Accts with Tolerated Overdraft | 2 | RUN_NO | Number of the Monitoring Run for Tolerated Overdraft | nvarchar | 8 | 0 | | |
TOPPayment Item |
5 | BKKPAYMEX_HD | Header Table of EFT Management: Outgoing Payt Transactions | 3 | RUN_NO | Sequential Number of a File | nvarchar | 5 | 0 | | |
6 | BKKPAYMIN_HD | Header Table of EFT Management Imported Items | 3 | RUN_NO | Sequential Number of a File | nvarchar | 5 | 0 | | |
7 | BKKPAYMIN_IT | Table of Imported Items | 3 | RUN_NO | Sequential Number of a File | nvarchar | 5 | 0 | | |
8 | BKKPAYMIN_PYNOT | BCA: Table of Payment Notes | 3 | RUN_NO | Sequential Number of a File | nvarchar | 5 | 0 | | |
9 | TBKK_CLEAR_REL | Assignment: Bank Key to Clearing Center ID | 4 | RUN_NO | Sequence number | nvarchar | 6 | 0 | | |
10 | TBKK_TXTKEY_DE | Assignment: Text Key -> Transaction Type | 4 | RUN_NO | Sequential Number in Text Key Maintenance | nvarchar | 5 | 0 | | |
TOPPrice Planning Workbench |
11 | WRF_PPW_PPDMDP | PPD Markdown Set | 11 | RUN_NO | Run Number | varbinary | 16 | 0 | | |
12 | WRF_PPW_WORKLERR | PPW Worklist Error Table | 26 | RUN_NO | Run Number | varbinary | 16 | 0 | | |
13 | WRF_PPW_WORKLIST | PPW Worklist | 27 | RUN_NO | Run Number | varbinary | 16 | 0 | | |