project QadFinancials > class BDInvoice > dataset tDIOpenBalance


copy of dataset tOpenBalance

table tDIOpenBalance

Description

temp-table used for the creation of Debtor-Opening-Balances

field namedata typedescription
tiInvoiceIdintegerInvoice ID
tcActioncharacter
tcBankNumbercharacterBank Number
tcBankNumberExtensioncharacterBankNumberExtention
tcBusinessRelationCodecharacterBusiness Relation Code
tcCCCurrencyCodecharacterCCCurrencyCode
tiCompanyIdintegerInternal ID of the active company.
tcCostCentreCodecharacterCost Center Code
tcCreditorCodecharacterCreditor Code
tcDebtorCodecharacterDebtor Code
tcDivisionCodecharacterSub-Account Code
tdExchangeRateScaledecimal(10)Exchange Rate Scale
tdExchangeRateTCLCdecimal(10)ExchangeRateTCLC
tdInvoiceAmountCCdecimal(4)CInvoiceCC
tdInvoiceAmountLCdecimal(4)CInvoiceLC
tdInvoiceAmountTCdecimal(4)CInvoiceTC
tdInvoiceHoldAmountTCdecimalHold Amount of the invoice in TC
ttInvoiceDatedateCInvoiceDate
tcInvoiceDescriptioncharacterInvoiceDescription
ttInvoiceDiscountDueDatedateInvoiceDiscountDueDate
ttInvoiceDueDatedateInvoiceDueDate
tcInvoiceReferencecharacterCInvoiceReference
ttInvoiceTaxPointDatedateCInvoiceTaxPointDate
tcInvoiceTSMNumbercharacterCInvoiceTSMNumber
tcInvoiceTypecharactertype
tiInvoiceVoucherintegerCInvoiceVoucher
tcJournalCodecharacterJournal Code
tcKeycharacterKey; unique identifier (no part of an index)
tcLCCurrencyCodecharacterLCCurrencyCode
tcNormalPaymentConditionCodecharacterNormal PaymentCondition
tlOnlyControlAccountlogicalOnly posting on a control account
tcPaymentMeanscharacterPayment Means
tiPeriodPeriodintegerAccounting Period
tiPeriodYearintegerAccounting year of the period
ttPostingDatedatePostingDate
tcPostingTextcharacterPostingText
tcPostingTypecharacterPosting Type
tcProjectCodecharacter
tcReasonCodecharacterReason Code
tcTCCurrencyCodecharacterTCCurrencyCode
tcTransferAccountCostCentreCodecharacterTransferAccountCostCentreCode
tcTransferAccountDivisionCodecharacterTransferAccountDivisionCode
tcTransferAccountGLCodecharacterGLTransferAccount
tcTransferAccountProjectCodecharacterTransferAccountProjectCode
tiBankNumber_IDinteger
tcOwnBankNumbercharacterOwn Bank Number
tcPaymentFormatcharacterPayment Format
tlInvoiceIsERSlogicalIs it a ERS invoice ?
tcInvoiceBatchNumbercharacterInvoice Batch Number
tdCCExchangeRateScaledecimal(10)
tdExchangeRateTCCCdecimal(10)
tcRoleNamecharacter
tcInvoiceCommentNotecharacter
tcDeductionCatCodecharacter
tcDayBookSetCodecharacterDay Book Set Code
tcVatCodecharacter
tcVatInOutcharacter
tcDomainCodecharacterThe domain code of the domain to which this session is logged in.
tdWHTFeeDebitTCdecimal
tdWHTFeeCreditTCdecimal
tdWHTExpenseDebitTCdecimal
tdWHTExpenseCreditTCdecimal
tcBLWIGroupCodecharacterBLWI Group Code
tcSalesPerson1characterSalesperson 1.This field displays the salesperson specified on the order to receive commission and quota credit for the order.
api annotation:The commission percentage defaults from the salesperson record.
tcSalesPerson2characterSalesperson 1.This field displays the salesperson specified on the order to receive commission and quota credit for the order.
api annotation:The commission percentage defaults from the salesperson record.
tcSalesPerson3characterSalesperson 1.This field displays the salesperson specified on the order to receive commission and quota credit for the order.
api annotation:The commission percentage defaults from the salesperson record.
tcSalesPerson4characterSalesperson 1.This field displays the salesperson specified on the order to receive commission and quota credit for the order.
api annotation:The commission percentage defaults from the salesperson record.
tdDInvoiceCom1decimal(2)Represents DInvoiceComm1 field
tdDInvoiceCom2decimal(2)Salesperson Commission. This field displays the commission percentage each salesperson receives.
api annotation:For invoices posted from sales orders, this field defaults from the associated sales order.
For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record.
tdDInvoiceCom3decimal(2)Salesperson Commission. This field displays the commission percentage each salesperson receives.
api annotation:For invoices posted from sales orders, this field defaults from the associated sales order.
For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record.
tdDInvoiceCom4decimal(2)Salesperson Commission. This field displays the commission percentage each salesperson receives.
api annotation:For invoices posted from sales orders, this field defaults from the associated sales order.
For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record.


Internal usage


QadFinancials
method BDInvoice.ApiCreateDebtorInvoices
method BDInvoice.ApiCreateDebtorInvoicesV01
method BDInvoice.CreateDInvoices
method BDInvoice.CreateDInvoicesValidate
method BDInvoice.CreateFinChgInvoices
method BDInvoice.GetOpeningBalanceVoucher