The Item Fields custom field is available for the Item Location Map table.
| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| atp_lead_time | NUMBER | 39 | 0 | APT lead time | |||
| available_count | NUMBER | 39 | 0 | Available count | |||
| average_cost | NUMBER | 30 | 15 | Average cost | |||
| backward_consumption_days | NUMBER | 39 | 0 | Backward consumption days | |||
| cost_0 | NUMBER | 30 | 15 | Cost | |||
| cost_accounting_status | VARCHAR2 | 4000 | Cost accounting status | ||||
| costing_lot_size | NUMBER | 39 | 0 | Costing lot size | |||
| default_return_cost | NUMBER | 30 | 15 | Default return cost | |||
| demand_source | VARCHAR2 | 50 | Demand source | ||||
| demand_time_fence | NUMBER | 39 | 0 | Demand time fence | |||
| fixed_lot_size | NUMBER | 39 | 0 | Fixed lot size | |||
| forward_consumption_days | NUMBER | 39 | 0 | Forward consumption days | |||
| in_transit_count | NUMBER | 18 | 8 | In transit count | |||
| inventory_cost_template | NUMBER | 39 | 0 | Inventory cost template | |||
| invt_count_classification | NUMBER | 39 | 0 | Inventory count classification | |||
| invt_count_interval | NUMBER | 39 | 0 | Inventory count interval | |||
| item_id | NUMBER | 39 | 0 | Item ID | |||
| last_invt_count_date | TIMESTAMP | Last inventory count date | |||||
| last_purchase_price | NUMBER | 39 | 0 | Last purchase price | |||
| location_id | NUMBER | 39 | 0 | Location ID | |||
| lot_sizing_method | VARCHAR2 | 50 | Lot sizing method | ||||
| next_invt_count_date | TIMESTAMP | Next inventory count date | |||||
| ns_lead_time | NUMBER | 39 | 0 | NetSuite lead time | |||
| on_hand_count | NUMBER | 21 | 11 | On hand count | |||
| on_hand_value | NUMBER | 29 | 11 | On hand value | |||
| on_order_count | NUMBER | 21 | 11 | On order count | |||
| periodic_lot_size_days | NUMBER | 39 | 0 | Periodic lot size days | |||
| periodic_lot_size_type | VARCHAR2 | 50 | Periodic lot size type | ||||
| pref_stock_level | NUMBER | 39 | 0 | Preferred stock level | |||
| quantitybackordered | NUMBER | 39 | 0 | Quantity back-ordered | |||
| reorder_point | NUMBER | 21 | 11 | Reorder point | |||
| reschedule_in_days | NUMBER | 39 | 0 | Reschedule in days | |||
| reschedule_out_days | NUMBER | 39 | 0 | Reschedule out days | |||
| safety_stock_level | NUMBER | 39 | 0 | Safety stock level | |||
| supply_time_fence | NUMBER | 39 | 0 | Supply time fence | |||
| supply_type | VARCHAR2 | 50 | Supply type | ||||
| wip | VARCHAR2 | 1 | WIP |