project QadFinancials > class BBill > business logic query BillById


Parameters


iiCompanyIdintegerCompany id
iiBill_IDinteger


query condition


  each Bill where
Bill.Company_Id = iiCompanyId AND
Bill.Bill_ID = iiBill_ID


query resultset tqBillById


field namedata typedb fielddescription
tiBill_IDintegerBill.Bill_IDRecord ID
tdBillClosingBalanceTCdecimalBill.BillClosingBalanceTCTC Closing Balance
ttBillConfirmDatedateBill.BillConfirmDateBill Confirm Date
ttBillDatedateBill.BillDateBill Date
ttBillDueDatedateBill.BillDueDateBill Due Date
tiBillNumberintegerBill.BillNumberBill Number
tcBillStatuscharacterBill.BillStatusStatus
tiBillYearintegerBill.BillYearBill Year
tiCompany_IDintegerBill.Company_IDLink to Company
tiCurrency_IDintegerBill.Currency_IDLink to Currency
tcCustomCombo0characterBill.CustomCombo0Custom Combo Field
tcCustomCombo1characterBill.CustomCombo1Custom Combo Field
tcCustomCombo2characterBill.CustomCombo2Custom Combo Field
tcCustomCombo3characterBill.CustomCombo3Custom Combo Field
tcCustomCombo4characterBill.CustomCombo4Custom Combo Field
tcCustomCombo5characterBill.CustomCombo5Custom Combo Field
tcCustomCombo6characterBill.CustomCombo6Custom Combo Field
tcCustomCombo7characterBill.CustomCombo7Custom Combo Field
tcCustomCombo8characterBill.CustomCombo8Custom Combo Field
tcCustomCombo9characterBill.CustomCombo9Custom Combo Field
ttCustomDate0dateBill.CustomDate0Custom Date Field
ttCustomDate1dateBill.CustomDate1Custom Date Field
ttCustomDate2dateBill.CustomDate2Custom Date Field
ttCustomDate3dateBill.CustomDate3Custom Date Field
ttCustomDate4dateBill.CustomDate4Custom Date Field
tdCustomDecimal0decimalBill.CustomDecimal0Custom Decimal Field
tdCustomDecimal1decimalBill.CustomDecimal1Custom Decimal Field
tdCustomDecimal2decimalBill.CustomDecimal2Custom Decimal Field
tdCustomDecimal3decimalBill.CustomDecimal3Custom Decimal Field
tdCustomDecimal4decimalBill.CustomDecimal4Custom Decimal Field
tiCustomInteger0integerBill.CustomInteger0Custom Integer Field
tiCustomInteger1integerBill.CustomInteger1Custom Integer Field
tiCustomInteger2integerBill.CustomInteger2Custom Integer Field
tiCustomInteger3integerBill.CustomInteger3Custom Integer Field
tiCustomInteger4integerBill.CustomInteger4Custom Integer Field
tcCustomLong0characterBill.CustomLong0Custom Long Field
tcCustomLong1characterBill.CustomLong1Custom Long Field
tcCustomNotecharacterBill.CustomNoteCustom Note Field
tcCustomShort0characterBill.CustomShort0Custom Short Field
tcCustomShort1characterBill.CustomShort1Custom Short Field
tcCustomShort2characterBill.CustomShort2Custom Short Field
tcCustomShort3characterBill.CustomShort3Custom Short Field
tcCustomShort4characterBill.CustomShort4Custom Short Field
tcCustomShort5characterBill.CustomShort5Custom Short Field
tcCustomShort6characterBill.CustomShort6Custom Short Field
tcCustomShort7characterBill.CustomShort7Custom Short Field
tcCustomShort8characterBill.CustomShort8Custom Short Field
tcCustomShort9characterBill.CustomShort9Custom Short Field
tiDebtor_IDintegerBill.Debtor_IDLink to Debtor
tiDInvoiceMovement_IDintegerBill.DInvoiceMovement_IDLink to highest DInvoiceMovement
tiEmployee_IDintegerBill.Employee_IDLink to Employee
ttLastModifiedDatedateBill.LastModifiedDateLast Modified Date
tiLastModifiedTimeintegerBill.LastModifiedTimeLast Modified Time
tcLastModifiedUsercharacterBill.LastModifiedUserLast Modified User
tcQADC01characterBill.QADC01unused QAD reserved field
tcQADC02characterBill.QADC02unused QAD reserved field
tdQADD01decimalBill.QADD01unused QAD reserved field
ttQADT01dateBill.QADT01unused QAD reserved field


Internal usage


QadFinancials
method BDInvoice.AdditionalUpdatesAllBill
method BDInvoice.ValidateComponentAllBill