| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | DFKK_ACCADJ | Adjustment Postings when Implementing Acct Assgmt Chars | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
2 | DFKK_NEWACCADJ | Obsolete: See DFKK_ACCADJ | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
3 | T706_CITYCD_CHG | Replacement/Combination of Community Code Numbers, Date-Dep. | 3 | KEY_DATE | End Date | nvarchar | 8 | 0 | | |
4 | TRCCT_CURRCHANGE | Currency changeover | 5 | KEY_DATE | Currency Changeover Key Date | nvarchar | 8 | 0 | | |
5 | VIXCITCADAO | Temporary architectural object data | 3 | KEY_DATE | Date | nvarchar | 8 | 0 | | |
6 | VIXCITCADLOG | Logging table for Splitting/Merging of Cadaster Data | 3 | KEY_DATE | Processing Date | nvarchar | 8 | 0 | | |
7 | VIXCITCADMSR | Temporary measurement data | 3 | KEY_DATE | Date | nvarchar | 8 | 0 | | |
8 | VIXCITCADRO | Temporary rental object data | 3 | KEY_DATE | Date | nvarchar | 8 | 0 | | |
9 | PIQPROC_DH | Activity Documents: Document Header | 5 | KEY_DATE | Activity Key Date (General) | nvarchar | 8 | 0 | | |
TOPBank Customer Accounts |
10 | BKKSO | BCA: Standing Orders | 10 | KEY_DATE | Key date | nvarchar | 2 | 0 | | |
TOPContract Accounts Receivable and Payable |
11 | DFKK_BALANOTE | Balance Confirmation - Check Table | 11 | KEY_DATE | Key Date for Balance Notification | nvarchar | 8 | 0 | | |
12 | DFKK_DUEGRID | OI - Reclassifications | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
13 | DFKK_HBALANOTE | Balance Confirmation - Run Table | 5 | KEY_DATE | Key Date for Balance Notification | nvarchar | 8 | 0 | | |
14 | DFKK_RECLASS | OI - Reclassifications | 2 | KEY_DATE | Key Date for Analysis of Open Items | nvarchar | 8 | 0 | | |
TOPElectronic Data Interchange |
15 | WRF_PRICAT_TRIG | Price Catalog Inbound: Trigger Table for Scheduled Data | 5 | KEY_DATE | Primary Update Date Set Online | nvarchar | 8 | 0 | | |
TOPInterestCharge Calculation |
16 | BKKM2 | Account Time Periods | 7 | KEY_DATE | Key date | nvarchar | 2 | 0 | | |
TOPJapan |
17 | PTJPFWS_ITEMDATA | (Obsolete) Request Item Data for Flexible Work Schedule JP | 10 | KEY_DATE | Start Date | nvarchar | 8 | 0 | | |
18 | T7JPCP_FORMSPC | Define Form Specification | 8 | KEY_DATE | Key Date for Data Retrieving | nvarchar | 2 | 0 | | |
19 | TPTJPFWS_ITEMDAT | Request Item Data for Flexible Work Schedule JP | 9 | KEY_DATE | Start Date | nvarchar | 8 | 0 | | |
TOPPosition Budgeting and Control |
20 | HRFPM_COLUMN_CON | Buffer for Columns in HRPBCM | 9 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
21 | DFMCA_BRF400 | BRF : Parameters for Facts of Property Tax | 11 | KEY_DATE | BRF: Key Date for Property Tax | nvarchar | 20 | 0 | | |
TOPTransaction Manager |
22 | IDCFM_DATA_SEC | Valuation-Area-Independent Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
23 | IDCFM_FRIM_DATA | Impairment Main Data | 10 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
24 | IDCFM_FRIM_DEXP | Impairment: BAdI Example Values: Expected & Expert Values | 10 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
25 | TRDTT_DATA_ADMIN | Legacy Data Transfer Admin. Entries Business Transactions | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
26 | TRDTT_DATA_SEC | Valuation-Area-Independent Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
27 | TRDTT_IGTDATA_SE | Intragroup Transaction (IGT) Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
28 | TRDTT_VADATA_FUT | Valuation-Area-Dependent Data for Futures | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
29 | TRDTT_VADATA_OTC | Valuation-Area-Dependent Data for MM, FX, OTC Derivatives. | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
30 | TRDTT_VADATA_SEC | Valuation-Area-Dependent Data for Securities | 2 | KEY_DATE | Position Value Date | nvarchar | 8 | 0 | | |
31 | TRGC_MIGR2 | Migration: Key Date of Data Transfer per Company Code | 3 | KEY_DATE | Migration: Key Date of Data Transfer | nvarchar | 8 | 0 | | |
32 | TRLIT_AD_MIGRATE | Accrual/Deferral: Log Data of Migration to EP 2: | 7 | KEY_DATE | Accrual/Deferral Key Date | nvarchar | 8 | 0 | | |
33 | TRLIT_AD_TRANS | Accrual/Deferral Business Transactions (Documentation avail) | 9 | KEY_DATE | End of Calculation Period | nvarchar | 8 | 0 | | |
34 | TWSPV | Security Prices for Special Valuation | 5 | KEY_DATE | Field of type DATS | nvarchar | 8 | 0 | | |
TOPTransfer to Financial Accounting |
35 | TLVT_MANUAL_VAL | Book Values for Manual Valuation of Positions | 2 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
36 | TRILT_DTRANS | Derived Business Transactions in the Income Ledger | 8 | KEY_DATE | Date of a Business Transaction in the Income Ledger | nvarchar | 8 | 0 | | |
37 | TRLT_INIT_IGT_SE | Initialization Values for Intragroup Transactions | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
38 | TRLT_INIT_TRANS | List of Initializing Business Transactions | 13 | KEY_DATE | Treasury Ledger Date | nvarchar | 8 | 0 | | |
39 | TRLT_INIT_VAL_FU | Initialization Values for TRL Futures Positions | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
40 | TRLT_INIT_VAL_HR | Init.Hedging Rel.:Mapping to Hedging Rel.in New Company Code | 9 | KEY_DATE | Treasury Ledger Date | nvarchar | 8 | 0 | | |
41 | TRLT_INIT_VAL_LO | Initialization Values for TRL Positions: Loans | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
42 | TRLT_INIT_VAL_SE | Initialization Values for TRL Positions: Securities | 2 | KEY_DATE | System Date | nvarchar | 8 | 0 | | |
43 | VALT_SP_VAL_SEC | Security Prices and NPV for Special Valuation | 10 | KEY_DATE | Key Date for Valuation | nvarchar | 8 | 0 | | |
TOPTranslation Tools |
44 | LXE_DURA | Problem Messages | 3 | KEY_DATE | Date of Last Change | nvarchar | 8 | 0 | | |