| 1 |
INVENTORY_ITEM_ID |
BIGINT |
8 |
| 2 |
ORGANIZATION_ID |
BIGINT |
8 |
| 3 |
LAST_UPDATE_DATE |
TIMESTAMP |
8 |
| 4 |
LAST_UPDATED_BY |
BIGINT |
8 |
| 5 |
CREATION_DATE |
TIMESTAMP |
8 |
| 6 |
CREATED_BY |
BIGINT |
8 |
| 7 |
LAST_UPDATE_LOGIN |
BIGINT |
8 |
| 8 |
SUMMARY_FLAG |
CHARACTER VARYING(1) |
1 |
| 9 |
ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 10 |
START_DATE_ACTIVE |
TIMESTAMP |
8 |
| 11 |
END_DATE_ACTIVE |
TIMESTAMP |
8 |
| 12 |
DESCRIPTION |
CHARACTER VARYING(240) |
240 |
| 13 |
BUYER_ID |
BIGINT |
8 |
| 14 |
ACCOUNTING_RULE_ID |
BIGINT |
8 |
| 15 |
INVOICING_RULE_ID |
BIGINT |
8 |
| 16 |
SEGMENT1 |
CHARACTER VARYING(40) |
40 |
| 17 |
SEGMENT2 |
CHARACTER VARYING(40) |
40 |
| 18 |
SEGMENT3 |
CHARACTER VARYING(40) |
40 |
| 19 |
SEGMENT4 |
CHARACTER VARYING(40) |
40 |
| 20 |
SEGMENT5 |
CHARACTER VARYING(40) |
40 |
| 21 |
SEGMENT6 |
CHARACTER VARYING(40) |
40 |
| 22 |
SEGMENT7 |
CHARACTER VARYING(40) |
40 |
| 23 |
SEGMENT8 |
CHARACTER VARYING(40) |
40 |
| 24 |
SEGMENT9 |
CHARACTER VARYING(40) |
40 |
| 25 |
SEGMENT10 |
CHARACTER VARYING(40) |
40 |
| 26 |
SEGMENT11 |
CHARACTER VARYING(40) |
40 |
| 27 |
SEGMENT12 |
CHARACTER VARYING(40) |
40 |
| 28 |
SEGMENT13 |
CHARACTER VARYING(40) |
40 |
| 29 |
SEGMENT14 |
CHARACTER VARYING(40) |
40 |
| 30 |
SEGMENT15 |
CHARACTER VARYING(40) |
40 |
| 31 |
SEGMENT16 |
CHARACTER VARYING(40) |
40 |
| 32 |
SEGMENT17 |
CHARACTER VARYING(40) |
40 |
| 33 |
SEGMENT18 |
CHARACTER VARYING(40) |
40 |
| 34 |
SEGMENT19 |
CHARACTER VARYING(40) |
40 |
| 35 |
SEGMENT20 |
CHARACTER VARYING(40) |
40 |
| 36 |
ATTRIBUTE_CATEGORY |
CHARACTER VARYING(30) |
30 |
| 37 |
ATTRIBUTE1 |
CHARACTER VARYING(240) |
240 |
| 38 |
ATTRIBUTE2 |
CHARACTER VARYING(240) |
240 |
| 39 |
ATTRIBUTE3 |
CHARACTER VARYING(240) |
240 |
| 40 |
ATTRIBUTE4 |
CHARACTER VARYING(240) |
240 |
| 41 |
ATTRIBUTE5 |
CHARACTER VARYING(240) |
240 |
| 42 |
ATTRIBUTE6 |
CHARACTER VARYING(240) |
240 |
| 43 |
ATTRIBUTE7 |
CHARACTER VARYING(240) |
240 |
| 44 |
ATTRIBUTE8 |
CHARACTER VARYING(240) |
240 |
| 45 |
ATTRIBUTE9 |
CHARACTER VARYING(240) |
240 |
| 46 |
ATTRIBUTE10 |
CHARACTER VARYING(240) |
240 |
| 47 |
ATTRIBUTE11 |
CHARACTER VARYING(240) |
240 |
| 48 |
ATTRIBUTE12 |
CHARACTER VARYING(240) |
240 |
| 49 |
ATTRIBUTE13 |
CHARACTER VARYING(240) |
240 |
| 50 |
ATTRIBUTE14 |
CHARACTER VARYING(240) |
240 |
| 51 |
ATTRIBUTE15 |
CHARACTER VARYING(240) |
240 |
| 52 |
PURCHASING_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 53 |
SHIPPABLE_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 54 |
CUSTOMER_ORDER_FLAG |
CHARACTER VARYING(1) |
1 |
| 55 |
INTERNAL_ORDER_FLAG |
CHARACTER VARYING(1) |
1 |
| 56 |
SERVICE_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 57 |
INVENTORY_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 58 |
ENG_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 59 |
INVENTORY_ASSET_FLAG |
CHARACTER VARYING(1) |
1 |
| 60 |
PURCHASING_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 61 |
CUSTOMER_ORDER_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 62 |
INTERNAL_ORDER_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 63 |
SO_TRANSACTIONS_FLAG |
CHARACTER VARYING(1) |
1 |
| 64 |
MTL_TRANSACTIONS_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 65 |
STOCK_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 66 |
BOM_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 67 |
BUILD_IN_WIP_FLAG |
CHARACTER VARYING(1) |
1 |
| 68 |
REVISION_QTY_CONTROL_CODE |
BIGINT |
8 |
| 69 |
ITEM_CATALOG_GROUP_ID |
BIGINT |
8 |
| 70 |
CATALOG_STATUS_FLAG |
CHARACTER VARYING(1) |
1 |
| 71 |
RETURNABLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 72 |
DEFAULT_SHIPPING_ORG |
BIGINT |
8 |
| 73 |
COLLATERAL_FLAG |
CHARACTER VARYING(1) |
1 |
| 74 |
TAXABLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 75 |
QTY_RCV_EXCEPTION_CODE |
CHARACTER VARYING(25) |
25 |
| 76 |
ALLOW_ITEM_DESC_UPDATE_FLAG |
CHARACTER VARYING(1) |
1 |
| 77 |
INSPECTION_REQUIRED_FLAG |
CHARACTER VARYING(1) |
1 |
| 78 |
RECEIPT_REQUIRED_FLAG |
CHARACTER VARYING(1) |
1 |
| 79 |
MARKET_PRICE |
NUMERIC(18,2) |
19 |
| 80 |
HAZARD_CLASS_ID |
BIGINT |
8 |
| 81 |
RFQ_REQUIRED_FLAG |
CHARACTER VARYING(1) |
1 |
| 82 |
QTY_RCV_TOLERANCE |
NUMERIC(18,2) |
19 |
| 83 |
LIST_PRICE_PER_UNIT |
NUMERIC(18,2) |
19 |
| 84 |
UN_NUMBER_ID |
BIGINT |
8 |
| 85 |
PRICE_TOLERANCE_PERCENT |
NUMERIC(18,2) |
19 |
| 86 |
ASSET_CATEGORY_ID |
BIGINT |
8 |
| 87 |
ROUNDING_FACTOR |
NUMERIC(18,2) |
19 |
| 88 |
UNIT_OF_ISSUE |
CHARACTER VARYING(25) |
25 |
| 89 |
ENFORCE_SHIP_TO_LOCATION_CODE |
CHARACTER VARYING(25) |
25 |
| 90 |
ALLOW_SUBSTITUTE_RECEIPTS_FLAG |
CHARACTER VARYING(1) |
1 |
| 91 |
ALLOW_UNORDERED_RECEIPTS_FLAG |
CHARACTER VARYING(1) |
1 |
| 92 |
ALLOW_EXPRESS_DELIVERY_FLAG |
CHARACTER VARYING(1) |
1 |
| 93 |
DAYS_EARLY_RECEIPT_ALLOWED |
NUMERIC(18,2) |
19 |
| 94 |
DAYS_LATE_RECEIPT_ALLOWED |
NUMERIC(18,2) |
19 |
| 95 |
RECEIPT_DAYS_EXCEPTION_CODE |
CHARACTER VARYING(25) |
25 |
| 96 |
RECEIVING_ROUTING_ID |
BIGINT |
8 |
| 97 |
INVOICE_CLOSE_TOLERANCE |
NUMERIC(18,2) |
19 |
| 98 |
RECEIVE_CLOSE_TOLERANCE |
NUMERIC(18,2) |
19 |
| 99 |
AUTO_LOT_ALPHA_PREFIX |
CHARACTER VARYING(30) |
30 |
| 100 |
START_AUTO_LOT_NUMBER |
CHARACTER VARYING(30) |
30 |
| 101 |
LOT_CONTROL_CODE |
NUMERIC(18,2) |
19 |
| 102 |
SHELF_LIFE_CODE |
BIGINT |
8 |
| 103 |
SHELF_LIFE_DAYS |
BIGINT |
8 |
| 104 |
SERIAL_NUMBER_CONTROL_CODE |
BIGINT |
8 |
| 105 |
START_AUTO_SERIAL_NUMBER |
CHARACTER VARYING(30) |
30 |
| 106 |
AUTO_SERIAL_ALPHA_PREFIX |
CHARACTER VARYING(30) |
30 |
| 107 |
SOURCE_TYPE |
BIGINT |
8 |
| 108 |
SOURCE_ORGANIZATION_ID |
BIGINT |
8 |
| 109 |
SOURCE_SUBINVENTORY |
CHARACTER VARYING(10) |
10 |
| 110 |
EXPENSE_ACCOUNT |
BIGINT |
8 |
| 111 |
ENCUMBRANCE_ACCOUNT |
BIGINT |
8 |
| 112 |
RESTRICT_SUBINVENTORIES_CODE |
BIGINT |
8 |
| 113 |
UNIT_WEIGHT |
NUMERIC(18,2) |
19 |
| 114 |
WEIGHT_UOM_CODE |
CHARACTER VARYING(3) |
3 |
| 115 |
VOLUME_UOM_CODE |
CHARACTER VARYING(3) |
3 |
| 116 |
UNIT_VOLUME |
NUMERIC(18,2) |
19 |
| 117 |
RESTRICT_LOCATORS_CODE |
BIGINT |
8 |
| 118 |
LOCATION_CONTROL_CODE |
BIGINT |
8 |
| 119 |
SHRINKAGE_RATE |
NUMERIC(18,2) |
19 |
| 120 |
ACCEPTABLE_EARLY_DAYS |
BIGINT |
8 |
| 121 |
PLANNING_TIME_FENCE_CODE |
BIGINT |
8 |
| 122 |
DEMAND_TIME_FENCE_CODE |
BIGINT |
8 |
| 123 |
LEAD_TIME_LOT_SIZE |
NUMERIC(18,2) |
19 |
| 124 |
STD_LOT_SIZE |
NUMERIC(18,2) |
19 |
| 125 |
CUM_MANUFACTURING_LEAD_TIME |
NUMERIC(18,2) |
19 |
| 126 |
OVERRUN_PERCENTAGE |
NUMERIC(18,2) |
19 |
| 127 |
MRP_CALCULATE_ATP_FLAG |
CHARACTER VARYING(1) |
1 |
| 128 |
ACCEPTABLE_RATE_INCREASE |
NUMERIC(18,2) |
19 |
| 129 |
ACCEPTABLE_RATE_DECREASE |
NUMERIC(18,2) |
19 |
| 130 |
CUMULATIVE_TOTAL_LEAD_TIME |
NUMERIC(18,2) |
19 |
| 131 |
PLANNING_TIME_FENCE_DAYS |
BIGINT |
8 |
| 132 |
DEMAND_TIME_FENCE_DAYS |
BIGINT |
8 |
| 133 |
END_ASSEMBLY_PEGGING_FLAG |
CHARACTER VARYING(1) |
1 |
| 134 |
REPETITIVE_PLANNING_FLAG |
CHARACTER VARYING(1) |
1 |
| 135 |
PLANNING_EXCEPTION_SET |
CHARACTER VARYING(10) |
10 |
| 136 |
BOM_ITEM_TYPE |
BIGINT |
8 |
| 137 |
PICK_COMPONENTS_FLAG |
CHARACTER VARYING(1) |
1 |
| 138 |
REPLENISH_TO_ORDER_FLAG |
CHARACTER VARYING(1) |
1 |
| 139 |
BASE_ITEM_ID |
BIGINT |
8 |
| 140 |
ATP_COMPONENTS_FLAG |
CHARACTER VARYING(1) |
1 |
| 141 |
ATP_FLAG |
CHARACTER VARYING(1) |
1 |
| 142 |
FIXED_LEAD_TIME |
NUMERIC(18,2) |
19 |
| 143 |
VARIABLE_LEAD_TIME |
NUMERIC(18,2) |
19 |
| 144 |
WIP_SUPPLY_LOCATOR_ID |
BIGINT |
8 |
| 145 |
WIP_SUPPLY_TYPE |
BIGINT |
8 |
| 146 |
WIP_SUPPLY_SUBINVENTORY |
CHARACTER VARYING(10) |
10 |
| 147 |
PRIMARY_UOM_CODE |
CHARACTER VARYING(3) |
3 |
| 148 |
PRIMARY_UNIT_OF_MEASURE |
CHARACTER VARYING(25) |
25 |
| 149 |
ALLOWED_UNITS_LOOKUP_CODE |
BIGINT |
8 |
| 150 |
COST_OF_SALES_ACCOUNT |
BIGINT |
8 |
| 151 |
SALES_ACCOUNT |
BIGINT |
8 |
| 152 |
DEFAULT_INCLUDE_IN_ROLLUP_FLAG |
CHARACTER VARYING(1) |
1 |
| 153 |
INVENTORY_ITEM_STATUS_CODE |
CHARACTER VARYING(10) |
10 |
| 154 |
INVENTORY_PLANNING_CODE |
BIGINT |
8 |
| 155 |
PLANNER_CODE |
CHARACTER VARYING(10) |
10 |
| 156 |
PLANNING_MAKE_BUY_CODE |
BIGINT |
8 |
| 157 |
FIXED_LOT_MULTIPLIER |
NUMERIC(18,2) |
19 |
| 158 |
ROUNDING_CONTROL_TYPE |
BIGINT |
8 |
| 159 |
CARRYING_COST |
NUMERIC(18,2) |
19 |
| 160 |
POSTPROCESSING_LEAD_TIME |
NUMERIC(18,2) |
19 |
| 161 |
PREPROCESSING_LEAD_TIME |
NUMERIC(18,2) |
19 |
| 162 |
FULL_LEAD_TIME |
NUMERIC(18,2) |
19 |
| 163 |
ORDER_COST |
NUMERIC(18,2) |
19 |
| 164 |
MRP_SAFETY_STOCK_PERCENT |
NUMERIC(18,2) |
19 |
| 165 |
MRP_SAFETY_STOCK_CODE |
BIGINT |
8 |
| 166 |
MIN_MINMAX_QUANTITY |
NUMERIC(18,2) |
19 |
| 167 |
MAX_MINMAX_QUANTITY |
NUMERIC(18,2) |
19 |
| 168 |
MINIMUM_ORDER_QUANTITY |
NUMERIC(18,2) |
19 |
| 169 |
FIXED_ORDER_QUANTITY |
NUMERIC(18,2) |
19 |
| 170 |
FIXED_DAYS_SUPPLY |
NUMERIC(18,2) |
19 |
| 171 |
MAXIMUM_ORDER_QUANTITY |
NUMERIC(18,2) |
19 |
| 172 |
ATP_RULE_ID |
BIGINT |
8 |
| 173 |
PICKING_RULE_ID |
BIGINT |
8 |
| 174 |
RESERVABLE_TYPE |
BIGINT |
8 |
| 175 |
POSITIVE_MEASUREMENT_ERROR |
NUMERIC(18,2) |
19 |
| 176 |
NEGATIVE_MEASUREMENT_ERROR |
NUMERIC(18,2) |
19 |
| 177 |
ENGINEERING_ECN_CODE |
CHARACTER VARYING(50) |
50 |
| 178 |
ENGINEERING_ITEM_ID |
BIGINT |
8 |
| 179 |
ENGINEERING_DATE |
TIMESTAMP |
8 |
| 180 |
SERVICE_STARTING_DELAY |
NUMERIC(18,2) |
19 |
| 181 |
VENDOR_WARRANTY_FLAG |
CHARACTER VARYING(1) |
1 |
| 182 |
SERVICEABLE_COMPONENT_FLAG |
CHARACTER VARYING(1) |
1 |
| 183 |
SERVICEABLE_PRODUCT_FLAG |
CHARACTER VARYING(1) |
1 |
| 184 |
BASE_WARRANTY_SERVICE_ID |
BIGINT |
8 |
| 185 |
PAYMENT_TERMS_ID |
BIGINT |
8 |
| 186 |
PREVENTIVE_MAINTENANCE_FLAG |
CHARACTER VARYING(1) |
1 |
| 187 |
PRIMARY_SPECIALIST_ID |
BIGINT |
8 |
| 188 |
SECONDARY_SPECIALIST_ID |
BIGINT |
8 |
| 189 |
SERVICEABLE_ITEM_CLASS_ID |
BIGINT |
8 |
| 190 |
TIME_BILLABLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 191 |
MATERIAL_BILLABLE_FLAG |
CHARACTER VARYING(30) |
30 |
| 192 |
EXPENSE_BILLABLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 193 |
PRORATE_SERVICE_FLAG |
CHARACTER VARYING(1) |
1 |
| 194 |
COVERAGE_SCHEDULE_ID |
BIGINT |
8 |
| 195 |
SERVICE_DURATION_PERIOD_CODE |
CHARACTER VARYING(10) |
10 |
| 196 |
SERVICE_DURATION |
NUMERIC(18,2) |
19 |
| 197 |
WARRANTY_VENDOR_ID |
BIGINT |
8 |
| 198 |
MAX_WARRANTY_AMOUNT |
NUMERIC(18,2) |
19 |
| 199 |
RESPONSE_TIME_PERIOD_CODE |
CHARACTER VARYING(30) |
30 |
| 200 |
RESPONSE_TIME_VALUE |
NUMERIC(18,2) |
19 |
| 201 |
NEW_REVISION_CODE |
CHARACTER VARYING(30) |
30 |
| 202 |
INVOICEABLE_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 203 |
TAX_CODE |
CHARACTER VARYING(50) |
50 |
| 204 |
INVOICE_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 205 |
MUST_USE_APPROVED_VENDOR_FLAG |
CHARACTER VARYING(1) |
1 |
| 206 |
REQUEST_ID |
BIGINT |
8 |
| 207 |
PROGRAM_APPLICATION_ID |
BIGINT |
8 |
| 208 |
PROGRAM_ID |
BIGINT |
8 |
| 209 |
PROGRAM_UPDATE_DATE |
TIMESTAMP |
8 |
| 210 |
OUTSIDE_OPERATION_FLAG |
CHARACTER VARYING(1) |
1 |
| 211 |
OUTSIDE_OPERATION_UOM_TYPE |
CHARACTER VARYING(25) |
25 |
| 212 |
SAFETY_STOCK_BUCKET_DAYS |
BIGINT |
8 |
| 213 |
AUTO_REDUCE_MPS |
NUMERIC(18,2) |
19 |
| 214 |
COSTING_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 215 |
AUTO_CREATED_CONFIG_FLAG |
CHARACTER VARYING(1) |
1 |
| 216 |
CYCLE_COUNT_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 217 |
ITEM_TYPE |
CHARACTER VARYING(30) |
30 |
| 218 |
MODEL_CONFIG_CLAUSE_NAME |
CHARACTER VARYING(10) |
10 |
| 219 |
SHIP_MODEL_COMPLETE_FLAG |
CHARACTER VARYING(1) |
1 |
| 220 |
MRP_PLANNING_CODE |
BIGINT |
8 |
| 221 |
RETURN_INSPECTION_REQUIREMENT |
NUMERIC(18,2) |
19 |
| 222 |
ATO_FORECAST_CONTROL |
NUMERIC(18,2) |
19 |
| 223 |
RELEASE_TIME_FENCE_CODE |
BIGINT |
8 |
| 224 |
RELEASE_TIME_FENCE_DAYS |
BIGINT |
8 |
| 225 |
CONTAINER_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 226 |
VEHICLE_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 227 |
MAXIMUM_LOAD_WEIGHT |
NUMERIC(18,2) |
19 |
| 228 |
MINIMUM_FILL_PERCENT |
NUMERIC(18,2) |
19 |
| 229 |
CONTAINER_TYPE_CODE |
CHARACTER VARYING(30) |
30 |
| 230 |
INTERNAL_VOLUME |
NUMERIC(18,2) |
19 |
| 231 |
WH_UPDATE_DATE |
TIMESTAMP |
8 |
| 232 |
PRODUCT_FAMILY_ITEM_ID |
BIGINT |
8 |
| 233 |
GLOBAL_ATTRIBUTE_CATEGORY |
CHARACTER VARYING(150) |
150 |
| 234 |
GLOBAL_ATTRIBUTE1 |
CHARACTER VARYING(150) |
150 |
| 235 |
GLOBAL_ATTRIBUTE2 |
CHARACTER VARYING(150) |
150 |
| 236 |
GLOBAL_ATTRIBUTE3 |
CHARACTER VARYING(150) |
150 |
| 237 |
GLOBAL_ATTRIBUTE4 |
CHARACTER VARYING(150) |
150 |
| 238 |
GLOBAL_ATTRIBUTE5 |
CHARACTER VARYING(150) |
150 |
| 239 |
GLOBAL_ATTRIBUTE6 |
CHARACTER VARYING(150) |
150 |
| 240 |
GLOBAL_ATTRIBUTE7 |
CHARACTER VARYING(150) |
150 |
| 241 |
GLOBAL_ATTRIBUTE8 |
CHARACTER VARYING(150) |
150 |
| 242 |
GLOBAL_ATTRIBUTE9 |
CHARACTER VARYING(150) |
150 |
| 243 |
GLOBAL_ATTRIBUTE10 |
CHARACTER VARYING(150) |
150 |
| 244 |
PURCHASING_TAX_CODE |
CHARACTER VARYING(50) |
50 |
| 245 |
OVERCOMPLETION_TOLERANCE_TYPE |
BIGINT |
8 |
| 246 |
OVERCOMPLETION_TOLERANCE_VALUE |
NUMERIC(18,2) |
19 |
| 247 |
EFFECTIVITY_CONTROL |
NUMERIC(18,2) |
19 |
| 248 |
CHECK_SHORTAGES_FLAG |
CHARACTER VARYING(1) |
1 |
| 249 |
OVER_SHIPMENT_TOLERANCE |
NUMERIC(18,2) |
19 |
| 250 |
UNDER_SHIPMENT_TOLERANCE |
NUMERIC(18,2) |
19 |
| 251 |
OVER_RETURN_TOLERANCE |
NUMERIC(18,2) |
19 |
| 252 |
UNDER_RETURN_TOLERANCE |
NUMERIC(18,2) |
19 |
| 253 |
EQUIPMENT_TYPE |
BIGINT |
8 |
| 254 |
RECOVERED_PART_DISP_CODE |
CHARACTER VARYING(30) |
30 |
| 255 |
DEFECT_TRACKING_ON_FLAG |
CHARACTER VARYING(1) |
1 |
| 256 |
USAGE_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 257 |
EVENT_FLAG |
CHARACTER VARYING(1) |
1 |
| 258 |
ELECTRONIC_FLAG |
CHARACTER VARYING(1) |
1 |
| 259 |
DOWNLOADABLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 260 |
VOL_DISCOUNT_EXEMPT_FLAG |
CHARACTER VARYING(1) |
1 |
| 261 |
COUPON_EXEMPT_FLAG |
CHARACTER VARYING(1) |
1 |
| 262 |
COMMS_NL_TRACKABLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 263 |
ASSET_CREATION_CODE |
CHARACTER VARYING(30) |
30 |
| 264 |
COMMS_ACTIVATION_REQD_FLAG |
CHARACTER VARYING(1) |
1 |
| 265 |
ORDERABLE_ON_WEB_FLAG |
CHARACTER VARYING(1) |
1 |
| 266 |
BACK_ORDERABLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 267 |
WEB_STATUS |
CHARACTER VARYING(30) |
30 |
| 268 |
INDIVISIBLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 269 |
DIMENSION_UOM_CODE |
CHARACTER VARYING(3) |
3 |
| 270 |
UNIT_LENGTH |
NUMERIC(18,2) |
19 |
| 271 |
UNIT_WIDTH |
NUMERIC(18,2) |
19 |
| 272 |
UNIT_HEIGHT |
NUMERIC(18,2) |
19 |
| 273 |
BULK_PICKED_FLAG |
CHARACTER VARYING(1) |
1 |
| 274 |
LOT_STATUS_ENABLED |
CHARACTER VARYING(1) |
1 |
| 275 |
DEFAULT_LOT_STATUS_ID |
BIGINT |
8 |
| 276 |
SERIAL_STATUS_ENABLED |
CHARACTER VARYING(1) |
1 |
| 277 |
DEFAULT_SERIAL_STATUS_ID |
BIGINT |
8 |
| 278 |
LOT_SPLIT_ENABLED |
CHARACTER VARYING(1) |
1 |
| 279 |
LOT_MERGE_ENABLED |
CHARACTER VARYING(1) |
1 |
| 280 |
INVENTORY_CARRY_PENALTY |
NUMERIC(18,2) |
19 |
| 281 |
OPERATION_SLACK_PENALTY |
NUMERIC(18,2) |
19 |
| 282 |
FINANCING_ALLOWED_FLAG |
CHARACTER VARYING(1) |
1 |
| 283 |
EAM_ITEM_TYPE |
NUMERIC(18,2) |
19 |
| 284 |
EAM_ACTIVITY_TYPE_CODE |
CHARACTER VARYING(30) |
30 |
| 285 |
EAM_ACTIVITY_CAUSE_CODE |
CHARACTER VARYING(30) |
30 |
| 286 |
EAM_ACT_NOTIFICATION_FLAG |
CHARACTER VARYING(1) |
1 |
| 287 |
EAM_ACT_SHUTDOWN_STATUS |
CHARACTER VARYING(30) |
30 |
| 288 |
DUAL_UOM_CONTROL |
NUMERIC(18,2) |
19 |
| 289 |
SECONDARY_UOM_CODE |
CHARACTER VARYING(3) |
3 |
| 290 |
DUAL_UOM_DEVIATION_HIGH |
NUMERIC(18,2) |
19 |
| 291 |
DUAL_UOM_DEVIATION_LOW |
NUMERIC(18,2) |
19 |
| 292 |
CONTRACT_ITEM_TYPE_CODE |
CHARACTER VARYING(30) |
30 |
| 293 |
SUBSCRIPTION_DEPEND_FLAG |
CHARACTER VARYING(1) |
1 |
| 294 |
SERV_REQ_ENABLED_CODE |
CHARACTER VARYING(30) |
30 |
| 295 |
SERV_BILLING_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 296 |
SERV_IMPORTANCE_LEVEL |
NUMERIC(18,2) |
19 |
| 297 |
PLANNED_INV_POINT_FLAG |
CHARACTER VARYING(1) |
1 |
| 298 |
LOT_TRANSLATE_ENABLED |
CHARACTER VARYING(1) |
1 |
| 299 |
DEFAULT_SO_SOURCE_TYPE |
CHARACTER VARYING(30) |
30 |
| 300 |
CREATE_SUPPLY_FLAG |
CHARACTER VARYING(1) |
1 |
| 301 |
SUBSTITUTION_WINDOW_CODE |
BIGINT |
8 |
| 302 |
SUBSTITUTION_WINDOW_DAYS |
BIGINT |
8 |
| 303 |
IB_ITEM_INSTANCE_CLASS |
CHARACTER VARYING(30) |
30 |
| 304 |
CONFIG_MODEL_TYPE |
CHARACTER VARYING(30) |
30 |
| 305 |
LOT_SUBSTITUTION_ENABLED |
CHARACTER VARYING(1) |
1 |
| 306 |
MINIMUM_LICENSE_QUANTITY |
NUMERIC(18,2) |
19 |
| 307 |
EAM_ACTIVITY_SOURCE_CODE |
CHARACTER VARYING(30) |
30 |
| 308 |
LIFECYCLE_ID |
BIGINT |
8 |
| 309 |
CURRENT_PHASE_ID |
BIGINT |
8 |
| 310 |
OBJECT_VERSION_NUMBER |
BIGINT |
8 |
| 311 |
TRACKING_QUANTITY_IND |
CHARACTER VARYING(30) |
30 |
| 312 |
ONT_PRICING_QTY_SOURCE |
CHARACTER VARYING(30) |
30 |
| 313 |
SECONDARY_DEFAULT_IND |
CHARACTER VARYING(30) |
30 |
| 314 |
OPTION_SPECIFIC_SOURCED |
NUMERIC(18,2) |
19 |
| 315 |
APPROVAL_STATUS |
CHARACTER VARYING(30) |
30 |
| 316 |
VMI_MINIMUM_UNITS |
NUMERIC(18,2) |
19 |
| 317 |
VMI_MINIMUM_DAYS |
NUMERIC(18,2) |
19 |
| 318 |
VMI_MAXIMUM_UNITS |
NUMERIC(18,2) |
19 |
| 319 |
VMI_MAXIMUM_DAYS |
NUMERIC(18,2) |
19 |
| 320 |
VMI_FIXED_ORDER_QUANTITY |
NUMERIC(18,2) |
19 |
| 321 |
SO_AUTHORIZATION_FLAG |
NUMERIC(18,2) |
19 |
| 322 |
CONSIGNED_FLAG |
NUMERIC(18,2) |
19 |
| 323 |
ASN_AUTOEXPIRE_FLAG |
NUMERIC(18,2) |
19 |
| 324 |
VMI_FORECAST_TYPE |
NUMERIC(18,2) |
19 |
| 325 |
FORECAST_HORIZON |
NUMERIC(18,2) |
19 |
| 326 |
EXCLUDE_FROM_BUDGET_FLAG |
NUMERIC(18,2) |
19 |
| 327 |
DAYS_TGT_INV_SUPPLY |
NUMERIC(18,2) |
19 |
| 328 |
DAYS_TGT_INV_WINDOW |
NUMERIC(18,2) |
19 |
| 329 |
DAYS_MAX_INV_SUPPLY |
NUMERIC(18,2) |
19 |
| 330 |
DAYS_MAX_INV_WINDOW |
NUMERIC(18,2) |
19 |
| 331 |
DRP_PLANNED_FLAG |
NUMERIC(18,2) |
19 |
| 332 |
CRITICAL_COMPONENT_FLAG |
NUMERIC(18,2) |
19 |
| 333 |
CONTINOUS_TRANSFER |
NUMERIC(18,2) |
19 |
| 334 |
CONVERGENCE |
NUMERIC(18,2) |
19 |
| 335 |
DIVERGENCE |
NUMERIC(18,2) |
19 |
| 336 |
CONFIG_ORGS |
CHARACTER VARYING(30) |
30 |
| 337 |
CONFIG_MATCH |
CHARACTER VARYING(30) |
30 |
| 338 |
ATTRIBUTE16 |
CHARACTER VARYING(240) |
240 |
| 339 |
ATTRIBUTE17 |
CHARACTER VARYING(240) |
240 |
| 340 |
ATTRIBUTE18 |
CHARACTER VARYING(240) |
240 |
| 341 |
ATTRIBUTE19 |
CHARACTER VARYING(240) |
240 |
| 342 |
ATTRIBUTE20 |
CHARACTER VARYING(240) |
240 |
| 343 |
ATTRIBUTE21 |
CHARACTER VARYING(240) |
240 |
| 344 |
ATTRIBUTE22 |
CHARACTER VARYING(240) |
240 |
| 345 |
ATTRIBUTE23 |
CHARACTER VARYING(240) |
240 |
| 346 |
ATTRIBUTE24 |
CHARACTER VARYING(240) |
240 |
| 347 |
ATTRIBUTE25 |
CHARACTER VARYING(240) |
240 |
| 348 |
ATTRIBUTE26 |
CHARACTER VARYING(240) |
240 |
| 349 |
ATTRIBUTE27 |
CHARACTER VARYING(240) |
240 |
| 350 |
ATTRIBUTE28 |
CHARACTER VARYING(240) |
240 |
| 351 |
ATTRIBUTE29 |
CHARACTER VARYING(240) |
240 |
| 352 |
ATTRIBUTE30 |
CHARACTER VARYING(240) |
240 |
| 353 |
CAS_NUMBER |
CHARACTER VARYING(30) |
30 |
| 354 |
CHILD_LOT_FLAG |
CHARACTER VARYING(1) |
1 |
| 355 |
CHILD_LOT_PREFIX |
CHARACTER VARYING(30) |
30 |
| 356 |
CHILD_LOT_STARTING_NUMBER |
NUMERIC(18,2) |
19 |
| 357 |
CHILD_LOT_VALIDATION_FLAG |
CHARACTER VARYING(1) |
1 |
| 358 |
COPY_LOT_ATTRIBUTE_FLAG |
CHARACTER VARYING(1) |
1 |
| 359 |
DEFAULT_GRADE |
CHARACTER VARYING(150) |
150 |
| 360 |
EXPIRATION_ACTION_CODE |
CHARACTER VARYING(32) |
32 |
| 361 |
EXPIRATION_ACTION_INTERVAL |
NUMERIC(18,2) |
19 |
| 362 |
GRADE_CONTROL_FLAG |
CHARACTER VARYING(1) |
1 |
| 363 |
HAZARDOUS_MATERIAL_FLAG |
CHARACTER VARYING(1) |
1 |
| 364 |
HOLD_DAYS |
NUMERIC(18,2) |
19 |
| 365 |
LOT_DIVISIBLE_FLAG |
CHARACTER VARYING(1) |
1 |
| 366 |
MATURITY_DAYS |
NUMERIC(18,2) |
19 |
| 367 |
PARENT_CHILD_GENERATION_FLAG |
CHARACTER VARYING(1) |
1 |
| 368 |
PROCESS_COSTING_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 369 |
PROCESS_EXECUTION_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 370 |
PROCESS_QUALITY_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 371 |
PROCESS_SUPPLY_LOCATOR_ID |
BIGINT |
8 |
| 372 |
PROCESS_SUPPLY_SUBINVENTORY |
CHARACTER VARYING(10) |
10 |
| 373 |
PROCESS_YIELD_LOCATOR_ID |
BIGINT |
8 |
| 374 |
PROCESS_YIELD_SUBINVENTORY |
CHARACTER VARYING(10) |
10 |
| 375 |
RECIPE_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 376 |
RETEST_INTERVAL |
NUMERIC(18,2) |
19 |
| 377 |
CHARGE_PERIODICITY_CODE |
CHARACTER VARYING(3) |
3 |
| 378 |
REPAIR_LEADTIME |
NUMERIC(18,2) |
19 |
| 379 |
REPAIR_YIELD |
NUMERIC(18,2) |
19 |
| 380 |
PREPOSITION_POINT |
CHARACTER VARYING(1) |
1 |
| 381 |
REPAIR_PROGRAM |
NUMERIC(18,2) |
19 |
| 382 |
SUBCONTRACTING_COMPONENT |
NUMERIC(18,2) |
19 |
| 383 |
OUTSOURCED_ASSEMBLY |
NUMERIC(18,2) |
19 |
| 384 |
EGO_MASTER_ITEMS_DFF_CTX |
CHARACTER VARYING(1) |
1 |
| 385 |
GDSN_OUTBOUND_ENABLED_FLAG |
CHARACTER VARYING(1) |
1 |
| 386 |
TRADE_ITEM_DESCRIPTOR |
CHARACTER VARYING(35) |
35 |
| 387 |
STYLE_ITEM_ID |
BIGINT |
8 |
| 388 |
STYLE_ITEM_FLAG |
CHARACTER VARYING(1) |
1 |
| 389 |
LAST_SUBMITTED_NIR_ID |
BIGINT |
8 |
| 390 |
DEFAULT_MATERIAL_STATUS_ID |
BIGINT |
8 |
| 391 |
GLOBAL_ATTRIBUTE11 |
CHARACTER VARYING(150) |
150 |
| 392 |
GLOBAL_ATTRIBUTE12 |
CHARACTER VARYING(150) |
150 |
| 393 |
GLOBAL_ATTRIBUTE13 |
CHARACTER VARYING(150) |
150 |
| 394 |
GLOBAL_ATTRIBUTE14 |
CHARACTER VARYING(150) |
150 |
| 395 |
GLOBAL_ATTRIBUTE15 |
CHARACTER VARYING(150) |
150 |
| 396 |
GLOBAL_ATTRIBUTE16 |
CHARACTER VARYING(150) |
150 |
| 397 |
GLOBAL_ATTRIBUTE17 |
CHARACTER VARYING(150) |
150 |
| 398 |
GLOBAL_ATTRIBUTE18 |
CHARACTER VARYING(150) |
150 |
| 399 |
GLOBAL_ATTRIBUTE19 |
CHARACTER VARYING(150) |
150 |
| 400 |
GLOBAL_ATTRIBUTE20 |
CHARACTER VARYING(150) |
150 |
| 401 |
CDC_SOURCE_SYSTEM_CODE |
CHARACTER VARYING(4) |
4 |
| 402 |
CDC_RECORD_TYPE |
CHARACTER VARYING(16) |
16 |
| 403 |
CDC_COMMIT_TIMESTAMP |
TIMESTAMP |
8 |
| 404 |
CDC_EXTRACT_TIMESTAMP |
TIMESTAMP |
8 |
| 405 |
SERIAL_TAGGING_FLAG |
CHARACTER VARYING(1) |
1 |