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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, 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 | This column is used to indicate the public unique identifier for the tax detail record.. | ||
| LNP_RECORD_KEY | NUMBER | 18 | This column is used to indicate unique identifier of LNP Record. | ||
| LNP_RECORD_ID | VARCHAR2 | 50 | This column is used to indicate LNP Record ID. | ||
| LNP_RECORD_PUID | VARCHAR2 | 480 | This column is used to indicate the public unique identifier for the LNP record. | ||
| REPORTING_PERIOD | VARCHAR2 | 100 | The reporting period that applies to the transaction. | ||
| AGENCY_ID | NUMBER | 8 | This column is used to indicate Agency ID. | ||
| TAX_CLASS_CODE | VARCHAR2 | 50 | Code to identify a business licence tax class. | ||
| CURRENCY_CODE | VARCHAR2 | 3 | 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 | 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 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | |||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_BL_TAX_DETAILN1_ | Non Unique | Default | BL_TAXDETAIL_KEY, LAST_UPDATE_DATE |
| PSC_BL_TAX_DETAIL_PK_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, BL_TAXDETAIL_KEY |