OCH24_S_ASSET
Description
Synonyms
SDSNZP05_BANK..CBP_OCH_S_ASSET
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ROW_ID | CHARACTER VARYING(15) | 15 |
| 2 | CREATED | TIMESTAMP | 8 |
| 3 | CREATED_BY | CHARACTER VARYING(15) | 15 |
| 4 | LAST_UPD | TIMESTAMP | 8 |
| 5 | LAST_UPD_BY | CHARACTER VARYING(15) | 15 |
| 6 | MODIFICATION_NUM | BIGINT | 8 |
| 7 | CONFLICT_ID | CHARACTER VARYING(15) | 15 |
| 8 | ASSET_NUM | CHARACTER VARYING(100) | 100 |
| 9 | AUTO_SR_FLG | CHARACTER(1) | 1 |
| 10 | BU_ID | CHARACTER VARYING(15) | 15 |
| 11 | COMP_UND_WRNTY_FLG | CHARACTER(1) | 1 |
| 12 | CUSTOMIZABLE_FLG | CHARACTER(1) | 1 |
| 13 | DMNDNG_DR_FLG | CHARACTER(1) | 1 |
| 14 | FLEET_FLG | CHARACTER(1) | 1 |
| 15 | HH_CONSUMED_FLG | CHARACTER(1) | 1 |
| 16 | PROD_UND_WRNTY_FLG | CHARACTER(1) | 1 |
| 17 | REFERENCEABLE_FLG | CHARACTER(1) | 1 |
| 18 | SRL_NUM_VRFD_FLG | CHARACTER(1) | 1 |
| 19 | TEST_ASSET_FLG | CHARACTER(1) | 1 |
| 20 | UND_MFG_WRNTY_FLG | CHARACTER(1) | 1 |
| 21 | BILLPAY_FLG | CHARACTER(1) | 1 |
| 22 | ALT_FUEL_FLG | CHARACTER(1) | 1 |
| 23 | ANNUAL_REVN | NUMERIC(22,7) | 19 |
| 24 | ANNUAL_USG | NUMERIC(22,7) | 19 |
| 25 | APR | NUMERIC(22,7) | 19 |
| 26 | APY | NUMERIC(22,7) | 19 |
| 27 | ARCHIVE_FLG | CHARACTER(1) | 1 |
| 28 | ASGN_DT | TIMESTAMP | 8 |
| 29 | ASGN_USR_EXCLD_FLG | CHARACTER(1) | 1 |
| 30 | ASSET_VALUE_AMT | NUMERIC(22,7) | 19 |
| 31 | ASSET_VAL_EXCH_DT | TIMESTAMP | 8 |
| 32 | AVAIL_BAL | NUMERIC(22,7) | 19 |
| 33 | AVERAGE_BAL | NUMERIC(22,7) | 19 |
| 34 | CAPACITY | NUMERIC(22,7) | 19 |
| 35 | CAUTION_FLG | CHARACTER(1) | 1 |
| 36 | CFG_VALDN_STAT_DT | TIMESTAMP | 8 |
| 37 | CURRENT_BAL | NUMERIC(22,7) | 19 |
| 38 | CUTOFF_FLG | CHARACTER(1) | 1 |
| 39 | DB_LAST_UPD | TIMESTAMP | 8 |
| 40 | DISCNT_AMT | NUMERIC(22,7) | 19 |
| 41 | DISCNT_PERCENT | NUMERIC(22,7) | 19 |
| 42 | DLR_INV_PRICE | NUMERIC(22,7) | 19 |
| 43 | EFFICIENCY_RATING | NUMERIC(22,7) | 19 |
| 44 | END_DT | TIMESTAMP | 8 |
| 45 | EXCHG_DT | TIMESTAMP | 8 |
| 46 | EXCH_DATE | TIMESTAMP | 8 |
| 47 | EXTD_QTY | NUMERIC(22,7) | 19 |
| 48 | EXTENDED_QTY | BIGINT | 8 |
| 49 | INCEPTION_DT | TIMESTAMP | 8 |
| 50 | INSTALL_DT | TIMESTAMP | 8 |
| 51 | INTERNAL_ASSET_FLG | CHARACTER(1) | 1 |
| 52 | INTR_RATE | NUMERIC(22,7) | 19 |
| 53 | LAST_DOWNLOAD_DT | TIMESTAMP | 8 |
| 54 | LAST_TEST_DT | TIMESTAMP | 8 |
| 55 | LCNS_EXP_DT | TIMESTAMP | 8 |
| 56 | LOAD_ADDED | NUMERIC(22,7) | 19 |
| 57 | METER_CNT | NUMERIC(22,7) | 19 |
| 58 | MFGD_DT | TIMESTAMP | 8 |
| 59 | MODEL_YR | BIGINT | 8 |
| 60 | MSRP | NUMERIC(22,7) | 19 |
| 61 | ORIGINAL_COST | NUMERIC(22,7) | 19 |
| 62 | POLICY_DISCNT_AMT | NUMERIC(22,7) | 19 |
| 63 | PREMIUM | NUMERIC(22,7) | 19 |
| 64 | PREMIUM_DT | TIMESTAMP | 8 |
| 65 | PROFIT | NUMERIC(22,7) | 19 |
| 66 | PR_REP_DNRM_FLG | CHARACTER(1) | 1 |
| 67 | PR_REP_MANL_FLG | CHARACTER(1) | 1 |
| 68 | PR_REP_SYS_FLG | CHARACTER(1) | 1 |
| 69 | PURCH_ADJ_UNIT_PRI | NUMERIC(22,7) | 19 |
| 70 | PURCH_DT | TIMESTAMP | 8 |
| 71 | PURCH_LST_UNIT_PRI | NUMERIC(22,7) | 19 |
| 72 | QTY | NUMERIC(22,7) | 19 |
| 73 | RECOVERED_DT | TIMESTAMP | 8 |
| 74 | REGISTERED_DT | TIMESTAMP | 8 |
| 75 | REL_LIMIT | NUMERIC(22,7) | 19 |
| 76 | REVENUE | NUMERIC(22,7) | 19 |
| 77 | RPLCMNT_VAL_AMT | NUMERIC(22,7) | 19 |
| 78 | SHIP_DT | TIMESTAMP | 8 |
| 79 | START_DT | TIMESTAMP | 8 |
| 80 | STATUS_CHG_DT | TIMESTAMP | 8 |
| 81 | SVC_PER_PROD_AMT | NUMERIC(22,7) | 19 |
| 82 | UNINSTALL_DT | TIMESTAMP | 8 |
| 83 | WARRANTY_END_DT | TIMESTAMP | 8 |
| 84 | WARRANTY_START_DT | TIMESTAMP | 8 |
| 85 | WRNTY_LAST_UPD_DT | TIMESTAMP | 8 |
| 86 | AAGSVC_CON_ID | CHARACTER VARYING(15) | 15 |
| 87 | AIA_INTEG1_ID | CHARACTER VARYING(500) | 500 |
| 88 | AIA_INTEG_ID | CHARACTER VARYING(150) | 150 |
| 89 | ALIAS_NAME | CHARACTER VARYING(100) | 100 |
| 90 | APPLNT_GRP_ID | CHARACTER VARYING(15) | 15 |
| 91 | ASSEMBLY_PORT_ID | CHARACTER VARYING(15) | 15 |
| 92 | ASSET_COND_CD | CHARACTER VARYING(30) | 30 |
| 93 | ASSET_IMG_ID | CHARACTER VARYING(15) | 15 |
| 94 | ASSET_MEM_INTEG_ID | CHARACTER VARYING(30) | 30 |
| 95 | ASSET_VAL_CURCY_CD | CHARACTER VARYING(20) | 20 |
| 96 | BAR_CODE_NUM | CHARACTER VARYING(30) | 30 |
| 97 | BASE_CURRENCY_CD | CHARACTER VARYING(30) | 30 |
| 98 | BILLACCT_ID | CHARACTER VARYING(15) | 15 |
| 99 | BILL_ACCNT_ID | CHARACTER VARYING(15) | 15 |
| 100 | BILL_PROFILE_ID | CHARACTER VARYING(15) | 15 |
| 101 | BILL_STATUS_CD | CHARACTER VARYING(30) | 30 |
| 102 | BL_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 103 | BODY_STYLE_CD | CHARACTER VARYING(30) | 30 |
| 104 | BRANCH_ID | CHARACTER VARYING(15) | 15 |
| 105 | BUILD | CHARACTER VARYING(30) | 30 |
| 106 | CAPITALIZED_CD | CHARACTER VARYING(30) | 30 |
| 107 | CASE_ID | CHARACTER VARYING(15) | 15 |
| 108 | CFG1_INTEG_ID | CHARACTER VARYING(40) | 40 |
| 109 | CFG2_INTEG_ID | CHARACTER VARYING(40) | 40 |
| 110 | CFG3_INTEG_ID | CHARACTER VARYING(40) | 40 |
| 111 | CFG_STATE_CD | CHARACTER VARYING(30) | 30 |
| 112 | CFG_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 113 | CFG_VALDN_STAT_CD | CHARACTER VARYING(30) | 30 |
| 114 | CHANNEL_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 115 | COMMENTS | CHARACTER VARYING(255) | 255 |
| 116 | COMPANY_CD | CHARACTER VARYING(30) | 30 |
| 117 | CONDITION_CD | CHARACTER VARYING(30) | 30 |
| 118 | COST_LST_ID | CHARACTER VARYING(15) | 15 |
| 119 | CURCY_CD | CHARACTER VARYING(20) | 20 |
| 120 | CUR_AGREE_ID | CHARACTER VARYING(15) | 15 |
| 121 | DATA_SRC | CHARACTER VARYING(30) | 30 |
| 122 | DB_LAST_UPD_SRC | CHARACTER VARYING(50) | 50 |
| 123 | DESC_TEXT | CHARACTER VARYING(255) | 255 |
| 124 | DLR_ID | CHARACTER VARYING(15) | 15 |
| 125 | DOORS_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 126 | DRIVE_TRAIN_CD | CHARACTER VARYING(30) | 30 |
| 127 | DYN_DISCNT_METH_CD | CHARACTER VARYING(30) | 30 |
| 128 | ENGINE_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 129 | EXTENSION_CD | CHARACTER VARYING(30) | 30 |
| 130 | EXT_COLOR_CD | CHARACTER VARYING(30) | 30 |
| 131 | FLEET_OU_ID | CHARACTER VARYING(15) | 15 |
| 132 | FLT_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 133 | FUEL_CD | CHARACTER VARYING(30) | 30 |
| 134 | HLTHACCNT_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 135 | INSCLM_EVT_ID | CHARACTER VARYING(15) | 15 |
| 136 | INTEGRATION_ID | CHARACTER VARYING(30) | 30 |
| 137 | INT_COLOR_CD | CHARACTER VARYING(30) | 30 |
| 138 | INVLOC_ID | CHARACTER VARYING(15) | 15 |
| 139 | LCNS_NUM | CHARACTER VARYING(30) | 30 |
| 140 | LCNS_STATE_CD | CHARACTER VARYING(10) | 10 |
| 141 | LOAD_PERIOD_CD | CHARACTER VARYING(30) | 30 |
| 142 | LOB_CD | CHARACTER VARYING(30) | 30 |
| 143 | LOT_NUM | CHARACTER VARYING(100) | 100 |
| 144 | MAKE_CD | CHARACTER VARYING(30) | 30 |
| 145 | METER_LOC | CHARACTER VARYING(50) | 50 |
| 146 | METER_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 147 | METER_USE_CD | CHARACTER VARYING(30) | 30 |
| 148 | MODEL_CD | CHARACTER VARYING(30) | 30 |
| 149 | NAME | CHARACTER VARYING(100) | 100 |
| 150 | NEW_USD_CD | CHARACTER VARYING(30) | 30 |
| 151 | OPER_STATUS_CD | CHARACTER VARYING(30) | 30 |
| 152 | ORG_CENSUS_ID | CHARACTER VARYING(15) | 15 |
| 153 | ORIG_ORDER_ID | CHARACTER VARYING(15) | 15 |
| 154 | OU_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 155 | OWNERSHIP_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 156 | OWNER_ACCNT_ID | CHARACTER VARYING(15) | 15 |
| 157 | OWNER_ASSET_NUM | CHARACTER VARYING(50) | 50 |
| 158 | OWNER_CON_ID | CHARACTER VARYING(15) | 15 |
| 159 | OWNR_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 160 | PARTNER_BANK | CHARACTER VARYING(50) | 50 |
| 161 | PARTNER_BRANCH | CHARACTER VARYING(50) | 50 |
| 162 | PAR_ASSET_ID | CHARACTER VARYING(15) | 15 |
| 163 | PER_ADDR_ID | CHARACTER VARYING(15) | 15 |
| 164 | PG_INTEG_ID | CHARACTER VARYING(30) | 30 |
| 165 | PNSN_SUBTYPE_CD | CHARACTER VARYING(30) | 30 |
| 166 | POLICY_SOURCE_ID | CHARACTER VARYING(15) | 15 |
| 167 | PORT_VALID_PROD_ID | CHARACTER VARYING(15) | 15 |
| 168 | PREF_SRV_DLR_ID | CHARACTER VARYING(15) | 15 |
| 169 | PRI_COMMIT_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 170 | PRI_DESC_TEXT | CHARACTER VARYING(250) | 250 |
| 171 | PRI_LST_ID | CHARACTER VARYING(15) | 15 |
| 172 | PRODUCER_CD | CHARACTER VARYING(30) | 30 |
| 173 | PROD_ID | CHARACTER VARYING(15) | 15 |
| 174 | PROD_INV_ID | CHARACTER VARYING(15) | 15 |
| 175 | PROMOTION_ID | CHARACTER VARYING(15) | 15 |
| 176 | PROM_GROUP_ID | CHARACTER VARYING(15) | 15 |
| 177 | PROM_GROUP_ITEM_ID | CHARACTER VARYING(15) | 15 |
| 178 | PROM_INTEG_ID | CHARACTER VARYING(30) | 30 |
| 179 | PROM_ITEM_ID | CHARACTER VARYING(15) | 15 |
| 180 | PROM_SRC_INTG_ID | CHARACTER VARYING(30) | 30 |
| 181 | PROP_LOSS_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 182 | PROP_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 183 | PR_ACCNT_ID | CHARACTER VARYING(15) | 15 |
| 184 | PR_ASSET_ID | CHARACTER VARYING(15) | 15 |
| 185 | PR_ASSET_WRNTY_ID | CHARACTER VARYING(15) | 15 |
| 186 | PR_CON_ID | CHARACTER VARYING(15) | 15 |
| 187 | PR_DISCNT_ID | CHARACTER VARYING(15) | 15 |
| 188 | PR_DRVR_ID | CHARACTER VARYING(15) | 15 |
| 189 | PR_EMP_ID | CHARACTER VARYING(15) | 15 |
| 190 | PR_FIN_DTL_ID | CHARACTER VARYING(15) | 15 |
| 191 | PR_GRP_OU_ID | CHARACTER VARYING(15) | 15 |
| 192 | PR_POSTN_ID | CHARACTER VARYING(15) | 15 |
| 193 | PR_TERR_ID | CHARACTER VARYING(15) | 15 |
| 194 | PURCH_LOC_DESC | CHARACTER VARYING(100) | 100 |
| 195 | RATE_CD | CHARACTER VARYING(30) | 30 |
| 196 | RATE_EXCEPTION | CHARACTER VARYING(30) | 30 |
| 197 | RATE_PLAN_CD | CHARACTER VARYING(30) | 30 |
| 198 | RATE_STATE | CHARACTER VARYING(30) | 30 |
| 199 | REASON_CD | CHARACTER VARYING(30) | 30 |
| 200 | REFERRAL_NAME | CHARACTER VARYING(100) | 100 |
| 201 | REF_NUMBER_1 | CHARACTER VARYING(30) | 30 |
| 202 | REF_NUMBER_2 | CHARACTER VARYING(30) | 30 |
| 203 | REF_NUMBER_3 | CHARACTER VARYING(30) | 30 |
| 204 | REGION | CHARACTER VARYING(50) | 50 |
| 205 | REL_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 206 | REV_NUM | CHARACTER VARYING(30) | 30 |
| 207 | ROOT_ASSET_ID | CHARACTER VARYING(15) | 15 |
| 208 | RTNG_DLR_ID | CHARACTER VARYING(15) | 15 |
| 209 | SERIAL_NUM | CHARACTER VARYING(100) | 100 |
| 210 | SERVICE_POINT_ID | CHARACTER VARYING(15) | 15 |
| 211 | SERV_ACCT_ID | CHARACTER VARYING(15) | 15 |
| 212 | SPL_RATE_LST_ID | CHARACTER VARYING(15) | 15 |
| 213 | SP_NUM | CHARACTER VARYING(250) | 250 |
| 214 | SRV_REGN_ID | CHARACTER VARYING(15) | 15 |
| 215 | SR_RTNG_CD | CHARACTER VARYING(30) | 30 |
| 216 | STATUS_CD | CHARACTER VARYING(30) | 30 |
| 217 | STAT_REASON_CD | CHARACTER VARYING(30) | 30 |
| 218 | STOCK_NUM | CHARACTER VARYING(30) | 30 |
| 219 | SUB_STATUS_CD | CHARACTER VARYING(30) | 30 |
| 220 | SUB_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 221 | SUPPLIER_OU_ID | CHARACTER VARYING(15) | 15 |
| 222 | SUSP_DRUG_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 223 | TERM_CD | CHARACTER VARYING(30) | 30 |
| 224 | THMBNL_IMAGE_ID | CHARACTER VARYING(15) | 15 |
| 225 | TIER_PRI_INFO | CHARACTER VARYING(250) | 250 |
| 226 | TIMEFRAME_CD | CHARACTER VARYING(30) | 30 |
| 227 | TRADEIN_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 228 | TRANSMISSION_CD | CHARACTER VARYING(30) | 30 |
| 229 | TRIM_CD | CHARACTER VARYING(30) | 30 |
| 230 | TYPE_CD | CHARACTER VARYING(30) | 30 |
| 231 | UOM_CD | CHARACTER VARYING(30) | 30 |
| 232 | USG_UOM_CD | CHARACTER VARYING(30) | 30 |
| 233 | VALUE_BASIS_CD | CHARACTER VARYING(30) | 30 |
| 234 | VERSION | CHARACTER VARYING(30) | 30 |
| 235 | WARRANTY_TYPE_CD | CHARACTER VARYING(30) | 30 |
| 236 | XA_CLASS_ID | CHARACTER VARYING(15) | 15 |
| 237 | X_CONTRACT_NUM | CHARACTER VARYING(100) | 100 |
| 238 | X_COST_CENTRE | CHARACTER VARYING(10) | 10 |
| 239 | X_CREATED_BY | CHARACTER VARYING(100) | 100 |
| 240 | X_CREATED_SYS | CHARACTER VARYING(100) | 100 |
| 241 | X_DELETED_BY | CHARACTER VARYING(100) | 100 |
| 242 | X_EFFECTIVE_DT | TIMESTAMP | 8 |
| 243 | X_FN_NUM | CHARACTER VARYING(30) | 30 |
| 244 | X_LAST_UPD_BY | CHARACTER VARYING(100) | 100 |
| 245 | X_LAST_UPD_DT | TIMESTAMP | 8 |
| 246 | X_LAST_UPD_SYS | CHARACTER VARYING(100) | 100 |
| 247 | X_LIFE_CYCLE_STAT_CHG_DT | TIMESTAMP | 8 |
| 248 | X_NAME | CHARACTER VARYING(500) | 500 |
| 249 | X_RECORD_END_DT | TIMESTAMP | 8 |
| 250 | X_RECORD_STATUS_CD | CHARACTER VARYING(30) | 30 |
| 251 | X_STATUS_CHG_DT | TIMESTAMP | 8 |
| 252 | X_TAX_ID_APPLY_FLG | CHARACTER(1) | 1 |
| 253 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 254 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 255 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 256 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |