OBP_GLAUDIT_GLBALANCE
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ORASEGMENT1 | CHARACTER VARYING(20) | 20 |
| 2 | ORASEGMENT2 | CHARACTER VARYING(20) | 20 |
| 3 | ORASEGMENT3 | CHARACTER VARYING(20) | 20 |
| 4 | ORASEGMENT4 | CHARACTER VARYING(20) | 20 |
| 5 | ORASEGMENT5 | CHARACTER VARYING(20) | 20 |
| 6 | ORASEGMENT6 | CHARACTER VARYING(20) | 20 |
| 7 | ORASEGMENT7 | CHARACTER VARYING(20) | 20 |
| 8 | ORASEGMENT8 | CHARACTER VARYING(20) | 20 |
| 9 | ORASEGMENT9 | CHARACTER VARYING(20) | 20 |
| 10 | ORASEGMENT10 | CHARACTER VARYING(20) | 20 |
| 11 | ORASEGMENT11 | CHARACTER VARYING(20) | 20 |
| 12 | GST_CODE | CHARACTER VARYING(20) | 20 |
| 13 | ORACLE_SOURCE | CHARACTER VARYING(20) | 20 |
| 14 | ORACLE_BATCH_ID | CHARACTER VARYING(20) | 20 |
| 15 | ORACLE_SET_OF_BOOKS_ID | CHARACTER VARYING(10) | 10 |
| 16 | ORACLE_HEADER_ID | CHARACTER VARYING(20) | 20 |
| 17 | ORACLE_PERIOD | CHARACTER VARYING(15) | 15 |
| 18 | ORACLE_ACCOUNTING_DATE | TIMESTAMP | 8 |
| 19 | ORACLE_CURRENCY | CHARACTER VARYING(5) | 5 |
| 20 | ORACLE_CATEGORY | CHARACTER VARYING(20) | 20 |
| 21 | ORACLE_JOURNAL_LINE_NO | INTEGER | 4 |
| 22 | ORACLE_SUSPENSE_FLAG | CHARACTER VARYING(5) | 5 |
| 23 | ORACLE_SUSPENSE_MESSAGE | CHARACTER VARYING(50) | 50 |
| 24 | AMOUNT | NUMERIC(17,2) | 19 |
| 25 | ENTRY_ID | CHARACTER VARYING(200) | 200 |
| 26 | TRN_REFERENCE_CODE | CHARACTER VARYING(30) | 30 |
| 27 | TRN_EVENT_SEQ_NUM | INTEGER | 4 |
| 28 | TRN_SUB_SEQ_NUM | INTEGER | 4 |
| 29 | TRN_EVENT_CODE | CHARACTER VARYING(30) | 30 |
| 30 | TRN_CODE | CHARACTER VARYING(20) | 20 |
| 31 | TRN_DESC | CHARACTER VARYING(200) | 200 |
| 32 | TRN_BANK_CODE | BIGINT | 8 |
| 33 | TRN_BRANCH_CODE | BIGINT | 8 |
| 34 | BATCH_CODE | CHARACTER VARYING(15) | 15 |
| 35 | CURRENT_BATCH_NUM | INTEGER | 4 |
| 36 | USER_REFERENCE_CODE | CHARACTER VARYING(10) | 10 |
| 37 | CHANNEL_CODE | CHARACTER VARYING(50) | 50 |
| 38 | TRN_DATE | CHARACTER VARYING(30) | 30 |
| 39 | VALUE_DATE | CHARACTER VARYING(8) | 8 |
| 40 | POSTING_DATE | CHARACTER VARYING(8) | 8 |
| 41 | PROCESS_DATE | CHARACTER VARYING(8) | 8 |
| 42 | PARTY_CODE | CHARACTER VARYING(10) | 10 |
| 43 | PRODUCT_CODE | CHARACTER VARYING(20) | 20 |
| 44 | DOMAIN_CATEGORY | CHARACTER VARYING(5) | 5 |
| 45 | DR_CR_TYPE | CHARACTER VARYING(20) | 20 |
| 46 | ACCT_CODE | CHARACTER VARYING(20) | 20 |
| 47 | LEDGER_CODE | CHARACTER VARYING(20) | 20 |
| 48 | ACCT_BRANCH_CODE | CHARACTER VARYING(20) | 20 |
| 49 | ACCT_MODULE_TYP | CHARACTER VARYING(10) | 10 |
| 50 | ACCT_CCY_AMT | NUMERIC(17,2) | 19 |
| 51 | ACCT_CCY_CODE | CHARACTER VARYING(5) | 5 |
| 52 | LOCAL_CCY_AMT | NUMERIC(17,2) | 19 |
| 53 | LOCAL_CCY_CODE | CHARACTER VARYING(5) | 5 |
| 54 | ACCT_LOCAL_RATE | INTEGER | 4 |
| 55 | RELATED_ACCT_CODE | CHARACTER VARYING(20) | 20 |
| 56 | RELATED_MODULE_TYP | CHARACTER VARYING(5) | 5 |
| 57 | SYSTEM_ACCT_CODE | CHARACTER VARYING(50) | 50 |
| 58 | GAAP_CODE | CHARACTER VARYING(20) | 20 |
| 59 | FIN_CYCLE_CODE | CHARACTER VARYING(20) | 20 |
| 60 | PERIOD_CODE | CHARACTER VARYING(20) | 20 |
| 61 | AMOUNT_TAG_CODE | CHARACTER VARYING(50) | 50 |
| 62 | ACCT_LEDGER_TAG_CODE | CHARACTER VARYING(50) | 50 |
| 63 | INSTRUMENT_CODE | CHARACTER VARYING(20) | 20 |
| 64 | ACCT_PARTY_CODE | CHARACTER VARYING(20) | 20 |
| 65 | ACCT_PRODUCT_CODE | CHARACTER VARYING(20) | 20 |
| 66 | ACCT_STATUS | CHARACTER VARYING(20) | 20 |
| 67 | LEDGER_BAL_UPD_TYP | CHARACTER VARYING(20) | 20 |
| 68 | ORIGINAL_ENTRY_ID | CHARACTER VARYING(50) | 50 |
| 69 | ACCOUNTING_SUSPENSE_FLAG | CHARACTER VARYING(20) | 20 |
| 70 | AUTHORIZED_FLAG | CHARACTER VARYING(20) | 20 |
| 71 | BALANCING_REQUIRED_FLAG | CHARACTER VARYING(20) | 20 |
| 72 | MODULE_SUSPENSE_FLAG | CHARACTER VARYING(20) | 20 |
| 73 | DELETED_FLAG | CHARACTER VARYING(20) | 20 |
| 74 | INTER_BRANCH_FLAG | CHARACTER VARYING(20) | 20 |
| 75 | NETTING_REQUIRED_FLAG | CHARACTER VARYING(20) | 20 |
| 76 | REVERSAL_FLAG | CHARACTER VARYING(20) | 20 |
| 77 | ACCT_TRN_TYP | CHARACTER VARYING(20) | 20 |
| 78 | LEDGER_FLAG | CHARACTER VARYING(20) | 20 |
| 79 | ERROR_CODE | CHARACTER VARYING(20) | 20 |
| 80 | ERR_CODE_DESC | CHARACTER VARYING(30) | 30 |
| 81 | CREATED_BY | CHARACTER VARYING(20) | 20 |
| 82 | AUTHORIZED_BY | CHARACTER VARYING(20) | 20 |
| 83 | LIFE_CYCLE_ID | CHARACTER VARYING(20) | 20 |
| 84 | INSURANCE_POLICY_ID | CHARACTER VARYING(20) | 20 |
| 85 | BILLER_ID | CHARACTER VARYING(20) | 20 |
| 86 | REGN_ID | CHARACTER VARYING(20) | 20 |
| 87 | TRANSACTION_REQ_REF_CODE | CHARACTER VARYING(20) | 20 |
| 88 | TRANSACTION_RESP_REF_CODE | CHARACTER VARYING(20) | 20 |
| 89 | MC_SERIAL_NUMBER | CHARACTER VARYING(20) | 20 |
| 90 | OFFER_ID | CHARACTER VARYING(20) | 20 |
| 91 | RATE_TYPE | CHARACTER VARYING(20) | 20 |
| 92 | CORRELATION_ID | CHARACTER VARYING(20) | 20 |
| 93 | F_V_FLAG | CHARACTER VARYING(20) | 20 |
| 94 | PCD_ACCT_NBR | CHARACTER VARYING(20) | 20 |
| 95 | PCD_ACT_D | CHARACTER VARYING(20) | 20 |
| 96 | TRUST_ID | CHARACTER VARYING(20) | 20 |
| 97 | FIXED_VARIABLE_FLAG | CHARACTER VARYING(3) | 3 |
| 98 | COST_CENTRE | CHARACTER VARYING(7) | 7 |
| 99 | DEPARTMENT_ID | INTEGER | 4 |
| 100 | GL_TYPE_CODE | CHARACTER VARYING(15) | 15 |
| 101 | ABS_PRODUCT_CODE | CHARACTER VARYING(15) | 15 |
| 102 | LOAN_SYSTEM_FLAG | CHARACTER VARYING(7) | 7 |
| 103 | ID | BIGINT | 8 |
| 104 | DATA_DATE | TIMESTAMP | 8 |
| 105 | LOAD_ID | INTEGER | 4 |
| 106 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 107 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 108 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 109 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |