| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000164000 | PSA for 0FI_AP_20 T90CLNT090 Vendor Balances | 12 | FISCVAR | | nvarchar | 2 | 0 | | |
2 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 18 | FISCVAR | | nvarchar | 2 | 0 | | |
3 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 18 | FISCVAR | | nvarchar | 2 | 0 | | |
4 | /BIC/B0000167000 | PSA for 0FI_AR_20 T90CLNT090 Customer Balances | 12 | FISCVAR | | nvarchar | 2 | 0 | | |
5 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 120 | FISCVAR | | nvarchar | 2 | 0 | | |
6 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 120 | FISCVAR | | nvarchar | 2 | 0 | | |
7 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 16 | FISCVAR | | nvarchar | 2 | 0 | | |
8 | /BIC/B0000171000 | PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances | 30 | FISCVAR | | nvarchar | 2 | 0 | | |
9 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 171 | FISCVAR | | nvarchar | 2 | 0 | | |
10 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 32 | FISCVAR | | nvarchar | 2 | 0 | | |
11 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 34 | FISCVAR | | nvarchar | 2 | 0 | | |
12 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 34 | FISCVAR | | nvarchar | 2 | 0 | | |
13 | /BIC/B0000218000 | PSA for 0CO_OM_OPA_1 T90CLNT090 Orders: Costs | 5 | FISCVAR | | nvarchar | 2 | 0 | | |
14 | /BIC/B0000219000 | PSA for 0CO_OM_OPA_3 T90CLNT090 Orders: Total plan | 5 | FISCVAR | | nvarchar | 2 | 0 | | |
15 | /BIC/B0000220000 | PSA for 0CO_OM_OPA_4 T90CLNT090 Orders: Statist. KFs | 5 | FISCVAR | | nvarchar | 2 | 0 | | |
16 | /BIC/B0000221000 | PSA for 0CO_OM_OPA_2 T90CLNT090 Orders: Budget | 5 | FISCVAR | | nvarchar | 2 | 0 | | |
17 | /BIC/B0000222000 | PSA for 0CO_OM_OPA_5 T90CLNT090 Orders: Selections | 5 | FISCVAR | | nvarchar | 2 | 0 | | |
18 | /BIC/B0000223000 | PSA for 0CO_OM_OPA_6 T90CLNT090 Orders: ActCostDelta | 8 | FISCVAR | | nvarchar | 2 | 0 | | |
TOPGeneral Ledger Accounting |
19 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 57 | FISCVAR | Fiscal year variant | nvarchar | 2 | 0 | | |
20 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 35 | FISCVAR | Fiscal year variant | nvarchar | 2 | 0 | | |
21 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 34 | FISCVAR | Fiscal year variant | nvarchar | 2 | 0 | | |