project QadFinancials > class BMFGInvoiceHistory > business logic query InvoiceHistoryByInvNbr


Parameters


icInvoiceNumbercharacter
icDomainCodecharacter


query condition


  each ih_hist where
ih_hist.ih_inv_nbr = icInvoiceNumber AND
ih_hist.ih_domain = icDomainCode


query resultset tqInvoiceHistoryByInvNbr


field namedata typedb fielddescription
tcih__chr01characterih_hist.ih__chr01
tcih__chr02characterih_hist.ih__chr02
tcih__chr03characterih_hist.ih__chr03
tcih__chr04characterih_hist.ih__chr04
tcih__chr05characterih_hist.ih__chr05
tcih__chr06characterih_hist.ih__chr06
tcih__chr07characterih_hist.ih__chr07
tcih__chr08characterih_hist.ih__chr08
tcih__chr09characterih_hist.ih__chr09
tcih__chr10characterih_hist.ih__chr10
tdih__dec01decimalih_hist.ih__dec01
tdih__dec02decimalih_hist.ih__dec02
ttih__dte01dateih_hist.ih__dte01
ttih__dte02dateih_hist.ih__dte02
tlih__log01logicalih_hist.ih__log01
tdih__qad01decimalih_hist.ih__qad01
tdih__qad02decimalih_hist.ih__qad02
tdih__qad03decimalih_hist.ih__qad03
tiih__qad04integerih_hist.ih__qad04
tcih__qadc01characterih_hist.ih__qadc01QAD Field
tcih__qadc02characterih_hist.ih__qadc02QAD Field
tcih__qadc03characterih_hist.ih__qadc03QAD Field
tcih__qadc04characterih_hist.ih__qadc04QAD Field
tcih__qadc05characterih_hist.ih__qadc05QAD Field
tdih__qadd01decimalih_hist.ih__qadd01QAD Field
tdih__qadd02decimalih_hist.ih__qadd02QAD Field
tdih__qadd03decimalih_hist.ih__qadd03QAD Field
tiih__qadi01integerih_hist.ih__qadi01QAD Field
tiih__qadi02integerih_hist.ih__qadi02QAD Field
tiih__qadi03integerih_hist.ih__qadi03QAD Field
tlih__qadl01logicalih_hist.ih__qadl01QAD Field
tlih__qadl02logicalih_hist.ih__qadl02QAD Field
tlih__qadl03logicalih_hist.ih__qadl03QAD Field
ttih__qadt01dateih_hist.ih__qadt01QAD Field
ttih__qadt02dateih_hist.ih__qadt02QAD Field
ttih__qadt03dateih_hist.ih__qadt03QAD Field
tcih_ar_acctcharacterih_hist.ih_ar_acctAR Account
tcih_ar_cccharacterih_hist.ih_ar_ccCost Ctr
tcih_ar_subcharacterih_hist.ih_ar_subAR Sub-Account
tcih_bankcharacterih_hist.ih_bankBank
tcih_batchcharacterih_hist.ih_batchBatch
tcih_billcharacterih_hist.ih_billBill-To
tcih_bolcharacterih_hist.ih_bolBOL
tcih_ca_nbrcharacterih_hist.ih_ca_nbrCall
tiih_cartonsintegerih_hist.ih_cartonsCartons
tcih_channelcharacterih_hist.ih_channelChannel
tiih_cmtindxintegerih_hist.ih_cmtindxComment Index
ttih_cncl_datedateih_hist.ih_cncl_dateCancel Date
ttih_conf_datedateih_hist.ih_conf_dateConfirmed Date
tcih_conrepcharacterih_hist.ih_conrepNetting Logic
tcih_cr_cardcharacterih_hist.ih_cr_cardCredit Card
tcih_cr_initcharacterih_hist.ih_cr_initCr Initials
tcih_cr_termscharacterih_hist.ih_cr_termsCredit Terms
tlih_creditlogicalih_hist.ih_creditCredit
tcih_crprlistcharacterih_hist.ih_crprlistCredit Price List
tcih_currcharacterih_hist.ih_currCurrency
tcih_custcharacterih_hist.ih_custCustomer
tcih_cust_pocharacterih_hist.ih_cust_poEnd Customer PO
tlih_custref_vallogicalih_hist.ih_custref_valCustomer Ref Is Customer Item
tcih_daybookcharacterih_hist.ih_daybookDaybook
tcih_daybooksetcharacterih_hist.ih_daybooksetDaybook Set
tdih_disc_pctdecimalih_hist.ih_disc_pctDisc %
tcih_divcharacterih_hist.ih_divDivision
tcih_domaincharacterih_hist.ih_domainDomain
ttih_due_datedateih_hist.ih_due_dateDue Date
tdih_ent_exdecimalih_hist.ih_ent_exExch Rate
tdih_ex_ratedecimalih_hist.ih_ex_rateExch Rate
tdih_ex_rate2decimalih_hist.ih_ex_rate2Exch Rate 2
tcih_ex_ratetypecharacterih_hist.ih_ex_ratetypeRate Type
tiih_export_batchintegerih_hist.ih_export_batchBatch
ttih_export_datedateih_hist.ih_export_dateExport Date
tiih_export_timeintegerih_hist.ih_export_timeExport Time
tiih_exru_seqintegerih_hist.ih_exru_seqSequence
tcih_fcg_codecharacterih_hist.ih_fcg_codeCharge Code
tlih_fix_prlogicalih_hist.ih_fix_prFixed Price
tlih_fix_ratelogicalih_hist.ih_fix_rateFixed Rate
tcih_fobcharacterih_hist.ih_fobFOB Point
tcih_fr_listcharacterih_hist.ih_fr_listFreight List
tdih_fr_min_wtdecimalih_hist.ih_fr_min_wtFrt Min Wt
tcih_fr_termscharacterih_hist.ih_fr_termsFreight Terms
tcih_fsm_typecharacterih_hist.ih_fsm_typeFSM Type
tcih_fst_idcharacterih_hist.ih_fst_idFST ID
tcih_inv_crcharacterih_hist.ih_inv_crInvoice To Credit
ttih_inv_datedateih_hist.ih_inv_dateInvoice Date
tcih_inv_mthdcharacterih_hist.ih_inv_mthdInvoices Via
tcih_inv_nbrcharacterih_hist.ih_inv_nbrInvoice
tlih_invoicedlogicalih_hist.ih_invoicedInvoiced
tdih_invoicetotaldecimalih_hist.ih_invoicetotalTotal
tcih_invoicetypecharacterih_hist.ih_invoicetypeInvoice Type
tcih_langcharacterih_hist.ih_langLanguage
ttih_mod_datedateih_hist.ih_mod_dateModified Date
tcih_nbrcharacterih_hist.ih_nbrSales Order
ttih_ord_datedateih_hist.ih_ord_dateOrder Date
tlih_partiallogicalih_hist.ih_partialPartial OK
tcih_pocharacterih_hist.ih_poPurchase Order
tcih_pr_listcharacterih_hist.ih_pr_listPrice List
tcih_pr_list2characterih_hist.ih_pr_list2List Price List
tdih_prep_taxdecimalih_hist.ih_prep_taxPrepaid Tax
tdih_prepaiddecimalih_hist.ih_prepaidPrepaid Amount
ttih_priced_dtdateih_hist.ih_priced_dtLast Price Dt
ttih_pricing_dtdateih_hist.ih_pricing_dtPricing Date
tlih_primarylogicalih_hist.ih_primaryPrimary SO
tlih_print_bllogicalih_hist.ih_print_blPrint Bill of Lading
tlih_print_pllogicalih_hist.ih_print_plPrint Pack List
tlih_print_sologicalih_hist.ih_print_soPrint Sales Order
tcih_projectcharacterih_hist.ih_projectProject
tlih_pstlogicalih_hist.ih_pstPST
tcih_pst_idcharacterih_hist.ih_pst_idPST ID
tdih_pst_pctdecimalih_hist.ih_pst_pctPST Pct
tcih_quotecharacterih_hist.ih_quoteQuote
ttih_req_datedateih_hist.ih_req_dateRequired Date
tiih_revintegerih_hist.ih_revRevision
tcih_rmkscharacterih_hist.ih_rmksRemarks
tdih_rstk_pctdecimalih_hist.ih_rstk_pctRestocking Charge
tcih_sa_nbrcharacterih_hist.ih_sa_nbrContract
tcih_sch_mthdcharacterih_hist.ih_sch_mthdSchedules Via
tlih_schedlogicalih_hist.ih_schedScheduled
tlih_secondarylogicalih_hist.ih_secondarySecondary EMT Order
tcih_shipcharacterih_hist.ih_shipShip-To
ttih_ship_datedateih_hist.ih_ship_dateShip Date
tlih_ship_englogicalih_hist.ih_ship_engShip-To Engineer
tcih_ship_pocharacterih_hist.ih_ship_poShip To PO
tcih_shipviacharacterih_hist.ih_shipviaShip Via
tcih_sitecharacterih_hist.ih_siteSite
tdih_sizedecimalih_hist.ih_sizeSize
tcih_size_umcharacterih_hist.ih_size_umSize UM
tcih_sourcecharacterih_hist.ih_sourceOrder Source
tcih_statcharacterih_hist.ih_statAction Status
ttih_tax_datedateih_hist.ih_tax_dateTax Date
tcih_tax_envcharacterih_hist.ih_tax_envTax Environment
tcih_tax_usagecharacterih_hist.ih_tax_usageTax Usage
tlih_taxablelogicalih_hist.ih_taxableTaxable
tcih_taxccharacterih_hist.ih_taxcTax Class
tlih_to_invlogicalih_hist.ih_to_invReady to Invoice
tdih_trl_amtdecimalih_hist.ih_trl_amtRounding Trailer Amount
tdih_trl1_amtdecimalih_hist.ih_trl1_amtTrailer Amt 1
tcih_trl1_cdcharacterih_hist.ih_trl1_cdTrailer 1
tdih_trl2_amtdecimalih_hist.ih_trl2_amtTrailer Amt 2
tcih_trl2_cdcharacterih_hist.ih_trl2_cdTrailer 2
tdih_trl3_amtdecimalih_hist.ih_trl3_amtTrailer Amt 3
tcih_trl3_cdcharacterih_hist.ih_trl3_cdTrailer 3
tcih_typecharacterih_hist.ih_typeType
tcih_user1characterih_hist.ih_user1Ufld1
tcih_user2characterih_hist.ih_user2Ufld2
tcih_useridcharacterih_hist.ih_useridUser ID
tdih_weightdecimalih_hist.ih_weightWeight
tcih_weight_umcharacterih_hist.ih_weight_umWeight UM
tdoid_ih_histdecimalih_hist.oid_ih_hist


Internal usage


QadFinancials
method BBillReport.GetDInvoiceDetailInfo
method BMFGLegalDocument.getHistInvoiceComponentsByNRM