project QadFinancials > class BCInvoiceAPMatching > dataset BCInvoiceAPMatching

class dataset

object identification

table tAPMatchingCIAPM

Description

Data for the creation of the Receiver matching for the Purchase order reciepts

field namedata typedescription
tc_Statuscharacter
tcPurchaseOrderNumbercharacter
tiPurchaseOrderLineNumberinteger
tcReceiverNumbercharacter
tdMatchQtydecimal
tdMatchUnitPricedecimal
tlIsPvodFinishedlogical
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter

table tAPMatchingCostCIAPM

Description

Temp-table to pass extra posting lines for the matching posting.
Debit-Credit amounts need to be filled for Standard accounts and open item accounts.
For Vat Accounts, the base- and vat amounts need to be filled. All the Vat information needs to be filled as well, as you would do when creating a normal journal entry on a Vat account.
The header table for this table is tCInvoiceCIAPM.

field namedata typedescription
tcGLCodecharacter
tcDivisionCodecharacter
tcCostCentreCodecharacter
tcProjectCodecharacter
tcSafStructureCodecharacter
tcCurrencyCodecharacter
tcLineTextcharacter
tdDebitTCdecimal
tdDebitLCdecimal
tdDebitCCdecimal
tdCreditTCdecimal
tdCreditLCdecimal
tdCreditCCdecimal
tcExchangeRateTypecharacter
tdExchangeRatedecimal
tdExchangeRateScaledecimal
tdPostingLineCCRatedecimal
tdPostingLineCCScaledecimal
ttExchangeRateDatedate
tc_Statuscharacter
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tcAllocationTypecharacter
tcAllocationKeycharacter
ttTaxPointDatedate
tcPostingVatInOutcharacter
tcPostingVatCodecharacter
tcPostingVatDomaincharacter
tcTransactionTypecharacter
tcTaxTransactionTypecharacter
tdBaseDebitTCdecimal
tdBaseCreditTCdecimal
tdBaseDebitLCdecimal
tdBaseCreditLCdecimal
tdBaseDebitCCdecimal
tdBaseCreditCCdecimal
tdVatDebitTCdecimal
tdVatCreditTCdecimal
tdVatDebitLCdecimal
tdVatCreditLCdecimal
tdVatDebitCCdecimal
tdVatCreditCCdecimal
tlNormalTaxIsAlreadyAbsRetlogical
tcAbsRetTaxGLCodecharacter
tcAbsRetTaxDivisionCodecharacter
tcFromTaxZonecharacter
tcToTaxZonecharacter
tcTaxEnvironmentcharacter
tlIsTaxablelogical
tcTaxClasscharacter
tcTaxUsagecharacter
tcTaxTypecharacter
tlTaxIsReverseChargeDomesticlogical
tiTaxAddressIDinteger
tcTaxIDFedercharacter
tcTaxIDStatecharacter
tcTaxIDMisc1character
tcTaxIDMisc2character
tcTaxIDMisc3character
tiOwnAddressIDinteger
tcOwnTaxIDFedercharacter
tcOwnTaxIDStatecharacter
tcOwnTaxIDMisc1character
tcOwnTaxIDMisc2character
tcOwnTaxIDMisc3character
tiOwnTaxIDDeclaratinteger
tlIsSuspDellogical
tlCalledFromMoveSuspDelTaxlogical

table tAPMatchingCostSafCIAPM

Description

Temp-table to pass the safs for the extra postinglines for the ap matching integration. The parent table for this table is tAPMatchingCostCIAPM.

field namedata typedescription
tcSafCodecharacter
tcSafConceptcharacter
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tAPMatchingLcChargeCIAPM

Description

Data for the creation of the Receiver matching for logistic charges

field namedata typedescription
tc_Statuscharacter
tcOrderNumbercharacter
tiOrderLineinteger
tcExternalReferencecharacter
tcInternalReferencecharacter
tcLcChargecharacter
tiPvoIdinteger
tiPvodLineIdinteger
tdMatchAmountTCdecimal
tlIsPvodFinishedlogical
tc_ParentRowidcharacter
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).

table tCInvoiceCIAPM

Description

Data for the Supplier invoice creation

field namedata typedescription
tc_Statuscharacter
tc_ParentRowidcharacter
tiCInvoice_IDinteger
tcCInvoiceReferenceIntcharacter
tcPurchaseOrderNumbercharacter
tcReceiverNumbercharacter
tlIsCreateCInvoicelogical
tcCInvoiceReferencecharacter
tcCreditorCodecharacter
tcRemittanceAddressNamecharacter
tcAddressNamecharacter
tcAddressStreet1character
tcAddressStreet2character
tcAddressStreet3character
tcAddressCitycharacter
tcAddressStateCodecharacter
tcAddressZipcharacter
tcAddressFormatcharacter
tcAddressCountryCodecharacter
tcAddressCountycharacter
ttCInvoicePostingDatedate
tcCInvoiceCurrencyCodecharacter
tcCInvoiceOwnBankNumbercharacter
tcDInvoiceNumbercharacter
ttCInvoiceDatedate
tcCInvoicePaymentCondCodecharacter
ttCInvoiceDiscountDueDatedate
ttCInvoiceDueDatedate
tcCInvoiceControlGLCodecharacter
tcCInvoiceCostCentreCodecharacter
tcCInvoiceDiscountGLCodecharacter
tcCInvoiceDiscountCostCentrecharacter
tcCompanyCodecharacter
tcCInvoiceRemarkcharacter
tcCInvoiceBankNumbercharacter
tcCInvoiceCheckFormcharacter
tlCInvoiceIsHoldAmountlogical
tdCInvoiceHoldAmountTCdecimal
tlCInvoiceIsStatusFinallogical
tcCInvoiceDivisionCodecharacter
tcCInvoiceDiscountDivisioncharacter
tcSitecharacter
tcDomainCodecharacterThe domain code of the domain to which this session is logged in.
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tiCInvoicePostingYearinteger
tcJournalCodecharacter
tiCInvoiceVoucherinteger
tlAPMatchingIsStatusFinallogical
tiCInvoiceRegistrationNrinteger
tcCInvoiceTSMNumbercharacter

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