| field name | data type | db field | description |
|---|
| tcidhlc__qadc01 | character | idhlc_hist.idhlc__qadc01 | |
| tcidhlc__qadc02 | character | idhlc_hist.idhlc__qadc02 | |
| tcidhlc_acct | character | idhlc_hist.idhlc_acct | Sales Acct |
| tcidhlc_cc | character | idhlc_hist.idhlc_cc | Cost Ctr |
| tcidhlc_charge_category | character | idhlc_hist.idhlc_charge_category | Category |
| tcidhlc_charge_type | character | idhlc_hist.idhlc_charge_type | Charge Type |
| tcidhlc_desc | character | idhlc_hist.idhlc_desc | Description |
| tcidhlc_desc1 | character | idhlc_hist.idhlc_desc1 | Description |
| tcidhlc_desc2 | character | idhlc_hist.idhlc_desc2 | Description |
| tcidhlc_domain | character | idhlc_hist.idhlc_domain | Domain |
| tcidhlc_fr_class | character | idhlc_hist.idhlc_fr_class | Freight Class |
| tdidhlc_fr_wt | decimal | idhlc_hist.idhlc_fr_wt | Unit Ship Weight |
| tcidhlc_fr_wt_um | character | idhlc_hist.idhlc_fr_wt_um | UM |
| tcidhlc_inv_nbr | character | idhlc_hist.idhlc_inv_nbr | Invoice |
| tiidhlc_line | integer | idhlc_hist.idhlc_line | SO Line |
| ttidhlc_mod_date | date | idhlc_hist.idhlc_mod_date | Modified Date |
| tcidhlc_mod_userid | character | idhlc_hist.idhlc_mod_userid | User ID |
| tcidhlc_nbr | character | idhlc_hist.idhlc_nbr | Sales Order |
| tcidhlc_part | character | idhlc_hist.idhlc_part | Item Number |
| tdidhlc_price | decimal | idhlc_hist.idhlc_price | Price |
| tcidhlc_prodline | character | idhlc_hist.idhlc_prodline | Product Line |
| tcidhlc_project | character | idhlc_hist.idhlc_project | Project |
| tdidhlc_qty_inv | decimal | idhlc_hist.idhlc_qty_inv | Qty Invoiced |
| tcidhlc_sub | character | idhlc_hist.idhlc_sub | Sales Sub-Acct |
| tiidhlc_sub_line | integer | idhlc_hist.idhlc_sub_line | Charge Line |
| tcidhlc_tax_env | character | idhlc_hist.idhlc_tax_env | Tax Environment |
| tcidhlc_tax_usage | character | idhlc_hist.idhlc_tax_usage | Tax Usage |
| tlidhlc_taxable | logical | idhlc_hist.idhlc_taxable | Taxable |
| tcidhlc_taxc | character | idhlc_hist.idhlc_taxc | Tax Class |
| tcidhlc_trl | character | idhlc_hist.idhlc_trl | Trailer |
| tcidhlc_um | character | idhlc_hist.idhlc_um | UM |
| tcidhlc_userc01 | character | idhlc_hist.idhlc_userc01 | User Field Character 1 |
| tcidhlc_userc02 | character | idhlc_hist.idhlc_userc02 | User Field Character 2 |
| tdoid_idhlc_hist | decimal | idhlc_hist.oid_idhlc_hist | |
each idhlc_hist where