dataset BCInvoiceAPMatching

class dataset

object identification

table tAPMatchingCIAPM

Description

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

field name	data type	description
tc_Status	character
tcPurchaseOrderNumber	character
tiPurchaseOrderLineNumber	integer
tcReceiverNumber	character
tdMatchQty	decimal
tdMatchUnitPrice	decimal
tlIsPvodFinished	logical
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character

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 name	data type	description
tcGLCode	character
tcDivisionCode	character
tcCostCentreCode	character
tcProjectCode	character
tcSafStructureCode	character
tcCurrencyCode	character
tcLineText	character
tdDebitTC	decimal
tdDebitLC	decimal
tdDebitCC	decimal
tdCreditTC	decimal
tdCreditLC	decimal
tdCreditCC	decimal
tcExchangeRateType	character
tdExchangeRate	decimal
tdExchangeRateScale	decimal
tdPostingLineCCRate	decimal
tdPostingLineCCScale	decimal
ttExchangeRateDate	date
tc_Status	character
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tcAllocationType	character
tcAllocationKey	character
ttTaxPointDate	date
tcPostingVatInOut	character
tcPostingVatCode	character
tcPostingVatDomain	character
tcTransactionType	character
tcTaxTransactionType	character
tdBaseDebitTC	decimal
tdBaseCreditTC	decimal
tdBaseDebitLC	decimal
tdBaseCreditLC	decimal
tdBaseDebitCC	decimal
tdBaseCreditCC	decimal
tdVatDebitTC	decimal
tdVatCreditTC	decimal
tdVatDebitLC	decimal
tdVatCreditLC	decimal
tdVatDebitCC	decimal
tdVatCreditCC	decimal
tlNormalTaxIsAlreadyAbsRet	logical
tcAbsRetTaxGLCode	character
tcAbsRetTaxDivisionCode	character
tcFromTaxZone	character
tcToTaxZone	character
tcTaxEnvironment	character
tlIsTaxable	logical
tcTaxClass	character
tcTaxUsage	character
tcTaxType	character
tlTaxIsReverseChargeDomestic	logical
tiTaxAddressID	integer
tcTaxIDFeder	character
tcTaxIDState	character
tcTaxIDMisc1	character
tcTaxIDMisc2	character
tcTaxIDMisc3	character
tiOwnAddressID	integer
tcOwnTaxIDFeder	character
tcOwnTaxIDState	character
tcOwnTaxIDMisc1	character
tcOwnTaxIDMisc2	character
tcOwnTaxIDMisc3	character
tiOwnTaxIDDeclarat	integer
tlIsSuspDel	logical
tlCalledFromMoveSuspDelTax	logical

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 name	data type	description
tcSafCode	character
tcSafConcept	character
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tAPMatchingLcChargeCIAPM

Description

Data for the creation of the Receiver matching for logistic charges

field name	data type	description
tc_Status	character
tcOrderNumber	character
tiOrderLine	integer
tcExternalReference	character
tcInternalReference	character
tcLcCharge	character
tiPvoId	integer
tiPvodLineId	integer
tdMatchAmountTC	decimal
tlIsPvodFinished	logical
tc_ParentRowid	character
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).

table tCInvoiceCIAPM

Description

Data for the Supplier invoice creation

field name	data type	description
tc_Status	character
tc_ParentRowid	character
tiCInvoice_ID	integer
tcCInvoiceReferenceInt	character
tcPurchaseOrderNumber	character
tcReceiverNumber	character
tlIsCreateCInvoice	logical
tcCInvoiceReference	character
tcCreditorCode	character
tcRemittanceAddressName	character
tcAddressName	character
tcAddressStreet1	character
tcAddressStreet2	character
tcAddressStreet3	character
tcAddressCity	character
tcAddressStateCode	character
tcAddressZip	character
tcAddressFormat	character
tcAddressCountryCode	character
tcAddressCounty	character
ttCInvoicePostingDate	date
tcCInvoiceCurrencyCode	character
tcCInvoiceOwnBankNumber	character
tcDInvoiceNumber	character
ttCInvoiceDate	date
tcCInvoicePaymentCondCode	character
ttCInvoiceDiscountDueDate	date
ttCInvoiceDueDate	date
tcCInvoiceControlGLCode	character
tcCInvoiceCostCentreCode	character
tcCInvoiceDiscountGLCode	character
tcCInvoiceDiscountCostCentre	character
tcCompanyCode	character
tcCInvoiceRemark	character
tcCInvoiceBankNumber	character
tcCInvoiceCheckForm	character
tlCInvoiceIsHoldAmount	logical
tdCInvoiceHoldAmountTC	decimal
tlCInvoiceIsStatusFinal	logical
tcCInvoiceDivisionCode	character
tcCInvoiceDiscountDivision	character
tcSite	character
tcDomainCode	character	The domain code of the domain to which this session is logged in.
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tiCInvoicePostingYear	integer
tcJournalCode	character
tiCInvoiceVoucher	integer
tlAPMatchingIsStatusFinal	logical
tiCInvoiceRegistrationNr	integer
tcCInvoiceTSMNumber	character

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character