project QadFinancials > class BDPaymentSelection > business logic query DPaySelLineByID

Parameters


iiCompanyIdintegerCompany id
iiPaySelIDinteger

query condition


  each DPaySel where
DPaySel.Company_Id = iiCompanyId AND
DPaySel.DPaySel_ID = iiPaySelID

      first BankPayFormat (inner-join) where
BankPayFormat.BankPayFormat_ID = DPaySel.BankPayFormat_ID AND

          first PayFormatType (inner-join) where
PayFormatType.PayFormatTypeCode = BankPayFormat.PayFormatTypeCode AND

      each DPaySelLine (inner-join) where
DPaySelLine.DPaySel_ID = DPaySel.DPaySel_ID AND

      first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = DPaySel.GL_ID AND

query resultset tqDPaySelLineByID


field namedata typedb fielddescription
tiBankCurrency_IDintegerGL.Currency_IDCurrency Code
tiBankNumber_IDintegerDPaySelLine.BankNumber_IDLink to Bank Number
tiBankPayFormat_IDintegerDPaySel.BankPayFormat_IDLink to BankPayFormat
tiCompany_IDintegerDPaySel.Company_IDLink to Company
tiDPaySel_IDintegerDPaySel.DPaySel_IDRecord ID
tcDPaySelCodecharacterDPaySel.DPaySelCodePayment Selection
ttDPaySelDatedateDPaySel.DPaySelDateDate
tiDPaySelLine_IDintegerDPaySelLine.DPaySelLine_IDRecord ID
tdDPaySelLineAmountTCdecimalDPaySelLine.DPaySelLineAmountTCTC Amount
tdDPaySelLineDiscountTCdecimalDPaySelLine.DPaySelLineDiscountTCTC Discount
tdDPaySelLineIntAmtTCdecimalDPaySelLine.DPaySelLineIntAmtTCTC Interest Amount
tdDPaySelLineIntRatedecimalDPaySelLine.DPaySelLineIntRateInterest Rate
tlDPaySelLineIsRefInFilelogicalDPaySelLine.DPaySelLineIsRefInFileIs contained in export file
tcDPaySelLineObjectTypecharacterDPaySelLine.DPaySelLineObjectTypeObject Type
tiDPaySelLineParentObject_IDintegerDPaySelLine.DPaySelLineParentObject_IDReference ID of the caller
tcDPaySelLineStatuscharacterDPaySelLine.DPaySelLineStatusStatus
tdDPaySelLineWHTAmtCCdecimalDPaySelLine.DPaySelLineWHTAmtCCSC WHT Amount
tdDPaySelLineWHTAmtLCdecimalDPaySelLine.DPaySelLineWHTAmtLCBC WHT Amount
tdDPaySelLineWHTAmtTCdecimalDPaySelLine.DPaySelLineWHTAmtTCTC WHT Amount
tcDPaySelPayFormatTypeCodecharacterDPaySelLine.DPaySelPayFormatTypeCodePayment format of the payment selection
tcDPaySelStatuscharacterDPaySel.DPaySelStatusStatus
tiGL_IDintegerDPaySel.GL_IDLink to GL
tcGLCodecharacterGL.GLCodeA code identifying the GL account.
tlGLIsLocalCurrencylogicalGL.GLIsLocalCurrencySet to true If postings are performed in the base currency only.
api annotation:When this field's value is true, the tcCurrencyCode field should be blank.
tcPayFormatTypePayInstrumentcharacterPayFormatType.PayFormatTypePayInstrumentPayment Instrument

Internal usage


QadFinancials
method BDCollection.RetrievePaySelInitial