| field name | data type | description |
|---|---|---|
| tiBillYearBE | integer | |
| tiBillNumberBE | integer | |
| BankStateAlloc_ID | integer | |
| Currency_ID | integer | |
| Company_ID | integer | |
| BankStateLine_ID | integer | |
| CInvoice_ID | integer | |
| CCollection_ID | integer | |
| DInvoice_ID | integer | |
| DCollection_ID | integer | |
| Posting_ID | integer | |
| BankState_ID | integer | |
| BankStateAllocType | character | |
| BankStateAllocAmountTC | decimal(4) | |
| BankStateAllocAmountLC | decimal(4) | |
| BankStateAllocPaidAmtTC | decimal(4) | |
| BankStateAllocDiscountTC | decimal(4) | |
| BankStateAllocBankAmountTC | decimal(4) | |
| BankStateAllocBankAmountLC | decimal(4) | |
| BankStateAllocBankRate | decimal(10) | |
| BankStateAllocBankRteScale | decimal(10) | |
| BankStateAllocCCRate | decimal(10) | |
| BankStateAllocCCScale | decimal(10) | |
| BankStateAllocDifferenceLC | decimal(4) | |
| BankStateAllocDifferenceCC | decimal(4) | |
| BankStateAllocBankValDate | date | |
| BankStateAllocBankDiscTC | decimal(4) | |
| BankStateAllocBankDiscLC | decimal(4) | |
| BankStateAllocDifferenceTC | decimal(4) | |
| BankStateAllocOpenBalTC | decimal(4) | |
| BankStateAllocBankImpRef | character | |
| BankStateAllocWHTAmtTC | decimal(4) | |
| BankStateAllocWHTAmtLC | decimal(4) | |
| BankStateAllocWHTAmtCC | decimal(4) | |
| BankStateAllocWHTTxFeeTC | decimal(4) | |
| BankStateAllocWHTPerc | decimal(2) | |
| BankStateAllocWHTLCRate | decimal(10) | |
| BankStateAllocWHTLCScale | decimal(10) | |
| BankStateAllocWHTCCRate | decimal(10) | |
| BankStateAllocWHTCCScale | decimal(10) | |
| tcDocNumberReference | character | |
| tcDocBusinessRelationCode | character | |
| ttDocDueDate | date | |
| ttDocInvDate | date | |
| ttDocDiscountDueDate | date | |
| tdDocBalance | decimal(4) | |
| tcDocCurrencyCode | character | |
| tcCollReference | character | |
| ttCollRequestedDate | date | |
| tdCollBalance | decimal(4) | |
| tlUIFullAllocation | logical | UIFullAllocation; field added just to support easy UI-development |
| tcDocBalanceCrDt | character | Sign of Balance nl Credit or Debit |
| tcAllocAmountCrDt | character | Sign of Alloc Amount nl Debit or Credit |
| tdNewBalanceTC | decimal(4) | New Balance Amount in TC |
| tcNewBalanceCrDt | character | Sign of new balance nl debit or credit |
| tdDocExchangeRate | decimal(10) | Document Exchange Rate |
| tiCollNumber | integer | Collection number |
| tcCollBalanceCrDt | character | Sign of new balance nl debit or credit |
| tcLocalCurrencyCode | character | Local currency code |
| tcCurrDifferenceCrDt | character | sign of currency details : credit or debit |
| tcCurrencyCode | character | |
| tcDocCredDebEmplCode | character | |
| tiDocCredDebEmplId | integer | |
| tcCurrencyDifferenceGLCode | character | GL Code for the Currency Differences |
| tiBankStateAllocSequence | integer | Sequence |
| tcCompanyCode | character | CompanyCode: 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. |
| tdDiscountPercentage | decimal(3) | Discount Percentage : keep it in calculated field so ui can used that when they allocate |
| tdDocExchangeRateScale | decimal(10) | RateScal for the document |
| tdDefaultPaymentAmountTC | decimal(4) | Default payment amount TC : invoice(document) amount - discount |
| tdDefaultDiscountAmountTC | decimal(4) | Default discount amount tc (calculated on net amount) |
| tcDocDescription | character | Description |
| tcDocDivisionCode | character | |
| tcDocProjectCode | character | |
| tcDocCostCentreCode | character | |
| tdDocVat | decimal(4) | |
| tcDocVatCrDt | character | |
| tdDocVatBase | decimal(4) | |
| tcDocVatBaseCrDt | character | |
| tiDocPostingID | integer | |
| tcVatCountryCode | character | |
| tlDiscountTaxAtPayment | logical | |
| tcShipperCode | character | |
| tcCollSelectionCode | character | |
| tdRunningAllocBalanceTC | decimal(4) | |
| tcDInvoiceDIText | character | Legacy Invoice Number |
| tdBankStateAllocPaidTC | decimal(4) | |
| tdDocCCExchangeRate | decimal(10) | |
| tdDocCCExchangeRateScale | decimal(10) | |
| tdDocOriginal | decimal(4) | |
| tcCCCurrDifferenceCrDt | character | Sign of statutory currency differences |
| tcCCCurrencyDifferenceGLCode | character | |
| tdBankStateAllocBankAmountCC | decimal(4) | |
| tdBankStateAllocBankDiscCC | decimal(4) | |
| tdBankStateAllocAmountTCSign | decimal(4) | |
| tdBankStateAllocOpenBalTCSign | decimal(4) | |
| tdNonDiscAmtTC | decimal(4) | Non Disc Amt |
| tcReasonCode | character | |
| tcDInvoiceDeductionCode | character | |
| tcDInvoiceDeductionStatus | character | |
| tcDInvoiceDeductionParentRowID | character | |
| tdDInvoiceDeductionTC | decimal(4) | |
| tlCreditorIsWHT | logical | Is the supplier of the supplier invoice defined with withholding tax or not |
| tlUpdateTax | logical | Update 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 |
| tdCInvoiceWHTUnpaidAmtTC | decimal(4) | The remaining unpaid amount of the withholding tax on the invoice |
| tdCInvoiceTotWHTBaseTC | decimal(4) | total withholding tax base amount in TC for all the lines you selected, used on UI |
| tdCInvoiceTotWHTTC | decimal(4) | withholding tax amount of the invoice |
| tdWHTBalanceTC | decimal(4) | Open Withholding tax amount defined on the supplier invoice |
| tdBankStateAllocBankWhtAmtTC | decimal(4) | Bank WHT Amount TC |
| tdInitiallyAllocatedWHTAmntTC | decimal(4) | Withholding tax amount in TC that is allocated but not yet paid in withholding tax |
| tcDInoviceDeductionCusReference | character | Deduction Customer reference. |
| ttDocPostingDate | date | |
| tcBillStatus | character | |
| tcDocTSMNumber | character | |
| tiBillYear | integer | |
| tiBillNumber | integer | |
| tcInvoiceDescription | character | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials
QadFitnesse