| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BOE_PAY_ITEM | Payment item data table | 22 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
2 | COPC_RPR_VAR_VL | COPC: RPR variant value | 6 | PAYMENT_DATE | Expected Payment Value Date | nvarchar | 8 | 0 | | |
3 | DFKKPTSAFTPAYMTD | Portugal: SAF-T Payment Method | 4 | PAYMENT_DATE | Portugal: SAF-T date | nvarchar | 10 | 0 | | |
4 | JBRDBCOMBEWEG | RM: DB Table BEWEG Extended Category of Primary Transaction | 11 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
5 | JBRHCOMBEWEG | hRM: Version Table BEWEG for Extended Cat. of Primary Trans. | 12 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
6 | JBRSVCOMBEWEG | RM: Flow Table for Cat. of Prim. Trans. for Saved Datasets | 12 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
7 | J_3RF_CTS_I | Currency Transaction Statement Document Items | 12 | PAYMENT_DATE | Document Date in Document | nvarchar | 8 | 0 | | |
8 | T7BREFD_NRESIPAY | Payment to non-resident or resident abroad | 5 | PAYMENT_DATE | Payment date | nvarchar | 8 | 0 | | |
9 | T7BREFD_PAYBPF | Beneficiary natural person - resident in Brazil | 5 | PAYMENT_DATE | Payment date | nvarchar | 8 | 0 | | |
10 | T7BREFD_PAYBPJ | Framework table control | 5 | PAYMENT_DATE | Payment date | nvarchar | 8 | 0 | | |
11 | T7BREFD_PYPAY | Wage types that form employee remuneration | 5 | PAYMENT_DATE | Pay date for payroll result | nvarchar | 8 | 0 | | |
12 | T7INLOAN_TRNSDT | Loans Specific Data | 15 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
13 | TEXT_CTY_EXPOS | Commodity Price Exposure | 88 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
14 | THAEXT_EXPOS_COP | Obsolet: Commodity exposure pricing data | 10 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
15 | THAEXT_TRANS_COP | Commodity exposure pricing data | 11 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
16 | THAEXT_TRAN_DCSP | Commodity exposure DCS pricing data | 13 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
17 | FDM_INVOICE_MEM | Invoice Information Provided | 13 | PAYMENT_DATE | Date of Last Incoming Payment for Invoice | nvarchar | 8 | 0 | | |
TOPBack Office |
18 | TRFT_MAN_POST | Manual Posting | 8 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
19 | TRST_CLASFLO | CFM: Class Flows in Securities Account | 29 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
20 | TRST_CLASFLO_REV | CFM: Reversed Class Flows in Securities Account | 29 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
21 | TRST_POSCHG_FLOW | CFM: Flow for Securities Account Position Change | 19 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
TOPCross-Application Components |
22 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 15 | PAYMENT_DATE | Probable Payment Date (Cash Discount 1 Due) | nvarchar | 8 | 0 | | |
23 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 22 | PAYMENT_DATE | Probable Payment Date (Cash Discount 1 Due) | nvarchar | 8 | 0 | | |
TOPTransaction Management |
24 | TCHT_HD_BEWEG_CY | SFGDT Commodity Flows Table | 5 | PAYMENT_DATE | Payment or Delivery Date | nvarchar | 8 | 0 | | |
TOPTransaction Manager |
25 | FDC1 | Cash Management Shadow table | 9 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
26 | SLDT_FLOW | Subledger Distributor Transactions | 52 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
27 | TCORT_CODFL | Deal: Flows | 19 | PAYMENT_DATE | Payment or Delivery Date | nvarchar | 8 | 0 | | |
28 | TCORT_CODUL2FL | Deal: 2nd Underlying's Flows | 22 | PAYMENT_DATE | Payment or Delivery Date | nvarchar | 8 | 0 | | |
29 | TCORT_CODULFL | Deal: Underlying Flows | 21 | PAYMENT_DATE | Payment or Delivery Date | nvarchar | 8 | 0 | | |
30 | TERT_FLOW | Flow Table for Rights that can be Exercised | 18 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
31 | TEXT_POS_FLOW | Exposure Position Flows | 56 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
32 | TEXT_REXP_ITEM | Raw Exposure Item | 30 | PAYMENT_DATE | Date on which the Payment will be made | nvarchar | 8 | 0 | | |
33 | TRCT_FLOW | Table of business transactions flows | 14 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
34 | TRDT_FLOW | Persistent distributor flows | 50 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
TOPTransfer to Financial Accounting |
35 | TRACT_ACCITEM | Accounting Items | 22 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
36 | TRPRT_PAYMENTS | Persistent Data for Payment Requests | 15 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |
TOPTreasury and Risk Management |
37 | TREAT_FLOW | Treasury: TREA Flows | 40 | PAYMENT_DATE | Payment Date | nvarchar | 8 | 0 | | |