project QadFinancials > class BBankEntry > dataset BBankEntry

class dataset

object identification

primary key
BankState_ID
object identity
BankState_ID
object status
BankStateStatus

table tBankState

Description

Bank State

field namedata typemnd.description
BankState_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
GL_IDintegeryesGL Account
Period_IDintegeryesGL Calendar Year
Currency_IDintegeryesCurrency Code
BankStateNumbercharacter(20)yesBank Statement No
BankStatePostingDatedateyesPosting Date
BankStateStatuscharacter(20)yesStatus
value list:{&BANKSTATESTATUSES}
BankStateOpeningBalancedecimal(4)noOpening Balance
BankStateMovementdecimal(4)noActivity
BankStateClosingBalancedecimal(4)noClosing Balance
BankStateBankImpRefcharacter(255)noBank Importing Reference
BankStateTransactionTypecharacter(20)yesTransaction Type
value list:{&BANKSTATETRANSTYPES}
BankStateInfocharacter(2000)noInformation
BankStateYearintegeryesBank Statement Year
tcGLBankNumbercharacter(40)noGLBankNumber; Bank nuber of the GL
tdGLBalancedecimal(4)noGLBalance
tcGLJournalCodecharacter(20)noDaybook
tcGLJournalLayerCodecharacter(20)noLayer Code
tdGLUnallocStatBalancedecimal(4)noUnallocated Statement Balance
tcCurrencyCodecharacter(3)yesCurrency Code
tcGLDescriptioncharacter(40)noGLDescription
tiPeriodYearintegeryesGL Calendar Year
tiPeriodPeriodintegeryesGL Period
tcGLCodecharacter(8)yesGL Account
tiGLBankNumberIdintegerno
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tBankStateAlloc

Description

Bank State Allocation.

field namedata typemnd.description
BankStateAlloc_IDintegeryesRecord ID
Currency_IDintegeryesCurrency Code
Company_IDintegeryesLink to Company
BankStateLine_IDintegeryesLink to BankStateLine
CInvoice_IDintegernoLink to CInvoice
CCollection_IDintegernoLink to CCollection
DInvoice_IDintegernoLink to DInvoice
DCollection_IDintegernoLink to DCollection
Posting_IDintegernoLink to Posting
BankState_IDintegernoLink to BankState
BankStateAllocTypecharacter(20)yesAllocation Type
value list:{&INVOICETYPESBANKSTATEALLOC}
BankStateAllocAmountTCdecimal(4)noTC Allocated
BankStateAllocAmountLCdecimal(4)noBC Amount
BankStateAllocPaidAmtTCdecimal(4)noTC Paid Amount
BankStateAllocDiscountTCdecimal(4)noTC Discount
BankStateAllocBankAmountTCdecimal(4)noTC Bank Amt
BankStateAllocBankAmountLCdecimal(4)noBC Bank Amount
BankStateAllocBankRatedecimal(10)yesAccounting Rate
BankStateAllocBankRteScaledecimal(10)noScale Factor
BankStateAllocCCRatedecimal(10)noSC Rate
BankStateAllocCCScaledecimal(10)noSC Rate Scale
BankStateAllocDifferenceLCdecimal(4)noBC Difference
BankStateAllocDifferenceCCdecimal(4)noSC Exch Rate Variance
BankStateAllocBankValDatedatenoRate Date
BankStateAllocBankDiscTCdecimal(4)noTC Bank Discount
BankStateAllocBankDiscLCdecimal(4)noBC Bank Discount
BankStateAllocDifferenceTCdecimal(4)noTC Difference
BankStateAllocOpenBalTCdecimal(4)noOpen Balance TC
BankStateAllocBankImpRefcharacter(255)noBank Importing Reference
BankStateAllocWHTAmtTCdecimal(4)noTC WHT Amount
BankStateAllocWHTAmtLCdecimal(4)noBC WHT Amount
BankStateAllocWHTAmtCCdecimal(4)noSC WHT Amount
BankStateAllocWHTTxFeeTCdecimal(4)noTC WHT Taxable Fee
BankStateAllocWHTPercdecimal(2)noWHT Percentage
BankStateAllocWHTLCRatedecimal(10)noWHT BC Rate
BankStateAllocWHTLCScaledecimal(10)noWHT BC Scale
BankStateAllocWHTCCRatedecimal(10)noWHT SC Rate
BankStateAllocWHTCCScaledecimal(10)noWHT SC Scale
tcDocNumberReferencecharacter(40)noInvoice Reference
tcDocBusinessRelationCodecharacter(20)noBus Rel
ttDocDueDatedatenoDue Date
ttDocInvDatedatenoInvoice Date
ttDocDiscountDueDatedatenoDiscount Due Date
tdDocBalancedecimal(4)noOpen Balance
tcDocCurrencyCodecharacter(20)noInvoice Currency Code
tcCollReferencecharacter(40)noSelection Reference
ttCollRequestedDatedatenoRequested Date
tdCollBalancedecimal(4)noOpen Amount
tlUIFullAllocationlogicalnoUIFullAllocation; field added just to support easy UI-development
tcDocBalanceCrDtcharacter(20)noSign of Balance nl Credit or Debit
value list:{&CREDITDEBITABBREVIATIONS}
tcAllocAmountCrDtcharacter(20)noSign of Alloc Amount nl Debit or Credit
value list:{&CREDITDEBITABBREVIATIONS}
tdNewBalanceTCdecimal(4)noNew Balance Amount in TC
tcNewBalanceCrDtcharacter(20)noSign of new balance nl debit or credit
value list:{&CREDITDEBITABBREVIATIONS}
tdDocExchangeRatedecimal(10)noDocument Exchange Rate
tiCollNumberintegernoCollection number
tcCollBalanceCrDtcharacter(20)noSign of new balance nl debit or credit
value list:{&CREDITDEBITABBREVIATIONS}
tcLocalCurrencyCodecharacter(20)noLocal currency code
tcCurrDifferenceCrDtcharacter(20)nosign of currency details : credit or debit
value list:{&CREDITDEBITABBREVIATIONS}
tcCurrencyCodecharacter(3)yesCurrency Code
tcDocCredDebEmplCodecharacter(20)noCode
tiDocCredDebEmplIdintegernoID
tcCurrencyDifferenceGLCodecharacter(20)noGL Code for the Currency Differences
tiBankStateAllocSequenceintegernoSequence
tcCompanyCodecharacter(20)noCompanyCode: 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)noDiscount Percentage : keep it in calculated field so ui can used that when they allocate
tdDocExchangeRateScaledecimal(10)noRateScal for the document
tdDefaultPaymentAmountTCdecimal(4)noDefault payment amount TC : invoice(document) amount - discount
tdDefaultDiscountAmountTCdecimal(4)noDefault discount amount tc (calculated on net amount)
tcDocDescriptioncharacter(40)noDescription
tcDocDivisionCodecharacter(20)noSub-Account
tcDocProjectCodecharacter(20)noProject
tcDocCostCentreCodecharacter(20)noCost Center
tdDocVatdecimal(4)noDoc Tax
tcDocVatCrDtcharacter(20)noDR/CR
tdDocVatBasedecimal(4)noDoc Tax Base
tcDocVatBaseCrDtcharacter(20)noDR/CR
tiDocPostingIDintegernoPay Posting ID
tcVatCountryCodecharacter(20)noTax Country Code
tlDiscountTaxAtPaymentlogicalnoDiscount Tax at Payment
tcShipperCodecharacter(20)noShipper
tcCollSelectionCodecharacter(20)noSelection Code
tdRunningAllocBalanceTCdecimal(4)noRunning Balance TC
tcDInvoiceDITextcharacter(32)noLegacy Invoice Number
tdBankStateAllocPaidTCdecimal(4)no
tdDocCCExchangeRatedecimal(10)no
tdDocCCExchangeRateScaledecimal(10)no
tdDocOriginaldecimal(4)no
tcCCCurrDifferenceCrDtcharacter(20)noSign of statutory currency differences
value list:{&CREDITDEBITABBREVIATIONS}
tcCCCurrencyDifferenceGLCodecharacter(20)no
tdBankStateAllocBankAmountCCdecimal(4)no
tdBankStateAllocBankDiscCCdecimal(4)no
tdBankStateAllocAmountTCSigndecimal(4)no
tdBankStateAllocOpenBalTCSigndecimal(4)no
tdNonDiscAmtTCdecimal(4)noNon Disc Amt
tcReasonCodecharacter(20)no
tcDInvoiceDeductionCodecharacter(20)no
tcDInvoiceDeductionStatuscharacterno
tcDInvoiceDeductionParentRowIDcharacterno
tdDInvoiceDeductionTCdecimal(4)no
tlCreditorIsWHTlogicalnoIs the supplier of the supplier invoice defined with withholding tax or not
tlUpdateTaxlogicalnoUpdate 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)noThe remaining unpaid amount of the withholding tax on the invoice
tdCInvoiceTotWHTBaseTCdecimal(4)nototal withholding tax base amount in TC for all the lines you selected, used on UI
tdCInvoiceTotWHTTCdecimal(4)nowithholding tax amount of the invoice
tdWHTBalanceTCdecimal(4)noOpen Withholding tax amount defined on the supplier invoice
tdBankStateAllocBankWhtAmtTCdecimal(4)noBank WHT Amount TC
tdInitiallyAllocatedWHTAmntTCdecimal(4)noWithholding tax amount in TC that is allocated but not yet paid in withholding tax
tcDInoviceDeductionCusReferencecharacternoDeduction Customer reference.
ttDocPostingDatedateno
tcBillStatuscharacter(20)no
tcDocTSMNumbercharacter(40)no
tiBillYearintegerno
tiBillNumberintegerno
tcInvoiceDescriptioncharacter(20)no
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBankStateLine.tc_Rowid
tc_Statuscharacternoupdate status

table tBankStateAllocColl

Description

BankState; Collection Allocations
Bank State Collection-Allocation

field namedata typemnd.description
BankStateAllocColl_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
BankStateAlloc_IDintegeryesLink to BankStateAlloc
CDocument_IDintegernoSupplier Payment Type
DDocument_IDintegernoSupplier Payment Type
BankState_IDintegernoLink to BankState
BankStateAllocCollIsAlloclogicalyesAllocated
BankStateAllocCollBankAmTCdecimal(4)noTC Bank Amt
BankStateAllocCollBankAmLCdecimal(4)noBC Bank Amount
BankStateAllocCollBankRatedecimal(10)noAccounting Rate
BankStateAllocCollRteScaledecimal(10)noScale Factor
BankStateAllocCollCCRatedecimal(10)noSC Rate
BankStateAllocCollCCScaledecimal(10)noSC Rate Scale
BankStateAllocCollDiffLCdecimal(4)noBC Difference
BankStateAllocCollDiffTCdecimal(4)noTC Difference
BankStateAllocCollDiffCCdecimal(4)noSC Exch Rate Difference
BankStateAllocCollBankDatedatenoValue Date
tcDocCurrencyCodecharacter(20)noCurrency
tcDocBusinessRelationCodecharacter(20)noBus Rel
tcDocNumberReferencecharacter(40)noPay No/Ref
tcDocTypecharacter(20)noPay Inst
tdDocAmountdecimal(4)noAmount
tcDocNamecharacter(20)noDocument name
tcDocAmountCrDtcharacter(20)noSign of new balance nl debit or credit
value list:{&CREDITDEBITABBREVIATIONS}
tcCDocumentTypecharacter(20)noSupplier Payment Type
tiCDocumentNumberintegernoSupplier Payment Number
tcDDocumentTypecharacter(20)noSupplier Payment Type
tiDDocumentNumberintegernoCustomer Payment Number
tiCDocumentYearintegernoSupplier Payment Year
tiDDocumentYearintegernoCustomer Payment Year
tdDocExchangeRatedecimal(10)noDocument Exchange Rate
tcCurrDifferenceCrDtcharacter(20)nosign of currency difference : debit or credit
tcCurrencyDifferenceGLCodecharacter(20)noGl code for the currency difference
tlDocIsBouncedlogicalnoIs the document bounced or not ?
tdDocExchangeRateScaledecimal(10)noDocument Scale Factor
tdDocAmountBCdecimal(4)noBC Amount
tiCDocumentPrePrintedNumberintegernoPreprinted Number
tdRunningAllocBalanceTCdecimal(4)noRunning Balance TC
tdDocCCExchangeRatedecimal(10)no
tdDocCCExchangeRateScaledecimal(10)no
tcCCCurrencyDifferenceGLCodecharacter(20)no
tcCCCurrDifferenceCrDtcharacter(20)no
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBankStateAlloc.tc_Rowid
tc_Statuscharacternoupdate status

table tBankStateLine

Description

Bank State Line

field namedata typemnd.description
BankStateLine_IDintegeryesRecord ID
BankState_IDintegeryesLink to BankState
Period_IDintegeryesGL Calendar Year
Posting_IDintegernoVoucher
Company_IDintegeryesLink to Company
BankStateLineNumberintegeryesNumber
BankStateLineValueDatedateyesValue Date
BankStateLinePostingDatedatenoPosting Date
BankStateLineDescriptioncharacter(40)yesDescription
BankStateLineAmountTCdecimal(4)noTC Amount
BankStateLineInOutcharacter(20)yesIn/Out
value list:{&BANKSTATELINEINOUTS}
BankStateLineStatuscharacter(20)yesStatus
value list:{&BANKSTATELINESTATUSES}
BankStateLineBankImpRefcharacter(255)noBank Importing Reference
BankStateLineInformationcharacter(2000)noInformation
BankStateLineExtRateScaledecimal(10)noScale Factor
BankStateLineExtReferencecharacter(40)noReference (Ext)
BankStateLineExtTSMcharacter(40)noTSM (Ext)
BankStateLineExtNamecharacter(40)noName (Ext)
BankStateLineExtSwiftCodecharacter(40)noSWIFT Code (Ext)
BankStateLineExtAddresscharacter(40)noAddress (Ext)
BankStateLineExtZipcharacter(20)noZip Code (Ext)
BankStateLineExtCitycharacter(40)noCity (Ext)
BankStateLineExtBankNumbercharacter(40)noBank Number (Ext)
BankStateLineExtDebCredcharacter(20)noCustomer/Supplier (Ext)
BankStateLineExtOriginalTCdecimal(4)noTC Original (Ext)
BankStateLineExtCurrencycharacter(20)noCurrency (Ext)
BankStateLineExtBankRatedecimal(10)noBank Rate (Ext)
BankStateLineExtCountrycharacter(20)noCountry (Ext)
BankStateLineExtCostCodecharacter(20)noCost Code (Ext)
tiPostingVoucherintegernoPosting Voucher
tiPostingPeriodYearintegernoPosting Period Year
tcPostingJournalCodecharacter(8)noPosting Daybook Code
tiPeriodYearintegeryesGL Calendar Year
tiPeriodPeriodintegeryesGL Period
tcPostingRowIdcharacternoRow ID
tlPrintlogicalnoPrint
tdBankStateLineAmountLCdecimal(4)noBank state line amount lc
tcExternalUniqueIdentifiercharacter(40)noStore 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.
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBankState.tc_Rowid
tc_Statuscharacternoupdate status

table tBankStateStageAlloc


field namedata typemnd.description
BankStateStageAlloc_IDdecimal(4)yesRecord ID
BankStateAlloc_IDintegernoLink to BankStateAlloc
DInvoiceStage_IDintegernoLink to DInvoiceStage
CInvoiceStage_IDintegernoLink to CInvoiceStage
BankState_IDintegernoLink to BankState
BankStateStageAllocAmntTCdecimal(4)noStage Allocation
BankStateStageAllocDiscTCdecimal(4)noStage Discount
BankStateStageAllocPaidTCdecimal(4)noStage Paid
BankStateStageAllocWHTTCdecimal(4)noTCWHT Amount
tdDefaultPaymentAmountTCdecimal(4)noTC Default Payment Amount
tdDefaultDiscountAmountTCdecimal(4)noTC Default Discount Amount
tdDefaultDiscountPercdecimal(2)no
ttDefaultDueDatedateno
ttDefaultDiscDatedateno
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tdDefaultWhtAmtTCdecimal(4)noDefault WHT Amount in TC
tdDefaultAllocAmountTCdecimal(4)noDefault Allocated Amount TC
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tBankStateAlloc.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter