| field name | data type | mnd. | description |
|---|---|---|---|
| ih_nbr | character(80) | yes | Sales Order |
| ih_cust | character(80) | no | Customer |
| ih_ship | character(80) | no | Ship-To |
| ih_ord_date | date | no | Order Date |
| ih_req_date | date | no | Required Date |
| ih_due_date | date | no | Due Date |
| ih_rmks | character(80) | no | Remarks |
| ih_cr_terms | character(80) | no | Credit Terms |
| ih_fob | character(30) | no | FOB Point |
| ih_po | character(30) | no | Purchase Order |
| ih_shipvia | character(30) | no | Ship Via |
| ih_partial | logical | no | Partial OK |
| ih_print_so | logical | no | Print Sales Order |
| ih_inv_nbr | character(80) | no | Invoice |
| ih_pr_list | character(80) | no | Price List |
| ih_source | character(80) | no | Order Source |
| ih_cr_card | character(30) | no | Credit Card |
| ih_print_pl | logical | no | Print Pack List |
| ih_cr_init | character(30) | no | Cr Initials |
| ih_stat | character(30) | no | Action Status |
| ih__qad01 | decimal(10) | no | |
| ih__qad02 | decimal(10) | no | |
| ih__qad03 | decimal(10) | no | |
| ih_disc_pct | decimal(10) | no | Disc % |
| ih_prepaid | decimal(10) | no | Prepaid Amount |
| ih_to_inv | logical | no | Ready to Invoice |
| ih_invoiced | logical | no | Invoiced |
| ih_ar_acct | character(80) | no | AR Account |
| ih_ar_cc | character(30) | no | Cost Ctr |
| ih_inv_date | date | no | Invoice Date |
| ih_ship_date | date | no | Ship Date |
| ih_taxable | logical | no | Taxable |
| ih_cmtindx | integer | no | Comment Index |
| ih__qad04 | integer | no | |
| ih_user1 | character(80) | no | Ufld1 |
| ih_user2 | character(80) | no | Ufld2 |
| ih_curr | character(30) | no | Currency |
| ih_ex_rate | decimal(10) | no | Exch Rate |
| ih_lang | character(30) | no | Language |
| ih_type | character(80) | no | Type |
| ih_conf_date | date | no | Confirmed Date |
| ih_rev | integer | no | Revision |
| ih_bol | character(30) | no | BOL |
| ih_pst | logical | no | PST |
| ih_fst_id | character(30) | no | FST ID |
| ih_trl1_amt | decimal(10) | no | Trailer Amt 1 |
| ih_trl1_cd | character(30) | no | Trailer 1 |
| ih_trl2_amt | decimal(10) | no | Trailer Amt 2 |
| ih_trl2_cd | character(30) | no | Trailer 2 |
| ih_trl3_amt | decimal(10) | no | Trailer Amt 3 |
| ih_trl3_cd | character(30) | no | Trailer 3 |
| ih_weight | decimal(10) | no | Weight |
| ih_weight_um | character(30) | no | Weight UM |
| ih_size | decimal(10) | no | Size |
| ih_size_um | character(30) | no | Size UM |
| ih_cartons | integer | no | Cartons |
| ih_site | character(80) | no | Site |
| ih_quote | character(80) | no | Quote |
| ih_taxc | character(30) | no | Tax Class |
| ih__chr01 | character(80) | no | |
| ih__chr02 | character(80) | no | |
| ih__chr03 | character(80) | no | |
| ih__chr04 | character(80) | no | |
| ih__chr05 | character(80) | no | |
| ih__chr06 | character(80) | no | |
| ih__chr07 | character(80) | no | |
| ih__chr08 | character(80) | no | |
| ih__chr09 | character(80) | no | |
| ih__chr10 | character(80) | no | |
| ih__dte01 | date | no | |
| ih__dte02 | date | no | |
| ih__dec01 | decimal(10) | no | |
| ih__dec02 | decimal(10) | no | |
| ih__log01 | logical | no | |
| ih_credit | logical | no | Credit |
| ih_inv_cr | character(80) | no | Invoice To Credit |
| ih_project | character(80) | no | Project |
| ih_pst_pct | decimal(10) | no | PST Pct |
| ih_pst_id | character(30) | no | PST ID |
| ih_fr_list | character(80) | no | Freight List |
| ih_fr_terms | character(80) | no | Freight Terms |
| ih_fix_rate | logical | no | Fixed Rate |
| ih_ent_ex | decimal(10) | no | Exch Rate |
| ih_bill | character(80) | no | Bill-To |
| ih_print_bl | logical | no | Print Bill of Lading |
| ih_userid | character(80) | no | User ID |
| ih_tax_date | date | no | Tax Date |
| ih_channel | character(80) | no | Channel |
| ih_inv_mthd | character(80) | no | Invoices Via |
| ih_fsm_type | character(83) | no | FSM Type |
| ih_bank | character(30) | no | Bank |
| ih_fr_min_wt | decimal(10) | no | Frt Min Wt |
| ih_pr_list2 | character(80) | no | List Price List |
| ih_tax_env | character(30) | no | Tax Environment |
| ih_tax_usage | character(80) | no | Tax Usage |
| ih_sa_nbr | character(80) | no | Contract |
| ih_crprlist | character(80) | no | Credit Price List |
| ih_ship_eng | logical | no | Ship-To Engineer |
| ih_cncl_date | date | no | Cancel Date |
| ih_conrep | character(80) | no | Netting Logic |
| ih_sched | logical | no | Scheduled |
| ih_fix_pr | logical | no | Fixed Price |
| ih_sch_mthd | character(30) | no | Schedules Via |
| ih_ca_nbr | character(80) | no | Call |
| ih_fcg_code | character(80) | no | Charge Code |
| ih_mod_date | date | no | Modified Date |
| ih_pricing_dt | date | no | Pricing Date |
| ih_priced_dt | date | no | Last Price Dt |
| ih_rstk_pct | decimal(10) | no | Restocking Charge |
| ih__qadc01 | character(80) | no | QAD Field |
| ih__qadc02 | character(80) | no | QAD Field |
| ih__qadc03 | character(80) | no | QAD Field |
| ih__qadc04 | character(80) | no | QAD Field |
| ih__qadc05 | character(80) | no | QAD Field |
| ih__qadt01 | date | no | QAD Field |
| ih__qadt02 | date | no | QAD Field |
| ih__qadt03 | date | no | QAD Field |
| ih__qadd01 | decimal(10) | no | QAD Field |
| ih__qadd02 | decimal(10) | no | QAD Field |
| ih__qadd03 | decimal(10) | no | QAD Field |
| ih__qadi01 | integer | no | QAD Field |
| ih__qadi02 | integer | no | QAD Field |
| ih__qadi03 | integer | no | QAD Field |
| ih__qadl01 | logical | no | QAD Field |
| ih__qadl02 | logical | no | QAD Field |
| ih__qadl03 | logical | no | QAD Field |
| ih_primary | logical | no | Primary SO |
| ih_cust_po | character(30) | no | End Customer PO |
| ih_secondary | logical | no | Secondary EMT Order |
| ih_ship_po | character(30) | no | Ship To PO |
| ih_ex_rate2 | decimal(10) | no | Exch Rate 2 |
| ih_ex_ratetype | character(80) | no | Rate Type |
| ih_div | character(80) | no | Division |
| ih_exru_seq | integer | no | Sequence |
| ih_export_batch | integer | no | Batch |
| ih_export_date | date | no | Export Date |
| ih_export_time | integer | no | Export Time |
| ih_ar_sub | character(80) | no | AR Sub-Account |
| ih_prep_tax | decimal(10) | no | Prepaid Tax |
| ih_custref_val | logical | no | Customer Ref Is Customer Item |
| ih_domain | character(8) | yes | Domain |
| oid_ih_hist | decimal(10) | no | |
| ih_daybookset | character(8) | no | Daybook Set |
| ih_invoicetype | character(25) | no | Invoice Type |
| ih_invoicetotal | decimal(10) | no | Total |
| ih_batch | character(80) | no | Batch |
| ih_daybook | character(8) | no | Daybook |
| ih_trl_amt | decimal(10) | no | Rounding Trailer Amount |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| idh_nbr | character(80) | yes | Sales Order |
| idh_due_date | date | no | Due Date |
| idh_per_date | date | no | Perform Date |
| idh_req_date | date | no | Required Date |
| idh_line | integer | no | Line |
| idh_part | character(30) | no | Item Number |
| idh_qty_ord | decimal(10) | no | Qty Ordered |
| idh_qty_all | decimal(10) | no | Qty Allocated |
| idh_qty_pick | decimal(10) | no | Qty Picked |
| idh_qty_ship | decimal(10) | no | Qty Shipped |
| idh_qty_inv | decimal(10) | no | Qty Invoiced |
| idh_loc | character(80) | no | Location |
| idh_type | character(30) | no | Ship Type |
| idh_price | decimal(10) | no | Price |
| idh_std_cost | decimal(10) | no | Cost |
| idh_qty_chg | decimal(10) | no | Qty To Ship |
| idh_bo_chg | decimal(10) | no | Qty Backord |
| idh_acct | character(80) | no | Sales Acct |
| idh_abnormal | logical | no | Abnormal Demand |
| idh_taxable | logical | no | Taxable |
| idh_serial | character(50) | no | Lot/Serial |
| idh_desc | character(80) | no | Description |
| idh_um | character(30) | no | UM |
| idh_cc | character(30) | no | Cost Ctr |
| idh_lot | character(80) | no | ID |
| idh_um_conv | decimal(10) | no | UM Conversion |
| idh_fa_nbr | character(30) | no | FAS W/O |
| idh_disc_pct | decimal(10) | no | Disc % |
| idh_project | character(80) | no | Project |
| idh_cmtindx | integer | no | Comment Index |
| idh_custpart | character(30) | no | Customer Item |
| idh__qad01 | integer | no | |
| idh_status | character(80) | no | Status |
| idh_dsc_acct | character(80) | no | Disc Acct |
| idh_dsc_cc | character(30) | no | Disc CC |
| idh_list_pr | decimal(10) | no | List Price |
| idh_user1 | character(80) | no | Ufld1 |
| idh_user2 | character(80) | no | Ufld2 |
| idh_sob_rev | date | no | Revised Date |
| idh_sob_std | logical | no | Standard Bill |
| idh_qty_qote | decimal(10) | no | Qty Quoted |
| idh_consume | logical | no | Consume Forecast |
| idh_expire | date | no | Expires |
| idh__qad02 | logical | no | |
| idh_taxc | character(30) | no | Tax Class |
| idh_inv_nbr | character(80) | no | Invoice |
| idh_site | character(80) | no | Site |
| idh_prodline | character(30) | no | Product Line |
| idh__chr01 | character(80) | no | |
| idh__chr02 | character(80) | no | |
| idh__chr03 | character(80) | no | |
| idh__chr04 | character(80) | no | |
| idh__chr05 | character(80) | no | |
| idh__chr06 | character(80) | no | |
| idh__chr07 | character(80) | no | |
| idh__chr08 | character(80) | no | |
| idh__chr09 | character(80) | no | |
| idh__chr10 | character(80) | no | |
| idh__dte01 | date | no | |
| idh__dte02 | date | no | |
| idh__dec01 | decimal(10) | no | |
| idh__dec02 | decimal(10) | no | |
| idh__log01 | logical | no | |
| idh__dte03 | date | no | |
| idh__dec03 | decimal(10) | no | |
| idh__dec04 | decimal(10) | no | |
| idh__dec05 | decimal(10) | no | |
| idh_tax_max | decimal(10) | no | Max Taxable Amount |
| idh_tax_in | logical | no | Tax In |
| idh_pst | logical | no | PST Taxable |
| idh_fr_rate | decimal(10) | no | Freight Rate |
| idh_calc_isb | logical | no | Calculate Isb |
| idh_owner | character(80) | no | Ownership |
| idh_rma_type | character(30) | no | RMA Type |
| idh_qty_item | decimal(10) | no | Item Quantity |
| idh_qty_per | decimal(10) | no | Duration |
| idh_ref | integer | no | Ref |
| idh_for | character(30) | no | For |
| idh_retro_price | decimal(10) | no | Retro Invoice Price |
| idh_contr_id | character(80) | no | Contract ID |
| idh_fst_list | logical | no | FST on List |
| idh_ord_mult | decimal(0) | no | Ord Mult |
| idh_pkg_code | character(30) | no | Pkg Code |
| idh_rlse_nbr | integer | no | Next Release ID |
| idh_sch_data | character(80) | no | Schedule Data |
| idh_sch_mrp | logical | no | Sched MRP Req |
| idh_sched | logical | no | Scheduled |
| idh_trans_lt | decimal(10) | no | Transport Leadtime |
| idh_fsm_type | character(80) | no | FSM Type |
| idh_sa_nbr | character(80) | no | Service Contract |
| idh_fix_pr | logical | no | Fixed Price |
| idh_fr_wt | decimal(10) | no | Unit Ship Weight |
| idh_fr_wt_um | character(30) | no | UM |
| idh_fr_class | character(80) | no | Freight Class |
| idh_fr_chg | decimal(10) | no | Unit Freight Charge |
| idh_tax_usage | character(80) | no | Tax Usage |
| idh_tax_env | character(30) | no | Tax Environment |
| idh_fr_list | character(80) | no | Freight List |
| idh_crt_int | decimal(10) | no | Credit Terms Int |
| idh_act_price | decimal(10) | no | Actual Price |
| idh_auto_ins | logical | no | Installation Call |
| idh_covered_amt | decimal(10) | no | Covered Amount |
| idh_override_lmt | logical | no | Override Limits |
| idh_enduser | character(80) | no | End User |
| idh_isb_loc | character(30) | no | Installed Base Location |
| idh_isb_ref | integer | no | ISB Ref |
| idh_ship | character(80) | no | Ship-To |
| idh_fixed_price | decimal(10) | no | Fixed Price |
| idh_inv_cost | decimal(10) | no | Invoice Cost |
| idh_partial | logical | no | Partial OK |
| idh_pickdate | date | no | Pick Date |
| idh_conrep | character(30) | no | Netting Logic |
| idh_out_po | character(80) | no | Display PO Number |
| idh_translt_hrs | decimal(10) | no | Transport Hours |
| idh_pr_list | character(80) | no | Price List |
| idh_dock | character(80) | no | Dock |
| idh_raw_days | integer | no | Raw Auth Days |
| idh_fab_days | integer | no | Fab Auth Days |
| idh_rbkt_days | integer | no | Req Schedule Days |
| idh_rbkt_weeks | integer | no | Req Schedule Weeks |
| idh_rbkt_mths | integer | no | Req Schedule Months |
| idh_sched_chgd | logical | no | Schedule Changed |
| idh_pastdue | character(30) | no | Past Due Logic |
| idh_drp_ref | character(80) | no | DRP Ref |
| idh_upd_isb | logical | no | Update Installed Base |
| idh_ca_nbr | character(80) | no | Call Number |
| idh_car_load | logical | no | Call Act. Rec. Load |
| idh_ca_line | integer | no | Call Line |
| idh_qty_cons | decimal(10) | no | Qty Consumed |
| idh_qty_ret | decimal(10) | no | Qty Returned |
| idh_qty_pend | decimal(10) | no | Qty Pending |
| idh_to_loc | character(80) | no | Location |
| idh_to_site | character(80) | no | Site |
| idh_ln_ref | character(80) | no | Line Ref |
| idh_to_ref | character(80) | no | Kit Ref |
| idh_qty_exch | decimal(10) | no | Qty Exchanged |
| idh_warr_start | date | no | Warranty Start Date |
| idh_sad_line | integer | no | Contract Line |
| idh_mod_userid | character(80) | no | User ID |
| idh_mod_date | date | no | Modified Date |
| idh_pricing_dt | date | no | Pricing Date |
| idh_sv_code | character(80) | no | Warranty Type |
| idh_for_serial | character(50) | no | Parent Item Serial |
| idh__qadc01 | character(80) | no | QAD Field |
| idh__qadc02 | character(80) | no | QAD Field |
| idh__qadc03 | character(80) | no | QAD field |
| idh__qadc04 | character(80) | no | QAD field |
| idh__qadc05 | character(80) | no | QAD field |
| idh__qadc06 | character(80) | no | QAD field |
| idh__qadi01 | integer | no | QAD Field |
| idh__qadi02 | integer | no | QAD Field |
| idh__qadi03 | integer | no | QAD Field |
| idh__qadi04 | integer | no | QAD Field |
| idh__qadd01 | decimal(10) | no | QAD Field |
| idh__qadd02 | decimal(10) | no | QAD Field |
| idh__qadd03 | decimal(10) | no | QAD Field |
| idh__qadd04 | decimal(10) | no | QAD Field |
| idh__qadd05 | decimal(10) | no | QAD Field |
| idh__qadl01 | logical | no | QAD Field |
| idh__qadl02 | logical | no | QAD Field |
| idh__qadl03 | logical | no | QAD Field |
| idh__qadl04 | logical | no | QAD Field |
| idh__qadl05 | logical | no | QAD Field |
| idh__qadt01 | date | no | QAD Field |
| idh__qadt02 | date | no | QAD Field |
| idh__qadt03 | date | no | QAD Field |
| idh__qadt04 | date | no | QAD Field |
| idh__qadt05 | date | no | QAD Field |
| idh_bonus | logical | no | Bonus Stock Line |
| idh_btb_type | character(30) | no | EMT Type |
| idh_btb_po | character(80) | no | EMT PO |
| idh_btb_pod_line | integer | no | EMT PO Line |
| idh_btb_vend | character(80) | no | EMT Supplier |
| idh_exp_del | date | no | Exp Delivery Date |
| idh_cfg_type | character(30) | no | Configuration |
| idh_div | character(80) | no | Division |
| idh_pl_priority | integer | no | P/L Priority |
| idh_prig1 | character(80) | no | Pricing Group 1 |
| idh_prig2 | character(80) | no | Pricing Group 2 |
| idh_sub | character(80) | no | Sales Sub-Acct |
| idh_dsc_project | character(80) | no | Disc Project |
| idh_dsc_sub | character(80) | no | Disc Sub-Acct |
| idh_promise_date | date | no | Promise Date |
| idh_modelyr | character(30) | no | Model Year |
| idh_custref | character(80) | no | Customer Ref |
| idh_domain | character(8) | yes | Domain |
| oid_idh_hist | decimal(10) | no | |
| idh_shipvia | character(30) | no | Ship Via |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tih_hist.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |