project QadFinancials > class BBillReport > business logic query GetDebtorInfoForBill


Parameters


iiCompanyIdintegerCompany id
iiBill_IDinteger


query condition


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

      first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = Bill.Debtor_ID AND

          first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = Debtor.BusinessRelation_ID AND

              each Address (inner-join) where
Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

                  first Country (outer-join) where
Country.Country_ID = Address.Country_ID AND

                  first County (outer-join) where
County.County_ID = Address.County_ID AND

                  first State (outer-join) where
State.State_ID = Address.State_ID AND

          first PaymentCondition (inner-join) where
PaymentCondition.PaymentCondition_ID = Debtor.NormalPaymentCondition_ID AND


query resultset tqGetDebtorInfoForBill


field namedata typedb fielddescription
tcAddressCitycharacterAddress.AddressCityCity. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressEMailcharacterAddress.AddressEMailE-Mail. This field indicates the e-mail address associated with this business relation.
This field can be blank.
tcAddressFaxcharacterAddress.AddressFaxFax. This field indicates the fax or telex number to use when sending documents to this address.
This field can be balnk.
tcAddressNamecharacterAddress.AddressNameName. The full name of this particular address.
The name of a headoffice address is the same as the name of the business relationship and can not be modified.
api annotation:PartialUpdate = yes - defaults to the name of the businessRelation.
tcAddressStreet1characterAddress.AddressStreet1Address: Line one of address details.
This field can be blank.
tcAddressStreet2characterAddress.AddressStreet2Address.Line two of address details.
This field can be blank.
tcAddressStreet3characterAddress.AddressStreet3Address.Line three of address details.
This field can be blank.
tcAddressZipcharacterAddress.AddressZipZip. The postal code or US zip code associated with this address.
This field is used to decide the tax zone for the address.
This field can be blank.
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
tiBusinessRelation_IDintegerDebtor.BusinessRelation_IDBusiness Relation
tcBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness Relation. A code to identify the business relation.
If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcBusinessRelationName1characterBusinessRelation.BusinessRelationName1Name: The full name of the business relation.
This field sets the default name for linked addresses such as customers and suppliers.
api annotation:PartialUpdate = yes - defaults to the BusinessRelationCode.
tiCountry_IDintegerCountry.Country_IDRecord ID
tcCountryDescriptioncharacterCountry.CountryDescriptionDescription
tiCounty_IDintegerCounty.County_IDRecord ID
tcCountyDescriptioncharacterCounty.CountyDescriptionDescription
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_IDintegerDebtor.Debtor_IDRecord ID
tiDInvoiceMovement_IDintegerBill.DInvoiceMovement_IDLink to highest DInvoiceMovement
tcPaymentConditionCodecharacterPaymentCondition.PaymentConditionCodeCredit Terms Code
tiState_IDintegerState.State_IDRecord ID
tcStateDescriptioncharacterState.StateDescriptionDescription


Internal usage


QadFinancials
method BBillReport.GetBillReportTitleInfo