| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKK_PE_DB_ITEM | Store Asynchronous Posting Response for Items | 8 | DATE_VALUE | Value Date | nvarchar | 8 | 0 | | |
TOPBank Customer Accounts |
2 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 20 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
TOPCommon Functions |
3 | INM_M_OBJ_MET_VA | Metrics Values | 10 | DATE_VALUE | Field of type DATS | nvarchar | 8 | 0 | | |
TOPCondition |
4 | BKK92 | Account Balancing (Interest and Charges) | 13 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
5 | BKK97 | Acct Balancing: Posting Data (Temporary Data)(for Deletion) | 13 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
TOPDistributor-Reseller-Management |
6 | /SAPHT/DRMRLSR | DRM Rule : Simple Rule | 13 | DATE_VALUE | DRM Rule : Date Value | nvarchar | 8 | 0 | | |
TOPGL transfer |
7 | BKKCNOITGL | Table of Items not Updated on the Account | 9 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
8 | BKKITGL | Gen. Ledger: Payment Item Data | 9 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
TOPMaster Data |
9 | BKK62_CC | Value Date Transaction Figures for Cash Concentration | 5 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
TOPPayment Item |
10 | BKKIT | Payment Item | 20 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
11 | BKKITAI | Info Items for Interest Penalty at Balancing | 7 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
12 | BKKITENQ | Blocked Payment Items | 20 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
13 | BKKITREL | Payment Item | 20 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
14 | BKKITRETREL | Payment Item Return to be released | 8 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
15 | BKKITTMP | Planned Payment Items | 21 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
16 | BKKITTMP_DEL | Planned Payment Items - Completed | 21 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
17 | BKKPAYMEX_IT | EFT Management: Items in Outgoing Payment Transactions | 34 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
18 | BKKPAYMIN_IT | Table of Imported Items | 15 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
TOPPayment Order |
19 | BKKPOIT | Item in Payment Order | 20 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
20 | BKKPOIT_TMP | Items in Planned Payment Order | 21 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
21 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 19 | DATE_VALUE | Value date | nvarchar | 8 | 0 | | |
TOPSocial Services and Social Security |
22 | PSSCD_SXP_APPT | SXP Appointment | 5 | DATE_VALUE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | |
TOPWorkforce Management Application |
23 | WFAC_WKRLDFLTN_D | Work Rules Default | 9 | DATE_VALUE | Date | nvarchar | 8 | 0 | | |
24 | WFAC_WKRLVALUE | Work Rule Value | 7 | DATE_VALUE | Date | nvarchar | 8 | 0 | | |
25 | WFAC_WKRL_DEF | Default Work Rules Definitions | 9 | DATE_VALUE | Date | nvarchar | 8 | 0 | | |
26 | WFAC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 8 | DATE_VALUE | Date | nvarchar | 8 | 0 | | |
27 | WFA_WRKRLST_V | Work Rule Set Values Master Data | 7 | DATE_VALUE | Date | nvarchar | 8 | 0 | | |
TOPWorkforce Management Core |
28 | WFMCAS_WRKRLST_V | Work Rule Set Values Master Data | 7 | DATE_VALUE | Date Value | nvarchar | 8 | 0 | | |
29 | WFMC_WKRLDFLTN_D | Work Rules Default | 9 | DATE_VALUE | Date Value | nvarchar | 8 | 0 | | |
30 | WFMC_WKRLVALUE | Work Rule Value | 7 | DATE_VALUE | Date Value | nvarchar | 8 | 0 | | |
31 | WFMC_WKRL_DEF | Default Work Rules Definitions | 9 | DATE_VALUE | Date Value | nvarchar | 8 | 0 | | |
32 | WFMC_WKRL_DFLT | Default Work Rules (Out of Use for Retail) | 8 | DATE_VALUE | Date Value | nvarchar | 8 | 0 | | |
33 | WFMC_WKRL_VALUE | Work Rule Value (out of use for Retail) | 7 | DATE_VALUE | Date Value | nvarchar | 8 | 0 | | |