PSC_BL_TAX_DETAIL

Stores the tax details of a business licence for a reporting period.

Details

  • Schema: FUSION

  • Object owner: PSC_BL

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PSC_BL_TAX_DETAIL_PK

BL_TAXDETAIL_KEY

Columns

Name Datatype Length Precision Not-null Comments
BL_TAXDETAIL_KEY NUMBER 18 Yes This column is used to indicate unique id for the tax details.
BL_TAXDETAIL_PUID VARCHAR2 480 Yes This column is used to indicate the public unique identifier for the tax detail record.
LNP_RECORD_KEY NUMBER 18 Yes This column is used to indicate unique identifier of LNP Record.
LNP_RECORD_ID VARCHAR2 50 Yes This column is used to indicate LNP Record ID.
LNP_RECORD_PUID VARCHAR2 480 Yes This column is used to indicate the public unique identifier for the LNP record.
REPORTING_PERIOD VARCHAR2 100 Yes The reporting period that applies to the transaction.
AGENCY_ID NUMBER 8 Yes This column is used to indicate Agency ID.
TAX_CLASS_CODE VARCHAR2 50 Yes Code to identify a business licence tax class.
CURRENCY_CODE VARCHAR2 3 Yes Identifier of a currency code according to the three character ISO standard.
ACTUAL_GROSS NUMBER This field is used to indicate the actual gross receipts reported.
ESTIMATED_GROSS NUMBER This field is used to indicate the estimated gross receipts reported.
FT_EMP_COUNT NUMBER This field is used to indicate the number of full time employees reported.
VEHICLE_NUM NUMBER This field is used to indicate the number of vehicles reported.
RES_UNIT_NUM NUMBER This field is used to indicate the number of residential units reported.
SQFT_COM_UNIT NUMBER This field is used to indicate the square footage of commercial rental units reported.
ADM_CHARGE NUMBER This field is used to indicate the total admission charge reported.
HOTEL_FEES NUMBER This field is used to indicate the motel or hotel fees reported.
MIGRATED_DATA_FLAG VARCHAR2 3 This column is used to indicate whether the tax detail record is migrated.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CUSTOM_ATTRIBUTE_1 NUMBER This field is used to indicate the custom attribute 1.
CUSTOM_ATTRIBUTE_2 NUMBER This field is used to indicate the custom attribute 2.
CUSTOM_ATTRIBUTE_3 NUMBER This field is used to indicate the custom attribute 3.
CUSTOM_ATTRIBUTE_4 NUMBER This field is used to indicate the custom attribute 4.
CUSTOM_ATTRIBUTE_5 NUMBER This field is used to indicate the custom attribute 5.
CUSTOM_ATTRIBUTE_6 NUMBER This field is used to indicate the custom attribute 6.
CUSTOM_ATTRIBUTE_7 NUMBER This field is used to indicate the custom attribute 7.
CUSTOM_ATTRIBUTE_8 NUMBER This field is used to indicate the custom attribute 8.
CUSTOM_ATTRIBUTE_9 NUMBER This field is used to indicate the custom attribute 9.
CUSTOM_ATTRIBUTE_10 NUMBER This field is used to indicate the custom attribute 10.
CUSTOM_ATTRIBUTE_11 NUMBER This field is used to indicate the custom attribute 11.
CUSTOM_ATTRIBUTE_12 NUMBER This field is used to indicate the custom attribute 12.
CUSTOM_ATTRIBUTE_13 NUMBER This field is used to indicate the custom attribute 13.
CUSTOM_ATTRIBUTE_14 NUMBER This field is used to indicate the custom attribute 14.
CUSTOM_ATTRIBUTE_15 NUMBER This field is used to indicate the custom attribute 15.
CUSTOM_ATTRIBUTE_16 NUMBER This field is used to indicate the custom attribute 16.
CUSTOM_ATTRIBUTE_17 NUMBER This field is used to indicate the custom attribute 17.
CUSTOM_ATTRIBUTE_18 NUMBER This field is used to indicate the custom attribute 18.
CUSTOM_ATTRIBUTE_19 NUMBER This field is used to indicate the custom attribute 19.
CUSTOM_ATTRIBUTE_20 NUMBER This field is used to indicate the custom attribute 20.
CUSTOM_ATTRIBUTE_21 NUMBER This field is used to indicate the custom attribute 21.
CUSTOM_ATTRIBUTE_22 NUMBER This field is used to indicate the custom attribute 22.
CUSTOM_ATTRIBUTE_23 NUMBER This field is used to indicate the custom attribute 23.
CUSTOM_ATTRIBUTE_24 NUMBER This field is used to indicate the custom attribute 24.
CUSTOM_ATTRIBUTE_25 NUMBER This field is used to indicate the custom attribute 25.
CUSTOM_ATTRIBUTE_26 NUMBER This field is used to indicate the custom attribute 26.
CUSTOM_ATTRIBUTE_27 NUMBER This field is used to indicate the custom attribute 27.
CUSTOM_ATTRIBUTE_28 NUMBER This field is used to indicate the custom attribute 28.
CUSTOM_ATTRIBUTE_29 NUMBER This field is used to indicate the custom attribute 29.
CUSTOM_ATTRIBUTE_30 NUMBER This field is used to indicate the custom attribute 30.
CUSTOM_ATTRIBUTE_31 NUMBER This field is used to indicate the custom attribute 31.
CUSTOM_ATTRIBUTE_32 NUMBER This field is used to indicate the custom attribute 32.
CUSTOM_ATTRIBUTE_33 NUMBER This field is used to indicate the custom attribute 33.
CUSTOM_ATTRIBUTE_34 NUMBER This field is used to indicate the custom attribute 34.
CUSTOM_ATTRIBUTE_35 NUMBER This field is used to indicate the custom attribute 35.
CUSTOM_ATTRIBUTE_36 NUMBER This field is used to indicate the custom attribute 36.
CUSTOM_ATTRIBUTE_37 NUMBER This field is used to indicate the custom attribute 37.
CUSTOM_ATTRIBUTE_38 NUMBER This field is used to indicate the custom attribute 38.
CUSTOM_ATTRIBUTE_39 NUMBER This field is used to indicate the custom attribute 39.
CUSTOM_ATTRIBUTE_40 NUMBER This field is used to indicate the custom attribute 40.
CUSTOM_ATTRIBUTE_41 NUMBER This field is used to indicate the custom attribute 41.
CUSTOM_ATTRIBUTE_42 NUMBER This field is used to indicate the custom attribute 42.
CUSTOM_ATTRIBUTE_43 NUMBER This field is used to indicate the custom attribute 43.
CUSTOM_ATTRIBUTE_44 NUMBER This field is used to indicate the custom attribute 44.
CUSTOM_ATTRIBUTE_45 NUMBER This field is used to indicate the custom attribute 45.
CUSTOM_ATTRIBUTE_46 NUMBER This field is used to indicate the custom attribute 46.
CUSTOM_ATTRIBUTE_47 NUMBER This field is used to indicate the custom attribute 47.
CUSTOM_ATTRIBUTE_48 NUMBER This field is used to indicate the custom attribute 48.
CUSTOM_ATTRIBUTE_49 NUMBER This field is used to indicate the custom attribute 49.
CUSTOM_ATTRIBUTE_50 NUMBER This field is used to indicate the custom attribute 50.
CUSTOM_ATTRIBUTE_51 NUMBER This field is used to indicate the custom attribute 51.
CUSTOM_ATTRIBUTE_52 NUMBER This field is used to indicate the custom attribute 52.
CUSTOM_ATTRIBUTE_53 NUMBER This field is used to indicate the custom attribute 53.
CUSTOM_ATTRIBUTE_54 NUMBER This field is used to indicate the custom attribute 54.
CUSTOM_ATTRIBUTE_55 NUMBER This field is used to indicate the custom attribute 55.
CUSTOM_ATTRIBUTE_56 NUMBER This field is used to indicate the custom attribute 56.
CUSTOM_ATTRIBUTE_57 NUMBER This field is used to indicate the custom attribute 57.
CUSTOM_ATTRIBUTE_58 NUMBER This field is used to indicate the custom attribute 58.
CUSTOM_ATTRIBUTE_59 NUMBER This field is used to indicate the custom attribute 59.
CUSTOM_ATTRIBUTE_60 NUMBER This field is used to indicate the custom attribute 60.
CUSTOM_ATTRIBUTE_61 NUMBER This field is used to indicate the custom attribute 61.
CUSTOM_ATTRIBUTE_62 NUMBER This field is used to indicate the custom attribute 62.
CUSTOM_ATTRIBUTE_63 NUMBER This field is used to indicate the custom attribute 63.
CUSTOM_ATTRIBUTE_64 NUMBER This field is used to indicate the custom attribute 64.
CUSTOM_ATTRIBUTE_65 NUMBER This field is used to indicate the custom attribute 65.
CUSTOM_ATTRIBUTE_66 NUMBER This field is used to indicate the custom attribute 66.
CUSTOM_ATTRIBUTE_67 NUMBER This field is used to indicate the custom attribute 67.
CUSTOM_ATTRIBUTE_68 NUMBER This field is used to indicate the custom attribute 68.
CUSTOM_ATTRIBUTE_69 NUMBER This field is used to indicate the custom attribute 69.
CUSTOM_ATTRIBUTE_70 NUMBER This field is used to indicate the custom attribute 70.
CUSTOM_ATTRIBUTE_71 NUMBER This field is used to indicate the custom attribute 71.
CUSTOM_ATTRIBUTE_72 NUMBER This field is used to indicate the custom attribute 72.
CUSTOM_ATTRIBUTE_73 NUMBER This field is used to indicate the custom attribute 73.
CUSTOM_ATTRIBUTE_74 NUMBER This field is used to indicate the custom attribute 74.
CUSTOM_ATTRIBUTE_75 NUMBER This field is used to indicate the custom attribute 75.
CUSTOM_ATTRIBUTE_76 NUMBER This field is used to indicate the custom attribute 76.
CUSTOM_ATTRIBUTE_77 NUMBER This field is used to indicate the custom attribute 77.
CUSTOM_ATTRIBUTE_78 NUMBER This field is used to indicate the custom attribute 78.
CUSTOM_ATTRIBUTE_79 NUMBER This field is used to indicate the custom attribute 79.
CUSTOM_ATTRIBUTE_80 NUMBER This field is used to indicate the custom attribute 80.
CUSTOM_ATTRIBUTE_81 NUMBER This field is used to indicate the custom attribute 81.
CUSTOM_ATTRIBUTE_82 NUMBER This field is used to indicate the custom attribute 82.
CUSTOM_ATTRIBUTE_83 NUMBER This field is used to indicate the custom attribute 83.
CUSTOM_ATTRIBUTE_84 NUMBER This field is used to indicate the custom attribute 84.
CUSTOM_ATTRIBUTE_85 NUMBER This field is used to indicate the custom attribute 85.
CUSTOM_ATTRIBUTE_86 NUMBER This field is used to indicate the custom attribute 86.
CUSTOM_ATTRIBUTE_87 NUMBER This field is used to indicate the custom attribute 87.
CUSTOM_ATTRIBUTE_88 NUMBER This field is used to indicate the custom attribute 88.
CUSTOM_ATTRIBUTE_89 NUMBER This field is used to indicate the custom attribute 89.
CUSTOM_ATTRIBUTE_90 NUMBER This field is used to indicate the custom attribute 90.
CUSTOM_ATTRIBUTE_91 NUMBER This field is used to indicate the custom attribute 91.
CUSTOM_ATTRIBUTE_92 NUMBER This field is used to indicate the custom attribute 92.
CUSTOM_ATTRIBUTE_93 NUMBER This field is used to indicate the custom attribute 93.
CUSTOM_ATTRIBUTE_94 NUMBER This field is used to indicate the custom attribute 94.
CUSTOM_ATTRIBUTE_95 NUMBER This field is used to indicate the custom attribute 95.
CUSTOM_ATTRIBUTE_96 NUMBER This field is used to indicate the custom attribute 96.
CUSTOM_ATTRIBUTE_97 NUMBER This field is used to indicate the custom attribute 97.
CUSTOM_ATTRIBUTE_98 NUMBER This field is used to indicate the custom attribute 98.
CUSTOM_ATTRIBUTE_99 NUMBER This field is used to indicate the custom attribute 99.
CUSTOM_ATTRIBUTE_100 NUMBER This field is used to indicate the custom attribute 100.
CUSTOM_ATTRIBUTE_101 NUMBER This field is used to indicate the custom attribute 101.
CUSTOM_ATTRIBUTE_102 NUMBER This field is used to indicate the custom attribute 102.
CUSTOM_ATTRIBUTE_103 NUMBER This field is used to indicate the custom attribute 103.
CUSTOM_ATTRIBUTE_104 NUMBER This field is used to indicate the custom attribute 104.
CUSTOM_ATTRIBUTE_105 NUMBER This field is used to indicate the custom attribute 105.
CUSTOM_ATTRIBUTE_106 NUMBER This field is used to indicate the custom attribute 106.
CUSTOM_ATTRIBUTE_107 NUMBER This field is used to indicate the custom attribute 107.
CUSTOM_ATTRIBUTE_108 NUMBER This field is used to indicate the custom attribute 108.
CUSTOM_ATTRIBUTE_109 NUMBER This field is used to indicate the custom attribute 109.
CUSTOM_ATTRIBUTE_110 NUMBER This field is used to indicate the custom attribute 110.
CUSTOM_ATTRIBUTE_111 NUMBER This field is used to indicate the custom attribute 111.
CUSTOM_ATTRIBUTE_112 NUMBER This field is used to indicate the custom attribute 112.
CUSTOM_ATTRIBUTE_113 NUMBER This field is used to indicate the custom attribute 113.
CUSTOM_ATTRIBUTE_114 NUMBER This field is used to indicate the custom attribute 114.
CUSTOM_ATTRIBUTE_115 NUMBER This field is used to indicate the custom attribute 115.
CUSTOM_ATTRIBUTE_116 NUMBER This field is used to indicate the custom attribute 116.
CUSTOM_ATTRIBUTE_117 NUMBER This field is used to indicate the custom attribute 117.
CUSTOM_ATTRIBUTE_118 NUMBER This field is used to indicate the custom attribute 118.
CUSTOM_ATTRIBUTE_119 NUMBER This field is used to indicate the custom attribute 119.
CUSTOM_ATTRIBUTE_120 NUMBER This field is used to indicate the custom attribute 120.
CUSTOM_ATTRIBUTE_121 NUMBER This field is used to indicate the custom attribute 121.
CUSTOM_ATTRIBUTE_122 NUMBER This field is used to indicate the custom attribute 122.
CUSTOM_ATTRIBUTE_123 NUMBER This field is used to indicate the custom attribute 123.
CUSTOM_ATTRIBUTE_124 NUMBER This field is used to indicate the custom attribute 124.
CUSTOM_ATTRIBUTE_125 NUMBER This field is used to indicate the custom attribute 125.
CUSTOM_ATTRIBUTE_126 NUMBER This field is used to indicate the custom attribute 126.
CUSTOM_ATTRIBUTE_127 NUMBER This field is used to indicate the custom attribute 127.
CUSTOM_ATTRIBUTE_128 NUMBER This field is used to indicate the custom attribute 128.
CUSTOM_ATTRIBUTE_129 NUMBER This field is used to indicate the custom attribute 129.
CUSTOM_ATTRIBUTE_130 NUMBER This field is used to indicate the custom attribute 130.
CUSTOM_ATTRIBUTE_131 NUMBER This field is used to indicate the custom attribute 131.
CUSTOM_ATTRIBUTE_132 NUMBER This field is used to indicate the custom attribute 132.
CUSTOM_ATTRIBUTE_133 NUMBER This field is used to indicate the custom attribute 133.
CUSTOM_ATTRIBUTE_134 NUMBER This field is used to indicate the custom attribute 134.
CUSTOM_ATTRIBUTE_135 NUMBER This field is used to indicate the custom attribute 135.
CUSTOM_ATTRIBUTE_136 NUMBER This field is used to indicate the custom attribute 136.
CUSTOM_ATTRIBUTE_137 NUMBER This field is used to indicate the custom attribute 137.
CUSTOM_ATTRIBUTE_138 NUMBER This field is used to indicate the custom attribute 138.
CUSTOM_ATTRIBUTE_139 NUMBER This field is used to indicate the custom attribute 139.
CUSTOM_ATTRIBUTE_140 NUMBER This field is used to indicate the custom attribute 140.
CUSTOM_ATTRIBUTE_141 NUMBER This field is used to indicate the custom attribute 141.
CUSTOM_ATTRIBUTE_142 NUMBER This field is used to indicate the custom attribute 142.
CUSTOM_ATTRIBUTE_143 NUMBER This field is used to indicate the custom attribute 143.
CUSTOM_ATTRIBUTE_144 NUMBER This field is used to indicate the custom attribute 144.
CUSTOM_ATTRIBUTE_145 NUMBER This field is used to indicate the custom attribute 145.
CUSTOM_ATTRIBUTE_146 NUMBER This field is used to indicate the custom attribute 146.
CUSTOM_ATTRIBUTE_147 NUMBER This field is used to indicate the custom attribute 147.
CUSTOM_ATTRIBUTE_148 NUMBER This field is used to indicate the custom attribute 148.
CUSTOM_ATTRIBUTE_149 NUMBER This field is used to indicate the custom attribute 149.
CUSTOM_ATTRIBUTE_150 NUMBER This field is used to indicate the custom attribute 150.
CUSTOM_ATTRIBUTE_151 NUMBER This field is used to indicate the custom attribute 151.
CUSTOM_ATTRIBUTE_152 NUMBER This field is used to indicate the custom attribute 152.
CUSTOM_ATTRIBUTE_153 NUMBER This field is used to indicate the custom attribute 153.
CUSTOM_ATTRIBUTE_154 NUMBER This field is used to indicate the custom attribute 154.
CUSTOM_ATTRIBUTE_155 NUMBER This field is used to indicate the custom attribute 155.
CUSTOM_ATTRIBUTE_156 NUMBER This field is used to indicate the custom attribute 156.
CUSTOM_ATTRIBUTE_157 NUMBER This field is used to indicate the custom attribute 157.
CUSTOM_ATTRIBUTE_158 NUMBER This field is used to indicate the custom attribute 158.
CUSTOM_ATTRIBUTE_159 NUMBER This field is used to indicate the custom attribute 159.
CUSTOM_ATTRIBUTE_160 NUMBER This field is used to indicate the custom attribute 160.
CUSTOM_ATTRIBUTE_161 NUMBER This field is used to indicate the custom attribute 161.
CUSTOM_ATTRIBUTE_162 NUMBER This field is used to indicate the custom attribute 162.
CUSTOM_ATTRIBUTE_163 NUMBER This field is used to indicate the custom attribute 163.
CUSTOM_ATTRIBUTE_164 NUMBER This field is used to indicate the custom attribute 164.
CUSTOM_ATTRIBUTE_165 NUMBER This field is used to indicate the custom attribute 165.
CUSTOM_ATTRIBUTE_166 NUMBER This field is used to indicate the custom attribute 166.
CUSTOM_ATTRIBUTE_167 NUMBER This field is used to indicate the custom attribute 167.
CUSTOM_ATTRIBUTE_168 NUMBER This field is used to indicate the custom attribute 168.
CUSTOM_ATTRIBUTE_169 NUMBER This field is used to indicate the custom attribute 169.
CUSTOM_ATTRIBUTE_170 NUMBER This field is used to indicate the custom attribute 170.
CUSTOM_ATTRIBUTE_171 NUMBER This field is used to indicate the custom attribute 171.
CUSTOM_ATTRIBUTE_172 NUMBER This field is used to indicate the custom attribute 172.
CUSTOM_ATTRIBUTE_173 NUMBER This field is used to indicate the custom attribute 173.
CUSTOM_ATTRIBUTE_174 NUMBER This field is used to indicate the custom attribute 174.
CUSTOM_ATTRIBUTE_175 NUMBER This field is used to indicate the custom attribute 175.
CUSTOM_ATTRIBUTE_176 NUMBER This field is used to indicate the custom attribute 176.
CUSTOM_ATTRIBUTE_177 NUMBER This field is used to indicate the custom attribute 177.
CUSTOM_ATTRIBUTE_178 NUMBER This field is used to indicate the custom attribute 178.
CUSTOM_ATTRIBUTE_179 NUMBER This field is used to indicate the custom attribute 179.
CUSTOM_ATTRIBUTE_180 NUMBER This field is used to indicate the custom attribute 180.
CUSTOM_ATTRIBUTE_181 NUMBER This field is used to indicate the custom attribute 181.
CUSTOM_ATTRIBUTE_182 NUMBER This field is used to indicate the custom attribute 182.
CUSTOM_ATTRIBUTE_183 NUMBER This field is used to indicate the custom attribute 183.
CUSTOM_ATTRIBUTE_184 NUMBER This field is used to indicate the custom attribute 184.
CUSTOM_ATTRIBUTE_185 NUMBER This field is used to indicate the custom attribute 185.
CUSTOM_ATTRIBUTE_186 NUMBER This field is used to indicate the custom attribute 186.
CUSTOM_ATTRIBUTE_187 NUMBER This field is used to indicate the custom attribute 187.
CUSTOM_ATTRIBUTE_188 NUMBER This field is used to indicate the custom attribute 188.
CUSTOM_ATTRIBUTE_189 NUMBER This field is used to indicate the custom attribute 189.
CUSTOM_ATTRIBUTE_190 NUMBER This field is used to indicate the custom attribute 190.
CUSTOM_ATTRIBUTE_191 NUMBER This field is used to indicate the custom attribute 191.
CUSTOM_ATTRIBUTE_192 NUMBER This field is used to indicate the custom attribute 192.
CUSTOM_ATTRIBUTE_193 NUMBER This field is used to indicate the custom attribute 193.
CUSTOM_ATTRIBUTE_194 NUMBER This field is used to indicate the custom attribute 194.
CUSTOM_ATTRIBUTE_195 NUMBER This field is used to indicate the custom attribute 195.
CUSTOM_ATTRIBUTE_196 NUMBER This field is used to indicate the custom attribute 196.
CUSTOM_ATTRIBUTE_197 NUMBER This field is used to indicate the custom attribute 197.
CUSTOM_ATTRIBUTE_198 NUMBER This field is used to indicate the custom attribute 198.
CUSTOM_ATTRIBUTE_199 NUMBER This field is used to indicate the custom attribute 199.
CUSTOM_ATTRIBUTE_200 NUMBER This field is used to indicate the custom attribute 200.

Foreign Keys

Table Foreign Table Foreign Key Column
psc_bl_taxdtl_attach psc_bl_tax_detail BL_TAXDETAIL_KEY

Indexes

Index Uniqueness Tablespace Columns
PSC_BL_TAX_DETAIL_PK Unique Default BL_TAXDETAIL_KEY
PSC_BL_TAX_DETAIL_U1 Unique PSC_BL_TAX_DETAIL_U1 BL_TAXDETAIL_PUID