| Name | Description | Type | Additional information |
|---|---|---|---|
| company_oe | string |
None. |
|
| opn | boolean |
None. |
|
| rec_type | string |
None. |
|
| order | integer |
None. |
|
| rec_seq | integer |
None. |
|
| line | integer |
None. |
|
| line_add | integer |
None. |
|
| customer | string |
None. |
|
| company_cu | string |
None. |
|
| company_it | string |
None. |
|
| company_ip | string |
None. |
|
| warehouse | string |
None. |
|
| invc_date | Object |
None. |
|
| invc_seq | integer |
None. |
|
| ord_class | string |
None. |
|
| vendor | string |
None. |
|
| product_line | string |
None. |
|
| tax_flag | boolean |
None. |
|
| req_date | string |
None. |
|
| cancel_date | Object |
None. |
|
| cancel_bo | boolean |
None. |
|
| com_amount | decimal number |
None. |
|
| com_pct | decimal number |
None. |
|
| spec | string |
None. |
|
| item | string |
None. |
|
| descr | Collection of string |
None. |
|
| location | string |
None. |
|
| picked | string |
None. |
|
| picked_date | Object |
None. |
|
| un_sale | boolean |
None. |
|
| msds_id | string |
None. |
|
| msds_rev_date | Object |
None. |
|
| um_o | string |
None. |
|
| q_ord | integer |
None. |
|
| q_ord_d | integer |
None. |
|
| q_comm | integer |
None. |
|
| q_comm_d | integer |
None. |
|
| q_printed | integer |
None. |
|
| q_printed_d | integer |
None. |
|
| q_itd | integer |
None. |
|
| q_itd_d | integer |
None. |
|
| q_bo | integer |
None. |
|
| q_bo_d | integer |
None. |
|
| q_picked | integer |
None. |
|
| q_picked_d | integer |
None. |
|
| prc_est | boolean |
None. |
|
| prc_origin | string |
None. |
|
| orig_price | decimal number |
None. |
|
| price_per | string |
None. |
|
| price | decimal number |
None. |
|
| dsc_amount | decimal number |
None. |
|
| dsc_pct | decimal number |
None. |
|
| o_ext | decimal number |
None. |
|
| o_ext_disc | decimal number |
None. |
|
| c_ext | decimal number |
None. |
|
| c_ext_disc | decimal number |
None. |
|
| bo_ext | decimal number |
None. |
|
| i_ext | decimal number |
None. |
|
| cost_ovrd | boolean |
None. |
|
| cost_est | boolean |
None. |
|
| cost_w | decimal number |
None. |
|
| load | decimal number |
None. |
|
| cost_per | string |
None. |
|
| o_cost_ext_w | decimal number |
None. |
|
| c_cost_ext_w | decimal number |
None. |
|
| i_cost_ext_w | decimal number |
None. |
|
| cost_a | decimal number |
None. |
|
| cost_per_a | string |
None. |
|
| o_cost_ext_a | decimal number |
None. |
|
| c_cost_ext_a | decimal number |
None. |
|
| i_cost_ext_a | decimal number |
None. |
|
| weight | decimal number |
None. |
|
| weight_per | string |
None. |
|
| o_weight_ext | decimal number |
None. |
|
| c_weight_ext | decimal number |
None. |
|
| i_weight_ext | decimal number |
None. |
|
| po | integer |
None. |
|
| po_line | integer |
None. |
|
| q_linked | integer |
None. |
|
| company_sa | string |
None. |
|
| item_stat | string |
None. |
|
| keep_inventory | boolean |
None. |
|
| price_by_components | boolean |
None. |
|
| future_order | boolean |
None. |
|
| components_on_invoice | boolean |
None. |
|
| components_on_picktick | boolean |
None. |
|
| manual_cmmt | boolean |
None. |
|
| prior_price | decimal number |
None. |
|
| prior_cost_w | decimal number |
None. |
|
| price_chg_pct | decimal number |
None. |
|
| cost_w_chg_pct | decimal number |
None. |
|
| prior_price_per | string |
None. |
|
| prior_cost_per | string |
None. |
|
| orig_price_per | string |
None. |
|
| orig_cost_w | decimal number |
None. |
|
| orig_cost_per_w | string |
None. |
|
| discontinued | boolean |
None. |
|
| q_tot_cmtd | integer |
None. |
|
| q_tot_cmtd_d | integer |
None. |
|
| q_linked_d | integer |
None. |
|
| q_itd_cmtd | integer |
None. |
|
| q_itd_cmtd_d | integer |
None. |
|
| company_ve | string |
None. |
|
| edipo_line | integer |
None. |
|
| blanket_order | boolean |
None. |
|
| price_col | string |
None. |
|
| q_ord_disp | decimal number |
None. |
|
| q_comm_disp | decimal number |
None. |
|
| q_printed_disp | decimal number |
None. |
|
| q_itd_disp | decimal number |
None. |
|
| q_bo_disp | decimal number |
None. |
|
| um_disp | string |
None. |
|
| blanket_rel | integer |
None. |
|
| on_hold | boolean |
None. |
|
| promise_date | Object |
None. |
|
| salesman1 | string |
None. |
|
| rental_order | integer |
None. |
|
| rental_line_add | integer |
None. |
|
| exchange_rate | decimal number |
None. |
|
| curx_price | decimal number |
None. |
|
| curx_o_ext | decimal number |
None. |
|
| curx_o_ext_disc | decimal number |
None. |
|
| curx_c_ext | decimal number |
None. |
|
| curx_c_ext_disc | decimal number |
None. |
|
| curx_i_ext | decimal number |
None. |
|
| curx_bo_ext | decimal number |
None. |
|
| list_price | decimal number |
None. |
|
| commodity_code | string |
None. |
|
| vat_percent | decimal number |
None. |
|
| vat_amount | decimal number |
None. |
|
| list_price_discount | decimal number |
None. |
|
| curx_list_price | decimal number |
None. |
|
| curx_vat_amount | decimal number |
None. |
|
| document | integer |
None. |
|
| doc_line | integer |
None. |
|
| doc_partner_id | string |
None. |
|
| print_on_invoice | boolean |
None. |
|
| print_on_quote | boolean |
None. |
|
| print_on_ackn | boolean |
None. |
|
| print_on_ps | boolean |
None. |
|
| o_price_sa | decimal number |
None. |
|
| c_ext_sa | decimal number |
None. |
|
| o_ext_sa | decimal number |
None. |
|
| line_add_sa | integer |
None. |
|
| c_price_sa | decimal number |
None. |
|
| pricing_terms | string |
None. |
|
| post_date | Object |
None. |
|
| use_alt_list | boolean |
None. |
|
| freight_amt | decimal number |
None. |
|
| cc_order | integer |
None. |
|
| freight_amt_add | decimal number |
None. |
|
| cc_rec_seq | integer |
None. |
|
| freight_ovrd | boolean |
None. |
|
| core_closed | boolean |
None. |
|
| cc_line_add | integer |
None. |
|
| sp_no | integer |
None. |
|
| sp_rec_seq | integer |
None. |
|
| sp_line_add | integer |
None. |
|
| sp_comp_seq | integer |
None. |
|
| ship_via_code | string |
None. |
|
| item_notes_flag | boolean |
None. |
|
| ar_flag | boolean |
None. |
|
| oe_totals_flag | boolean |
None. |
|
| sa_totals_flag | boolean |
None. |
|
| pick_time | Collection of integer |
None. |
|
| print_on_pk | boolean |
None. |
|
| curx_orig_price | decimal number |
None. |
|
| inv_updated | boolean |
None. |
|
| orig_item | string |
None. |
|
| wo_no | integer |
None. |
|
| rs_price | decimal number |
None. |
|
| rs_shipping_amt | decimal number |
None. |
|
| rs_tax_amt | decimal number |
None. |
|
| um_descr | string |
None. |
|
| um_index | integer |
None. |
|
| wave_item_seq | integer |
None. |
|
| tax_code | string |
None. |
|
| spoil_line_add | integer |
None. |
|
| price_comment | string |
None. |
|
| edipo_orig_item | string |
None. |
|
| edipo_assrt_item | string |
None. |
|
| entry_item | string |
None. |
|
| tag_no | integer |
None. |
|
| components_on_quote | boolean |
None. |
|
| sel_flag | boolean |
None. |
|
| orig_restrict | boolean |
None. |
|
| ship_complete | boolean |
None. |
|
| q_bo_orig | Object |
None. |
|
| q_bo_d_orig | Object |
None. |
|
| created_date_time | date |
None. |
|
| created_by | string |
None. |
|
| terms_code | string |
None. |
|
| job_rel | string |
None. |
|
| cost_ovrd_a | boolean |
None. |
|
| cost_origin_a | string |
None. |
|
| cost_origin_w | string |
None. |
|
| edi_orig_price | decimal number |
None. |
|
| price_surcharge | decimal number |
None. |
|
| curx_price_surcharge | decimal number |
None. |
|
| edi_misc | Collection of string |
None. |
|
| price_rebate | decimal number |
None. |
|
| curx_price_rebate | decimal number |
None. |
|
| o_ext_no_reb | decimal number |
None. |
|
| o_ext_disc_no_reb | decimal number |
None. |
|
| curx_o_ext_no_reb | decimal number |
None. |
|
| curx_o_ext_disc_no_reb | decimal number |
None. |
|
| c_ext_no_reb | decimal number |
None. |
|
| curx_c_ext_no_reb | decimal number |
None. |
|
| c_ext_disc_no_reb | decimal number |
None. |
|
| curx_c_ext_disc_no_reb | decimal number |
None. |
|
| rebate_class | string |
None. |
|
| special | boolean |
None. |
|
| free_freight_level | decimal number |
None. |
|
| date_needed | Object |
None. |
|
| length | decimal number |
None. |
|
| width | decimal number |
None. |
|
| inventory_item | string |
None. |
|
| __lineid | integer |
None. |
|
| __rowid | string |
None. |