project QadFinancials > class BBankEntry > dataset tPossibleBankStateAlloc


copy of class table tBankStateAlloc

table tPossibleBankStateAlloc

Description

PossibleBankStateAlloc; temp-table containing the possible BankStateAlloc records for the allocations

field namedata typedescription
tiBillYearBEinteger
tiBillNumberBEinteger
BankStateAlloc_IDinteger
Currency_IDinteger
Company_IDinteger
BankStateLine_IDinteger
CInvoice_IDinteger
CCollection_IDinteger
DInvoice_IDinteger
DCollection_IDinteger
Posting_IDinteger
BankState_IDinteger
BankStateAllocTypecharacter
BankStateAllocAmountTCdecimal(4)
BankStateAllocAmountLCdecimal(4)
BankStateAllocPaidAmtTCdecimal(4)
BankStateAllocDiscountTCdecimal(4)
BankStateAllocBankAmountTCdecimal(4)
BankStateAllocBankAmountLCdecimal(4)
BankStateAllocBankRatedecimal(10)
BankStateAllocBankRteScaledecimal(10)
BankStateAllocCCRatedecimal(10)
BankStateAllocCCScaledecimal(10)
BankStateAllocDifferenceLCdecimal(4)
BankStateAllocDifferenceCCdecimal(4)
BankStateAllocBankValDatedate
BankStateAllocBankDiscTCdecimal(4)
BankStateAllocBankDiscLCdecimal(4)
BankStateAllocDifferenceTCdecimal(4)
BankStateAllocOpenBalTCdecimal(4)
BankStateAllocBankImpRefcharacter
BankStateAllocWHTAmtTCdecimal(4)
BankStateAllocWHTAmtLCdecimal(4)
BankStateAllocWHTAmtCCdecimal(4)
BankStateAllocWHTTxFeeTCdecimal(4)
BankStateAllocWHTPercdecimal(2)
BankStateAllocWHTLCRatedecimal(10)
BankStateAllocWHTLCScaledecimal(10)
BankStateAllocWHTCCRatedecimal(10)
BankStateAllocWHTCCScaledecimal(10)
tcDocNumberReferencecharacter
tcDocBusinessRelationCodecharacter
ttDocDueDatedate
ttDocInvDatedate
ttDocDiscountDueDatedate
tdDocBalancedecimal(4)
tcDocCurrencyCodecharacter
tcCollReferencecharacter
ttCollRequestedDatedate
tdCollBalancedecimal(4)
tlUIFullAllocationlogicalUIFullAllocation; field added just to support easy UI-development
tcDocBalanceCrDtcharacterSign of Balance nl Credit or Debit
tcAllocAmountCrDtcharacterSign of Alloc Amount nl Debit or Credit
tdNewBalanceTCdecimal(4)New Balance Amount in TC
tcNewBalanceCrDtcharacterSign of new balance nl debit or credit
tdDocExchangeRatedecimal(10)Document Exchange Rate
tiCollNumberintegerCollection number
tcCollBalanceCrDtcharacterSign of new balance nl debit or credit
tcLocalCurrencyCodecharacterLocal currency code
tcCurrDifferenceCrDtcharactersign of currency details : credit or debit
tcCurrencyCodecharacter
tcDocCredDebEmplCodecharacter
tiDocCredDebEmplIdinteger
tcCurrencyDifferenceGLCodecharacterGL Code for the Currency Differences
tiBankStateAllocSequenceintegerSequence
tcCompanyCodecharacterCompanyCode: functionaly speaking, this is a RKBF for field tBankStateAlloc.Company_ID.
It was no use defining this using the std RKBF functionality because the company_ID does not get set for other companies because the current CompanyID is passed as input parameter to the query.
Solution: write manualy the reuiqred code in method Calculate() and ValidateComponent() to convert the CompanyCode into the CompanyID and vice-versa.
tdDiscountPercentagedecimal(3)Discount Percentage : keep it in calculated field so ui can used that when they allocate
tdDocExchangeRateScaledecimal(10)RateScal for the document
tdDefaultPaymentAmountTCdecimal(4)Default payment amount TC : invoice(document) amount - discount
tdDefaultDiscountAmountTCdecimal(4)Default discount amount tc (calculated on net amount)
tcDocDescriptioncharacterDescription
tcDocDivisionCodecharacter
tcDocProjectCodecharacter
tcDocCostCentreCodecharacter
tdDocVatdecimal(4)
tcDocVatCrDtcharacter
tdDocVatBasedecimal(4)
tcDocVatBaseCrDtcharacter
tiDocPostingIDinteger
tcVatCountryCodecharacter
tlDiscountTaxAtPaymentlogical
tcShipperCodecharacter
tcCollSelectionCodecharacter
tdRunningAllocBalanceTCdecimal(4)
tcDInvoiceDITextcharacterLegacy Invoice Number
tdBankStateAllocPaidTCdecimal(4)
tdDocCCExchangeRatedecimal(10)
tdDocCCExchangeRateScaledecimal(10)
tdDocOriginaldecimal(4)
tcCCCurrDifferenceCrDtcharacterSign of statutory currency differences
tcCCCurrencyDifferenceGLCodecharacter
tdBankStateAllocBankAmountCCdecimal(4)
tdBankStateAllocBankDiscCCdecimal(4)
tdBankStateAllocAmountTCSigndecimal(4)
tdBankStateAllocOpenBalTCSigndecimal(4)
tdNonDiscAmtTCdecimal(4)Non Disc Amt
tcReasonCodecharacter
tcDInvoiceDeductionCodecharacter
tcDInvoiceDeductionStatuscharacter
tcDInvoiceDeductionParentRowIDcharacter
tdDInvoiceDeductionTCdecimal(4)
tlCreditorIsWHTlogicalIs the supplier of the supplier invoice defined with withholding tax or not
tlUpdateTaxlogicalUpdate Tax : if all withholding tax lines of the invoice, has update tax allowed on true, then it will be true here and you can change the WHT Amount, otherwise not
tdCInvoiceWHTUnpaidAmtTCdecimal(4)The remaining unpaid amount of the withholding tax on the invoice
tdCInvoiceTotWHTBaseTCdecimal(4)total withholding tax base amount in TC for all the lines you selected, used on UI
tdCInvoiceTotWHTTCdecimal(4)withholding tax amount of the invoice
tdWHTBalanceTCdecimal(4)Open Withholding tax amount defined on the supplier invoice
tdBankStateAllocBankWhtAmtTCdecimal(4)Bank WHT Amount TC
tdInitiallyAllocatedWHTAmntTCdecimal(4)Withholding tax amount in TC that is allocated but not yet paid in withholding tax
tcDInoviceDeductionCusReferencecharacterDeduction Customer reference.
ttDocPostingDatedate
tcBillStatuscharacter
tcDocTSMNumbercharacter
tiBillYearinteger
tiBillNumberinteger
tcInvoiceDescriptioncharacter
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BBankEntry.CreateDeduction
method BBankEntry.CreatePrepayment
method BBankEntry.GetPossibleAllocations
method BBankEntry.GetPossibleAllocationsCInvoice
method BBankEntry.GetPossibleAllocationsDInvoice
method BBankEntry.GetPossibleCollAllocations
method BBankEntry.GetPossibleCollAllocationsCreditor
method BBankEntry.GetPossibleCollAllocationsDebtor

QadFitnesse
method BBankEntry.ApiGetPossibleAllocations