| field name | data type | description |
|---|---|---|
| ttShipDate | date | |
| tcSONbr | character | |
| tiSOLine | integer | |
| tcItemCode | character | |
| tcItemDescription1 | character | |
| tcItemDescription2 | character | |
| tdQty | decimal | |
| tcUM | character | |
| tdPrice | decimal | |
| tdSales | decimal | |
| tcShipTo | character | |
| tcRmks | character | |
| tdTax | decimal | |
| tcpt_desc2 | character | |
| tcpt_desc1 | character | |
| tltx2d_tax_in | logical | |
| titx2d_line | integer | |
| tdtx2d_totamt | decimal(10) | |
| tdtx2d_cur_tax_amt | decimal(10) | |
| tctx2d_tax_code | character | |
| tctx2d_ref | character | |
| tctx2d_nbr | character | |
| tctx2d_domain | character | |
| tltrl_taxable | logical | |
| tltrl_pst | logical | |
| tltrl_fst | logical | |
| tdoid_trl_mstr | decimal(10) | |
| tctrl_user2 | character | |
| tctrl_user1 | character | |
| tctrl_taxc | character | |
| tctrl_sub | character | |
| tctrl_project | character | |
| tctrl_domain | character | |
| tctrl_desc | character | |
| tctrl_code | character | |
| tctrl_cc | character | |
| tctrl_acct | character | |
| tctrl__qadc01 | character | |
| ttih_tax_date | date | |
| ttih_ship_date | date | |
| ttih_req_date | date | |
| ttih_pricing_dt | date | |
| ttih_priced_dt | date | |
| ttih_ord_date | date | |
| ttih_mod_date | date | |
| ttih_inv_date | date | |
| ttih_export_date | date | |
| ttih_due_date | date | |
| ttih_conf_date | date | |
| ttih_cncl_date | date | |
| ttih__qadt03 | date | |
| ttih__qadt02 | date | |
| ttih__qadt01 | date | |
| ttih__dte02 | date | |
| ttih__dte01 | date | |
| tlih_to_inv | logical | |
| tlih_taxable | logical | |
| tlih_ship_eng | logical | |
| tlih_secondary | logical | |
| tlih_sched | logical | |
| tlih_pst | logical | |
| tlih_print_so | logical | |
| tlih_print_pl | logical | |
| tlih_print_bl | logical | |
| tlih_primary | logical | |
| tlih_partial | logical | |
| tlih_invoiced | logical | |
| tlih_fix_rate | logical | |
| tlih_fix_pr | logical | |
| tlih_custref_val | logical | |
| tlih_credit | logical | |
| tlih__qadl03 | logical | |
| tlih__qadl02 | logical | |
| tlih__qadl01 | logical | |
| tlih__log01 | logical | |
| tiih_rev | integer | |
| tiih_exru_seq | integer | |
| tiih_export_time | integer | |
| tiih_export_batch | integer | |
| tiih_cmtindx | integer | |
| tiih_cartons | integer | |
| tiih__qadi03 | integer | |
| tiih__qadi02 | integer | |
| tiih__qadi01 | integer | |
| tiih__qad04 | integer | |
| tdoid_ih_hist | decimal(10) | |
| tdih_weight | decimal(10) | |
| tdih_trl3_amt | decimal(10) | |
| tdih_trl2_amt | decimal(10) | |
| tdih_trl1_amt | decimal(10) | |
| tdih_trl_amt | decimal(10) | |
| tdih_size | decimal(10) | |
| tdih_rstk_pct | decimal(10) | |
| tdih_pst_pct | decimal(10) | |
| tdih_prepaid | decimal(10) | |
| tdih_prep_tax | decimal(10) | |
| tdih_invoicetotal | decimal(10) | |
| tdih_fr_min_wt | decimal(10) | |
| tdih_ex_rate2 | decimal(10) | |
| tdih_ex_rate | decimal(10) | |
| tdih_ent_ex | decimal(10) | |
| tdih_disc_pct | decimal(10) | |
| tdih__qadd03 | decimal(10) | |
| tdih__qadd02 | decimal(10) | |
| tdih__qadd01 | decimal(10) | |
| tdih__qad03 | decimal(10) | |
| tdih__qad02 | decimal(10) | |
| tdih__qad01 | decimal(10) | |
| tdih__dec02 | decimal(10) | |
| tdih__dec01 | decimal(10) | |
| tcih_weight_um | character | |
| tcih_userid | character | |
| tcih_user2 | character | |
| tcih_user1 | character | |
| tcih_type | character | |
| tcih_trl3_cd | character | |
| tcih_trl2_cd | character | |
| tcih_trl1_cd | character | |
| tcih_taxc | character | |
| tcih_tax_usage | character | |
| tcih_tax_env | character | |
| tcih_stat | character | |
| tcih_source | character | |
| tcih_size_um | character | |
| tcih_site | character | |
| tcih_shipvia | character | |
| tcih_ship_po | character | |
| tcih_ship | character | |
| tcih_sch_mthd | character | |
| tcih_sa_nbr | character | |
| tcih_rmks | character | |
| tcih_quote | character | |
| tcih_pst_id | character | |
| tcih_project | character | |
| tcih_pr_list2 | character | |
| tcih_pr_list | character | |
| tcih_po | character | |
| tcih_nbr | character | |
| tcih_lang | character | |
| tcih_invoicetype | character | |
| tcih_inv_nbr | character | |
| tcih_inv_mthd | character | |
| tcih_inv_cr | character | |
| tcih_fst_id | character | |
| tcih_fsm_type | character | |
| tcih_fr_terms | character | |
| tcih_fr_list | character | |
| tcih_fob | character | |
| tcih_fcg_code | character | |
| tcih_ex_ratetype | character | |
| tcih_domain | character | |
| tcih_div | character | |
| tcih_daybookset | character | |
| tcih_daybook | character | |
| tcih_cust_po | character | |
| tcih_cust | character | |
| tcih_curr | character | |
| tcih_crprlist | character | |
| tcih_cr_terms | character | |
| tcih_cr_init | character | |
| tcih_cr_card | character | |
| tcih_conrep | character | |
| tcih_channel | character | |
| tcih_ca_nbr | character | |
| tcih_bol | character | |
| tcih_bill | character | |
| tcih_batch | character | |
| tcih_bank | character | |
| tcih_ar_sub | character | |
| tcih_ar_cc | character | |
| tcih_ar_acct | character | |
| tcih__qadc05 | character | |
| tcih__qadc04 | character | |
| tcih__qadc03 | character | |
| tcih__qadc02 | character | |
| tcih__qadc01 | character | |
| tcih__chr10 | character | |
| tcih__chr09 | character | |
| tcih__chr08 | character | |
| tcih__chr07 | character | |
| tcih__chr06 | character | |
| tcih__chr05 | character | |
| tcih__chr04 | character | |
| tcih__chr03 | character | |
| tcih__chr02 | character | |
| tcih__chr01 | character | |
| ttidh_warr_start | date | |
| ttidh_sob_rev | date | |
| ttidh_req_date | date | |
| ttidh_promise_date | date | |
| ttidh_pricing_dt | date | |
| ttidh_pickdate | date | |
| ttidh_per_date | date | |
| ttidh_mod_date | date | |
| ttidh_expire | date | |
| ttidh_exp_del | date | |
| ttidh_due_date | date | |
| ttidh__qadt05 | date | |
| ttidh__qadt04 | date | |
| ttidh__qadt03 | date | |
| ttidh__qadt02 | date | |
| ttidh__qadt01 | date | |
| ttidh__dte03 | date | |
| ttidh__dte02 | date | |
| ttidh__dte01 | date | |
| tlidh_upd_isb | logical | |
| tlidh_taxable | logical | |
| tlidh_tax_in | logical | |
| tlidh_sob_std | logical | |
| tlidh_sched_chgd | logical | |
| tlidh_sched | logical | |
| tlidh_sch_mrp | logical | |
| tlidh_pst | logical | |
| tlidh_partial | logical | |
| tlidh_override_lmt | logical | |
| tlidh_fst_list | logical | |
| tlidh_fix_pr | logical | |
| tlidh_consume | logical | |
| tlidh_car_load | logical | |
| tlidh_calc_isb | logical | |
| tlidh_bonus | logical | |
| tlidh_auto_ins | logical | |
| tlidh_abnormal | logical | |
| tlidh__qadl05 | logical | |
| tlidh__qadl04 | logical | |
| tlidh__qadl03 | logical | |
| tlidh__qadl02 | logical | |
| tlidh__qadl01 | logical | |
| tlidh__qad02 | logical | |
| tlidh__log01 | logical | |
| tiidh_sad_line | integer | |
| tiidh_rlse_nbr | integer | |
| tiidh_ref | integer | |
| tiidh_rbkt_weeks | integer | |
| tiidh_rbkt_mths | integer | |
| tiidh_rbkt_days | integer | |
| tiidh_raw_days | integer | |
| tiidh_pl_priority | integer | |
| tiidh_line | integer | |
| tiidh_isb_ref | integer | |
| tiidh_fab_days | integer | |
| tiidh_cmtindx | integer | |
| tiidh_ca_line | integer | |
| tiidh_btb_pod_line | integer | |
| tiidh__qadi04 | integer | |
| tiidh__qadi03 | integer | |
| tiidh__qadi02 | integer | |
| tiidh__qadi01 | integer | |
| tiidh__qad01 | integer | |
| tdoid_idh_hist | decimal(10) | |
| tdidh_um_conv | decimal(10) | |
| tdidh_translt_hrs | decimal(10) | |
| tdidh_trans_lt | decimal(10) | |
| tdidh_tax_max | decimal(10) | |
| tdidh_std_cost | decimal(10) | |
| tdidh_retro_price | decimal(10) | |
| tdidh_qty_ship | decimal(10) | |
| tdidh_qty_ret | decimal(10) | |
| tdidh_qty_qote | decimal(10) | |
| tdidh_qty_pick | decimal(10) | |
| tdidh_qty_per | decimal(10) | |
| tdidh_qty_pend | decimal(10) | |
| tdidh_qty_ord | decimal(10) | |
| tdidh_qty_item | decimal(10) | |
| tdidh_qty_inv | decimal(10) | |
| tdidh_qty_exch | decimal(10) | |
| tdidh_qty_cons | decimal(10) | |
| tdidh_qty_chg | decimal(10) | |
| tdidh_qty_all | decimal(10) | |
| tdidh_price | decimal(10) | |
| tdidh_ord_mult | decimal(0) | |
| tdidh_list_pr | decimal(10) | |
| tdidh_inv_cost | decimal(10) | |
| tdidh_fr_wt | decimal(10) | |
| tdidh_fr_rate | decimal(10) | |
| tdidh_fr_chg | decimal(10) | |
| tdidh_fixed_price | decimal(10) | |
| tdidh_disc_pct | decimal(10) | |
| tdidh_crt_int | decimal(10) | |
| tdidh_covered_amt | decimal(10) | |
| tdidh_bo_chg | decimal(10) | |
| tdidh_act_price | decimal(10) | |
| tdidh__qadd05 | decimal(10) | |
| tdidh__qadd04 | decimal(10) | |
| tdidh__qadd03 | decimal(10) | |
| tdidh__qadd02 | decimal(10) | |
| tdidh__qadd01 | decimal(10) | |
| tdidh__dec05 | decimal(10) | |
| tdidh__dec04 | decimal(10) | |
| tdidh__dec03 | decimal(10) | |
| tdidh__dec02 | decimal(10) | |
| tdidh__dec01 | decimal(10) | |
| tcidh_user2 | character | |
| tcidh_user1 | character | |
| tcidh_um | character | |
| tcidh_type | character | |
| tcidh_to_site | character | |
| tcidh_to_ref | character | |
| tcidh_to_loc | character | |
| tcidh_taxc | character | |
| tcidh_tax_usage | character | |
| tcidh_tax_env | character | |
| tcidh_sv_code | character | |
| tcidh_sub | character | |
| tcidh_status | character | |
| tcidh_site | character | |
| tcidh_shipvia | character | |
| tcidh_ship | character | |
| tcidh_serial | character | |
| tcidh_sch_data | character | |
| tcidh_sa_nbr | character | |
| tcidh_rma_type | character | |
| tcidh_project | character | |
| tcidh_prodline | character | |
| tcidh_prig2 | character | |
| tcidh_prig1 | character | |
| tcidh_pr_list | character | |
| tcidh_pkg_code | character | |
| tcidh_pastdue | character | |
| tcidh_part | character | |
| tcidh_owner | character | |
| tcidh_out_po | character | |
| tcidh_nbr | character | |
| tcidh_modelyr | character | |
| tcidh_mod_userid | character | |
| tcidh_lot | character | |
| tcidh_loc | character | |
| tcidh_ln_ref | character | |
| tcidh_isb_loc | character | |
| tcidh_inv_nbr | character | |
| tcidh_fsm_type | character | |
| tcidh_fr_wt_um | character | |
| tcidh_fr_list | character | |
| tcidh_fr_class | character | |
| tcidh_for_serial | character | |
| tcidh_for | character | |
| tcidh_fa_nbr | character | |
| tcidh_enduser | character | |
| tcidh_dsc_sub | character | |
| tcidh_dsc_project | character | |
| tcidh_dsc_cc | character | |
| tcidh_dsc_acct | character | |
| tcidh_drp_ref | character | |
| tcidh_domain | character | |
| tcidh_dock | character | |
| tcidh_div | character | |
| tcidh_desc | character | |
| tcidh_custref | character | |
| tcidh_custpart | character | |
| tcidh_contr_id | character | |
| tcidh_conrep | character | |
| tcidh_cfg_type | character | |
| tcidh_cc | character | |
| tcidh_ca_nbr | character | |
| tcidh_btb_vend | character | |
| tcidh_btb_type | character | |
| tcidh_btb_po | character | |
| tcidh_acct | character | |
| tcidh__qadc06 | character | |
| tcidh__qadc05 | character | |
| tcidh__qadc04 | character | |
| tcidh__qadc03 | character | |
| tcidh__qadc02 | character | |
| tcidh__qadc01 | character | |
| tcidh__chr10 | character | |
| tcidh__chr09 | character | |
| tcidh__chr08 | character | |
| tcidh__chr07 | character | |
| tcidh__chr06 | character | |
| tcidh__chr05 | character | |
| tcidh__chr04 | character | |
| tcidh__chr03 | character | |
| tcidh__chr02 | character | |
| tcidh__chr01 | character |
| field name | data type | description |
|---|---|---|
| tiBillReport_ID | integer | |
| tcPaymentType | character | |
| tdPaymentAmt | decimal | |
| ttPostingDate | date | |
| ttPaymentDate | date | |
| tcBillCurrency | character | |
| tiDDocument_ID | integer | |
| tcDDocumentReference | character | |
| tcPaymentTarget | character | |
| tcPaymentInstrument | character | |
| tcGLTransaction | character | |
| tcPostingTxt | character | |
| tiPosting_ID | integer | |
| tcPaySelCode | character | |
| tcPayFormatTypeCode | character | |
| tiBill_ID | integer | |
| tdBillClosingBalanceTC | decimal(4) | |
| ttBillConfirmDate | date | |
| ttBillDate | date | |
| tiBillNumber | integer | |
| tcBillStatus | character | |
| tiBillYear | integer | |
| tiCompany_ID | integer | |
| tiDInvoiceMovement_ID | integer |
| field name | data type | description |
|---|---|---|
| tiBillReport_ID | integer | |
| tiBill_ID | integer | |
| tiBillYear | integer | |
| tiBillNumber | integer | |
| tcBillCollector | character | |
| tiDInvoice_ID | integer | |
| tcDInvoiceReference | character | |
| ttBillDate | date | |
| tcDebtorAddress | character | |
| tcDebtorCodeInReport | character | |
| tcBankNumberSwiftCode | character | |
| tcBankName | character | |
| tdPaymentAmt | decimal | |
| tdSalesTax | decimal | |
| tdSalesTotalAmt | decimal | |
| tcBusinessRelationName | character | |
| tcBusinessRelationID | character | |
| tcBusinessRelationAddr2 | character | |
| tcBusinessRelationAddr1 | character | |
| tcDInvoiceBalanceCrDt | character | |
| tdDInvoiceBalance | decimal | |
| tcPaymentConditionCode | character | |
| tdDInvoiceVatExchangeRate | decimal | |
| tdDInvoiceOriginalBalance | decimal | |
| tcBankNumberBranch | character | |
| tcBankNumber | character | |
| tcBankAccountCode | character | |
| tcBankAccountType | character | |
| tcBillCurrency | character | |
| tcBillScheduleCode | character | |
| tcDInvoiceType | character | |
| tdDInvoiceVatBalance | decimal | |
| tdPreviousBalance | decimal | |
| ttBillClosingDate | date | |
| ttDInvoiceDate | date | |
| ttDueDate | date | |
| ttIssuedDate | date | Bill Issued Date |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| ti_Sequence | integer | Use this data item to add as a field in public temp-tables. |
| 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 | |
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tcContactInfo | character | |
| tcShipTo | character | |
| tcUM | character | |
| tcCompanyName | character | |
| tdPrice | decimal | |
| tcCompanyAddress | character | |
| tcItemCode | character | |
| tcBillStatus | character | |
| tcSONbr | character | |
| tiSOLine | integer | |
| ttShipDate | date | |
| tcRmks | character | |
| tdQty | decimal | |
| tcItemDescription1 | character | |
| tcItemDescription2 | character | |
| tlIsPreBillInitial | logical | |
| tlPrintItemDetail | logical | |
| tltx2d_tax_in | logical | |
| titx2d_line | integer | |
| tdtx2d_totamt | decimal(10) | |
| tdtx2d_cur_tax_amt | decimal(10) | |
| tctx2d_trl | character | |
| tctx2d_tax_code | character | |
| tctx2d_ref | character | |
| tctx2d_nbr | character | |
| tctx2d_domain | character | |
| tcpt_desc2 | character | |
| tcpt_desc1 | character | |
| tltrl_taxable | logical | |
| tltrl_pst | logical | |
| tltrl_fst | logical | |
| tdoid_trl_mstr | decimal(10) | |
| tctrl_user2 | character | |
| tctrl_user1 | character | |
| tctrl_taxc | character | |
| tctrl_sub | character | |
| tctrl_project | character | |
| tctrl_domain | character | |
| tctrl_desc | character | |
| tctrl_code | character | |
| tctrl_cc | character | |
| tctrl_acct | character | |
| tctrl__qadc01 | character | |
| ttih_tax_date | date | |
| ttih_ship_date | date | |
| ttih_req_date | date | |
| ttih_pricing_dt | date | |
| ttih_priced_dt | date | |
| ttih_ord_date | date | |
| ttih_mod_date | date | |
| ttih_inv_date | date | |
| ttih_export_date | date | |
| ttih_due_date | date | |
| ttih_conf_date | date | |
| ttih_cncl_date | date | |
| ttih__qadt03 | date | |
| ttih__qadt02 | date | |
| ttih__qadt01 | date | |
| ttih__dte02 | date | |
| ttih__dte01 | date | |
| tlih_to_inv | logical | |
| tlih_taxable | logical | |
| tlih_ship_eng | logical | |
| tlih_secondary | logical | |
| tlih_sched | logical | |
| tlih_pst | logical | |
| tlih_print_so | logical | |
| tlih_print_pl | logical | |
| tlih_print_bl | logical | |
| tlih_primary | logical | |
| tlih_partial | logical | |
| tlih_invoiced | logical | |
| tlih_fix_rate | logical | |
| tlih_fix_pr | logical | |
| tlih_custref_val | logical | |
| tlih_credit | logical | |
| tlih__qadl03 | logical | |
| tlih__qadl02 | logical | |
| tlih__qadl01 | logical | |
| tlih__log01 | logical | |
| tiih_rev | integer | |
| tiih_exru_seq | integer | |
| tiih_export_time | integer | |
| tiih_export_batch | integer | |
| tiih_cmtindx | integer | |
| tiih_cartons | integer | |
| tiih__qadi03 | integer | |
| tiih__qadi02 | integer | |
| tiih__qadi01 | integer | |
| tiih__qad04 | integer | |
| tdoid_ih_hist | decimal(10) | |
| tdih_weight | decimal(10) | |
| tdih_trl3_amt | decimal(10) | |
| tdih_trl2_amt | decimal(10) | |
| tdih_trl1_amt | decimal(10) | |
| tdih_trl_amt | decimal(10) | |
| tdih_size | decimal(10) | |
| tdih_rstk_pct | decimal(10) | |
| tdih_pst_pct | decimal(10) | |
| tdih_prepaid | decimal(10) | |
| tdih_prep_tax | decimal(10) | |
| tdih_invoicetotal | decimal(10) | |
| tdih_fr_min_wt | decimal(10) | |
| tdih_ex_rate2 | decimal(10) | |
| tdih_ex_rate | decimal(10) | |
| tdih_ent_ex | decimal(10) | |
| tdih_disc_pct | decimal(10) | |
| tdih__qadd03 | decimal(10) | |
| tdih__qadd02 | decimal(10) | |
| tdih__qadd01 | decimal(10) | |
| tdih__qad03 | decimal(10) | |
| tdih__qad02 | decimal(10) | |
| tdih__qad01 | decimal(10) | |
| tdih__dec02 | decimal(10) | |
| tdih__dec01 | decimal(10) | |
| tcih_weight_um | character | |
| tcih_userid | character | |
| tcih_user2 | character | |
| tcih_user1 | character | |
| tcih_type | character | |
| tcih_trl3_cd | character | |
| tcih_trl2_cd | character | |
| tcih_trl1_cd | character | |
| tcih_taxc | character | |
| tcih_tax_usage | character | |
| tcih_tax_env | character | |
| tcih_stat | character | |
| tcih_source | character | |
| tcih_size_um | character | |
| tcih_site | character | |
| tcih_shipvia | character | |
| tcih_ship_po | character | |
| tcih_ship | character | |
| tcih_sch_mthd | character | |
| tcih_sa_nbr | character | |
| tcih_rmks | character | |
| tcih_quote | character | |
| tcih_pst_id | character | |
| tcih_project | character | |
| tcih_pr_list2 | character | |
| tcih_pr_list | character | |
| tcih_po | character | |
| tcih_nbr | character | |
| tcih_lang | character | |
| tcih_invoicetype | character | |
| tcih_inv_nbr | character | |
| tcih_inv_mthd | character | |
| tcih_inv_cr | character | |
| tcih_fst_id | character | |
| tcih_fsm_type | character | |
| tcih_fr_terms | character | |
| tcih_fr_list | character | |
| tcih_fob | character | |
| tcih_fcg_code | character | |
| tcih_ex_ratetype | character | |
| tcih_domain | character | |
| tcih_div | character | |
| tcih_daybookset | character | |
| tcih_daybook | character | |
| tcih_cust_po | character | |
| tcih_cust | character | |
| tcih_curr | character | |
| tcih_crprlist | character | |
| tcih_cr_terms | character | |
| tcih_cr_init | character | |
| tcih_cr_card | character | |
| tcih_conrep | character | |
| tcih_channel | character | |
| tcih_ca_nbr | character | |
| tcih_bol | character | |
| tcih_bill | character | |
| tcih_batch | character | |
| tcih_bank | character | |
| tcih_ar_sub | character | |
| tcih_ar_cc | character | |
| tcih_ar_acct | character | |
| tcih__qadc05 | character | |
| tcih__qadc04 | character | |
| tcih__qadc03 | character | |
| tcih__qadc02 | character | |
| tcih__qadc01 | character | |
| tcih__chr10 | character | |
| tcih__chr09 | character | |
| tcih__chr08 | character | |
| tcih__chr07 | character | |
| tcih__chr06 | character | |
| tcih__chr05 | character | |
| tcih__chr04 | character | |
| tcih__chr03 | character | |
| tcih__chr02 | character | |
| tcih__chr01 | character | |
| ttidh_warr_start | date | |
| ttidh_sob_rev | date | |
| ttidh_req_date | date | |
| ttidh_promise_date | date | |
| ttidh_pricing_dt | date | |
| ttidh_pickdate | date | |
| ttidh_per_date | date | |
| ttidh_mod_date | date | |
| ttidh_expire | date | |
| ttidh_exp_del | date | |
| ttidh_due_date | date | |
| ttidh__qadt05 | date | |
| ttidh__qadt04 | date | |
| ttidh__qadt03 | date | |
| ttidh__qadt02 | date | |
| ttidh__qadt01 | date | |
| ttidh__dte03 | date | |
| ttidh__dte02 | date | |
| ttidh__dte01 | date | |
| tlidh_upd_isb | logical | |
| tlidh_taxable | logical | |
| tlidh_tax_in | logical | |
| tlidh_sob_std | logical | |
| tlidh_sched_chgd | logical | |
| tlidh_sched | logical | |
| tlidh_sch_mrp | logical | |
| tlidh_pst | logical | |
| tlidh_partial | logical | |
| tlidh_override_lmt | logical | |
| tlidh_fst_list | logical | |
| tlidh_fix_pr | logical | |
| tlidh_consume | logical | |
| tlidh_car_load | logical | |
| tlidh_calc_isb | logical | |
| tlidh_bonus | logical | |
| tlidh_auto_ins | logical | |
| tlidh_abnormal | logical | |
| tlidh__qadl05 | logical | |
| tlidh__qadl04 | logical | |
| tlidh__qadl03 | logical | |
| tlidh__qadl02 | logical | |
| tlidh__qadl01 | logical | |
| tlidh__qad02 | logical | |
| tlidh__log01 | logical | |
| tiidh_sad_line | integer | |
| tiidh_rlse_nbr | integer | |
| tiidh_ref | integer | |
| tiidh_rbkt_weeks | integer | |
| tiidh_rbkt_mths | integer | |
| tiidh_rbkt_days | integer | |
| tiidh_raw_days | integer | |
| tiidh_pl_priority | integer | |
| tiidh_line | integer | |
| tiidh_isb_ref | integer | |
| tiidh_fab_days | integer | |
| tiidh_cmtindx | integer | |
| tiidh_ca_line | integer | |
| tiidh_btb_pod_line | integer | |
| tiidh__qadi04 | integer | |
| tiidh__qadi03 | integer | |
| tiidh__qadi02 | integer | |
| tiidh__qadi01 | integer | |
| tiidh__qad01 | integer | |
| tdoid_idh_hist | decimal(10) | |
| tdidh_um_conv | decimal(10) | |
| tdidh_translt_hrs | decimal(10) | |
| tdidh_trans_lt | decimal(10) | |
| tdidh_tax_max | decimal(10) | |
| tdidh_std_cost | decimal(10) | |
| tdidh_retro_price | decimal(10) | |
| tdidh_qty_ship | decimal(10) | |
| tdidh_qty_ret | decimal(10) | |
| tdidh_qty_qote | decimal(10) | |
| tdidh_qty_pick | decimal(10) | |
| tdidh_qty_per | decimal(10) | |
| tdidh_qty_pend | decimal(10) | |
| tdidh_qty_ord | decimal(10) | |
| tdidh_qty_item | decimal(10) | |
| tdidh_qty_inv | decimal(10) | |
| tdidh_qty_exch | decimal(10) | |
| tdidh_qty_cons | decimal(10) | |
| tdidh_qty_chg | decimal(10) | |
| tdidh_qty_all | decimal(10) | |
| tdidh_price | decimal(10) | |
| tdidh_ord_mult | decimal(0) | |
| tdidh_list_pr | decimal(10) | |
| tdidh_inv_cost | decimal(10) | |
| tdidh_fr_wt | decimal(10) | |
| tdidh_fr_rate | decimal(10) | |
| tdidh_fr_chg | decimal(10) | |
| tdidh_fixed_price | decimal(10) | |
| tdidh_disc_pct | decimal(10) | |
| tdidh_crt_int | decimal(10) | |
| tdidh_covered_amt | decimal(10) | |
| tdidh_bo_chg | decimal(10) | |
| tdidh_act_price | decimal(10) | |
| tdidh__qadd05 | decimal(10) | |
| tdidh__qadd04 | decimal(10) | |
| tdidh__qadd03 | decimal(10) | |
| tdidh__qadd02 | decimal(10) | |
| tdidh__qadd01 | decimal(10) | |
| tdidh__dec05 | decimal(10) | |
| tdidh__dec04 | decimal(10) | |
| tdidh__dec03 | decimal(10) | |
| tdidh__dec02 | decimal(10) | |
| tdidh__dec01 | decimal(10) | |
| tcidh_user2 | character | |
| tcidh_user1 | character | |
| tcidh_um | character | |
| tcidh_type | character | |
| tcidh_to_site | character | |
| tcidh_to_ref | character | |
| tcidh_to_loc | character | |
| tcidh_taxc | character | |
| tcidh_tax_usage | character | |
| tcidh_tax_env | character | |
| tcidh_sv_code | character | |
| tcidh_sub | character | |
| tcidh_status | character | |
| tcidh_site | character | |
| tcidh_shipvia | character | |
| tcidh_ship | character | |
| tcidh_serial | character | |
| tcidh_sch_data | character | |
| tcidh_sa_nbr | character | |
| tcidh_rma_type | character | |
| tcidh_project | character | |
| tcidh_prodline | character | |
| tcidh_prig2 | character | |
| tcidh_prig1 | character | |
| tcidh_pr_list | character | |
| tcidh_pkg_code | character | |
| tcidh_pastdue | character | |
| tcidh_part | character | |
| tcidh_owner | character | |
| tcidh_out_po | character | |
| tcidh_nbr | character | |
| tcidh_modelyr | character | |
| tcidh_mod_userid | character | |
| tcidh_lot | character | |
| tcidh_loc | character | |
| tcidh_ln_ref | character | |
| tcidh_isb_loc | character | |
| tcidh_inv_nbr | character | |
| tcidh_fsm_type | character | |
| tcidh_fr_wt_um | character | |
| tcidh_fr_list | character | |
| tcidh_fr_class | character | |
| tcidh_for_serial | character | |
| tcidh_for | character | |
| tcidh_fa_nbr | character | |
| tcidh_enduser | character | |
| tcidh_dsc_sub | character | |
| tcidh_dsc_project | character | |
| tcidh_dsc_cc | character | |
| tcidh_dsc_acct | character | |
| tcidh_drp_ref | character | |
| tcidh_domain | character | |
| tcidh_dock | character | |
| tcidh_div | character | |
| tcidh_desc | character | |
| tcidh_custref | character | |
| tcidh_custpart | character | |
| tcidh_contr_id | character | |
| tcidh_conrep | character | |
| tcidh_cfg_type | character | |
| tcidh_cc | character | |
| tcidh_ca_nbr | character | |
| tcidh_btb_vend | character | |
| tcidh_btb_type | character | |
| tcidh_btb_po | character | |
| tcidh_acct | character | |
| tcidh__qadc06 | character | |
| tcidh__qadc05 | character | |
| tcidh__qadc04 | character | |
| tcidh__qadc03 | character | |
| tcidh__qadc02 | character | |
| tcidh__qadc01 | character | |
| tcidh__chr10 | character | |
| tcidh__chr09 | character | |
| tcidh__chr08 | character | |
| tcidh__chr07 | character | |
| tcidh__chr06 | character | |
| tcidh__chr05 | character | |
| tcidh__chr04 | character | |
| tcidh__chr03 | character | |
| tcidh__chr02 | character | |
| tcidh__chr01 | character |
| field name | data type | description |
|---|---|---|
| ti_Sequence | integer | Use this data item to add as a field in public temp-tables. |
| tcBusinessFieldLabel | character | |
| tcBusinessFieldName | character | BusinessFieldName |
| tcOperator | character | Operator |
| tcParameterValue | character | ParameterValue |
| field name | data type | description |
|---|---|---|
| tcCompanyCode | character | |
| tcCurrLC | character | |
| tcDateFormat | character | |
| tiDecCC | integer | |
| tcDecimalFormat | character | |
| tiDecLC | integer | |
| tcDecTC | character | |
| tiDocLayoutMode | integer | |
| tcExtraInfo | character | |
| tiFilterMode | integer | |
| tiPageBreakMode | integer | |
| tcReportTitle | character | |
| tiSummaryMode | integer | |
| tcUser | character | |
| tcDomainCode | character | |
| tcCompanyDescription | character | |
| tcUserLogin | character | Current User login ID |
| tlShadeAltLines | logical |
| field name | data type | description |
|---|---|---|
| tcCode | character | |
| tcText | character |
QadFinancials