| field name | data type | db field | description |
|---|
| tcidh__chr01 | character | idh_hist.idh__chr01 | |
| tcidh__chr02 | character | idh_hist.idh__chr02 | |
| tcidh__chr03 | character | idh_hist.idh__chr03 | |
| tcidh__chr04 | character | idh_hist.idh__chr04 | |
| tcidh__chr05 | character | idh_hist.idh__chr05 | |
| tcidh__chr06 | character | idh_hist.idh__chr06 | |
| tcidh__chr07 | character | idh_hist.idh__chr07 | |
| tcidh__chr08 | character | idh_hist.idh__chr08 | |
| tcidh__chr09 | character | idh_hist.idh__chr09 | |
| tcidh__chr10 | character | idh_hist.idh__chr10 | |
| tdidh__dec01 | decimal | idh_hist.idh__dec01 | |
| tdidh__dec02 | decimal | idh_hist.idh__dec02 | |
| tdidh__dec03 | decimal | idh_hist.idh__dec03 | |
| tdidh__dec04 | decimal | idh_hist.idh__dec04 | |
| tdidh__dec05 | decimal | idh_hist.idh__dec05 | |
| ttidh__dte01 | date | idh_hist.idh__dte01 | |
| ttidh__dte02 | date | idh_hist.idh__dte02 | |
| ttidh__dte03 | date | idh_hist.idh__dte03 | |
| tlidh__log01 | logical | idh_hist.idh__log01 | |
| tiidh__qad01 | integer | idh_hist.idh__qad01 | |
| tlidh__qad02 | logical | idh_hist.idh__qad02 | |
| tcidh__qadc01 | character | idh_hist.idh__qadc01 | QAD Field |
| tcidh__qadc02 | character | idh_hist.idh__qadc02 | QAD Field |
| tcidh__qadc03 | character | idh_hist.idh__qadc03 | QAD field |
| tcidh__qadc04 | character | idh_hist.idh__qadc04 | QAD field |
| tcidh__qadc05 | character | idh_hist.idh__qadc05 | QAD field |
| tcidh__qadc06 | character | idh_hist.idh__qadc06 | QAD field |
| tdidh__qadd01 | decimal | idh_hist.idh__qadd01 | QAD Field |
| tdidh__qadd02 | decimal | idh_hist.idh__qadd02 | QAD Field |
| tdidh__qadd03 | decimal | idh_hist.idh__qadd03 | QAD Field |
| tdidh__qadd04 | decimal | idh_hist.idh__qadd04 | QAD Field |
| tdidh__qadd05 | decimal | idh_hist.idh__qadd05 | QAD Field |
| tiidh__qadi01 | integer | idh_hist.idh__qadi01 | QAD Field |
| tiidh__qadi02 | integer | idh_hist.idh__qadi02 | QAD Field |
| tiidh__qadi03 | integer | idh_hist.idh__qadi03 | QAD Field |
| tiidh__qadi04 | integer | idh_hist.idh__qadi04 | QAD Field |
| tlidh__qadl01 | logical | idh_hist.idh__qadl01 | QAD Field |
| tlidh__qadl02 | logical | idh_hist.idh__qadl02 | QAD Field |
| tlidh__qadl03 | logical | idh_hist.idh__qadl03 | QAD Field |
| tlidh__qadl04 | logical | idh_hist.idh__qadl04 | QAD Field |
| tlidh__qadl05 | logical | idh_hist.idh__qadl05 | QAD Field |
| ttidh__qadt01 | date | idh_hist.idh__qadt01 | QAD Field |
| ttidh__qadt02 | date | idh_hist.idh__qadt02 | QAD Field |
| ttidh__qadt03 | date | idh_hist.idh__qadt03 | QAD Field |
| ttidh__qadt04 | date | idh_hist.idh__qadt04 | QAD Field |
| ttidh__qadt05 | date | idh_hist.idh__qadt05 | QAD Field |
| tlidh_abnormal | logical | idh_hist.idh_abnormal | Abnormal Demand |
| tcidh_acct | character | idh_hist.idh_acct | Sales Acct |
| tdidh_act_price | decimal | idh_hist.idh_act_price | Actual Price |
| tlidh_auto_ins | logical | idh_hist.idh_auto_ins | Installation Call |
| tdidh_bo_chg | decimal | idh_hist.idh_bo_chg | Qty Backord |
| tlidh_bonus | logical | idh_hist.idh_bonus | Bonus Stock Line |
| tcidh_btb_po | character | idh_hist.idh_btb_po | EMT PO |
| tiidh_btb_pod_line | integer | idh_hist.idh_btb_pod_line | EMT PO Line |
| tcidh_btb_type | character | idh_hist.idh_btb_type | EMT Type |
| tcidh_btb_vend | character | idh_hist.idh_btb_vend | EMT Supplier |
| tiidh_ca_line | integer | idh_hist.idh_ca_line | Call Line |
| tcidh_ca_nbr | character | idh_hist.idh_ca_nbr | Call Number |
| tlidh_calc_isb | logical | idh_hist.idh_calc_isb | Calculate Isb |
| tlidh_car_load | logical | idh_hist.idh_car_load | Call Act. Rec. Load |
| tcidh_cc | character | idh_hist.idh_cc | Cost Ctr |
| tcidh_cfg_type | character | idh_hist.idh_cfg_type | Configuration |
| tiidh_cmtindx | integer | idh_hist.idh_cmtindx | Comment Index |
| tcidh_conrep | character | idh_hist.idh_conrep | Netting Logic |
| tlidh_consume | logical | idh_hist.idh_consume | Consume Forecast |
| tcidh_contr_id | character | idh_hist.idh_contr_id | Contract ID |
| tdidh_covered_amt | decimal | idh_hist.idh_covered_amt | Covered Amount |
| tdidh_crt_int | decimal | idh_hist.idh_crt_int | Credit Terms Int |
| tcidh_custpart | character | idh_hist.idh_custpart | Customer Item |
| tcidh_custref | character | idh_hist.idh_custref | Customer Ref |
| tcidh_desc | character | idh_hist.idh_desc | Description |
| tdidh_disc_pct | decimal | idh_hist.idh_disc_pct | Disc % |
| tcidh_div | character | idh_hist.idh_div | Division |
| tcidh_dock | character | idh_hist.idh_dock | Dock |
| tcidh_domain | character | idh_hist.idh_domain | Domain |
| tcidh_drp_ref | character | idh_hist.idh_drp_ref | DRP Ref |
| tcidh_dsc_acct | character | idh_hist.idh_dsc_acct | Disc Acct |
| tcidh_dsc_cc | character | idh_hist.idh_dsc_cc | Disc CC |
| tcidh_dsc_project | character | idh_hist.idh_dsc_project | Disc Project |
| tcidh_dsc_sub | character | idh_hist.idh_dsc_sub | Disc Sub-Acct |
| ttidh_due_date | date | idh_hist.idh_due_date | Due Date |
| tcidh_enduser | character | idh_hist.idh_enduser | End User |
| ttidh_exp_del | date | idh_hist.idh_exp_del | Exp Delivery Date |
| ttidh_expire | date | idh_hist.idh_expire | Expires |
| tcidh_fa_nbr | character | idh_hist.idh_fa_nbr | FAS W/O |
| tiidh_fab_days | integer | idh_hist.idh_fab_days | Fab Auth Days |
| tlidh_fix_pr | logical | idh_hist.idh_fix_pr | Fixed Price |
| tdidh_fixed_price | decimal | idh_hist.idh_fixed_price | Fixed Price |
| tcidh_for | character | idh_hist.idh_for | For |
| tcidh_for_serial | character | idh_hist.idh_for_serial | Parent Item Serial |
| tdidh_fr_chg | decimal | idh_hist.idh_fr_chg | Unit Freight Charge |
| tcidh_fr_class | character | idh_hist.idh_fr_class | Freight Class |
| tcidh_fr_list | character | idh_hist.idh_fr_list | Freight List |
| tdidh_fr_rate | decimal | idh_hist.idh_fr_rate | Freight Rate |
| tdidh_fr_wt | decimal | idh_hist.idh_fr_wt | Unit Ship Weight |
| tcidh_fr_wt_um | character | idh_hist.idh_fr_wt_um | UM |
| tcidh_fsm_type | character | idh_hist.idh_fsm_type | FSM Type |
| tlidh_fst_list | logical | idh_hist.idh_fst_list | FST on List |
| tdidh_inv_cost | decimal | idh_hist.idh_inv_cost | Invoice Cost |
| tcidh_inv_nbr | character | idh_hist.idh_inv_nbr | Invoice |
| tcidh_isb_loc | character | idh_hist.idh_isb_loc | Installed Base Location |
| tiidh_isb_ref | integer | idh_hist.idh_isb_ref | ISB Ref |
| tiidh_line | integer | idh_hist.idh_line | Line |
| tdidh_list_pr | decimal | idh_hist.idh_list_pr | List Price |
| tcidh_ln_ref | character | idh_hist.idh_ln_ref | Line Ref |
| tcidh_loc | character | idh_hist.idh_loc | Location |
| tcidh_lot | character | idh_hist.idh_lot | ID |
| ttidh_mod_date | date | idh_hist.idh_mod_date | Modified Date |
| tcidh_mod_userid | character | idh_hist.idh_mod_userid | User ID |
| tcidh_modelyr | character | idh_hist.idh_modelyr | Model Year |
| tcidh_nbr | character | idh_hist.idh_nbr | Sales Order |
| tdidh_ord_mult | decimal | idh_hist.idh_ord_mult | Ord Mult |
| tcidh_out_po | character | idh_hist.idh_out_po | Display PO Number |
| tlidh_override_lmt | logical | idh_hist.idh_override_lmt | Override Limits |
| tcidh_owner | character | idh_hist.idh_owner | Ownership |
| tcidh_part | character | idh_hist.idh_part | Item Number |
| tlidh_partial | logical | idh_hist.idh_partial | Partial OK |
| tcidh_pastdue | character | idh_hist.idh_pastdue | Past Due Logic |
| ttidh_per_date | date | idh_hist.idh_per_date | Perform Date |
| ttidh_pickdate | date | idh_hist.idh_pickdate | Pick Date |
| tcidh_pkg_code | character | idh_hist.idh_pkg_code | Pkg Code |
| tiidh_pl_priority | integer | idh_hist.idh_pl_priority | P/L Priority |
| tcidh_pr_list | character | idh_hist.idh_pr_list | Price List |
| tdidh_price | decimal | idh_hist.idh_price | Price |
| ttidh_pricing_dt | date | idh_hist.idh_pricing_dt | Pricing Date |
| tcidh_prig1 | character | idh_hist.idh_prig1 | Pricing Group 1 |
| tcidh_prig2 | character | idh_hist.idh_prig2 | Pricing Group 2 |
| tcidh_prodline | character | idh_hist.idh_prodline | Product Line |
| tcidh_project | character | idh_hist.idh_project | Project |
| ttidh_promise_date | date | idh_hist.idh_promise_date | Promise Date |
| tlidh_pst | logical | idh_hist.idh_pst | PST Taxable |
| tdidh_qty_all | decimal | idh_hist.idh_qty_all | Qty Allocated |
| tdidh_qty_chg | decimal | idh_hist.idh_qty_chg | Qty To Ship |
| tdidh_qty_cons | decimal | idh_hist.idh_qty_cons | Qty Consumed |
| tdidh_qty_exch | decimal | idh_hist.idh_qty_exch | Qty Exchanged |
| tdidh_qty_inv | decimal | idh_hist.idh_qty_inv | Qty Invoiced |
| tdidh_qty_item | decimal | idh_hist.idh_qty_item | Item Quantity |
| tdidh_qty_ord | decimal | idh_hist.idh_qty_ord | Qty Ordered |
| tdidh_qty_pend | decimal | idh_hist.idh_qty_pend | Qty Pending |
| tdidh_qty_per | decimal | idh_hist.idh_qty_per | Duration |
| tdidh_qty_pick | decimal | idh_hist.idh_qty_pick | Qty Picked |
| tdidh_qty_qote | decimal | idh_hist.idh_qty_qote | Qty Quoted |
| tdidh_qty_ret | decimal | idh_hist.idh_qty_ret | Qty Returned |
| tdidh_qty_ship | decimal | idh_hist.idh_qty_ship | Qty Shipped |
| tiidh_raw_days | integer | idh_hist.idh_raw_days | Raw Auth Days |
| tiidh_rbkt_days | integer | idh_hist.idh_rbkt_days | Req Schedule Days |
| tiidh_rbkt_mths | integer | idh_hist.idh_rbkt_mths | Req Schedule Months |
| tiidh_rbkt_weeks | integer | idh_hist.idh_rbkt_weeks | Req Schedule Weeks |
| tiidh_ref | integer | idh_hist.idh_ref | Ref |
| ttidh_req_date | date | idh_hist.idh_req_date | Required Date |
| tdidh_retro_price | decimal | idh_hist.idh_retro_price | Retro Invoice Price |
| tiidh_rlse_nbr | integer | idh_hist.idh_rlse_nbr | Next Release ID |
| tcidh_rma_type | character | idh_hist.idh_rma_type | RMA Type |
| tcidh_sa_nbr | character | idh_hist.idh_sa_nbr | Service Contract |
| tiidh_sad_line | integer | idh_hist.idh_sad_line | Contract Line |
| tcidh_sch_data | character | idh_hist.idh_sch_data | Schedule Data |
| tlidh_sch_mrp | logical | idh_hist.idh_sch_mrp | Sched MRP Req |
| tlidh_sched | logical | idh_hist.idh_sched | Scheduled |
| tlidh_sched_chgd | logical | idh_hist.idh_sched_chgd | Schedule Changed |
| tcidh_serial | character | idh_hist.idh_serial | Lot/Serial |
| tcidh_ship | character | idh_hist.idh_ship | Ship-To |
| tcidh_shipvia | character | idh_hist.idh_shipvia | Ship Via |
| tcidh_site | character | idh_hist.idh_site | Site |
| ttidh_sob_rev | date | idh_hist.idh_sob_rev | Revised Date |
| tlidh_sob_std | logical | idh_hist.idh_sob_std | Standard Bill |
| tcidh_status | character | idh_hist.idh_status | Status |
| tdidh_std_cost | decimal | idh_hist.idh_std_cost | Cost |
| tcidh_sub | character | idh_hist.idh_sub | Sales Sub-Acct |
| tcidh_sv_code | character | idh_hist.idh_sv_code | Warranty Type |
| tcidh_tax_env | character | idh_hist.idh_tax_env | Tax Environment |
| tlidh_tax_in | logical | idh_hist.idh_tax_in | Tax In |
| tdidh_tax_max | decimal | idh_hist.idh_tax_max | Max Taxable Amount |
| tcidh_tax_usage | character | idh_hist.idh_tax_usage | Tax Usage |
| tlidh_taxable | logical | idh_hist.idh_taxable | Taxable |
| tcidh_taxc | character | idh_hist.idh_taxc | Tax Class |
| tcidh_to_loc | character | idh_hist.idh_to_loc | Location |
| tcidh_to_ref | character | idh_hist.idh_to_ref | Kit Ref |
| tcidh_to_site | character | idh_hist.idh_to_site | Site |
| tdidh_trans_lt | decimal | idh_hist.idh_trans_lt | Transport Leadtime |
| tdidh_translt_hrs | decimal | idh_hist.idh_translt_hrs | Transport Hours |
| tcidh_type | character | idh_hist.idh_type | Ship Type |
| tcidh_um | character | idh_hist.idh_um | UM |
| tdidh_um_conv | decimal | idh_hist.idh_um_conv | UM Conversion |
| tlidh_upd_isb | logical | idh_hist.idh_upd_isb | Update Installed Base |
| tcidh_user1 | character | idh_hist.idh_user1 | Ufld1 |
| tcidh_user2 | character | idh_hist.idh_user2 | Ufld2 |
| ttidh_warr_start | date | idh_hist.idh_warr_start | Warranty Start Date |
| tdoid_idh_hist | decimal | idh_hist.oid_idh_hist | |
each idh_hist where