| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TBKKSEPA_ORD | Customizing for ordering party SEPA | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
2 | TBKKSEPA_RCV | Recipient party oriented Customizing for SEPA | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPAssetLiability Management |
3 | TTD_FLOW_MAP | Time Deposit to Treasury Flow Map | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPBank Customer Accounts |
4 | BCA_US_BKK_TD | BCA: Time deposit account data | 11 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
5 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 35 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
6 | BKKSO | BCA: Standing Orders | 6 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
7 | TBCA_US_DEA_DED | Cross Reference Escheat Deduction Codes | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
8 | TBCA_US_DEA_DEDT | Deduction Codes Text Description | 5 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
9 | TBCA_US_TRAN_SEQ | Overdraft transaction priority sequence for Products | 5 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
10 | TBKKSOAUTH | Amount Authorization/Dual Control Standing Order | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPCondition |
11 | BKK97 | Acct Balancing: Posting Data (Temporary Data)(for Deletion) | 24 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
12 | TBKK8B | Categorization Transaction Types (Item Counter) | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
13 | TBKK8L | Assignment Transaction Type Category (Diff.Type) | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
14 | TBKK8L2 | Assignment Transaction Type Category 2 (Diff. Type) | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPFSCM In-House Cash |
15 | IHC_DB_CL_TYPES | Technical Settings for AMS Update | 9 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPGL transfer |
16 | BKKCNOITGL | Table of Items not Updated on the Account | 17 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
17 | TBKKCTTP | Assignment PT Transaction Type / GL Transaction | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPInterestCharge Calculation |
18 | TBKKM3 | Assignment Posting Categories <-> Medium/Transaction Types | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
19 | TBKKM4 | Assignment Trans. Type -> Business Transaction Code | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPMaster Data |
20 | BKK43 | BCA: Reference Accounts | 17 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPPayment Item |
21 | BKKIT | Payment Item | 35 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
22 | BKKITAI | Info Items for Interest Penalty at Balancing | 15 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
23 | BKKITENQ | Blocked Payment Items | 35 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
24 | BKKITPRE | Parked Payment Items | 10 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
25 | BKKITREL | Payment Item | 35 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
26 | BKKITRETREL | Payment Item Return to be released | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
27 | BKKITTMP | Planned Payment Items | 36 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
28 | BKKITTMP_DEL | Planned Payment Items - Completed | 36 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
29 | BKKPAYMEX_IT | EFT Management: Items in Outgoing Payment Transactions | 29 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
30 | BKKPAYMIN_IT | Table of Imported Items | 24 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
31 | TBKKG3_TERM | Transaction Type Customizing for Term Objects | 5 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
32 | TBKKIAUTH | Amount Authorization/Dual Control Payment Items | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
33 | TBKKICTR | Amount Authorization/Dual Control Payment Items | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
34 | TBKKIDF | BCA: Defaults for Transaction | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
35 | TBKK_TRNSTYPE_DE | Assignment Transaction Type -> Text Key | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
36 | TBKK_TXTKEY_DE | Assignment: Text Key -> Transaction Type | 7 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
37 | TBKK_VALDAT_TOL | Tolerance Days for Value Dts in Incoming Payment Trans.(DTA) | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPPayment Order |
38 | BKKPOIT | Item in Payment Order | 16 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
39 | BKKPOIT_TMP | Items in Planned Payment Order | 17 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
40 | BKKPOIT_TMP_DEL | Items in Planned Payment Order | 15 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
41 | TBKKOAUTH | Amount Authorization/Dual Control Payment Order | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
42 | TBKKOCTR | Amount Authorization/Dual Control Payment Order | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
TOPProduct definition |
43 | TBKKG3 | Transaction types | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
44 | TBKKG31 | Return Reason, Assigned Transaction Types | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
45 | TBKKG31T | Return Reason | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
46 | TBKKG32 | Transaction Type Offsetting Posting Inter. Initiated PT | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
47 | TBKKG33 | Transaction Types: Notification of Returns | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
48 | TBKKG34 | Transaction Types: Payment Notes for Returns | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
49 | TBKKG34K | Transaction Types: Payment Notes for Returns W/o Sequ.No. | 2 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
50 | TBKKG34P | Payment Notes for Returns, Text Symbols for SAPscript | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
51 | TBKKG3T | Text Table for Transaction Types | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
52 | TBKKG3_TCODE | Assignment Activity to Transaction Type | 3 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
53 | TBKKG5 | Assignment Functions Group - Medium, Transaction Type | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |
54 | TBKKG7 | Assignment Blocking Reason - Medium, Transaction Type | 4 | TRNSTYPE | Transaction Type | nvarchar | 4 | 0 | | |