OBP24_CZ_SC_OR_EXPR_CRGS
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_CZ_SC_OR_EXPR_CRGS
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | MASTER_KEY | CHARACTER VARYING(100) | 100 |
| 2 | S_SPARE_106_400 | BIGINT | 8 |
| 3 | S_HOME_TELEPHONE_FLG_401 | CHARACTER VARYING(1) | 1 |
| 4 | S_EMAIL_ADDRESS_FLG_402 | CHARACTER VARYING(1) | 1 |
| 5 | S_FAX_FLG_403 | CHARACTER VARYING(1) | 1 |
| 6 | S_REV_FCLTY_OTH_ORGS_404 | SMALLINT | 2 |
| 7 | S_NREV_FCLTY_OTH_ORGS_405 | SMALLINT | 2 |
| 8 | S_EXIST_SM_NREV_FCLTY_406 | SMALLINT | 2 |
| 9 | S_EXIST_SM_REV_FCLTY_407 | SMALLINT | 2 |
| 10 | S_S_M_TCE_408 | BIGINT | 8 |
| 11 | S_TIME_CUR_ADDR_MMM_410 | SMALLINT | 2 |
| 12 | S_TIME_PREV_ADDR_MMM_411 | SMALLINT | 2 |
| 13 | S_TOT_TIME_ADD_MMM_412 | SMALLINT | 2 |
| 14 | S_BUSINESS_POST_CODE_414 | CHARACTER VARYING(4) | 4 |
| 15 | S_STATE_OF_REG_LOC_415 | CHARACTER VARYING(4) | 4 |
| 16 | S_MOBILE_TELEPH_FLG_420 | CHARACTER VARYING(1) | 1 |
| 17 | S_BUSINESS_TYPE_425 | CHARACTER VARYING(3) | 3 |
| 18 | S_NATURE_OF_BUSINESS_427 | CHARACTER VARYING(4) | 4 |
| 19 | S_APP_CUST_TYPE_428 | CHARACTER VARYING(3) | 3 |
| 20 | S_T_BUSINESS_COMMENCE_429 | SMALLINT | 2 |
| 21 | S_TOT_BENEF_SHAREHOLD_432 | SMALLINT | 2 |
| 22 | S_RE_FINANCE_FLG_487 | CHARACTER VARYING(1) | 1 |
| 23 | S_SERVICING_ACCPT_FLG_498 | CHARACTER VARYING(1) | 1 |
| 24 | S_SERVICING_AMT_513 | INTEGER | 4 |
| 25 | S_WORST_CURRENT_DELQ_554 | SMALLINT | 2 |
| 26 | S_TRANSACTION_TYPE_699 | CHARACTER VARYING(3) | 3 |
| 27 | S_WORKING_CAPITAL_AMT_710 | BIGINT | 8 |
| 28 | S_WORKING_CAPITAL_PCT_711 | SMALLINT | 2 |
| 29 | S_GOODS_AMT_712 | BIGINT | 8 |
| 30 | S_REST_GOODS_TYP_FLG_713 | CHARACTER VARYING(1) | 1 |
| 31 | S_REST_GOODS_LOC_FLG_714 | CHARACTER VARYING(1) | 1 |
| 32 | S_AGG_GOODS_RISK_AMT_715 | BIGINT | 8 |
| 33 | S_AGG_A_BACKING_AMT_716 | BIGINT | 8 |
| 34 | S_AGG_A_RISK_EX_PCT_717 | NUMERIC(9,2) | 19 |
| 35 | S_GOODS_TYPE_729 | CHARACTER VARYING(4) | 4 |
| 36 | S_SUBGROUP_OF_GOODS_730 | CHARACTER VARYING(4) | 4 |
| 37 | S_SUPPL_OF_GOODS_IND_731 | CHARACTER VARYING(1) | 1 |
| 38 | S_B2BAY_SPARE_67_732 | CHARACTER VARYING(1) | 1 |
| 39 | S_RESTRICTED_PRODUCT_733 | CHARACTER VARYING(1) | 1 |
| 40 | S_B2BAY_SPARE_69_734 | CHARACTER VARYING(1) | 1 |
| 41 | S_MIN_T_IN_BUSINESS_735 | INTEGER | 4 |
| 42 | S_GTOR_MISMATCH_FLG_737 | CHARACTER VARYING(1) | 1 |
| 43 | S_S_M_DIRECTOR_FLG_738 | CHARACTER VARYING(1) | 1 |
| 44 | S_B2BAY_SPARE_68_741 | CHARACTER VARYING(1) | 1 |
| 45 | S_PROB_STRONG_CUSRSHP_744 | BYTEINT | 1 |
| 46 | S_PROB_WRST_CUSRISKG_748 | SMALLINT | 2 |
| 47 | S_PROB_BEST_CUSRISKG_749 | SMALLINT | 2 |
| 48 | S_PROB_WRST_CUSGB_FLG_751 | CHARACTER VARYING(1) | 1 |
| 49 | S_PRO_WRSCUS_O_C_G1_754 | SMALLINT | 2 |
| 50 | S_PRO_BSTCUS_O_C_G1_755 | SMALLINT | 2 |
| 51 | S_PRO_WRSCUS_O_C_G2_758 | SMALLINT | 2 |
| 52 | S_PRO_BSTCUS_O_C_G2_759 | SMALLINT | 2 |
| 53 | S_PRO_WRSCUS_O_C_G3_762 | SMALLINT | 2 |
| 54 | S_PRO_BSTCUS_O_C_G3_763 | SMALLINT | 2 |
| 55 | S_PROB_MX_CUS_TOT_CCL_764 | BIGINT | 8 |
| 56 | S_PROB_MX_CUS_A_RULC_765 | BIGINT | 8 |
| 57 | S_PRO_MX_CUS_JNT_CCL_766 | BIGINT | 8 |
| 58 | S_PROB_MX_CUS_REV_LIM_767 | BIGINT | 8 |
| 59 | S_PRO_MX_CUS_J_REVLIM_768 | BIGINT | 8 |
| 60 | S_PRO_MX_CUS_FTERMLIM_769 | BIGINT | 8 |
| 61 | S_PRO_MX_CUS_J_FTLIM_770 | BIGINT | 8 |
| 62 | S_PROB_MX_CUS_SEC_LIM_771 | BIGINT | 8 |
| 63 | S_PRO_CU_UNSQUAL_S_F_772 | CHARACTER VARYING(1) | 1 |
| 64 | S_PRO_CU_UNSQUAL_B_F_773 | CHARACTER VARYING(1) | 1 |
| 65 | S_PRO_CU_UNSQUAL_IV_F_774 | CHARACTER VARYING(1) | 1 |
| 66 | S_PRO_CU_UNSQUAL_FA_F_775 | CHARACTER VARYING(1) | 1 |
| 67 | S_PRO_CU_UNSQUAL_SA_F_776 | CHARACTER VARYING(1) | 1 |
| 68 | S_PRO_CU_UNSQUAL_JO_F_777 | CHARACTER VARYING(1) | 1 |
| 69 | S_PRO_CUS_SECQUAL_S_F_778 | CHARACTER VARYING(1) | 1 |
| 70 | S_PRO_CUS_SECQUAL_B_F_779 | CHARACTER VARYING(1) | 1 |
| 71 | S_PRO_CU_SECQUAL_IV_F_780 | CHARACTER VARYING(1) | 1 |
| 72 | S_PRO_CU_SECQUAL_FA_F_781 | CHARACTER VARYING(1) | 1 |
| 73 | S_PRO_CU_SECQUAL_SA_F_782 | CHARACTER VARYING(1) | 1 |
| 74 | S_PRO_CU_SECQUAL_JO_F_783 | CHARACTER VARYING(1) | 1 |
| 75 | S_PRO_CU_EXIST_PRCMOD_784 | NUMERIC(7,2) | 19 |
| 76 | S_TOT_CURMPAY2WCAPPCT_800 | NUMERIC(9,2) | 19 |
| 77 | S_TOT_PROMPAY2WCAPPCT_801 | NUMERIC(9,2) | 19 |
| 78 | S_INTEREST_COVER_R_802 | NUMERIC(9,2) | 19 |
| 79 | S_EQUITY_RATIO_803 | NUMERIC(9,2) | 19 |
| 80 | S_CURRENT_RATIO_804 | NUMERIC(9,2) | 19 |
| 81 | S_QUICK_RATIO_805 | NUMERIC(9,2) | 19 |
| 82 | S_ROA_806 | NUMERIC(9,2) | 19 |
| 83 | S_ROE_807 | NUMERIC(9,2) | 19 |
| 84 | S_CREDITOR_DAYS_808 | NUMERIC(9,2) | 19 |
| 85 | S_DEBTOR_DAYS_809 | NUMERIC(9,2) | 19 |
| 86 | S_Z_SCORE_810 | NUMERIC(9,2) | 19 |
| 87 | S_ANZSIC_CODE_811 | INTEGER | 4 |
| 88 | S_AMORTISATION_812 | NUMERIC(11,2) | 19 |
| 89 | S_B2BAY_SPARE_70_813 | NUMERIC(11,2) | 19 |
| 90 | S_AVG_STOCK_814 | NUMERIC(11,2) | 19 |
| 91 | S_BARGAIN_POW_OF_CUST_815 | CHARACTER VARYING(2) | 2 |
| 92 | S_BARGAIN_POW_OF_T_816 | CHARACTER VARYING(2) | 2 |
| 93 | S_CRGS_SCORECARD_SEL_817 | CHARACTER VARYING(3) | 3 |
| 94 | S_SALES_PERFORM_L36M_818 | NUMERIC(11,2) | 19 |
| 95 | S_STOCK_TURNOVER_819 | NUMERIC(11,2) | 19 |
| 96 | S_NET_OPERATING_INC_820 | NUMERIC(11,2) | 19 |
| 97 | S_B2BAY_SPARE_25_821 | NUMERIC(11,2) | 19 |
| 98 | S_B2BAY_SPARE_26_822 | NUMERIC(11,2) | 19 |
| 99 | S_CAPCTY_ON_HIST_RES_823 | NUMERIC(7,2) | 19 |
| 100 | S_CPCTY_ON_PRJCTD_RES_824 | NUMERIC(7,2) | 19 |
| 101 | S_CAP_REINVST_ALLOW_825 | NUMERIC(11,2) | 19 |
| 102 | S_B2BAY_SPARE_27_826 | NUMERIC(11,2) | 19 |
| 103 | S_CATEGORY_OF_BUILDER_827 | CHARACTER VARYING(6) | 6 |
| 104 | S_CFB_OPERATING_SALES_828 | NUMERIC(11,2) | 19 |
| 105 | S_B2BAY_SPARE_28_829 | NUMERIC(11,2) | 19 |
| 106 | S_B2BAY_SPARE_29_830 | NUMERIC(11,2) | 19 |
| 107 | S_B2BAY_SPARE_30_831 | NUMERIC(11,2) | 19 |
| 108 | S_B2BAY_SPARE_31_832 | NUMERIC(11,2) | 19 |
| 109 | S_B2BAY_SPARE_32_833 | NUMERIC(11,2) | 19 |
| 110 | S_B2BAY_SPARE_33_834 | NUMERIC(11,2) | 19 |
| 111 | S_B2BAY_SPARE_34_835 | NUMERIC(11,2) | 19 |
| 112 | S_B2BAY_SPARE_35_836 | NUMERIC(11,2) | 19 |
| 113 | S_B2BAY_SPARE_36_837 | NUMERIC(11,2) | 19 |
| 114 | S_B2BAY_SPARE_37_838 | NUMERIC(11,2) | 19 |
| 115 | S_COND_PRE_EXI_LOANS_839 | CHARACTER VARYING(2) | 2 |
| 116 | S_STAGE_OF_CONSTRUCT_840 | NUMERIC(7,2) | 19 |
| 117 | S_B2BAY_SPARE_71_841 | NUMERIC(11,2) | 19 |
| 118 | S_B2BAY_SPARE_38_842 | NUMERIC(11,2) | 19 |
| 119 | S_TOT_CURR_ASSETS_843 | INTEGER | 4 |
| 120 | S_TOT_CURR_LIAB_844 | INTEGER | 4 |
| 121 | S_B2BAY_SPARE_39_845 | NUMERIC(7,2) | 19 |
| 122 | S_DEBT_SERV_COVER_R_846 | NUMERIC(7,2) | 19 |
| 123 | S_DEBT_SERV_REQ_847 | NUMERIC(11,2) | 19 |
| 124 | S_DEPRECIATION_848 | NUMERIC(11,2) | 19 |
| 125 | S_B2BAY_SPARE_40_849 | INTEGER | 4 |
| 126 | S_DEV_OR_PROP_PSTCODE_850 | INTEGER | 4 |
| 127 | S_DEV_RELATED_COMMITS_851 | NUMERIC(11,2) | 19 |
| 128 | S_B2BAY_SPARE_41_852 | NUMERIC(11,2) | 19 |
| 129 | S_B2BAY_SPARE_42_853 | NUMERIC(6,2) | 19 |
| 130 | S_EXTRAORD_EXPENSES_854 | NUMERIC(11,2) | 19 |
| 131 | S_EXTRAORD_INCOME_855 | NUMERIC(11,2) | 19 |
| 132 | S_EXTRAORD_ITEMS_856 | NUMERIC(11,2) | 19 |
| 133 | S_FINANCE_LEASE_EXP_857 | NUMERIC(11,2) | 19 |
| 134 | S_FIT_WITH_NEIGHRHD_858 | CHARACTER VARYING(2) | 2 |
| 135 | S_GEOINDUSTRY_SECTOR_859 | CHARACTER VARYING(7) | 7 |
| 136 | S_GROSS_REAL_V_EX_GST_860 | NUMERIC(11,2) | 19 |
| 137 | S_GROSS_RENTAL_INCOME_861 | NUMERIC(11,2) | 19 |
| 138 | S_EXPERIENCE_862 | NUMERIC(15,2) | 19 |
| 139 | S_INTANGIBLE_ASSETS_863 | INTEGER | 4 |
| 140 | S_INTEREST_EXPENSE_864 | NUMERIC(11,2) | 19 |
| 141 | S_INTERNAL_RATEOFRET_865 | NUMERIC(7,2) | 19 |
| 142 | S_INVENTORY_866 | INTEGER | 4 |
| 143 | S_B2BAY_SPARE_43_867 | NUMERIC(11,2) | 19 |
| 144 | S_B2BAY_SPARE_44_868 | NUMERIC(11,2) | 19 |
| 145 | S_B2BAY_SPARE_45_869 | NUMERIC(11,2) | 19 |
| 146 | S_LIVING_ALLOWANCE_870 | NUMERIC(11,2) | 19 |
| 147 | S_MGMT_INTEGRITY_871 | CHARACTER VARYING(2) | 2 |
| 148 | S_MATURITY_CURR_T_872 | SMALLINT | 2 |
| 149 | S_B2BAY_SPARE_46_873 | NUMERIC(11,2) | 19 |
| 150 | S_B2BAY_SPARE_72_874 | NUMERIC(11,2) | 19 |
| 151 | S_B2BAY_SPARE_47_875 | NUMERIC(11,2) | 19 |
| 152 | S_B2BAY_SPARE_66_876 | SMALLINT | 2 |
| 153 | S_NON_CURRENT_ASSETS_877 | INTEGER | 4 |
| 154 | S_B2BAY_SPARE_48_878 | INTEGER | 4 |
| 155 | S_NONOPERATING_EXP_879 | NUMERIC(11,2) | 19 |
| 156 | S_NONOPERATING_INCOME_880 | NUMERIC(11,2) | 19 |
| 157 | S_N_PROJ_UNDRTN_PRINC_881 | INTEGER | 4 |
| 158 | S_N_SUCPRJ_COMP_PRINC_882 | INTEGER | 4 |
| 159 | S_OFFICERS_COMPENS_883 | NUMERIC(11,2) | 19 |
| 160 | S_B2BAY_SPARE_49_884 | NUMERIC(11,2) | 19 |
| 161 | S_PAST_PROJ_SUC_R_PCT_885 | SMALLINT | 2 |
| 162 | S_PHY_ATTR_RISK_MGM_P_886 | CHARACTER VARYING(7) | 7 |
| 163 | S_B2BAY_SPARE_50_887 | INTEGER | 4 |
| 164 | S_B2BAY_SPARE_51_888 | INTEGER | 4 |
| 165 | S_B2BAY_SPARE_52_889 | INTEGER | 4 |
| 166 | S_B2BAY_SPARE_53_890 | INTEGER | 4 |
| 167 | S_POST_DDSOP_SM_OBLOC_891 | INTEGER | 4 |
| 168 | S_POST_DDSOP_SM_PAYAD_892 | INTEGER | 4 |
| 169 | S_B2BAY_SPARE_54_893 | INTEGER | 4 |
| 170 | S_B2BAY_SPARE_55_894 | INTEGER | 4 |
| 171 | S_POST_DDSOP_TOT_NCA_895 | INTEGER | 4 |
| 172 | S_POST_DDSOP_TOT_NCL_896 | INTEGER | 4 |
| 173 | S_PRESALES_AMOUNT_897 | NUMERIC(11,2) | 19 |
| 174 | S_B2BAY_SPARE_73_898 | NUMERIC(11,2) | 19 |
| 175 | S_PROJECT_COST_899 | NUMERIC(11,2) | 19 |
| 176 | S_PROJ_COST2GRV_RATIO_900 | NUMERIC(7,2) | 19 |
| 177 | S_PROJ_GEARING_POS_901 | NUMERIC(7,2) | 19 |
| 178 | S_PROJECTD_DEBTCOV_R_902 | NUMERIC(7,2) | 19 |
| 179 | S_PROJECTD_FNDS_ADS_903 | NUMERIC(11,2) | 19 |
| 180 | S_PROPERTY_CONDITION_904 | CHARACTER VARYING(2) | 2 |
| 181 | S_B2BAY_SPARE_56_905 | INTEGER | 4 |
| 182 | S_B2BAY_SPARE_57_906 | NUMERIC(7,2) | 19 |
| 183 | S_PRESALES2LOAN_RATIO_907 | NUMERIC(7,2) | 19 |
| 184 | S_RELTD_PARTYLOANS_A_908 | INTEGER | 4 |
| 185 | S_RELTD_PARTY_LOANS_L_909 | INTEGER | 4 |
| 186 | S_RENT_ARREARS_910 | NUMERIC(11,2) | 19 |
| 187 | S_RENT_ARREARS_PCT_911 | NUMERIC(7,2) | 19 |
| 188 | S_RENTAL_INCOME_PERF_912 | NUMERIC(7,2) | 19 |
| 189 | S_SALES_913 | NUMERIC(11,2) | 19 |
| 190 | S_SIMILARITY_PRE_PROJ_914 | CHARACTER VARYING(2) | 2 |
| 191 | S_SRC_OF_SPONSOR_EQ_915 | CHARACTER VARYING(2) | 2 |
| 192 | S_TANGIBLE_ASSETS_916 | INTEGER | 4 |
| 193 | S_TANGIBLE_NET_WORTH_917 | INTEGER | 4 |
| 194 | S_TRG_SALES2INVST_PCT_918 | NUMERIC(7,2) | 19 |
| 195 | S_TENANCY_MIX_919 | CHARACTER VARYING(7) | 7 |
| 196 | S_TERM_OF_THE_PROJECT_920 | SMALLINT | 2 |
| 197 | S_TOT_LIABILITIES_921 | INTEGER | 4 |
| 198 | S_TOT_ASSETS_922 | INTEGER | 4 |
| 199 | S_B2BAY_SPARE_58_923 | INTEGER | 4 |
| 200 | S_TOT_EXPENSES_924 | NUMERIC(11,2) | 19 |
| 201 | S_B2BAY_SPARE_59_925 | NUMERIC(11,2) | 19 |
| 202 | S_B2BAY_SPARE_60_926 | INTEGER | 4 |
| 203 | S_B2BAY_SPARE_61_927 | INTEGER | 4 |
| 204 | S_B2BAY_SPARE_62_928 | INTEGER | 4 |
| 205 | S_TOT_MOTOR_VEHICLE_A_929 | INTEGER | 4 |
| 206 | S_B2BAY_SPARE_63_930 | INTEGER | 4 |
| 207 | S_B2BAY_SPARE_64_931 | INTEGER | 4 |
| 208 | S_B2BAY_SPARE_65_932 | INTEGER | 4 |
| 209 | S_TOT_PLANT_EQUIP_A_933 | INTEGER | 4 |
| 210 | S_TRADE_CREDITORS_934 | INTEGER | 4 |
| 211 | S_VACANCY_PCT_935 | NUMERIC(7,2) | 19 |
| 212 | S_WRKNG_CAP2SALES_PCT_936 | NUMERIC(8,3) | 19 |
| 213 | S_WORKING_WITHIN_BUD_937 | NUMERIC(7,2) | 19 |
| 214 | S_YRS_AS_SELFEMP_DEVL_938 | SMALLINT | 2 |
| 215 | S_ASSET_REVALUATIONS_939 | NUMERIC(15,2) | 19 |
| 216 | S_COST_OF_GOODS_SOLD_940 | NUMERIC(15,2) | 19 |
| 217 | S_NET_PRO_B_INT_A_TAX_941 | NUMERIC(15,2) | 19 |
| 218 | S_PRO_B_TAX_EXTORD_I_942 | NUMERIC(15,2) | 19 |
| 219 | S_B2BAY_SPARE_5_943 | INTEGER | 4 |
| 220 | S_B2BAY_SPARE_6_944 | INTEGER | 4 |
| 221 | S_B2BAY_SPARE_7_945 | INTEGER | 4 |
| 222 | S_B2BAY_SPARE_8_946 | INTEGER | 4 |
| 223 | S_B2BAY_SPARE_9_947 | NUMERIC(12,2) | 19 |
| 224 | S_B2BAY_SPARE_10_948 | NUMERIC(12,2) | 19 |
| 225 | S_B2BAY_SPARE_11_949 | NUMERIC(12,2) | 19 |
| 226 | S_B2BAY_SPARE_12_950 | NUMERIC(12,2) | 19 |
| 227 | S_B2BAY_SPARE_13_951 | NUMERIC(12,2) | 19 |
| 228 | S_B2BAY_SPARE_14_952 | NUMERIC(12,2) | 19 |
| 229 | S_B2BAY_SPARE_15_953 | NUMERIC(12,2) | 19 |
| 230 | S_SUBGROUP_OF_GOODS2_954 | CHARACTER VARYING(4) | 4 |
| 231 | S_B2BAY_SPARE_17_955 | CHARACTER VARYING(4) | 4 |
| 232 | S_B2BAY_SPARE_18_956 | CHARACTER VARYING(4) | 4 |
| 233 | S_B2BAY_SPARE_19_957 | CHARACTER VARYING(4) | 4 |
| 234 | S_B2BAY_SPARE_20_958 | CHARACTER VARYING(4) | 4 |
| 235 | S_SERVICING_AMT_1061 | INTEGER | 4 |
| 236 | S_OVERWRITE_DEC_CAT_1062 | CHARACTER VARYING(1) | 1 |
| 237 | S_SELFEMP_INC_VAR_1177 | NUMERIC(7,2) | 19 |
| 238 | U_SPARE_106_400 | BIGINT | 8 |
| 239 | U_HOME_TELEPHONE_FLG_401 | CHARACTER VARYING(1) | 1 |
| 240 | U_EMAIL_ADDRESS_FLG_402 | CHARACTER VARYING(1) | 1 |
| 241 | U_FAX_FLG_403 | CHARACTER VARYING(1) | 1 |
| 242 | U_REV_FCLTY_OTH_ORGS_404 | SMALLINT | 2 |
| 243 | U_NREV_FCLTY_OTH_ORGS_405 | SMALLINT | 2 |
| 244 | U_EXIST_SM_NREV_FCLTY_406 | SMALLINT | 2 |
| 245 | U_EXIST_SM_REV_FCLTY_407 | SMALLINT | 2 |
| 246 | U_S_M_TCE_408 | BIGINT | 8 |
| 247 | U_TIME_CUR_ADDR_MMM_410 | SMALLINT | 2 |
| 248 | U_TIME_PREV_ADDR_MMM_411 | SMALLINT | 2 |
| 249 | U_TOT_TIME_ADD_MMM_412 | SMALLINT | 2 |
| 250 | U_BUSINESS_POST_CODE_414 | CHARACTER VARYING(4) | 4 |
| 251 | U_STATE_OF_REG_LOC_415 | CHARACTER VARYING(4) | 4 |
| 252 | U_MOBILE_TELEPH_FLG_420 | CHARACTER VARYING(1) | 1 |
| 253 | U_BUSINESS_TYPE_425 | CHARACTER VARYING(3) | 3 |
| 254 | U_NATURE_OF_BUSINESS_427 | CHARACTER VARYING(4) | 4 |
| 255 | U_APP_CUST_TYPE_428 | CHARACTER VARYING(3) | 3 |
| 256 | U_T_BUSINESS_COMMENCE_429 | SMALLINT | 2 |
| 257 | U_TOT_BENEF_SHAREHOLD_432 | SMALLINT | 2 |
| 258 | U_RE_FINANCE_FLG_487 | CHARACTER VARYING(1) | 1 |
| 259 | U_SERVICING_ACCPT_FLG_498 | CHARACTER VARYING(1) | 1 |
| 260 | U_SERVICING_AMT_513 | INTEGER | 4 |
| 261 | U_WORST_CURRENT_DELQ_554 | SMALLINT | 2 |
| 262 | U_TRANSACTION_TYPE_699 | CHARACTER VARYING(3) | 3 |
| 263 | U_WORKING_CAPITAL_AMT_710 | BIGINT | 8 |
| 264 | U_WORKING_CAPITAL_PCT_711 | SMALLINT | 2 |
| 265 | U_GOODS_AMT_712 | BIGINT | 8 |
| 266 | U_REST_GOODS_TYP_FLG_713 | CHARACTER VARYING(1) | 1 |
| 267 | U_REST_GOODS_LOC_FLG_714 | CHARACTER VARYING(1) | 1 |
| 268 | U_AGG_GOODS_RISK_AMT_715 | BIGINT | 8 |
| 269 | U_AGG_A_BACKING_AMT_716 | BIGINT | 8 |
| 270 | U_AGG_A_RISK_EX_PCT_717 | NUMERIC(9,2) | 19 |
| 271 | U_GOODS_TYPE_729 | CHARACTER VARYING(4) | 4 |
| 272 | U_SUBGROUP_OF_GOODS_730 | CHARACTER VARYING(4) | 4 |
| 273 | U_SUPPL_OF_GOODS_IND_731 | CHARACTER VARYING(1) | 1 |
| 274 | U_B2BAY_SPARE_67_732 | CHARACTER VARYING(1) | 1 |
| 275 | U_RESTRICTED_PRODUCT_733 | CHARACTER VARYING(1) | 1 |
| 276 | U_B2BAY_SPARE_69_734 | CHARACTER VARYING(1) | 1 |
| 277 | U_MIN_T_IN_BUSINESS_735 | INTEGER | 4 |
| 278 | U_GTOR_MISMATCH_FLG_737 | CHARACTER VARYING(1) | 1 |
| 279 | U_S_M_DIRECTOR_FLG_738 | CHARACTER VARYING(1) | 1 |
| 280 | U_B2BAY_SPARE_68_741 | CHARACTER VARYING(1) | 1 |
| 281 | U_PROB_STRONG_CUSRSHP_744 | BYTEINT | 1 |
| 282 | U_PROB_WRST_CUSRISKG_748 | SMALLINT | 2 |
| 283 | U_PROB_BEST_CUSRISKG_749 | SMALLINT | 2 |
| 284 | U_PROB_WRST_CUSGB_FLG_751 | CHARACTER VARYING(1) | 1 |
| 285 | U_PRO_WRSCUS_O_C_G1_754 | SMALLINT | 2 |
| 286 | U_PRO_BSTCUS_O_C_G1_755 | SMALLINT | 2 |
| 287 | U_PRO_WRSCUS_O_C_G2_758 | SMALLINT | 2 |
| 288 | U_PRO_BSTCUS_O_C_G2_759 | SMALLINT | 2 |
| 289 | U_PRO_WRSCUS_O_C_G3_762 | SMALLINT | 2 |
| 290 | U_PRO_BSTCUS_O_C_G3_763 | SMALLINT | 2 |
| 291 | U_PROB_MX_CUS_TOT_CCL_764 | BIGINT | 8 |
| 292 | U_PROB_MX_CUS_A_RULC_765 | BIGINT | 8 |
| 293 | U_PRO_MX_CUS_JNT_CCL_766 | BIGINT | 8 |
| 294 | U_PROB_MX_CUS_REV_LIM_767 | BIGINT | 8 |
| 295 | U_PRO_MX_CUS_J_REVLIM_768 | BIGINT | 8 |
| 296 | U_PRO_MX_CUS_FTERMLIM_769 | BIGINT | 8 |
| 297 | U_PRO_MX_CUS_J_FTLIM_770 | BIGINT | 8 |
| 298 | U_PROB_MX_CUS_SEC_LIM_771 | BIGINT | 8 |
| 299 | U_PRO_CU_UNSQUAL_S_F_772 | CHARACTER VARYING(1) | 1 |
| 300 | U_PRO_CU_UNSQUAL_B_F_773 | CHARACTER VARYING(1) | 1 |
| 301 | U_PRO_CU_UNSQUAL_IV_F_774 | CHARACTER VARYING(1) | 1 |
| 302 | U_PRO_CU_UNSQUAL_FA_F_775 | CHARACTER VARYING(1) | 1 |
| 303 | U_PRO_CU_UNSQUAL_SA_F_776 | CHARACTER VARYING(1) | 1 |
| 304 | U_PRO_CU_UNSQUAL_JO_F_777 | CHARACTER VARYING(1) | 1 |
| 305 | U_PRO_CUS_SECQUAL_S_F_778 | CHARACTER VARYING(1) | 1 |
| 306 | U_PRO_CUS_SECQUAL_B_F_779 | CHARACTER VARYING(1) | 1 |
| 307 | U_PRO_CU_SECQUAL_IV_F_780 | CHARACTER VARYING(1) | 1 |
| 308 | U_PRO_CU_SECQUAL_FA_F_781 | CHARACTER VARYING(1) | 1 |
| 309 | U_PRO_CU_SECQUAL_SA_F_782 | CHARACTER VARYING(1) | 1 |
| 310 | U_PRO_CU_SECQUAL_JO_F_783 | CHARACTER VARYING(1) | 1 |
| 311 | U_PRO_CU_EXIST_PRCMOD_784 | NUMERIC(7,2) | 19 |
| 312 | U_TOT_CURMPAY2WCAPPCT_800 | NUMERIC(9,2) | 19 |
| 313 | U_TOT_PROMPAY2WCAPPCT_801 | NUMERIC(9,2) | 19 |
| 314 | U_INTEREST_COVER_R_802 | NUMERIC(9,2) | 19 |
| 315 | U_EQUITY_RATIO_803 | NUMERIC(9,2) | 19 |
| 316 | U_CURRENT_RATIO_804 | NUMERIC(9,2) | 19 |
| 317 | U_QUICK_RATIO_805 | NUMERIC(9,2) | 19 |
| 318 | U_ROA_806 | NUMERIC(9,2) | 19 |
| 319 | U_ROE_807 | NUMERIC(9,2) | 19 |
| 320 | U_CREDITOR_DAYS_808 | NUMERIC(9,2) | 19 |
| 321 | U_DEBTOR_DAYS_809 | NUMERIC(9,2) | 19 |
| 322 | U_Z_SCORE_810 | NUMERIC(9,2) | 19 |
| 323 | U_ANZSIC_CODE_811 | INTEGER | 4 |
| 324 | U_AMORTISATION_812 | NUMERIC(11,2) | 19 |
| 325 | U_B2BAY_SPARE_70_813 | NUMERIC(11,2) | 19 |
| 326 | U_AVG_STOCK_814 | NUMERIC(11,2) | 19 |
| 327 | U_BARGAIN_POW_OF_CUST_815 | CHARACTER VARYING(2) | 2 |
| 328 | U_BARGAIN_POW_OF_T_816 | CHARACTER VARYING(2) | 2 |
| 329 | U_CRGS_SCORECARD_SEL_817 | CHARACTER VARYING(3) | 3 |
| 330 | U_SALES_PERFORM_L36M_818 | NUMERIC(11,2) | 19 |
| 331 | U_STOCK_TURNOVER_819 | NUMERIC(11,2) | 19 |
| 332 | U_NET_OPERATING_INC_820 | NUMERIC(11,2) | 19 |
| 333 | U_B2BAY_SPARE_25_821 | NUMERIC(11,2) | 19 |
| 334 | U_B2BAY_SPARE_26_822 | NUMERIC(11,2) | 19 |
| 335 | U_CAPCTY_ON_HIST_RES_823 | NUMERIC(7,2) | 19 |
| 336 | U_CPCTY_ON_PRJCTD_RES_824 | NUMERIC(7,2) | 19 |
| 337 | U_CAP_REINVST_ALLOW_825 | NUMERIC(11,2) | 19 |
| 338 | U_B2BAY_SPARE_27_826 | NUMERIC(11,2) | 19 |
| 339 | U_CATEGORY_OF_BUILDER_827 | CHARACTER VARYING(6) | 6 |
| 340 | U_CFB_OPERATING_SALES_828 | NUMERIC(11,2) | 19 |
| 341 | U_B2BAY_SPARE_28_829 | NUMERIC(11,2) | 19 |
| 342 | U_B2BAY_SPARE_29_830 | NUMERIC(11,2) | 19 |
| 343 | U_B2BAY_SPARE_30_831 | NUMERIC(11,2) | 19 |
| 344 | U_B2BAY_SPARE_31_832 | NUMERIC(11,2) | 19 |
| 345 | U_B2BAY_SPARE_32_833 | NUMERIC(11,2) | 19 |
| 346 | U_B2BAY_SPARE_33_834 | NUMERIC(11,2) | 19 |
| 347 | U_B2BAY_SPARE_34_835 | NUMERIC(11,2) | 19 |
| 348 | U_B2BAY_SPARE_35_836 | NUMERIC(11,2) | 19 |
| 349 | U_B2BAY_SPARE_36_837 | NUMERIC(11,2) | 19 |
| 350 | U_B2BAY_SPARE_37_838 | NUMERIC(11,2) | 19 |
| 351 | U_COND_PRE_EXI_LOANS_839 | CHARACTER VARYING(2) | 2 |
| 352 | U_STAGE_OF_CONSTRUCT_840 | NUMERIC(7,2) | 19 |
| 353 | U_B2BAY_SPARE_71_841 | NUMERIC(11,2) | 19 |
| 354 | U_B2BAY_SPARE_38_842 | NUMERIC(11,2) | 19 |
| 355 | U_TOT_CURR_ASSETS_843 | INTEGER | 4 |
| 356 | U_TOT_CURR_LIAB_844 | INTEGER | 4 |
| 357 | U_B2BAY_SPARE_39_845 | NUMERIC(7,2) | 19 |
| 358 | U_DEBT_SERV_COVER_R_846 | NUMERIC(7,2) | 19 |
| 359 | U_DEBT_SERV_REQ_847 | NUMERIC(11,2) | 19 |
| 360 | U_DEPRECIATION_848 | NUMERIC(11,2) | 19 |
| 361 | U_B2BAY_SPARE_40_849 | INTEGER | 4 |
| 362 | U_DEV_OR_PROP_PSTCODE_850 | INTEGER | 4 |
| 363 | U_DEV_RELATED_COMMITS_851 | NUMERIC(11,2) | 19 |
| 364 | U_B2BAY_SPARE_41_852 | NUMERIC(11,2) | 19 |
| 365 | U_B2BAY_SPARE_42_853 | NUMERIC(6,2) | 19 |
| 366 | U_EXTRAORD_EXPENSES_854 | NUMERIC(11,2) | 19 |
| 367 | U_EXTRAORD_INCOME_855 | NUMERIC(11,2) | 19 |
| 368 | U_EXTRAORD_ITEMS_856 | NUMERIC(11,2) | 19 |
| 369 | U_FINANCE_LEASE_EXP_857 | NUMERIC(11,2) | 19 |
| 370 | U_FIT_WITH_NEIGHRHD_858 | CHARACTER VARYING(2) | 2 |
| 371 | U_GEOINDUSTRY_SECTOR_859 | CHARACTER VARYING(7) | 7 |
| 372 | U_GROSS_REAL_V_EX_GST_860 | NUMERIC(11,2) | 19 |
| 373 | U_GROSS_RENTAL_INCOME_861 | NUMERIC(11,2) | 19 |
| 374 | U_EXPERIENCE_862 | INTEGER | 4 |
| 375 | U_INTANGIBLE_ASSETS_863 | INTEGER | 4 |
| 376 | U_INTEREST_EXPENSE_864 | NUMERIC(11,2) | 19 |
| 377 | U_INTERNAL_RATEOFRET_865 | NUMERIC(7,2) | 19 |
| 378 | U_INVENTORY_866 | INTEGER | 4 |
| 379 | U_B2BAY_SPARE_43_867 | NUMERIC(11,2) | 19 |
| 380 | U_B2BAY_SPARE_44_868 | NUMERIC(11,2) | 19 |
| 381 | U_B2BAY_SPARE_45_869 | NUMERIC(11,2) | 19 |
| 382 | U_LIVING_ALLOWANCE_870 | NUMERIC(11,2) | 19 |
| 383 | U_MGMT_INTEGRITY_871 | CHARACTER VARYING(2) | 2 |
| 384 | U_MATURITY_CURR_T_872 | SMALLINT | 2 |
| 385 | U_B2BAY_SPARE_46_873 | NUMERIC(11,2) | 19 |
| 386 | U_B2BAY_SPARE_72_874 | NUMERIC(11,2) | 19 |
| 387 | U_B2BAY_SPARE_47_875 | NUMERIC(11,2) | 19 |
| 388 | U_B2BAY_SPARE_66_876 | SMALLINT | 2 |
| 389 | U_NON_CURRENT_ASSETS_877 | INTEGER | 4 |
| 390 | U_B2BAY_SPARE_48_878 | INTEGER | 4 |
| 391 | U_NONOPERATING_EXP_879 | NUMERIC(11,2) | 19 |
| 392 | U_NONOPERATING_INCOME_880 | NUMERIC(11,2) | 19 |
| 393 | U_N_PROJ_UNDRTN_PRINC_881 | INTEGER | 4 |
| 394 | U_N_SUCPRJ_COMP_PRINC_882 | INTEGER | 4 |
| 395 | U_OFFICERS_COMPENS_883 | NUMERIC(11,2) | 19 |
| 396 | U_B2BAY_SPARE_49_884 | NUMERIC(11,2) | 19 |
| 397 | U_PAST_PROJ_SUC_R_PCT_885 | SMALLINT | 2 |
| 398 | U_PHY_ATTR_RISK_MGM_P_886 | CHARACTER VARYING(7) | 7 |
| 399 | U_B2BAY_SPARE_50_887 | INTEGER | 4 |
| 400 | U_B2BAY_SPARE_51_888 | INTEGER | 4 |
| 401 | U_B2BAY_SPARE_52_889 | INTEGER | 4 |
| 402 | U_B2BAY_SPARE_53_890 | INTEGER | 4 |
| 403 | U_POST_DDSOP_SM_OBLOC_891 | INTEGER | 4 |
| 404 | U_POST_DDSOP_SM_PAYAD_892 | INTEGER | 4 |
| 405 | U_B2BAY_SPARE_54_893 | INTEGER | 4 |
| 406 | U_B2BAY_SPARE_55_894 | INTEGER | 4 |
| 407 | U_POST_DDSOP_TOT_NCA_895 | INTEGER | 4 |
| 408 | U_POST_DDSOP_TOT_NCL_896 | INTEGER | 4 |
| 409 | U_PRESALES_AMOUNT_897 | NUMERIC(11,2) | 19 |
| 410 | U_B2BAY_SPARE_73_898 | NUMERIC(11,2) | 19 |
| 411 | U_PROJECT_COST_899 | NUMERIC(11,2) | 19 |
| 412 | U_PROJ_COST2GRV_RATIO_900 | NUMERIC(7,2) | 19 |
| 413 | U_PROJ_GEARING_POS_901 | NUMERIC(7,2) | 19 |
| 414 | U_PROJECTD_DEBTCOV_R_902 | NUMERIC(7,2) | 19 |
| 415 | U_PROJECTD_FNDS_ADS_903 | NUMERIC(11,2) | 19 |
| 416 | U_PROPERTY_CONDITION_904 | CHARACTER VARYING(2) | 2 |
| 417 | U_B2BAY_SPARE_56_905 | INTEGER | 4 |
| 418 | U_B2BAY_SPARE_57_906 | NUMERIC(7,2) | 19 |
| 419 | U_PRESALES2LOAN_RATIO_907 | NUMERIC(7,2) | 19 |
| 420 | U_RELTD_PARTYLOANS_A_908 | INTEGER | 4 |
| 421 | U_RELTD_PARTY_LOANS_L_909 | INTEGER | 4 |
| 422 | U_RENT_ARREARS_910 | NUMERIC(11,2) | 19 |
| 423 | U_RENT_ARREARS_PCT_911 | NUMERIC(7,2) | 19 |
| 424 | U_RENTAL_INCOME_PERF_912 | NUMERIC(7,2) | 19 |
| 425 | U_SALES_913 | NUMERIC(11,2) | 19 |
| 426 | U_SIMILARITY_PRE_PROJ_914 | CHARACTER VARYING(2) | 2 |
| 427 | U_SRC_OF_SPONSOR_EQ_915 | CHARACTER VARYING(2) | 2 |
| 428 | U_TANGIBLE_ASSETS_916 | INTEGER | 4 |
| 429 | U_TANGIBLE_NET_WORTH_917 | INTEGER | 4 |
| 430 | U_TRG_SALES2INVST_PCT_918 | NUMERIC(7,2) | 19 |
| 431 | U_TENANCY_MIX_919 | CHARACTER VARYING(7) | 7 |
| 432 | U_TERM_OF_THE_PROJECT_920 | SMALLINT | 2 |
| 433 | U_TOT_LIABILITIES_921 | INTEGER | 4 |
| 434 | U_TOT_ASSETS_922 | INTEGER | 4 |
| 435 | U_B2BAY_SPARE_58_923 | INTEGER | 4 |
| 436 | U_TOT_EXPENSES_924 | NUMERIC(11,2) | 19 |
| 437 | U_B2BAY_SPARE_59_925 | NUMERIC(11,2) | 19 |
| 438 | U_B2BAY_SPARE_60_926 | INTEGER | 4 |
| 439 | U_B2BAY_SPARE_61_927 | INTEGER | 4 |
| 440 | U_B2BAY_SPARE_62_928 | INTEGER | 4 |
| 441 | U_TOT_MOTOR_VEHICLE_A_929 | INTEGER | 4 |
| 442 | U_B2BAY_SPARE_63_930 | INTEGER | 4 |
| 443 | U_B2BAY_SPARE_64_931 | INTEGER | 4 |
| 444 | U_B2BAY_SPARE_65_932 | INTEGER | 4 |
| 445 | U_TOT_PLANT_EQUIP_A_933 | INTEGER | 4 |
| 446 | U_TRADE_CREDITORS_934 | INTEGER | 4 |
| 447 | U_VACANCY_PCT_935 | NUMERIC(7,2) | 19 |
| 448 | U_WRKNG_CAP2SALES_PCT_936 | NUMERIC(8,3) | 19 |
| 449 | U_WORKING_WITHIN_BUD_937 | NUMERIC(7,2) | 19 |
| 450 | U_YRS_AS_SELFEMP_DEVL_938 | SMALLINT | 2 |
| 451 | U_ASSET_REVALUATIONS_939 | NUMERIC(15,2) | 19 |
| 452 | U_COST_OF_GOODS_SOLD_940 | NUMERIC(15,2) | 19 |
| 453 | U_NET_PRO_B_INT_A_TAX_941 | NUMERIC(15,2) | 19 |
| 454 | U_PRO_B_TAX_EXTORD_I_942 | NUMERIC(15,2) | 19 |
| 455 | U_B2BAY_SPARE_5_943 | INTEGER | 4 |
| 456 | U_B2BAY_SPARE_6_944 | INTEGER | 4 |
| 457 | U_B2BAY_SPARE_7_945 | INTEGER | 4 |
| 458 | U_B2BAY_SPARE_8_946 | INTEGER | 4 |
| 459 | U_B2BAY_SPARE_9_947 | NUMERIC(12,2) | 19 |
| 460 | U_B2BAY_SPARE_10_948 | NUMERIC(12,2) | 19 |
| 461 | U_B2BAY_SPARE_11_949 | NUMERIC(12,2) | 19 |
| 462 | U_B2BAY_SPARE_12_950 | NUMERIC(12,2) | 19 |
| 463 | U_B2BAY_SPARE_13_951 | NUMERIC(12,2) | 19 |
| 464 | U_B2BAY_SPARE_14_952 | NUMERIC(12,2) | 19 |
| 465 | U_B2BAY_SPARE_15_953 | NUMERIC(12,2) | 19 |
| 466 | U_SUBGROUP_OF_GOODS2_954 | CHARACTER VARYING(4) | 4 |
| 467 | U_B2BAY_SPARE_17_955 | CHARACTER VARYING(4) | 4 |
| 468 | U_B2BAY_SPARE_18_956 | CHARACTER VARYING(4) | 4 |
| 469 | U_B2BAY_SPARE_19_957 | CHARACTER VARYING(4) | 4 |
| 470 | U_B2BAY_SPARE_20_958 | CHARACTER VARYING(4) | 4 |
| 471 | U_SERVICING_AMT_1061 | INTEGER | 4 |
| 472 | U_OVERWRITE_DEC_CAT_1062 | CHARACTER VARYING(1) | 1 |
| 473 | U_SELFEMP_INC_VAR_1177 | NUMERIC(7,2) | 19 |
| 474 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 475 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 476 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 477 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |