| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBack Office |
1 | TRFT_FLOW | Treasury: Table with TRF Flows | 8 | FLOW_CAT | Flow Category - Listed Options and Futures | nvarchar | 3 | 0 | | |
TOPFSCM In-House Cash |
2 | IHC_DB_CL_ACCTS | Account Determination for AMS Update | 6 | FLOW_CAT | Credit/Debit Indicator | nvarchar | 1 | 0 | | |
3 | IHC_DB_CL_TYPES | Technical Settings for AMS Update | 5 | FLOW_CAT | Credit/Debit Indicator | nvarchar | 1 | 0 | | |
4 | IHC_DB_TOVR | Provisional Turnover (Based on Value Date, aft.Posting Date) | 7 | FLOW_CAT | Credit/Debit Indicator | nvarchar | 1 | 0 | | |
5 | IHC_DB_TOVR_ENQ | Provisional Turnover (Based on Value Date, aft.Posting Date) | 6 | FLOW_CAT | Credit/Debit Indicator | nvarchar | 1 | 0 | | |
6 | IHC_TAB_APM_TT | Automatic Payments: Determine IHC Transaction Type | 4 | FLOW_CAT | Indicator: Bank Transfer/Debit Memo | nvarchar | 1 | 0 | | |
7 | IHC_TAB_XBS_TT | IHC: Transaction Type External Inbound Payment | 5 | FLOW_CAT | Credit/Debit Indicator | nvarchar | 1 | 0 | | |
TOPTransaction Manager |
8 | TEXTS_FLOWCAT | Flow categories | 1 | FLOW_CAT | Exposure flow category | nvarchar | 3 | 0 | | |
9 | TEXTS_FLOWCAT_T | Flow category texts | 2 | FLOW_CAT | Exposure flow category | nvarchar | 3 | 0 | | |
10 | TEXT_POS_FLOW | Exposure Position Flows | 51 | FLOW_CAT | Exposure flow category | nvarchar | 3 | 0 | | |