| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CCEE/FISC_CROA | Fiscalization Croatia: Fiscalized documents | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
2 | /CCEE/FISC_NUMBR | Fiscalization Croatia: Number Range Number Assignment | 5 | FISCAL_YEAR | To fiscal year | nvarchar | 4 | 0 | | |
3 | /OPT/VT_DOC_HEA1 | Document Header - copy of /opt/vt_doc_head | 13 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
4 | /OPT/VT_DOC_HEAD | Document Header | 13 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
5 | /OPT/X149 | OPENTEXT: Approval Diagnostic data | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
6 | /OPT/Y149 | OPENTEXT: Approval Diagnostic data | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
7 | /OPT/Z149 | OPENTEXT: Approval Diagnostic data | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
8 | /ORS/DIAGNOSTICS | OPENTEXT: Approval Diagnostic data | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
9 | /SAPPSSRM/THRESL | Thresholds | 7 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
10 | EPIC_CBC | EPIC:Cash budgeting control consumption table | 3 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
11 | J_1UF_TAX_MAIN | Tax Declaration and Clarification Declaration | 7 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
12 | T7CLCERTIFNBR | Employee Income Certificate number assignment | 2 | FISCAL_YEAR | Year | nvarchar | 4 | 0 | | |
13 | T7UNPF_FI_OPRHD | Operation Header | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPAccounting Interface |
14 | GLE_ECS_BAL | ECS+GL Balances by Company Code, Account, Fiscal Year, Crcy | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
15 | GLE_ECS_BAL_ITEM | GL open items that are not in ECS | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
16 | GLE_ECS_ITEM | ECS: Error Correction Items | 8 | FISCAL_YEAR | Fiscal Year of Posted Document | nvarchar | 4 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
17 | FDM_INVOICE_MEM | Invoice Information Provided | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
18 | FDM_INV_MEM_OBS | Invoice Information Provided Obsolete | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPBudgeting and Availability Control |
19 | GMBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 5 | FISCAL_YEAR | Fiscal Year of Grantee Organization | nvarchar | 4 | 0 | | |
20 | GMHBDGTFYDLINE | GM Budgeting Fiscal Year Distribution Lines | 6 | FISCAL_YEAR | Fiscal Year of Grantee Organization | nvarchar | 4 | 0 | | |
TOPBusiness Package for Manager Self-Service FI |
21 | FCOM_WHERE_USED | Usage of Master Data Objects | 12 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
22 | /OPT/S_GR_HDR | VSS Staging Table: GR Header | 6 | FISCAL_YEAR | Material Document Year | nvarchar | 4 | 0 | | |
23 | /OPT/S_GR_LIN | VSS Stageing Table: GR Line | 7 | FISCAL_YEAR | Material Document Year | nvarchar | 4 | 0 | | |
24 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 7 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
25 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 8 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
26 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
27 | /OPT/VIM_HD_NPO | VIM IE Monitor: Header Data for Parked NPO Invoices | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
28 | /OPT/VIM_HD_PO | VIM IE Monitor: Header Data for Parked PO Invoices | 3 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
29 | /OPT/VIM_NPO_WID | VIM IE Monitortable: WI Header Data for NPO Invoices | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
30 | /OPT/VIM_NPO_WIH | VIM IE Monitortable: WI Header Data for NPO Invoices | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
31 | /OPT/VIM_PO_WID | VIM Report: WI Header Data for PO Invoices | 3 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
32 | /OPT/VIM_PO_WIH | VIM Report: WI Header Data for PO Invoices | 3 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPFunctions for U.S. Federal Government |
33 | FMFG_ABP | Parameters for Automatic Budget Postings Functionality | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
34 | FMFG_ABP_HDR_DEF | ABP Budget Entry Document default attributes | 3 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPInformation System |
35 | FTI_BI_REP_ODS | Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW | 27 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPTransaction Management |
36 | TCHT_HD_SFGDT | SFGDT Representation of Instruments | 14 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
37 | THXET_MEAS_HEAD | Effectiveness Test Results | 4 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
38 | THXT_HINST | Hedge Instrument | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
39 | THXT_HITEM | Hedge Item DB table | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
40 | THXT_HREL | Hedging Relationship | 6 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
41 | TRDTT_DATSUB_ADM | Legacy Data Trnsfr: Admin., Designation of Subposition | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
42 | TRDTT_DES_ADMIN | LDT: Admin. of Bus.Trans.Designation in Hedging Relationship | 3 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
43 | TRDTT_VAD_FUTSUB | Valuation Area-Dependent Data for Futures with Subpositions | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
44 | TRDTT_VAD_OTCSUB | Val.Area-Dependent Data for MM, FX, OTC Deriv. w. Subpos. | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
45 | TRDTT_VAD_SECSUB | Valuation Area-Dependent Data for Securities w. Subpositions | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
TOPTransfer to Financial Accounting |
46 | TLVT_VAL_STEP | Treasury: Valuation Step | 10 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
47 | TRLT_BACKUPVORAB | Backup Flow Table from Preliminary Solution - Pos. Mgmt Sol. | 29 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
48 | TRLT_INIT_DES | Init.Hedging Relationship: Bus.Trans.Mgmt, Designation | 3 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
49 | TRLT_INIT_SUB_OT | Init.Hedging Rel.: Data for MM, FX, OTC Deriv.with Subpos. | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
50 | TRLT_INIT_SUB_SE | Init.Hedging Relationship for Securities with Subpositions | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |
51 | TRLT_INIT_SUB_TR | Init.Hedging Rel.: Bus.Trans.Mgmnt, Designation Subpositions | 5 | FISCAL_YEAR | Fiscal Year | nvarchar | 4 | 0 | | |