| Name | Description | Type | Additional information |
|---|---|---|---|
| company_oe | string |
None. |
|
| opn | boolean |
None. |
|
| rec_type | string |
None. |
|
| order | integer |
None. |
|
| rec_seq | integer |
None. |
|
| last_line | integer |
None. |
|
| last_add_line | integer |
None. |
|
| stat | string |
None. |
|
| ord_class | string |
None. |
|
| ord_date | string |
None. |
|
| wanted_date | string |
None. |
|
| required_date | Object |
None. |
|
| cancel_date | Object |
None. |
|
| enter_by | string |
None. |
|
| ttime_ent | string |
None. |
|
| ord_ext | string |
None. |
|
| oe_prefix | string |
None. |
|
| source_code | string |
None. |
|
| hold_code | string |
None. |
|
| tax_code | string |
None. |
|
| tax_exempt | string |
None. |
|
| bo_flag | boolean |
None. |
|
| print_label | boolean |
None. |
|
| warehouse | string |
None. |
|
| customer | string |
None. |
|
| company_cu | string |
None. |
|
| cu_group | string |
None. |
|
| cu_po | string |
None. |
|
| order_by | string |
None. |
|
| used_by | string |
None. |
|
| phone | string |
None. |
|
| fax | string |
None. |
|
| ship_id | string |
None. |
|
| name | string |
None. |
|
| state | string |
None. |
|
| postal_code | string |
None. |
|
| ship_atn | string |
None. |
|
| ship_via_code | string |
None. |
|
| ship_cmpl | boolean |
None. |
|
| ship_date | Object |
None. |
|
| cr_aprv_date | Object |
None. |
|
| cr_check_ided | boolean |
None. |
|
| cr_expln | string |
None. |
|
| cr_fail_code | Collection of string |
None. |
|
| cr_rel_id | string |
None. |
|
| fob | string |
None. |
|
| freight_zone | string |
None. |
|
| job_rel | string |
None. |
|
| invoice_group | string |
None. |
|
| invc_seq | integer |
None. |
|
| invc_date | Object |
None. |
|
| times_printed | integer |
None. |
|
| print_time | integer |
None. |
|
| ps_batch_no | integer |
None. |
|
| terms_code | string |
None. |
|
| disc_date | Object |
None. |
|
| disc_amt | decimal number |
None. |
|
| due_date | Object |
None. |
|
| salesman1 | string |
None. |
|
| salesman2 | string |
None. |
|
| salesman3 | string |
None. |
|
| com_pct | decimal number |
None. |
|
| com_split1 | decimal number |
None. |
|
| com_split2 | decimal number |
None. |
|
| o_tot_pieces | integer |
None. |
|
| o_tot_wt | decimal number |
None. |
|
| o_disc_pct | decimal number |
None. |
|
| o_disc_amt | decimal number |
None. |
|
| o_tot_gross | decimal number |
None. |
|
| o_tot_cost | decimal number |
None. |
|
| o_deposit | decimal number |
None. |
|
| o_deposit_open | decimal number |
None. |
|
| o_deposit_no | string |
None. |
|
| c_tot_pieces | integer |
None. |
|
| c_tot_wt | decimal number |
None. |
|
| c_tot_cubes | integer |
None. |
|
| c_disc_pct | decimal number |
None. |
|
| c_disc_amt | decimal number |
None. |
|
| c_tot_taxable | decimal number |
None. |
|
| c_tot_taxable_it | decimal number |
None. |
|
| c_tot_tax_amt | decimal number |
None. |
|
| c_tot_code | Collection of string |
None. |
|
| c_tot_code_amt | Collection of decimal number |
None. |
|
| c_tot_code_cost | Collection of decimal number |
None. |
|
| c_tot_cost | decimal number |
None. |
|
| c_tot_cost_a | decimal number |
None. |
|
| c_tot_gross | decimal number |
None. |
|
| c_tot_net_ar | decimal number |
None. |
|
| opn_tot_gross | decimal number |
None. |
|
| i_tot_pieces | integer |
None. |
|
| i_tot_cubes | decimal number |
None. |
|
| i_tot_wt | decimal number |
None. |
|
| i_disc_amt | decimal number |
None. |
|
| i_tot_taxable | decimal number |
None. |
|
| i_tot_tax_amt | decimal number |
None. |
|
| i_tot_codes_amt | decimal number |
None. |
|
| i_tot_codes_cost | decimal number |
None. |
|
| i_tot_cost | decimal number |
None. |
|
| i_tot_cost_a | decimal number |
None. |
|
| i_tot_gross | decimal number |
None. |
|
| i_pay_codes_tot | decimal number |
None. |
|
| i_cash_disc | decimal number |
None. |
|
| i_cash_discbl | decimal number |
None. |
|
| i_tot_net_ar | decimal number |
None. |
|
| sy_lookup | string |
None. |
|
| ar_type | string |
None. |
|
| ar_customer | string |
None. |
|
| i_pay_code_amt | Collection of decimal number |
None. |
|
| i_pay_code | Collection of string |
None. |
|
| i_pay_code_ref | Collection of string |
None. |
|
| sel_flag | boolean |
None. |
|
| adr | Collection of string |
None. |
|
| country_code | string |
None. |
|
| company_ar | string |
None. |
|
| company_sa | string |
None. |
|
| ak_batch_no | integer |
None. |
|
| future | boolean |
None. |
|
| post_date | Object |
None. |
|
| register | integer |
None. |
|
| manual_cmmt | boolean |
None. |
|
| free_form_shipto | boolean |
None. |
|
| pick_method | string |
None. |
|
| tot_c_tot_wt | decimal number |
None. |
|
| tot_c_tot_code_amt | decimal number |
None. |
|
| i_tot_taxable_it | decimal number |
None. |
|
| proc_date | Object |
None. |
|
| proc_stat | string |
None. |
|
| proc_time | integer |
None. |
|
| proc_user_id | string |
None. |
|
| ship_via_acct | string |
None. |
|
| Manifest_id | string |
None. |
|
| o_tot_taxable | decimal number |
None. |
|
| o_tot_taxable_it | decimal number |
None. |
|
| o_tot_tax_amt | decimal number |
None. |
|
| o_tot_net_ar | decimal number |
None. |
|
| shipped | boolean |
None. |
|
| residential | boolean |
None. |
|
| fc_flag | boolean |
None. |
|
| cu_po_date | Object |
None. |
|
| pick_stat | string |
None. |
|
| store_num | string |
None. |
|
| no_auto_bill_manifest | boolean |
None. |
|
| blind_ship | boolean |
None. |
|
| verify_stat | string |
None. |
|
| pick_user_id | string |
None. |
|
| o_deposit_on_acct | decimal number |
None. |
|
| verify_user_id | string |
None. |
|
| posted | boolean |
None. |
|
| pick_and_hold | boolean |
None. |
|
| pick_and_hold_comp | boolean |
None. |
|
| blanket_order | boolean |
None. |
|
| blanket_first_date | Object |
None. |
|
| blanket_shipments | integer |
None. |
|
| blanket_days | integer |
None. |
|
| blanket_qty | integer |
None. |
|
| created_date | string |
None. |
|
| pay_code | Collection of string |
None. |
|
| pay_code_card | Collection of string |
None. |
|
| pay_code_exp | Collection of Object |
None. |
|
| ship_cmplt_2nd_ps | boolean |
None. |
|
| price_by | string |
None. |
|
| cc_email | string |
None. |
|
| return_value | decimal number |
None. |
|
| confirmed | boolean |
None. |
|
| ship_data_exp | boolean |
None. |
|
| edipo_vendor | string |
None. |
|
| ps_batch_seq | integer |
None. |
|
| ci_batch_no | integer |
None. |
|
| dept_no | string |
None. |
|
| dept_name | string |
None. |
|
| rental_order | integer |
None. |
|
| num_pages | integer |
None. |
|
| currency_code | string |
None. |
|
| exchange_rate | decimal number |
None. |
|
| curx_o_deposit | decimal number |
None. |
|
| curx_o_disc_amt | decimal number |
None. |
|
| curx_o_tot_gross | decimal number |
None. |
|
| curx_o_tot_net_ar | decimal number |
None. |
|
| curx_o_tot_taxable | decimal number |
None. |
|
| curx_o_tot_taxable_it | decimal number |
None. |
|
| curx_o_tot_tax_amt | decimal number |
None. |
|
| curx_c_disc_amt | decimal number |
None. |
|
| curx_c_tot_gross | decimal number |
None. |
|
| curx_c_tot_net_ar | decimal number |
None. |
|
| curx_c_tot_taxable | decimal number |
None. |
|
| curx_c_tot_taxable_it | decimal number |
None. |
|
| curx_c_tot_tax_amt | decimal number |
None. |
|
| curx_i_tot_gross | decimal number |
None. |
|
| curx_opn_tot_gross | decimal number |
None. |
|
| curx_c_tot_code_amt | Collection of decimal number |
None. |
|
| curx_return_value | decimal number |
None. |
|
| c_tax_breakdown_amt | Collection of decimal number |
None. |
|
| c_tax_breakdown_code | Collection of string |
None. |
|
| curx_c_tax_breakdown_amt | Collection of decimal number |
None. |
|
| invoice | integer |
None. |
|
| curx_o_tax_breakdown_amt | Collection of decimal number |
None. |
|
| o_tax_breakdown_amt | Collection of decimal number |
None. |
|
| c_tax_breakdown_pct | Collection of decimal number |
None. |
|
| c_tax_breakdown_pct_amt | Collection of decimal number |
None. |
|
| curx_c_tax_breakdown_pct_amt | Collection of decimal number |
None. |
|
| o_tax_breakdown_pct_amt | Collection of decimal number |
None. |
|
| curx_o_tax_breakdown_pct_amt | Collection of decimal number |
None. |
|
| date_out | string |
None. |
|
| return_date | Object |
None. |
|
| return_pieces | integer |
None. |
|
| c_tax_breakdown_units | Collection of integer |
None. |
|
| document | integer |
None. |
|
| doc_partner_id | string |
None. |
|
| c_tax_breakdown_items | Collection of integer |
None. |
|
| delivery_terms | string |
None. |
|
| consolidate_order | integer |
None. |
|
| consolidate_rec_seq | integer |
None. |
|
| consolidated_order | boolean |
None. |
|
| curx_o_deposit_open | decimal number |
None. |
|
| curx_o_deposit_on_acct | decimal number |
None. |
|
| ship_group_no | integer |
None. |
|
| string |
None. |
||
| created_time | integer |
None. |
|
| created_by | string |
None. |
|
| calc_tot_code | Collection of boolean |
None. |
|
| cash_tendered | decimal number |
None. |
|
| cash_change | decimal number |
None. |
|
| curx_cash_tendered | decimal number |
None. |
|
| curx_cash_change | decimal number |
None. |
|
| c_tot_gross_excl | decimal number |
None. |
|
| curx_c_tot_gross_excl | decimal number |
None. |
|
| o_tot_gross_excl | decimal number |
None. |
|
| curx_o_tot_gross_excl | decimal number |
None. |
|
| discount_exclude | string |
None. |
|
| ship_grp_seq | integer |
None. |
|
| edit_notes | boolean |
None. |
|
| phone_ext | string |
None. |
|
| customer_prospect | string |
None. |
|
| sale_close_date | Object |
None. |
|
| sale_prob_pct | decimal number |
None. |
|
| consolidated_order_cig | boolean |
None. |
|
| consolidate_invc_date | Object |
None. |
|
| reminder_string | string |
None. |
|
| curx_tot_cod_amt | decimal number |
None. |
|
| tot_cod_amt | decimal number |
None. |
|
| ics_needs_recalc | boolean |
None. |
|
| un_sale | boolean |
None. |
|
| card_encrypt | Collection of string |
None. |
|
| card_length | Collection of integer |
None. |
|
| card_is_encrypted | Collection of boolean |
None. |
|
| customer_ext | string |
None. |
|
| appl_disc_pct | decimal number |
None. |
|
| o_appl_disc_amt | decimal number |
None. |
|
| c_appl_disc_amt | decimal number |
None. |
|
| curx_o_appl_disc_amt | decimal number |
None. |
|
| curx_c_appl_disc_amt | decimal number |
None. |
|
| inv_updated | boolean |
None. |
|
| inv_register | integer |
None. |
|
| inv_post_date | Object |
None. |
|
| exp_bol | integer |
None. |
|
| o_pc_total | decimal number |
None. |
|
| curx_o_pc_total | decimal number |
None. |
|
| c_pc_total | decimal number |
None. |
|
| curx_c_pc_total | decimal number |
None. |
|
| orderby_name | string |
None. |
|
| orderby_adr | Collection of string |
None. |
|
| orderby_phone | string |
None. |
|
| orderby_fax | string |
None. |
|
| orderby_email | string |
None. |
|
| orderby_state | string |
None. |
|
| orderby_postal_code | string |
None. |
|
| orderby_country_code | string |
None. |
|
| ship_dist_ctr | string |
None. |
|
| split_due_date | Collection of Object |
None. |
|
| split_due_percent | Collection of decimal number |
None. |
|
| rs_ship_via_code | string |
None. |
|
| priority_order | boolean |
None. |
|
| doc_src | integer |
None. |
|
| doc_src_seq | integer |
None. |
|
| order_min_ovrd | boolean |
None. |
|
| follow_up_date | Object |
None. |
|
| prep_time | decimal number |
None. |
|
| delivery_route | string |
None. |
|
| delivery_date | string |
None. |
|
| stop | integer |
None. |
|
| driver_code | string |
None. |
|
| truck_code | string |
None. |
|
| expedite | boolean |
None. |
|
| points_per_unit | decimal number |
None. |
|
| o_tot_units | integer |
None. |
|
| o_tot_points | decimal number |
None. |
|
| o_tot_points_amt | decimal number |
None. |
|
| curx_o_tot_points_amt | decimal number |
None. |
|
| c_tot_units | integer |
None. |
|
| c_tot_points | decimal number |
None. |
|
| c_tot_points_amt | decimal number |
None. |
|
| curx_c_tot_points_amt | decimal number |
None. |
|
| points_flag | boolean |
None. |
|
| wanted_date_range | string |
None. |
|
| c_tot_extra_points | decimal number |
None. |
|
| o_tot_extra_points | decimal number |
None. |
|
| load_status | string |
None. |
|
| sec_code | Collection of string |
None. |
|
| points_bonus_flag | boolean |
None. |
|
| web_item_check | boolean |
None. |
|
| check_it_restrict | boolean |
None. |
|
| split_due_date_2 | Collection of Object |
None. |
|
| split_due_percent_2 | Collection of decimal number |
None. |
|
| split_due_type | string |
None. |
|
| vmi_replen | boolean |
None. |
|
| cell_phone | string |
None. |
|
| consolidated_order_3pl | boolean |
None. |
|
| print_credit_flag | boolean |
None. |
|
| route_date | Object |
None. |
|
| split_total_payments | integer |
None. |
|
| terms_disc_ovrd | boolean |
None. |
|
| bol | integer |
None. |
|
| pick_priority_dt | Object |
None. |
|
| calc_surcharge | boolean |
None. |
|
| surcharge_calc | boolean |
None. |
|
| cross_dock | boolean |
None. |
|
| edi_misc | Collection of string |
None. |
|
| calc_rebate | boolean |
None. |
|
| card_token | Collection of string |
None. |
|
| free_freight_pct | decimal number |
None. |
|
| freight_amount | decimal number |
None. |
|
| free_freight_status | string |
None. |
|
| free_freight_flag | boolean |
None. |
|
| free_freight_level | decimal number |
None. |
|
| manifest_key | string |
None. |
|
| o_credit | decimal number |
None. |
|
| cc_fee_pct | decimal number |
None. |
|
| cc_fee_amt | decimal number |
None. |
|
| __rowid | string |
None. |