field name | data type | mnd. | description |
BankStateAlloc_ID | integer | yes | Record ID |
Currency_ID | integer | yes | Currency Code |
Company_ID | integer | yes | Link to Company |
BankStateLine_ID | integer | yes | Link to BankStateLine |
CInvoice_ID | integer | no | Link to CInvoice |
CCollection_ID | integer | no | Link to CCollection |
DInvoice_ID | integer | no | Link to DInvoice |
DCollection_ID | integer | no | Link to DCollection |
Posting_ID | integer | no | Link to Posting |
BankState_ID | integer | no | Link to BankState |
BankStateAllocType | character(20) | yes | Allocation Type |
| value list: | | {&INVOICETYPESBANKSTATEALLOC} |
BankStateAllocAmountTC | decimal(4) | no | TC Allocated |
BankStateAllocAmountLC | decimal(4) | no | BC Amount |
BankStateAllocPaidAmtTC | decimal(4) | no | TC Paid Amount |
BankStateAllocDiscountTC | decimal(4) | no | TC Discount |
BankStateAllocBankAmountTC | decimal(4) | no | TC Bank Amt |
BankStateAllocBankAmountLC | decimal(4) | no | BC Bank Amount |
BankStateAllocBankRate | decimal(10) | yes | Accounting Rate |
BankStateAllocBankRteScale | decimal(10) | no | Scale Factor |
BankStateAllocCCRate | decimal(10) | no | SC Rate |
BankStateAllocCCScale | decimal(10) | no | SC Rate Scale |
BankStateAllocDifferenceLC | decimal(4) | no | BC Difference |
BankStateAllocDifferenceCC | decimal(4) | no | SC Exch Rate Variance |
BankStateAllocBankValDate | date | no | Rate Date |
BankStateAllocBankDiscTC | decimal(4) | no | TC Bank Discount |
BankStateAllocBankDiscLC | decimal(4) | no | BC Bank Discount |
BankStateAllocDifferenceTC | decimal(4) | no | TC Difference |
BankStateAllocOpenBalTC | decimal(4) | no | Open Balance TC |
BankStateAllocBankImpRef | character(255) | no | Bank Importing Reference |
BankStateAllocWHTAmtTC | decimal(4) | no | TC WHT Amount |
BankStateAllocWHTAmtLC | decimal(4) | no | BC WHT Amount |
BankStateAllocWHTAmtCC | decimal(4) | no | SC WHT Amount |
BankStateAllocWHTTxFeeTC | decimal(4) | no | TC WHT Taxable Fee |
BankStateAllocWHTPerc | decimal(2) | no | WHT Percentage |
BankStateAllocWHTLCRate | decimal(10) | no | WHT BC Rate |
BankStateAllocWHTLCScale | decimal(10) | no | WHT BC Scale |
BankStateAllocWHTCCRate | decimal(10) | no | WHT SC Rate |
BankStateAllocWHTCCScale | decimal(10) | no | WHT SC Scale |
tcDocNumberReference | character(40) | no | Invoice Reference |
tcDocBusinessRelationCode | character(20) | no | Bus Rel |
ttDocDueDate | date | no | Due Date |
ttDocInvDate | date | no | Invoice Date |
ttDocDiscountDueDate | date | no | Discount Due Date |
tdDocBalance | decimal(4) | no | Open Balance |
tcDocCurrencyCode | character(20) | no | Invoice Currency Code |
tcCollReference | character(40) | no | Selection Reference |
ttCollRequestedDate | date | no | Requested Date |
tdCollBalance | decimal(4) | no | Open Amount |
tlUIFullAllocation | logical | no | UIFullAllocation; field added just to support easy UI-development |
tcDocBalanceCrDt | character(20) | no | Sign of Balance nl Credit or Debit |
| value list: | | {&CREDITDEBITABBREVIATIONS} |
tcAllocAmountCrDt | character(20) | no | Sign of Alloc Amount nl Debit or Credit |
| value list: | | {&CREDITDEBITABBREVIATIONS} |
tdNewBalanceTC | decimal(4) | no | New Balance Amount in TC |
tcNewBalanceCrDt | character(20) | no | Sign of new balance nl debit or credit |
| value list: | | {&CREDITDEBITABBREVIATIONS} |
tdDocExchangeRate | decimal(10) | no | Document Exchange Rate |
tiCollNumber | integer | no | Collection number |
tcCollBalanceCrDt | character(20) | no | Sign of new balance nl debit or credit |
| value list: | | {&CREDITDEBITABBREVIATIONS} |
tcLocalCurrencyCode | character(20) | no | Local currency code |
tcCurrDifferenceCrDt | character(20) | no | sign of currency details : credit or debit |
| value list: | | {&CREDITDEBITABBREVIATIONS} |
tcCurrencyCode | character(3) | yes | Currency Code |
tcDocCredDebEmplCode | character(20) | no | Code |
tiDocCredDebEmplId | integer | no | ID |
tcCurrencyDifferenceGLCode | character(20) | no | GL Code for the Currency Differences |
tiBankStateAllocSequence | integer | no | Sequence |
tcCompanyCode | character(20) | no | 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) | no | Discount Percentage : keep it in calculated field so ui can used that when they allocate |
tdDocExchangeRateScale | decimal(10) | no | RateScal for the document |
tdDefaultPaymentAmountTC | decimal(4) | no | Default payment amount TC : invoice(document) amount - discount |
tdDefaultDiscountAmountTC | decimal(4) | no | Default discount amount tc (calculated on net amount) |
tcDocDescription | character(40) | no | Description |
tcDocDivisionCode | character(20) | no | Sub-Account |
tcDocProjectCode | character(20) | no | Project |
tcDocCostCentreCode | character(20) | no | Cost Center |
tdDocVat | decimal(4) | no | Doc Tax |
tcDocVatCrDt | character(20) | no | DR/CR |
tdDocVatBase | decimal(4) | no | Doc Tax Base |
tcDocVatBaseCrDt | character(20) | no | DR/CR |
tiDocPostingID | integer | no | Pay Posting ID |
tcVatCountryCode | character(20) | no | Tax Country Code |
tlDiscountTaxAtPayment | logical | no | Discount Tax at Payment |
tcShipperCode | character(20) | no | Shipper |
tcCollSelectionCode | character(20) | no | Selection Code |
tdRunningAllocBalanceTC | decimal(4) | no | Running Balance TC |
tcDInvoiceDIText | character(32) | no | Legacy Invoice Number |
tdBankStateAllocPaidTC | decimal(4) | no | |
tdDocCCExchangeRate | decimal(10) | no | |
tdDocCCExchangeRateScale | decimal(10) | no | |
tdDocOriginal | decimal(4) | no | |
tcCCCurrDifferenceCrDt | character(20) | no | Sign of statutory currency differences |
| value list: | | {&CREDITDEBITABBREVIATIONS} |
tcCCCurrencyDifferenceGLCode | character(20) | no | |
tdBankStateAllocBankAmountCC | decimal(4) | no | |
tdBankStateAllocBankDiscCC | decimal(4) | no | |
tdBankStateAllocAmountTCSign | decimal(4) | no | |
tdBankStateAllocOpenBalTCSign | decimal(4) | no | |
tdNonDiscAmtTC | decimal(4) | no | Non Disc Amt |
tcReasonCode | character(20) | no | |
tcDInvoiceDeductionCode | character(20) | no | |
tcDInvoiceDeductionStatus | character | no | |
tcDInvoiceDeductionParentRowID | character | no | |
tdDInvoiceDeductionTC | decimal(4) | no | |
tlCreditorIsWHT | logical | no | Is the supplier of the supplier invoice defined with withholding tax or not |
tlUpdateTax | logical | no | 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) | no | The remaining unpaid amount of the withholding tax on the invoice |
tdCInvoiceTotWHTBaseTC | decimal(4) | no | total withholding tax base amount in TC for all the lines you selected, used on UI |
tdCInvoiceTotWHTTC | decimal(4) | no | withholding tax amount of the invoice |
tdWHTBalanceTC | decimal(4) | no | Open Withholding tax amount defined on the supplier invoice |
tdBankStateAllocBankWhtAmtTC | decimal(4) | no | Bank WHT Amount TC |
tdInitiallyAllocatedWHTAmntTC | decimal(4) | no | Withholding tax amount in TC that is allocated but not yet paid in withholding tax |
tcDInoviceDeductionCusReference | character | no | Deduction Customer reference. |
ttDocPostingDate | date | no | |
tcBillStatus | character(20) | no | |
tcDocTSMNumber | character(40) | no | |
tiBillYear | integer | no | |
tiBillNumber | integer | no | |
tcInvoiceDescription | character(20) | no | |
LastModifiedDate | date | no | Last Modified Date |
LastModifiedTime | integer | no | Last Modified Time |
LastModifiedUser | character(20) | no | Last Modified User |
QADC01 | character(40) | no | unused QAD reserved field |
QADC02 | character | no | unused QAD reserved field |
QADT01 | date | no | unused QAD reserved field |
QADD01 | decimal(10) | no | unused QAD reserved field |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | yes | = tBankStateLine.tc_Rowid |
tc_Status | character | no | update status |
field name | data type | mnd. | description |
BankStateAllocColl_ID | integer | yes | Record ID |
Company_ID | integer | yes | Link to Company |
BankStateAlloc_ID | integer | yes | Link to BankStateAlloc |
CDocument_ID | integer | no | Supplier Payment Type |
DDocument_ID | integer | no | Supplier Payment Type |
BankState_ID | integer | no | Link to BankState |
BankStateAllocCollIsAlloc | logical | yes | Allocated |
BankStateAllocCollBankAmTC | decimal(4) | no | TC Bank Amt |
BankStateAllocCollBankAmLC | decimal(4) | no | BC Bank Amount |
BankStateAllocCollBankRate | decimal(10) | no | Accounting Rate |
BankStateAllocCollRteScale | decimal(10) | no | Scale Factor |
BankStateAllocCollCCRate | decimal(10) | no | SC Rate |
BankStateAllocCollCCScale | decimal(10) | no | SC Rate Scale |
BankStateAllocCollDiffLC | decimal(4) | no | BC Difference |
BankStateAllocCollDiffTC | decimal(4) | no | TC Difference |
BankStateAllocCollDiffCC | decimal(4) | no | SC Exch Rate Difference |
BankStateAllocCollBankDate | date | no | Value Date |
tcDocCurrencyCode | character(20) | no | Currency |
tcDocBusinessRelationCode | character(20) | no | Bus Rel |
tcDocNumberReference | character(40) | no | Pay No/Ref |
tcDocType | character(20) | no | Pay Inst |
tdDocAmount | decimal(4) | no | Amount |
tcDocName | character(20) | no | Document name |
tcDocAmountCrDt | character(20) | no | Sign of new balance nl debit or credit |
| value list: | | {&CREDITDEBITABBREVIATIONS} |
tcCDocumentType | character(20) | no | Supplier Payment Type |
tiCDocumentNumber | integer | no | Supplier Payment Number |
tcDDocumentType | character(20) | no | Supplier Payment Type |
tiDDocumentNumber | integer | no | Customer Payment Number |
tiCDocumentYear | integer | no | Supplier Payment Year |
tiDDocumentYear | integer | no | Customer Payment Year |
tdDocExchangeRate | decimal(10) | no | Document Exchange Rate |
tcCurrDifferenceCrDt | character(20) | no | sign of currency difference : debit or credit |
tcCurrencyDifferenceGLCode | character(20) | no | Gl code for the currency difference |
tlDocIsBounced | logical | no | Is the document bounced or not ? |
tdDocExchangeRateScale | decimal(10) | no | Document Scale Factor |
tdDocAmountBC | decimal(4) | no | BC Amount |
tiCDocumentPrePrintedNumber | integer | no | Preprinted Number |
tdRunningAllocBalanceTC | decimal(4) | no | Running Balance TC |
tdDocCCExchangeRate | decimal(10) | no | |
tdDocCCExchangeRateScale | decimal(10) | no | |
tcCCCurrencyDifferenceGLCode | character(20) | no | |
tcCCCurrDifferenceCrDt | character(20) | no | |
LastModifiedDate | date | no | Last Modified Date |
LastModifiedTime | integer | no | Last Modified Time |
LastModifiedUser | character(20) | no | Last Modified User |
QADC01 | character(40) | no | unused QAD reserved field |
QADC02 | character | no | unused QAD reserved field |
QADT01 | date | no | unused QAD reserved field |
QADD01 | decimal(10) | no | unused QAD reserved field |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | yes | = tBankStateAlloc.tc_Rowid |
tc_Status | character | no | update status |
field name | data type | mnd. | description |
BankStateLine_ID | integer | yes | Record ID |
BankState_ID | integer | yes | Link to BankState |
Period_ID | integer | yes | GL Calendar Year |
Posting_ID | integer | no | Voucher |
Company_ID | integer | yes | Link to Company |
BankStateLineNumber | integer | yes | Number |
BankStateLineValueDate | date | yes | Value Date |
BankStateLinePostingDate | date | no | Posting Date |
BankStateLineDescription | character(40) | yes | Description |
BankStateLineAmountTC | decimal(4) | no | TC Amount |
BankStateLineInOut | character(20) | yes | In/Out |
| value list: | | {&BANKSTATELINEINOUTS} |
BankStateLineStatus | character(20) | yes | Status |
| value list: | | {&BANKSTATELINESTATUSES} |
BankStateLineBankImpRef | character(255) | no | Bank Importing Reference |
BankStateLineInformation | character(2000) | no | Information |
BankStateLineExtRateScale | decimal(10) | no | Scale Factor |
BankStateLineExtReference | character(40) | no | Reference (Ext) |
BankStateLineExtTSM | character(40) | no | TSM (Ext) |
BankStateLineExtName | character(40) | no | Name (Ext) |
BankStateLineExtSwiftCode | character(40) | no | SWIFT Code (Ext) |
BankStateLineExtAddress | character(40) | no | Address (Ext) |
BankStateLineExtZip | character(20) | no | Zip Code (Ext) |
BankStateLineExtCity | character(40) | no | City (Ext) |
BankStateLineExtBankNumber | character(40) | no | Bank Number (Ext) |
BankStateLineExtDebCred | character(20) | no | Customer/Supplier (Ext) |
BankStateLineExtOriginalTC | decimal(4) | no | TC Original (Ext) |
BankStateLineExtCurrency | character(20) | no | Currency (Ext) |
BankStateLineExtBankRate | decimal(10) | no | Bank Rate (Ext) |
BankStateLineExtCountry | character(20) | no | Country (Ext) |
BankStateLineExtCostCode | character(20) | no | Cost Code (Ext) |
tiPostingVoucher | integer | no | Posting Voucher |
tiPostingPeriodYear | integer | no | Posting Period Year |
tcPostingJournalCode | character(8) | no | Posting Daybook Code |
tiPeriodYear | integer | yes | GL Calendar Year |
tiPeriodPeriod | integer | yes | GL Period |
tcPostingRowId | character | no | Row ID |
tlPrint | logical | no | Print |
tdBankStateLineAmountLC | decimal(4) | no | Bank state line amount lc |
tcExternalUniqueIdentifier | character(40) | no | Store the external identity of class table if the component is started in batch mode. This value will be used for SetMessage method to link the tFcmessage recotd with external class table records. Now only PIBF is using this item. This field will store the BankImpLine.tc_rowid, because every bankimline record can be used to create one BankStateLine record. |
CustomShort0 | character(20) | no | Custom Short Field |
CustomShort1 | character(20) | no | Custom Short Field |
CustomShort2 | character(20) | no | Custom Short Field |
CustomShort3 | character(20) | no | Custom Short Field |
CustomShort4 | character(20) | no | Custom Short Field |
CustomShort5 | character(20) | no | Custom Short Field |
CustomShort6 | character(20) | no | Custom Short Field |
CustomShort7 | character(20) | no | Custom Short Field |
CustomShort8 | character(20) | no | Custom Short Field |
CustomShort9 | character(20) | no | Custom Short Field |
CustomCombo0 | character(20) | no | Custom Combo Field |
CustomCombo1 | character(20) | no | Custom Combo Field |
CustomCombo2 | character(20) | no | Custom Combo Field |
CustomCombo3 | character(20) | no | Custom Combo Field |
CustomCombo4 | character(20) | no | Custom Combo Field |
CustomCombo5 | character(20) | no | Custom Combo Field |
CustomCombo6 | character(20) | no | Custom Combo Field |
CustomCombo7 | character(20) | no | Custom Combo Field |
CustomCombo8 | character(20) | no | Custom Combo Field |
CustomCombo9 | character(20) | no | Custom Combo Field |
CustomLong0 | character(255) | no | Custom Long Field |
CustomLong1 | character(255) | no | Custom Long Field |
CustomNote | character(2000) | no | Custom Note Field |
CustomDate0 | date | no | Custom Date Field |
CustomDate1 | date | no | Custom Date Field |
CustomDate2 | date | no | Custom Date Field |
CustomDate3 | date | no | Custom Date Field |
CustomDate4 | date | no | Custom Date Field |
CustomInteger0 | integer | no | Custom Integer Field |
CustomInteger1 | integer | no | Custom Integer Field |
CustomInteger2 | integer | no | Custom Integer Field |
CustomInteger3 | integer | no | Custom Integer Field |
CustomInteger4 | integer | no | Custom Integer Field |
CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
LastModifiedDate | date | no | Last Modified Date |
LastModifiedTime | integer | no | Last Modified Time |
LastModifiedUser | character(20) | no | Last Modified User |
QADC01 | character(40) | no | unused QAD reserved field |
QADC02 | character | no | unused QAD reserved field |
QADT01 | date | no | unused QAD reserved field |
QADD01 | decimal(10) | no | unused QAD reserved field |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | yes | = tBankState.tc_Rowid |
tc_Status | character | no | update status |
field name | data type | mnd. | description |
BankStateStageAlloc_ID | decimal(4) | yes | Record ID |
BankStateAlloc_ID | integer | no | Link to BankStateAlloc |
DInvoiceStage_ID | integer | no | Link to DInvoiceStage |
CInvoiceStage_ID | integer | no | Link to CInvoiceStage |
BankState_ID | integer | no | Link to BankState |
BankStateStageAllocAmntTC | decimal(4) | no | Stage Allocation |
BankStateStageAllocDiscTC | decimal(4) | no | Stage Discount |
BankStateStageAllocPaidTC | decimal(4) | no | Stage Paid |
BankStateStageAllocWHTTC | decimal(4) | no | TCWHT Amount |
tdDefaultPaymentAmountTC | decimal(4) | no | TC Default Payment Amount |
tdDefaultDiscountAmountTC | decimal(4) | no | TC Default Discount Amount |
tdDefaultDiscountPerc | decimal(2) | no | |
ttDefaultDueDate | date | no | |
ttDefaultDiscDate | date | no | |
QADC01 | character(40) | no | unused QAD reserved field |
QADC02 | character | no | unused QAD reserved field |
QADT01 | date | no | unused QAD reserved field |
QADD01 | decimal(10) | no | unused QAD reserved field |
tdDefaultWhtAmtTC | decimal(4) | no | Default WHT Amount in TC |
tdDefaultAllocAmountTC | decimal(4) | no | Default Allocated Amount TC |
tc_Rowid | character | yes | primary index |
tc_ParentRowid | character | yes | = tBankStateAlloc.tc_Rowid |
tc_Status | character | no | update status |