| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000173000 | PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal. | 37 | BALANCE | | decimal | 17 | 0 | | |
2 | /BIC/B0000174000 | PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs | 39 | BALANCE | | decimal | 17 | 0 | | |
3 | /BIC/B0000175000 | PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q) | 39 | BALANCE | | decimal | 17 | 0 | | |
4 | BOE_PLE_ITEM | Pledge item data table of BoE management | 23 | BALANCE | Pledge Balance | decimal | 13 | 2 | | |
5 | DIAN_A_1008_07 | Cached Data of DIAN Format 1003 version 07 | 18 | BALANCE | Account receivables balance | decimal | 22 | 2 | | |
6 | DIAN_A_1009_07 | Cached Data of DIAN Format 1009 version 07 | 18 | BALANCE | Account payables balance | decimal | 22 | 2 | | |
7 | EPIC_DUM_BAL | Balance of Dummy Bank | 6 | BALANCE | Amount in document currency | decimal | 13 | 2 | | |
8 | EPIC_DUM_TRANSAC | Transactions of Dummy Bank | 12 | BALANCE | Amount in document currency | decimal | 13 | 2 | | |
9 | EPIC_EBR_BAL | Bank Account Balance by Bank Receipt | 6 | BALANCE | Bank Account Balance on Bank Receipt | decimal | 13 | 2 | | |
10 | EPIC_EBR_FEB | Additional Data on Bank Statement Line Item for Bank Receipt | 22 | BALANCE | Bank Account Balance on Bank Receipt | decimal | 13 | 2 | | |
11 | EPIC_EBR_HDR | OBSOLETE!!! | 39 | BALANCE | Bank Account Balance on Bank Receipt | decimal | 13 | 2 | | |
12 | P2UN_EGRT | NPO: EG Internal summary structure | 41 | BALANCE | EG Advance Balance | decimal | 10 | 2 | | |
13 | VIXCITCADAO | Temporary architectural object data | 120 | BALANCE | Balance | decimal | 15 | 2 | | |
14 | VIXCITTASIDATA | TASI master data | 19 | BALANCE | Balance | decimal | 15 | 2 | | |
TOPBank Customer Accounts |
15 | BCA_US_DEA_ESCH | Escheat Accounts Data | 8 | BALANCE | Account balance | decimal | 23 | 2 | | |
TOPBrazil |
16 | T7BRCO5 | Compensation balance of GSW | 11 | BALANCE | Balance | decimal | 13 | 2 | | |
TOPChina |
17 | T7CN3F | Reported Tax Data | 22 | BALANCE | tax report banlance to next month | decimal | 15 | 2 | | |
TOPCondition |
18 | BKK92 | Account Balancing (Interest and Charges) | 28 | BALANCE | Balance | decimal | 23 | 2 | | |
19 | BKK9A | Posting and Value Date Balances Carried Forward | 9 | BALANCE | Balance | decimal | 23 | 2 | | |
TOPFlexible Real Estate Management |
20 | VIXCITICIDATA | ICI master data | 30 | BALANCE | Balance | decimal | 15 | 2 | | |
TOPGeneral Ledger Accounting |
21 | FAGL_BW_LOG_ITEM | FI-GL: Log for BW Extraction: Line Items | 62 | BALANCE | Accumulated balance | decimal | 17 | 2 | | |
22 | FAGL_BW_LOG_TOTL | FI-GL: Log for BW Extraction: Totals Records | 40 | BALANCE | Accumulated balance | decimal | 17 | 2 | | |
23 | FAGL_QUEUE_LOG | Log of Delta Queue for Error Analysis | 39 | BALANCE | Accumulated balance | decimal | 17 | 2 | | |
24 | T8G40 | Account assignment objects for document splitting | 4 | BALANCE | Create zero balance for account assignment object | nvarchar | 1 | 0 | | |
TOPInterestCharge Calculation |
25 | BKKMBALNOT | BCA: Balance Notification Data | 6 | BALANCE | Balance Shown in the Balance Notification (Account Currency) | decimal | 23 | 2 | | |
TOPItaly |
26 | T5ITIN1 | Contribution INAIL table | 9 | BALANCE | INAIL: Balance Amount | decimal | 15 | 2 | | |
TOPJoint Venture und Production Sharing Accounting |
27 | T8JK | Accounts for posting exchange differences | 6 | BALANCE | Account for balance sheet | nvarchar | 10 | 0 | | |
TOPLocalization |
28 | RFCASH_HU | Exchange rate calculation log (Hungary) | 8 | BALANCE | Cash Journal Amount Field with +/- Sign | decimal | 15 | 2 | | |
TOPMaster Data |
29 | BKK50 | Account balance | 4 | BALANCE | Account balance | decimal | 23 | 2 | | |
30 | BKK54 | Account Balance of Hierarchies | 6 | BALANCE | Account balance | decimal | 23 | 2 | | |
31 | BKKOVR_ACCNT | Item Table: Accounts with Tolerated Overdraft | 17 | BALANCE | Account balance | decimal | 23 | 2 | | |
TOPProcess Controls |
32 | GRPC_ACCOUNT_GRP | Account Group Scoping Info. | 8 | BALANCE | Balance Value | decimal | 15 | 2 | | |
TOPRisk Analysis |
33 | JBRACCOUNT | RM BP Update Administration for Account Balances | 3 | BALANCE | Acct balance | decimal | 17 | 2 | | |
34 | JBRAMOUNT | RM: Account Balance Summarization in Base Portfolio | 7 | BALANCE | Acct balance | decimal | 17 | 2 | | |
TOPTraders and Schedulers Workbench |
35 | OIJBRDH | RD header f.batch:Don't use(obsolete) & don't delete(XPRA) | 88 | BALANCE | Indicator to supress balance quantities in Stock Projection | nvarchar | 1 | 0 | | |
36 | OIJLOCMAT | OIL-TSW: Location Rundown/Planning material table | 77 | BALANCE | Indicator to supress balance quantities in Stock Projection | nvarchar | 1 | 0 | | |
37 | OIJRDH | Rundown header: Don't use (obsolete) & don't delete (XPRA) | 87 | BALANCE | Indicator to supress balance quantities in Stock Projection | nvarchar | 1 | 0 | | |
38 | OIJTSMAT | OIL-TSW: TS Rundown/Planning material table | 76 | BALANCE | Indicator to supress balance quantities in Stock Projection | nvarchar | 1 | 0 | | |
39 | OIJ_RDHEAD | Stock Projection header | 90 | BALANCE | Indicator to supress balance quantities in Stock Projection | nvarchar | 1 | 0 | | |