project QadFinancials > class BCInvoiceJournalEntry > dataset BCInvoiceJournalEntry

class dataset

object identification

table tApiCInvoiceBankCIJE

Description

ApiCInvoiceBankCIJE

field namedata typedescription
CInvoiceBank_IDinteger
CInvoice_IDinteger
BankNumber_IDinteger
CInvoiceBankToPayTCdecimal(4)TC Payment Amount. This field displays the payment amount in the transaction currency.
tcOwnBankNumbercharacterOwn Bank Number. This field displays the account number that receives payments from this customer.
This number is defined on the supplier record, and is normally the default bank account number for the entity you are currently working in.
tcPayFormatTypeCodecharacterPayment Format. The payment format you have defined for payments from your bank to this supplier.
The value of the field can only be the formats initially defined for the account.
This field is calculated by the system.
tcPayFormatTypePayInstrumentcharacterPayment Instrument. The payment instrument defined for payments to this supplier from your bank account.
This field is calculated by the system.
tiBankPayFormat_IDinteger
tlValidatePaymentlogicalValidate Payment: This field validate the payment when the cinvoicebank amount is changed : when you come from payment selection it is false, otherwise true.
tcBankNumbercharacterBank Number. The supplier bank account number. This field is mandatory when the payment instrument for the supplier is electronic.
This field is calculated by the system.
tcBankNumberExtensioncharacterExtension. This field indicates the bank number extension. The extension defines the currency when an account has amounts in multiple currencies.
This field is calculated by the system.
tcBankNumberFormattedcharacterFormatted Number. This field displays the supplier bank account number, formatted according to the validation you applied.
This field is calculated by the system.
tcBankNumberSwiftCodecharacterSWIFT Code. This field displays the SWIFT code of the bank.
SWIFT (the Society for Worldwide Interbank Financial Telecommunication) is a banking network for world-wide payments between banks. Also known as the BIC or Bank Identifier Code.
This field is calculated by the system and can be blank.
tcBankNumberValidationcharacterValidation. This field identifies the bank format validation for the supplier bank account.
Account number validation ensures that the account number is formatted according to the regulations of the national banking system.
This field is calculated by the system.
tcBusinessRelationCodecharacterBusiness Relation Code. This field displays the business relation for the supplier's bank, and contains bank addressing information.
This field is calculated by the system.
tiParentObject_IDinteger
tcOwnGLCodecharacterOwn Gl Account.The default supplier bank account configured for the supplier.
If you have configured multiple accounts for this supplier, you can add these account details by inserting a new row for each account. You can use a maximum of three bank accounts to make the invoice payment,specifying the bank reference and amounts to be paid per account in each case. The total of the separate amounts must equal the total invoice amount.
This field is calculated by the system.
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoiceBankPayCodeCIJE

Description

ApiCInvoiceBankPayCodeCIJE

field namedata typedescription
CInvoiceBankPayCode_IDinteger
CInvoiceBank_IDinteger
PayFormatCode_IDinteger
PayFormatGroup_IDinteger
CInvoiceBankPayCodeValuecharacterAttribute Value. A new attribute of the payment Format.
This field is added by the user for bank payment.
api annotation:This field defaults from the value user set in the payment maintance.
tcPayFormatGroupCodecharacterPayFormat Attribute level. This field indicates which level the new attributes belongs to.
tlPayFormatGroupIsMandatorylogicalMandatory. This field indicates if the new field added by the user is mandatory for input.
tcPayFormatGroupDataTypecharacterData Type. This field indicates the data type of the attribute added by the user.
tcPayFormatGroupInputOptioncharacterInput Option. This field indicates if a payment attribute value can be entered manually (editable) or has to be selected from a list (selectable).
tcPayFormatGroupDescriptioncharacterAttribute Name Description. This field displays the description of the Attribute added by the user.
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoiceCIJE

Description

ApiCInvoiceCIJE

field namedata typedescription
CInvoice_IDinteger
Company_IDinteger
Period_IDinteger
Creditor_IDinteger
Division_IDinteger
Journal_IDinteger
LinkedCInvoice_IDinteger
CInvoiceCurrency_IDinteger
Reason_IDinteger
NormalPaymentCondition_IDinteger
BLWIGroup_IDinteger
OwnVatNumber_IDinteger
CreditorVatNumber_IDinteger
TransactionStartCountry_IDinteger
TransactionEndCountry_IDinteger
Project_IDinteger
CostCentre_IDinteger
Role_IDinteger
VatCurrency_IDinteger
ShipToAddress_IDinteger
PurchaseType_IDinteger
ControlGL_IDinteger
ReplacedCInvoice_IDinteger
CInvoicePostingDatedatePosting Date. This filed indicates the date on which the invoice is to be posted.
api annotation:This field defaults from the invoice creation date.
CInvoiceTypecharacterInvoice Type. This field identifies the invoice type.
The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined.
CInvoiceVoucherintegerVoucher. This field displays the numeric identifier assigned to the posting.
When the daybook of the journal entry is changed (after transfer), the voucher is cleared.
Voucher must be unique in one GL period.
When the user input is zero, the system automatically assign a value not used yet for this field.
CInvoiceDatedateInvoice Date. This field indicates the invoice creation date.
The system uses this field with the credit terms to calculate due date and discount date.
api annotation:This field defaults from the system date.
CInvoiceTaxPointDatedateTax Point Date.This field indicates the date to be used in tax calculations.
api annotation:This field defaults from the posting date.
CInvoiceReferencecharacterReference. An alphanumeric reference to help identify the invoice in the system.
This reference is typically the ID number of the invoice received from the supplier.
CInvoiceDescriptioncharacterDescription. A brief description of the invoice. The system generates a default description based on the Reference and Supplier Code.
CInvoiceOriginalDebitLCdecimal(4)BC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency.
This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate.
CInvoiceOriginalCreditLCdecimal(4)BC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency.
This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate.
CInvoiceOriginalDebitTCdecimal(4)TC AP Amount. This field displays the debit total invoice amount in the transaction currency.
If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same.
CInvoiceOriginalCreditTCdecimal(4)TC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency.
If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same.
CInvoiceOriginalDebitCCdecimal(4)SC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency.
This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
CInvoiceOriginalCreditCCdecimal(4)SC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency.
This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
CInvoiceExchangeRatedecimal(10)Exchange Rate. The exchange rate used by the invoice.
The BC Invoice Amount is calculated based on the exchange rate.
If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted.
CInvoiceRateScaledecimal(10)Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments.
CInvoiceCCRatedecimal(10)SC Rate. The statutory exchange rate used by the invoice.
The SC Invoice Amount is calculated based on the SC rate.
CInvoiceCCScaledecimal(10)Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments.
CInvoiceAllocationStatuscharacterAllocation Status.This field indicates whether postings occur and if they affect transient or official layers.
User can not delete an invoice which has a non-initial invoice status code.
CInvoiceIsLockPaymentlogicalLock Payment. This field indicates if the invoice is locked for payment. The invoice cannot be included in any automatic payment selections if this field is true.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsInvoiceApprovedlogicalInvoice Approved. This field indicates if the invoice is already approved for payment.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceContactcharacterContact. This field indicates the name of the purchasing contact in the supplier company.
api annotation:This field defaults from the Contact field of the invoice's supplier.
CInvoiceTSMNumbercharacterPayment Reference. This field displays a unique reference number to be included in the supplier payment file.
This reference can consist of a Transfer with Structured Message (TSM) number.
This field can be blank.
CInvoiceDueDatedateDue Date.This field indicates the date when payment become due.
This field can be modified without affecting the credit terms.
This field is calculated by the system based on the credit terms and the invoice date.
CInvoiceDiscountDueDatedateDiscount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date.
User can modify this field without affecting the credit terms.
CInvoiceVatBaseDebitLCdecimal(4)BC Base Amount DR. This field displays the debit base amount in the base currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
CInvoiceVatBaseCreditLCdecimal(4)BC Base Amount CR. This field displays the credit base amount in the base currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
CInvoiceVatBaseDebitTCdecimal(4)TC Base Amount DR. This field displays the debit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatBaseCreditTCdecimal(4)TC Base Amount CR. This field displays the credit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatBaseDebitCCdecimal(4)SC Base Amount DR. This field displays the debit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
CInvoiceVatBaseCreditCCdecimal(4)SC Base Amount CR. This field displays the credit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
CInvoiceVatDebitLCdecimal(4)BC Tax Amount DR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
CInvoiceVatCreditLCdecimal(4)BC Tax Amount CR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
CInvoiceVatDebitTCdecimal(4)TC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatCreditTCdecimal(4)TC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatDebitCCdecimal(4)BC Tax Amount DR. This field displays the debit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount DR and the SC rate.
CInvoiceVatCreditCCdecimal(4)SC Tax Amount CR. This field displays the credit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount CR and the SC rate.
CInvoiceCITextcharacterCIDescription. A brief description for the SI posting.
api annotation:This field defaults from the CInvoiceDescription.
CInvoiceMFTextcharacterMFDescription. A brief description for the Matching posting.
api annotation:This field defaults from the CInvoiceDescription.
CInvoiceBalanceDebitLCdecimal(4)BC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
CInvoiceBalanceCreditLCdecimal(4)BC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
CInvoiceBalanceDebitTCdecimal(4)TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
CInvoiceBalanceCreditTCdecimal(4)TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
CInvoiceBalanceDebitCCdecimal(4)SC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
CInvoiceBalanceCreditCCdecimal(4)BC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
CInvoiceCirecClosingDatedateSIREC Closing Date.This field displays the date on which the Unallocated Invoices account has been backed out for this invoice.
CInvoiceIsVatDelaylogicalTax Delay. This field indicates if the Taxes on purchase orders and supplier invoices or credit notes are delayed.
CInvoiceIsOpenlogicalOpen.This field indicates if the invoice has been completely paid.
This field is updated automatically when complete payment is confirmed.
This field is read-only.
api annotation:PartialUpdate = yes - defaults to true
CInvoiceIsSelectedlogicalSelected. This field indicates whether the invoice is included in a payment selection.
This field is read-only.
CInvoiceBalanceLCdecimal(4)BC Balance. This field displays the sum of the debit and credit amounts of all posting lines in base currency.
This field is calculated by the system using the TC Balance and the Exchange rate.
CInvoiceBalanceTCdecimal(4)Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency.
CInvoiceBalanceCCdecimal(4)SC Balance. This field displays the sum of the debit and credit amounts of all posting lines in statutory currency.
This field is calculated by the system using the TC Balance and the SC rate.
CInvoiceClosingDatedateClosing Date. This field displays the date on which the open balance became zero.
CInvoiceIsLogisticMatchinglogicalReceiver Matching.This field indicates If the Receiver Matching function is enabled.
This field is calculated by the system using the invoice status code.
CInvoicePostingPeriodintegerGL Period.This field indicates the period when the invoice to be posted.
If this field is modified, the posting and tax dates are changed correspondingly.
api annotation:This field defaults to the period associated with the posting date.
CInvoicePostingYearintegerYear.This field indicates the accounting year for the invoice.
If you modify these fields, the posting and tax dates are changed correspondingly.
api annotation:This field defaults to the accounting year associated with the posting date.
CInvoicePostingYearPeriodintegerYear/Period. This field indicates the accounting year and period for the invoice.
If you modify these fields, the posting and tax dates are changed correspondingly.
api annotation:This field defaults to the accounting year and period associated with the posting date.
CInvoiceVatExchangeRatedecimal(10)Tax Exchange Rate. The exchange rate used to calculate the tax of the invoice.
The BC Tax amount is calculated using the Tax exchange rate.
CInvoiceVatRateScaledecimal(10)Tax Rate Scale. This field indicates the scale factor applying to the tax exchange rate in use for foreign currency payments.
CInvoiceIsTaxablelogicalTaxable. This field indicates if the invoice is taxable.
This field defaults to true if the supplier is taxable.
CInvoiceOwnVatNumbercharacterOwn Tax Number. This field displays the tax number for the entity in which you are working.
api annotation:The tax number defaults from the headoffice address of the business relation to which the entity is linked.
CInvoiceCreditorVatNumbercharacterSupplier Tax Number. This field indicates the tax number used by the supplier.
The value for this field is the State Tax ID of the headoffice address of the business relation associated with the supplier.
CInvoiceNonDiscAmtLCdecimal(4)BC Non-discount Amount. This field display the invoice amount without discount in base currency.
This field is calculated by the system using the TC Non-discount Amount and the Exchange rate.
CInvoiceNonDiscAmtCCdecimal(4)SC Non-discount Amount. This field display the invoice amount without discount in statutory currency.
This field is calculated by the system using the TC Non-discount Amount and the SC rate.
CInvoiceNonDiscAmtTCdecimal(4)TC Non-discount Amount. This field display the invoice amount without discount in base currency.
CInvoiceNonRecTaxAmtTCdecimal(4)Non-Rev Tax Amount. This field displays the percentage of tax that is not recoverable.
Taxes are recoverable whenever your company is eligible to offset a percentage of tax on purchases against tax collected on sales. Recoverable taxes are common in Europe.
CInvoiceHoldAmountTCdecimal(4)TC Hold Amount. This field displays the amount of the invoice total that is not to be paid.
If this field is not blank, the hold amount is taken into account during payment processing.
Hold amounts must be:
For invoices or correction invoices: Less than the invoice total and greater than zero.
For credit notes or correction credit notes: Greater than the document total and less than zero.
The hold amount for a negative payment must always be set to zero.
CInvoicePoDomaincharacterPO Domain. This field indicates which domain the purchase order belongs to.
CInvoicePoNbrcharacterPO Number. This fields identifies the PO receipts which the invoice matches.
CInvoiceIsExternallogicalExternal. This field indicates if the daybook used is external.
This field is calculated by the system using the daybook code.
CInvoiceIsTaxConfirmedlogicalTax Confirmed. This field indicates if the taxes for the invoice have been confirmed and cannot be changed anymore.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsTaxExcludedlogicalTax Excluded.This field indicates if the amount specified for Invoice Amount excludes tax.
api annotation:This field defaults from the Customer Invoice Total Excludes Tax field in Global Tax Management Control.
CInvoiceIsWithBanklogicalWith Bank. This field indicates if the invoice has a supplier bank number specified for it.
api annotation:PartialUpdate = yes - defaults to true
CInvoiceIsDiscTaxAtInvlogicalDiscount Tax at Invoice.This field indicates if the invoice has a discount for tax.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsDiscTaxAtPaymlogicalDiscount Tax at Payment. This field indicates if the invoice has a discount for tax at the time of payment.
The discount amount at the time of payment only applies to the tax base amount.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsInitialStatuslogicalInitial Status. This field indicates if the invoice is in initial status.
api annotation:This field defaults from the Initial Status field of the Invoice status code.
CInvoiceRegistrationNrintegerRegistration number. This field displays the sequential number assigned to each invoice upon initial entry in the system.
CInvoiceCreationDatedateCreation Date.This field indicates the invoice creation date.
Thid fields is read-only.
api annotation:Thid fields defautls from the system date.
CInvoiceCommentNotecharacterComment. This field contains user's comment of the invoice.
CInvoiceBatchNumbercharacterBatch Number. This field is used to identify a group of supplier invoices created at one time using Evaluated Receipts Settlement (ERS) functions.
CInvoiceIsERSlogicalERS: This field indicates if the invoice is created using Evaluated Receipts Settlement (ERS) functions.
CInvoiceDayBookSetCodecharacterDaybook Set Code. This field indicates the daybook set you want to use to number the invoice.
This field defaults form:1. the daybook set associated with the supplier in Supplier Data Maintenance.
2. If you specified a PO number in the PO Number field, the daybook set on the PO overrides the daybook set on the supplier data record if they are different, and defaults instead.
3. If you specify more than one PO in the PO Number grid, the daybook set associated with the first PO defaults in. You can overwrite the default value.
CInvoiceSiteCodecharacterSite. The site for which you want to use specific invoice numbering. The default value is:1.The site associated with the supplier in Supplier Data Maintenance.
2. If you specified a PO in the PO Number grid, the site on the PO overrides the site on the supplier data record if they are different, and defaults instead.
3. If you specified more than one PO in the PO Number grid, the site associated with the first PO defaults in.
This field is blank if daybook sets by site is not activated.
CInvoiceIsWHTlogical
CInvoiceWHTTotAmtDebitTCdecimal(4)
CInvoiceWHTTotAmtCreditTCdecimal(4)
CInvoiceWHTBaseAmtDebitTCdecimal(4)
CInvoiceWHTBaseAmtCreditTCdecimal(4)
CInvoiceWHTTotAmtDebitLCdecimal(4)
CInvoiceWHTTotAmtCreditLCdecimal(4)
CInvoiceWHTBaseAmtDebitLCdecimal(4)
CInvoiceWHTBaseAmtCreditLCdecimal(4)
CInvoiceWHTTotAmtDebitCCdecimal(4)
CInvoiceWHTTotAmtCreditCCdecimal(4)
CInvoiceWHTBaseAmtDebitCCdecimal(4)
CInvoiceWHTBaseAmtCreditCCdecimal(4)
tcReasonAllocationStatuscharacterInvoice Status Code Allocation Status.This field indicates the allocation status defined for the invoice's status code.
This field is calculated using the invoice status code.
tcLocalCurrencyCodecharacterBase Currency. This fields inficates the base currency used by the invoice.
tcStatutoryCurrencyCodecharacterStatutory Currency. This field indicates the statutory currency used by the invoice.
tdCInvoiceOriginalTCdecimal(4)Original TC Amount
if Type = Invoice => CInvoiceOriginalCreditTC
if Type = CreditNote => CInvoiceOriginalDebitTC
tdCInvoiceOriginalLCdecimal(4)Original LC Amount
if Type = Invoice => CInvoiceOriginalCreditLC
if Type = CreditNote => CInvoiceOriginalDebitLC
tdCInvoiceOriginalCCdecimal(4)Original CC Amount
if Type = Invoice => CInvoiceOriginalCreditCC
if Type = CreditNote => CInvoiceOriginalDebitCC
tdTotalAmountDebitTCdecimal(4)total debit amount in TC
=>sum of the CInvoiceVatBaseDebitTC and CInvoiceVatDebitTC
tdTotalAmountCreditTCdecimal(4)total credit amount in TC
=>sum of the CInvoiceVatBaseCreditTC and CInvoiceVatCreditTC
tcCAJournalCodecharacterAdjustment. The Journal Code for the Creditor Adjustment Posting.
tiCAVoucherintegerSA Voucher. Voucher of Creditor Adjusment Posting.
tcMFJournalCodecharacterDaybook. The Daybook code of the Matching Daybook used for this invoice.
This field is Calculated by the system.
tcPaymentMeansTranslatedcharacterPayment Instrument. This field displays the payment instrument defined for payments to this supplier from your bank account.
tdCInvoiceVatBaseTCdecimal(4)TC Tax Base Amount
if Type = Invoice => CInvoiceVatBaseCreditTC
if Type = CreditNote => CInvoiceVatBaseDebitTC
tdCInvoiceVatBaseLCdecimal(4)BC Tax Base Amount
if Type = Invoice => CInvoiceVatBaseCreditBC
if Type = CreditNote => CInvoiceVatBaseDebitBC
tcNormalPaymentConditionTypecharacterCredit Terms. The credit terms that apply to this invoice. Credit terms determine invoice due dates and any settlement discounts on early payments. Credit terms also determine if multiple payments are made in stages based on invoice percentages.
api annotation:This field defaults from the credit term type of the supplier record accosiated with the invoice.
tiVatCurrencyNumDecintegerTax Currency Number of Decimals. This field displays the deciamls of the tax currency used by the invoice.
tlCreditorIsTaxReportlogicalTax Report. This field indicates if the supplier of the invoice authorize generation of a supplier tax activity (1099) report.
This field is calculated by the system using the supplier code.
tcOwnVatNumberCountryCodecharacterOwn Tax Number Country Code. This field indicates the tax number Country for the entity in which you are working.
This field is calculated by the system according to the Own Tax Number.
tcCredVatNumberCountryCodecharacterSupplier Tax Number Country Code. This field indicates the tax number Country of the supplier.
This field is calculated by the system according to the supplier Tax Number.
tcCInvoiceNumbercharacterInvoice Number. The system generate invoice number based on the daybook code.
tdCInvoiceOriginalAmountdecimal(2)TC Original Amt. Calculated field for the original amount.
tdCInvoiceOpenAmountdecimal(2)TC Open Amt.Open amount is the total amount of the open item minus any credit to be applied(TC).
This field is calculated by the system.
tiOverdueDaysintegerOverdue Days. The overdue days are determined using the credit terms, as of date, and grace days you apply to this finance charge.
This field is calculated by the system.
tcShipToTaxZonecharacterTax Zone. The ship-to tax zone from the purchase order line site.
This field is calculated by the system according to the ship-to address.
tlShipToAddressIsTaxInCitylogicalTax in City. This field indicates if the ship-to address from the purchase order line site is Tax in city.
This field is calculated by the system according to the ship-to address.
tdCInvoiceOriginalAmountLCdecimal(2)BC Original Amount
if Type = Invoice => CInvoiceOriginalCreditBC
if Type = CreditNote => CInvoiceOriginalDebitBC
tdCInvoiceOpenAmountLCdecimal(2)BC Open Amt.Open amount is the total amount of the open item minus any credit to be applied(BC).
This field is calculated by the system using the tdCInvoiceOpenAmountTC.
tlCInvoiceIsReferencedlogicalReferenced. This field indicates if other invoices have linked to this invoice.
This field is calculated by the system.
tlShipToCountryIsEUCountrylogicalShip-To is an EU Country. This field indicates if the supplier's Ship-To address is in EU country.
This field is calculated by the system according to the ship-to address.
tiShipToAddressIdinteger
tiBusinessRelation_IDinteger
tcCreditorCodecharacterSupplier Code. The code that identifies the supplier to be paid with this invoice.
This field is calculated by the system.
tcBusinessRelationCodecharacterBusiness Relation.The business relation code linked to the supplier.
This field is calculated by the system using the supplier code.
tcBusinessRelationName1characterBusiness Relation Name. Calculated field displays the business relation name linked to the supplier.
tcDivisionCodecharacterSub-Account Code. This field displays the code of sub-account if the supplier control account is defined with sub-account analysis.
This sub-account applies to all invoice posting lines.
This field can be blank.
tcJournalCodecharacterDaybook Code. This field identifies an internal daybook that matches the invoice type: supplier invoice, invoice correction, credit note, or credit note correction.
This field is calculated by the system.
tcCurrencyCodecharacterCurrency Code.This filed identifies the currency of the invoice amount entered by the user.
tcReasonCodecharacterInvoice Status Code. This field determines the approval, payment, and allocation status of the invoice.
This field is calculated by the system.
api annotation:The initial code defaults from the supplier record.
CInvoiceCreationTimeStringcharacterSeconds since midnight in HH:MM:SS
tcNormalPaymentConditionCodecharacterCredit Terms Code. The calculated code identifies the credit terms that apply to this invoice.
When the credit terms code is changed, the invoice due date is recalculated.
api annotation:Credit terms code defaults from the credit term of the supplier record.
CInvoiceInvCertCertificatecharacterDuplicate field from SysProperty
tcBLWIGroupCodecharacterBLWI Group. This field identifies a BLWI group for the subject of this invoice, if valid.
The BLWI status applies to certain trade transactions for organizations in Belgium and Luxemburg only.
CInvoiceInvCertVersioncharacterVersion of the Certificate
tcTransactionStartCountryCodecharacterTransactionStart Country Code. This field identifies the start country of the transaction.
This field is calculated by the system.
CInvoiceInvCertKeycharacter
tcTransactionEndCountryCodecharacterTransactionEnd Country Code. This field identifies the end country of the transaction.
This field is calculated by the system.
CInvoiceInvCertSignatureCurrcharacter
tcProjectCodecharacterProject. The project to which this invoice is to be posted.
CInvoiceInvCertSignaturePrevcharacter
tcCostCentreCodecharacterCost Center Code. The cost center to which this invoice is to be posted.
CInvoiceInvCertSignatureShortcharacter4-character signature based upon the content of DInvoiceInvCertSignatureCurr
tcRoleNamecharacterRole Name. This field ensures that approval workflow is applied to the supplier invoice, with an approval request sent to the specified role.
This field is not blank only when automatic ad-hoc workflow is enabled and the Specific SI Approval field is selected in the Maintain System function.
This field is calculated by the system.
tcVatCurrencyCodecharacterCurrency Code.This field identifies the currency used by the invoice for tax use.
This field is calculated by the system.
tcShipToAddressCitycharacterCity. The city for the ship-to address.
This field is calculated by the system using the ship-to address city.
tcShipToAddressStatecharacterState. The state or province for the ship-to address.
This field is calculated by the system using the ship-to address.
tcShipToAddressStreet1characterAddress: Line one of the ship-to address details.
tcShipToAddressStreet2characterAddress: Line two of the ship-to address details.
This field can be blank.
tcShipToAddressStreet3characterAddress: Line three of the ship-to address details.
This field can be blank.
tcShipToAddressTypeCodecharacterAddress Type: A code that identifies the type of the ship-to address.
This field is calculated by the system.
tcShipToAddressZipcharacterZip. The postal code or US zip code associated with the ship-to address.
This field is calculated by the system.
tcShipToBusinessRelationCodecharacterBusiness Relation. This field identifies the Business relation of the ship-to address.
This field is calculated by the system according to the ship-to address.
tcShipToCountryCodecharacterCounty Code. This field identifies the county for the ship-to address.
This field is calculate by the system.
tcPurchaseTypeCodecharacterPurchase Type. The Purchase type of the invoice.
Purchase types group invoices together for reporting, letting you track your cash expenditures for different types of expenses.
This field can be blank.
tcControlGLCodecharacterAccount.This field identifies the supplier control GL account.
This field is calculated by the system according to the supplier.
tlShipFromCountryIsEUCountrylogicalShip-From is an EU Country. This field indicates if the Ship-From address is in EU country.
This field is calculated by the system.
tlControlGLIsDivisionAccountlogicalDivision Account. This filed indicates if the supplier control account is defined with sub-account analysis.
This field is calculated by the system.
tlCInvoiceIsReverseBySignlogicaltlCInvoiceIsReverseBySign. Calculated field for reversing invoices. Depending on a setup parameter in the AP control file, invoices are reversed with negative debits or credits instead of swtiching debit to credit and credit to debit.
tcShipFromTaxClasscharacterShip From Tax Class. The tax class of the Ship-From business relation, which is associated with the current entity.
This field is calculated by the system according to the supplier record.
tcShipFromTaxUsagecharacterShip From Tax Usage. The tax Usage of the Ship-From business relation, which is associated with the current entity.
This field is calculated by the system according to the supplier record.
tcShipFromTaxZonecharacterShip From Tax Zone. Calculated field identifies the tax zone of the Ship-From business relation, which is associated with the current entity.
tcShipFromCountryCodecharacterShip From Country Code.This field idetifies the country of the Ship-From business relation, which is associated with the current entity.
This field is calculated by the system.
tcCInvoiceReference1characterReference. The reference of other invoice linked to this invoices.
This field is calculated by the system according to the linked invoice.
tiLinkedCInvoiceVoucherintegerVoucher. The numeric identifier assigned to the posting linked to this invoice.
This field is calculated by the system according to the linked invoice.
tcLinkedJournalCodecharacterDaybook Code.This field identifies the daybook of other invoice linked to this invoices.
This field is calculated by the system according to the linked invoice.
tiLinkedPeriodYearintegerGL Calendar Year. The GL Calendar Year of other invoice linked to this invoices.
This field is calculated by the system according to the linked invoice.
tlDaybookOnInvoicelogicalDaybookOnInvoice. This field indicates whether or not the user can update the Daybook field on the UI. If it is true the field is editable if not then it is disabled.
This field is calculated by the system.
tcCInvoiceReferenceDuplicatecharacterCalculated field with the concatenated string holding following fields pipe-delimited:
o iiCompanyID
o icCreditorCode
o icCInvoiceType
o icCInvoiceReference
o ilCInvoiceIsInitialStatus
This is used to make sure we do only once get a warning in case we enter an invoice with a reference that already exists.
tlCInvoiceIsForLegalDoclogical
tiShipFromAddressIdinteger
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
CustomShort10character
CustomShort11character
CustomShort12character
CustomShort13character
CustomShort14character
CustomShort15character
CustomShort16character
CustomShort17character
CustomShort18character
CustomShort19character
CustomCombo10character
CustomCombo11character
CustomCombo12character
CustomCombo13character
CustomCombo14character
CustomDecimal5decimal(4)
CustomDecimal6decimal(4)
CustomDecimal7decimal(4)
CustomDecimal8decimal(4)
CustomDecimal9decimal(4)
CustomDecimal10decimal(4)
CustomDecimal11decimal(4)
CustomDecimal12decimal(4)
CustomDecimal13decimal(4)
CustomDecimal14decimal(4)
CustomDate5date
CustomDate6date
CustomDate7date
CustomDate8date
CustomDate9date
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoiceMovementCIJE

Description

ApiCInvoiceMovementCIJE

field namedata typedescription
CInvoiceMovement_IDinteger
CInvoice_IDinteger
PostingLine_IDinteger
Company_IDinteger
Period_IDinteger
Creditor_IDinteger
CInvoiceMovementTypecharacterCInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc).
CInvoiceMovementYearPeriodintegerYear/GL Period. This field indicates the accounting year and period for the invoice's movement.
CInvoiceMovementDiscountTCdecimal(4)CInvoiceMovementDiscountTC. The amount of payment discount in TC.
CInvoiceMovementPostDatedatePosting Date. The Posting Date of the Invoice's movement.
CInvoiceMovementIsForDraftlogicalFor Draft. This field indicates if the invoice is for draft use.
The invoice is initially saved as a draft. Draft invoices do not generate postings when saved, and so do not affect the AP sub-ledger or general ledger.
tcWHTPostingLineIDscharacterWHT Posting Line IDs : comma separated list of wht posting line id's, we need that for rolling back everything. for example, when you get error at moment of save of banking entry, then the wht posting lines must be rolled back automatically. method GetPostingInfoOfInstance will be extended
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoicePOCIJE

Description

ApiCInvoicePOCIJE

field namedata typedescription
CInvoicePO_IDinteger
CInvoice_IDinteger
CInvoicePOPoDomaincharacterPO Domain. This field indicates which domain the purchase order belongs to.
CInvoicePOPoNbrcharacterPO Number. This fields identifies the PO receipts which the invoice matches.
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoicePostingCIJE

Description

ApiCInvoicePostingCIJE

field namedata typedescription
CInvoicePosting_IDinteger
CInvoice_IDinteger
CIRECPostingLine_IDinteger
Posting_IDinteger
CInvoicePostingTypecharacterInvoice Type. This field displays the invoice type.
Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined.
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoiceStageCIJE

Description

ApiCInvoiceStageCIJE

field namedata typedescription
CInvoiceStage_IDinteger
CInvoice_IDinteger
PaymentConditionStaged_IDinteger
CInvoiceStageDueDatedateDue Date. The date when this stage should end.
CInvoiceStagePercentdecimal(10)CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for.
CInvoiceStageAmountTCdecimal(4)CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage.
CInvoiceStageAmountLCdecimal(4)CInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage.
CInvoiceStageAmountCCdecimal(4)CInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage.
CInvoiceStageAmtAppliedTCdecimal(4)CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage.
CInvoiceStageDiscDatedateCInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given.
CInvoiceStageDiscPercdecimal(3)CInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given.
CInvoiceStageTSMNumbercharacter
tcPaymentConditionCodecharacterCredit Terms Code. This field idetifies the Credit Term used in this stage.
tcPaymentConditionDescriptcharacterDescription. This field displays the description of the Credit Term used in this stage.
tdPaymentConditionPercentagedecimal(3)Discount Percentage. This field indicates the discount rate used in the stage.
This field is calculated using the Credit Term.
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoiceVatCIJE

Description

ApiCInvoiceVatCIJE

field namedata typedescription
CInvoiceVat_IDinteger
CInvoice_IDinteger
Vat_IDinteger
NormalTaxGL_IDinteger
NormalTaxDivision_IDinteger
AbsRetTaxGL_IDinteger
AbsRetTaxDivision_IDinteger
SuspDelTaxGL_IDinteger
SuspDelTaxDivision_IDinteger
PostingVat_IDinteger
CInvoiceVatVatBaseDebitLCdecimal(4)BC Base Amount DR. This field displays the debit base amount in the base currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
CInvoiceVatVatBaseCreditLCdecimal(4)BC Base Amount CR. This field displays the credit base amount in the base currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
CInvoiceVatVatBaseDebitTCdecimal(4)TC Base Amount DR. This field displays the debit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatBaseCreditTCdecimal(4)TC Base Amount CR. This field displays the credit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatBaseDebitCCdecimal(4)SC Base Amount DR. This field displays the debit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
CInvoiceVatVatBaseCreditCCdecimal(4)SC Base Amount CR. This field displays the credit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
CInvoiceVatVatDebitLCdecimal(4)BC Tax Amount DR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
CInvoiceVatVatCreditLCdecimal(4)BC Tax Amount CR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
CInvoiceVatVatDebitTCdecimal(4)TC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatCreditTCdecimal(4)TC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatDebitCCdecimal(4)SC Tax Amount DR. This field displays the debit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount DR and the SC rate.
CInvoiceVatVatCreditCCdecimal(4)SC Tax Amount CR. This field displays the credit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount CR and the SC rate.
CInvoiceVatIsTaxablelogicalTaxable. This field indicates if the invoice is taxable.
This field defaults to true if the supplier is taxable.
CInvoiceVatNonRecTaxAmtTCdecimal(4)Non-Rev Tax Amount. This field displays the percentage of tax that is not recoverable.
Taxes are recoverable whenever your company is eligible to offset a percentage of tax on purchases against tax collected on sales. Recoverable taxes are common in Europe.
CInvoiceVatIsUpdAllowlogicalUpdate Tax Allowed. When this is field is true, you can modify the base and tax credit and debit amounts during transaction entry.
This field is useful for overriding the system if there is a need to match amounts on manually issued documents. In some environments, tax authorities require that you cannot modify the calculated tax amounts.
CInvoiceVatIsAbsRetlogicalRetained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government.
CInvoiceVatIsAccrRcpUslogicalCInvoiceVatIsAccrRcpUS Tax is accrued at receipt. This is a parameter of the tax rate code in GTM.
CInvoiceVatTaxTrTypecharacterCInvoiceVatTaxTrType Tax transaction type. This is a parameter of the tax rate code in GTM.
CInvoiceVatIsRevChargelogicalCInvoiceIsRevCharge.This field indicates if the invoice tax is of type Reverse Charge.
CInvoiceVatUILinkedRowIDcharacter
CInvoiceVatSequenceintegerCInvoceVatSequence.The sequentiel number of the tax line on the invoice.
CInvoiceVatNTBaseDebitTCdecimal(4)TC Base Debit Non-taxable. This field displays the Non-taxable debit base amount in the transaction currency.
This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatNTBaseCreditTCdecimal(4)TC Base Credit Non-taxable. This field displays the Non-taxable credit base amount in the transaction currency.
This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatIsSuspDellogicalCInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM.
CInvoiceVatSuspDelTaxAmtTCdecimal(4)Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency.
TxuTaxUsagecharacterTax Usage. These fields default from the supplier, and can be modified.
TxenvTaxEnvcharacterTax Environment. This field is automatically calculated based on the supplier and ship-to address details, and can be modified.
TxclTaxClscharacterTax Class. This field default from the supplier, and can be modified.
TxtyTaxTypecharacterTax Type. This field displays the tax type, which defaults from the tax environment.
tdCInvoiceVatVatBaseDebitVCdecimal(4)Obsolete field.
tdCInvoiceVatVatBaseCreditVCdecimal(4)Obsolete field.
tdCInvoiceVatVatDebitVCdecimal(4)Obsolete field.
tdCInvoiceVatVatCreditVCdecimal(4)Obsolete field.
tlIsRecalculateTaxlogicalRecalc. When you change the tax class, tax usage, tax environment, or the Taxable fields or modify one of the base amounts, this field is automatically set to true,and the system recalculates the amounts when you have completed the line in the grid. You can also manually set this field to true or false.
tcDomainCodecharacterDomain. This field displays the doamin of the invoice (the current domain).
tcVatInOutcharactertcVatInOut Indication if the tax in Input (tax on purchases) or Output (tax on sales).
tcVatCodecharacterTax Code. This field displays the code of the tax rate, based on the tax environment for the combination of supplier and ship-to address.
tcNormalTaxGLCodecharacterNormal Tax Account. This field indicates the Gl account for tax use.
The Tax accounts are defined for the current domain in Domain/Account Control.
tcNormalTaxDivisionCodecharacterNormal Tax Sub-Account. This field indicates the sub-account if the supplier control account is defined with sub-account analysis.
tcAbsRetTaxGLCodecharacterRetained Tax Account. This field indicates the GL account used to retain the tax.
When you have selected the Retained/Absorbed options.
This field is defined in Tax Rate Maintenance.
tcAbsRetTaxDivisionCodecharacterRetained Tax Sub-Account.This field indicates the sub- Account used to retain the tax.
When you have selected the Retained/Absorbed options.
This field is defined in Tax Rate Maintenance.
tcSuspDelTaxGLCodecharacterDelayed Tax Account. This field indicates the GL account used to handle the delayed tax.
tcSuspDelTaxDivisionCodecharacterDelayed Tax Sub-Account. This field indicates the sub-account used to handle the delayed tax.
tlTx2InvDisclogicalDiscount invoice at Invoice?
tdCInvoiceVatExchangeRateCCdecimal(10)SC Exchange Rate
LastModifiedDatedate
LastModifiedTimeinteger
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiCInvoiceWHTCIJE

Description

Table contains withholding tax records.

field namedata typedescription
CInvoiceWHT_IDinteger
CInvoice_IDinteger
Vat_IDinteger
GL_IDinteger
Division_IDinteger
CInvoiceVat_IDinteger
CInvoiceWHTFeeDebitTCdecimal(4)
CInvoiceWHTFeeCreditTCdecimal(4)
CInvoiceWHTExpenseDebitTCdecimal(4)
CInvoiceWHTExpenseCreditTCdecimal(4)
CInvoiceWHTTaxFeeDebitTCdecimal(4)
CInvoiceWHTTaxFeeCreditTCdecimal(4)
CInvoiceWHTTaxFeeDebitCCdecimal(4)
CInvoiceWHTTaxFeeCreditCCdecimal(4)
CInvoiceWHTTaxFeeDebitLCdecimal(4)
CInvoiceWHTTaxFeeCreditLCdecimal(4)
CInvoiceWHTAmtDebitTCdecimal(4)
CInvoiceWHTAmtCreditTCdecimal(4)
CInvoiceWHTAmtDebitCCdecimal(4)
CInvoiceWHTAmtCreditCCdecimal(4)
CInvoiceWHTAmtDebitLCdecimal(4)
CInvoiceWHTAmtCreditLCdecimal(4)
CInvoiceWHTTaxPctdecimal(2)
CInvoiceWHTRecovTaxPctdecimal(2)
CInvoiceWHTTaxTypecharacter
CInvoiceWHTTaxTrTypecharacter
CInvoiceWHTIsUpdAllowlogical
CInvoiceWHTIsOrigFromAPMlogical
CInvoiceWHTBaseTaxPctdecimal(2)
tcVatCodecharacter
tcDomainCodecharacter
tcVatInOutcharacter
tcVatDescriptioncharacter
tctx2DesccharacterTax Rate Description
tdtx2TaxPctdecimal(2)
tdtx2PctRecvdecimal(2)Tax Percentage Recoverable
tctx2TaxTypecharacterTax Type
tcGLCodecharacter
tcDivisionCodecharacter
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiPostingCIJE

Description

ApiPostingCIJE

field namedata typedescription
Posting_IDinteger
Company_IDinteger
Journal_IDinteger
ReportingJournal_IDinteger
Period_IDinteger
PeriodMark_IDinteger
CreatorUsr_IDinteger
LastVerifiedUsr_IDinteger
LastApprovedUsr_IDinteger
AutoReversalPosting_IDinteger
PostingVoucherintegerVoucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
api annotation:In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
PostingDatedateThe accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
PostingSystemDatedateThe system date of the posting corresponding to "PostingDate".
api annotation:In Create mode, when Partial Update = yes - this field gets a default value which is the current date of the system.
PostingValueDatedateThe value date (used for banking entries).
PostingTextcharacterFree text describing the posting.
api annotation:Value for this field defaults to blank
PostingSecondTextcharacter
PostingBusinessRelationTxtcharacterWhen the posting is a transaction linked to a business relation (for example, an invoice posting), this field contains the Business Relation Name. Used for information purposes on reports and browses.
api annotation:Value for this field defaults to blank.
PostingInvoiceReferenceTxtcharacterWhen the posting is part of an invoice posting, then this field contains the invoice number (Year/Daybook/Voucher extended with supplier invoice Reference in case of a supplier invoice). Used for information purpose on reports and browsers.
api annotation:Value for this field defaults to blank
PostingParentTextcharacterContains the description field from the parent object that triggered the posting. When the posting is an invoice posting, this field contains the invoice description. When the posting is a banking entry posting, the description of the bank statement line is copied to this field, etc. Used for information purposes on reports and browses.
api annotation:Value for this field defaults to blank.
PostingPeriodintegerThe GL period for the posting. The period must be open.
PostingYearintegerThe GL calendar year for the posting.
PostingYearPeriodintegerThe GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear".
api annotation:If Partial Update is true, the value defaults using PostingPeriod and PostingYear.
PostingOriginIsExternallogicalIndicate whether the posting is from an External Origin. When creating cross company postings, set this to true.
api annotation:Value for this field defaults to false.
PostingOriginReferencecharacterGL Reference Number. Format is ZZYYMMDD999999 where ZZ = module (IC, SO, WO) YY = Year, MM = Month, DD = Day, 999999 = Running Journal Number.
MfgPro equivalent: glt_ref
PostingOriginDocumentcharacterTransaction History Number (Inventory or Operations) or Invoice Number (Sales Order)
MfgPro equivalent: glt_doc
PostingOriginDocumentTypecharacterDocument Type (I for Invoice, OP for Work Orders)
MfgPro equivalent: glt_doc_type
PostingOriginTransTypecharacterSystem generated code used to identify a transaction (IC for Inventory, WO for Work Orders, SO for Sales Orders, FA for Fixed Assets)
MfgPro equivalent: glt_tr_type
PostingOriginDaybookCodecharacterDaybook Code (normally this corresponds with our JournalCode)
MfgPro equivalent: glt_dy_code
PostingOriginDaybookNumbercharacterDaybook Number (normally this corresponds with our PostingVoucher)
MfgPro equivalent: glt_dy_num
PostingBatchNumbercharacterSome financial input programs allow you to enter a batch number and to keep a control total on the screen of all the transactions entered with the same batch number.
api annotation:Not applicable for application integration.
PostingOriginAddressCodecharacterFor invoices created with Invoice Post and Print, the address code of the bill-to customer is stored in this field.
PostingOriginatorReferencecharacterOriginal Posting Reference. this field must contain the key values of the refered posting, if this posting is a manual reversal or replacement of an existing posting.
api annotation:Value for this field defaults to blank.
PostingIsReplacementlogicalIndicate whether the posting is a replacement of an existing posting.
api annotation:Value for this field defaults to "false". For reversal postings, either automatic or manual - this value defaults to "true".
PostingIsReversinglogicalIndicate whether the posting is a reversal of an existing posting.
api annotation:Value for this field defaults to "false".
PostingIsReversingBySignlogicalIndicate whether the mathematical inversion - inverse the mathematic sign of the amounts (+ => - and - => +) - has been applied.
api annotation:Value for this field defaults to "false".
PostingIsZeroValueAllowedlogicalIndicate whether zero values are allowed in the posting lines.
api annotation:Value for this field defaults to "false".
PostingIsSkipAutoAssignLClogicalWhen a LC field (Base Currency Amount field of PostingLine) is left zero, but the TC field (transaction currency amount) is not zero, then the posting component automatically calculates the corresponding value for the LC field. With some postings, this behavior is not wanted and can be suppressed by setting this flag to "true".
api annotation:Value for this field defaults to "false".
PostingAddGLNbrintegerWhen additional GL numbering is enabled for an entity, all postings for this entity are assigned a continuous, uninterrupted incremental sequence numbers as the value for this field.
api annotation:When additional GL numbering is not enabled for the current entity, value for this field defaults to 0.
PostingAddGLNbrDatedate
PostingAddGLNbrRevDatedate
PostingVerifyStatuscharacterChina Financial Regulation requires that all GL transactions be verified as well as approved. This field holds the verification status.
api annotation:Value for this field defaults to "INITIAL".
PostingVerifyCommentscharacterWhen running the process of verification, the verifier can add some comments on the transaction.
api annotation:Value for this field defaults to blank.
PostingVerifiedDatedateThe date when this posting is last verified.
api annotation:Value for this field defaults to blank.
PostingVerifiedTimeintegerLast Verified Time.
api annotation:System generates a default value for this field depending on when this posting was last verified. The combination of "PostingVerifiedDate" and "PostingVerifiedTime" uniquely identify the time at which this posting was last verified.
PostingApproveStatuscharacterChina Financial Regulation requires that all the GL transactions must be verified as well as approved. This field holds the Approval status.
api annotation:Value for this field defaults to "INITIAL".
PostingApproveCommentscharacterWhen running the process of approval, the approver can add some comments on the transaction.
api annotation:Value for this field defaults to blank.
PostingApprovedDatedateThe date on which this posting was last approved.
api annotation:Value for this field defaults to blank.
PostingApprovedTimeintegerLast Approved Time.
api annotation:The system generates default values for this field, depending on when this posting was last approved. The combination of "PostingApprovedDate" and "PostingApprovedTime" uniquely identify the time at which this posting was last approved.
PostingMirrorRefcharacterWhen Mirror Accounting is activated, postings that are mirrored get a reference to their paired posting. The reference contains year, daybook and voucher.
api annotation:Value for this field defaults to blank.
PostingIsAutoReversallogicalIndicate whether the posting leads to an automatic reversal.
api annotation:Value for this field defaults to "false".
PostingAutoReversalTypecharacterIf this posting is involved in automatic reversal activity of posting, value of this field will indicate whether this posting is the original one or the reversing one. It is calculated by the system.
api annotation:If the flag PostingIsAutoReversal is "true", the field value defaults to "ORIGINAL ENTRY" for the original posting, and to "REVERSING ENTRY" for the reversing posting.
PostingAutoReversalDatedateAutomatic Reversal Date.
api annotation:When the flag PostingIsAutoReversal is "true" - If partialupdate="false", complete this field manually with a date in a later period than the one of the original entry; If partialupdate="true", value of this field will default to the first day of the next period.
PostingBankImpRefcharacter
PostingIsCorrectionlogicalIndicates whether the posting is part of a correction action.
api annotation:Value for this field defaults to "false".
ObsoleteClosing_IDinteger
PostingCreationDatedate
PostingCreationTimeStringcharacterSeconds since midnight in HH:MM:SS
tcLocalCurrencycharacterLocal currency code
api annotation:?
tcStatutoryCurrencycharacterStatutory Currency.
tcTemplateCodecharacterTemplate Code. A code which identifies a template.
api annotation:Value for this field defaults to null. If the flag "tlSaveAsTemplate" is on, you should enter a string in this field as the posting template code.
tlSaveAsTemplatelogicalIndicate whether to save the posting lines of this journal entry as a template.
api annotation:Value for this field defaults to "false".
tiSharedCompanyIdintegerID of the CompanyShared record.
tiYearForNbrintegerYear used for additional GL numbering.
tlIsAddGLNbrlogicalAdditional GL Numbering Enabled.
Indicate whether additional GL numbering is required.
tiOriginVoucherintegerOriginal Voucher - just a calculated field used by the software as temporary storage during execution of the logic.
tiOriginPostingIdintegerOriginal Posting ID?
tcJournalCodecharacterThe daybook code of this posting.
api annotation:The daybook must be an active daybook in the shared set for the current entity. When the accounting layer linked to the daybook tcJournalCode is not of type "Official", some GL types are not allowed, e.g. DEBTORCONTROL, CREDITORCONTROL, VAT.

When the accounting layer linked to the daybook tcJournalCode is of type "TRANSIENT"; then the GL type cannot be OPENITEM and INVENTORY.
tcLayerTypeCodecharacterThe layer type of the used daybook.
api annotation:Default value for this field depends on the daybook used.
tcJournalTypeCodecharacterThe daybook type of the daybook used.
api annotation:For journal entries, this field defaults to "JOURNAL ENTRY". In other types of transactions (e.g. banking entry/invoices etc), this field must be set to the correct journal type.
tiLayer_IDintegerID of the posting daybook layer.
tcUsrLogincharacterThe creator of the posting.
tcPeriodTypeCodecharacterType code of the GL period 'normal', 'correction', 'closing'.
tcReportingJournalCodecharacterFor AR and AP transactions, it is possible to have additional daybooks under which a posting should be classified during tax reporting.
api annotation:For AP/AR transactions, this field defaults to the journal code of the posting. Otherwise, it remains blank.
tlJournalAccessAllowedlogicalUsed to determine whether a user has access to modify a posting
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
CustomShort10character
CustomShort11character
CustomShort12character
CustomShort13character
CustomShort14character
CustomCombo10character
CustomCombo11character
CustomCombo12character
CustomCombo13character
CustomCombo14character
CustomDecimal5decimal(4)
CustomDecimal6decimal(4)
CustomDecimal7decimal(4)
CustomDecimal8decimal(4)
CustomDecimal9decimal(4)
CustomDate5date
CustomDate6date
CustomDate7date
CustomDate8date
CustomDate9date
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiPostingLineCIJE

Description

ApiPostingLineCIJE

field namedata typedescription
PostingLine_IDinteger
Company_IDinteger
PostingLineMaster_IDinteger
PostingLineTransaction_IDinteger
Posting_IDinteger
CostCentre_IDinteger
Currency_IDinteger
Division_IDinteger
GL_IDinteger
Project_IDinteger
IntercoBusinessRelation_IDinteger
Period_IDinteger
CrossCompany_IDinteger
CrossCompanyPosting_IDinteger
CrossCompanyPostingLine_IDinteger
PostingLineSequenceinteger
PostingLineTextcharacter
api annotation:Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting.
PostingLineDebitLCdecimal(4)
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale.
BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field.
PostingLineDebitTCdecimal(4)
PostingLineDebitCCdecimal(4)
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale.
SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field.
PostingLineDebitPCdecimal(4)
api annotation:This field is obsolete.
PostingLineCreditLCdecimal(4)
api annotation:Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale.
BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field.
PostingLineCreditTCdecimal(4)
PostingLineCreditCCdecimal(4)
api annotation:Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale.
SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field
PostingLineCreditPCdecimal(4)
api annotation:This field is obsolete and can be left blank.
PostingLineIsProjPostinglogical
PostingLineQTYdecimal(10)
api annotation:Value for this field defaults to 0.0000.
PostingLineProjectTextcharacter
api annotation:Value for this field defaults to blank.
PostingLineCostCentreTextcharacter
api annotation:Value for this field defaults to blank.
PostingLineSafTextcharacter
api annotation:Value for this field defaults to blank.
PostingLineExchangeRatedecimal(10)
api annotation:Default value for this field depends on the exchang erate shared set specified for the current domain.
PostingLineRateScaledecimal(10)
api annotation:The default value is 1.
PostingLineCCRatedecimal(10)The exchange rate used to convert between transaction (TC) and statutory(SC) amounts.
api annotation:Default value for this field depends on the exchangerate shared set specified for the current domain.
PostingLineCCScaledecimal(10)A decimal number that must be multiplied by the exchange rate to get the real exchange rate. Its format is 9999999.9999999 and it was introduced to extend the accuracy of the exchange rate.
api annotation:The default value is 1.
PostingYearPeriodintegerThe GL calendar year/period for the journal entry.
api annotation:In Create mode, it will get be defaulted to the value for the field PostingYearPeriod of tPosting.
PostingDatedatePosting Date.
api annotation:If this field is blank, it gets a default value equal to the value of PostingDate in tPosting.
PostingLineCrossExternRefcharacterExt Reference (Cross-Cy) - must be filled when create a cross-company posting.
api annotation:Value for this field defaults to blank.
PostingLineOriginLineNbrintegerEquivalent to PostingLineSequence, however there is a difference in format and the value may differ in a number of specific cases.
MfgPro Equivalent: glt_line
api annotation:Value for this field defaults to 0.
PostingLineMirrorRefcharacterThis holds a reference number to link the source and mirror postinglines together.
--> Source account 1 and mirror account 1 will have the same reference.
--> Source account 2 and mirror account 2 will also have the same reference (but different from source and mirror account 1).
api annotation:Value for this field defaults to blank.
PostingLineMirrorTypecharacterSOURCE or MIRROR (Depending if the posting line uses the source account or the mirror account).
api annotation:Value for this field defaults to blank.
PostingLineAddGLNbrinteger
PostingLineGrossIncAccRefcharacter
PostingLineAddGLNbrDatedate
PostingLineLegalDocNbrcharacter
tcProjectDescriptioncharacter
tcGLCodecharacterThe GL account used in this posting line.
api annotation:This GL account must be active and from the shared set of the entity. The same GL account can appear twice or more in the same posting.

GL accounts used in the postings must be of type 'Manual'.

When the GL account is an open item account, the postings on the account are stored as individual items with a balance.

Each posting on this account type results either from the creation of a new open item ('INITIAL") or a change in the balance of an existing open item ("MOVEMENT").
tlPostingLineIsLocalCurrencylogicalThis flag indicates that the currency for the posting line is the base currency. This is set automatically.
tiVatPostIDintegerVAT post ID
tcGLDescriptioncharacter
tlGLIsAutomaticAccountlogical
tcGLTypeCodecharacter
api annotation:GL accounts used in the postings must be of type "Manual".

When the account is an open item account, then the postings on the account are stored as individual items with a balance.

Each possting on this account type results from either the creation of a new open item ("INITIAL") or a change in the balance of an existing open item ("MOVEMENT").
tcUnitCodecharacter
tcAllocationTypecharacterType of the open item posting. For example, a new item or a link to an existing item.
api annotation:Each posting line for an open item account must contain either:

Information for the creation of a new open item.
tcAllocationType = "INITIAL",
tcAllocationKey = a new mnemonic (reference to an open item).

Or

a reference to an existing posting on the same account .
tcAllocationType = "MOVEMENT"
tcAllocationKey = an existing reference to an open item.
tcAllocationKeycharacterReference key to an open item.
api annotation:Each posting line for an open item account must contain either:

Information for the creation of a new open item.
tcAllocationType = "INITIAL",
tcAllocationKey = a new mnemonic (reference to an open item).

Or

a reference to an existing posting on the same account .
tcAllocationType = "MOVEMENT"
tcAllocationKey = an existing reference to an open item.
tcAllocationPostingLinecharacter
tcIntercoBusinessRelationCodecharacterWhen the GL is an intercompany account (Intercompany Account box checked), then an intercompany business relation must be entered on the posting line.
api annotation:When the field tcIntercoBusinessRelationCode is blank and the GL has a default business relation specified, this default is used.

When the account is a fixed intercompany account (Fixed Intercompany box checked), the default intercompany business relation is the only valid value.
tcCurrencyCodecharacterThe currency code of this posting line.
api annotation:If a tcCurrencyCode is supplied for a local currency posting, this currency must be the local currency of the current entity.

When the posting account is a single currency account, then the posting line must contain the currency in tcCurrencyCode.

When a posting is in the local currency of the entity, the TC amount must equal the LC value.
tcDivisionCodecharacterThe sub-account code of the GL account used in this posting line.
api annotation:When the account is defined with sub-account analysis, then a sub-account must be entered on the posting line. If so, then this field defaults to the sub-account found in the account definition.

The account and sub-account combination must be allowed by the COA mask.
tcCostCentreCodecharacterThe cost center code of the account used in this posting line.
api annotation:When the account is defined with cost center analysis, a cost center code must be entered on the posting line. The field defaults to the cost center in the account definition (if specified).

The account and cost center combination must be allowed by the COA mask.

If the posting account allows dual analysis, then both cost center and project analysis must be specified on the posting line. If left blank, the default values found in the account definition are used.
tcProjectCodecharacterThe project code of the account used in this posting line.
api annotation:When the account is defined with project analysis, a project code must be entered on the posting line. The field defaults to the project in the account definition (if specified).

The account and project combination must be allowed by the COA mask.

If the posting account allows dual analysis, then both cost center and project analysis must be specified on the posting line. If left blank, the default values found in the account definition are used.
tlGLIsDebitAccountlogical
tcCrossCompanyCurrencyCodecharacterCrossCompanyCurrencyCode
tcCrossCompanyGLCodecharacter
api annotation:Cross-company is a special type of intercompany. When the data of the other company is also in the same database, you can create a cross-company posting that generates a second posting in that other company's accounting. Both postings balance each other and are also linked to each other. So cross-company postings are pairs of postings where one posting is in one entity and the other posting is in another entity. Both postings are linked to each other with reference fields.
tcCrossCompanyIntercoCodecharacter
tcCrossCompanyCodecharacter
tcDivisionDescriptioncharacter
tlLinkedCrCyDaemonReqExistslogicalThis calculated field is set to True when the posting is a cross-company posting and is created by the cross-company daemon, otherwise its value is set to false, and no logic is applied to calculate the field value for modified records
tcCostCentreDescriptioncharacter
tlSkipCOAValForPeriodCostinglogical
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
CustomShort10character
CustomShort11character
CustomShort12character
CustomShort13character
CustomShort14character
CustomShort15character
CustomShort16character
CustomShort17character
CustomShort18character
CustomShort19character
CustomCombo10character
CustomCombo11character
CustomCombo12character
CustomCombo13character
CustomCombo14character
CustomDecimal5decimal(4)
CustomDecimal6decimal(4)
CustomDecimal7decimal(4)
CustomDecimal8decimal(4)
CustomDecimal9decimal(4)
CustomDate5date
CustomDate6date
CustomDate7date
CustomDate8date
CustomDate9date
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiPostingSafCIJE

Description

ApiPostingSafCIJE

field namedata typedescription
PostingSaf_IDinteger
PostingLine_IDinteger
Saf_IDinteger
SafStructure_IDinteger
Posting_IDinteger
PostingSafParentTypecharacterParent Type. Indicates the parent type of this SAF record.
PostingSafInputSequenceintegerSequence number of this SAF within all the SAF lines for the same posting line.
tcSafCodecharacterThe SAF Code used in this posting. Must be of concept "tcSafConceptCode".
tcSafConceptCodecharacterThe SAF concept of this posting, part of the SAF structure in "tcSafStructureCode".
tcSafStructureCodecharacterThe SAF structure.
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
CustomShort0character
CustomShort1character
CustomShort2character
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiPostingVatCIJE

Description

ApiPostingVatCIJE

field namedata typedescription
PostingVat_IDinteger
Posting_IDinteger
PostingLine_IDinteger
Vat_IDinteger
VatRule_IDinteger
VatPeriod_IDinteger
PeriodMark_IDinteger
Currency_IDinteger
VatGroup_IDinteger
PostingVatBaseDebitLCdecimal(4)BC (Base/Local Currency) Base Debit amount.
PostingVatBaseDebitTCdecimal(4)TC (Transaction Currency) Base Debit amount.
PostingVatBaseDebitCCdecimal(4)SC (Statutory Currency) Base Debit amount.
PostingVatBaseCreditLCdecimal(4)BC (Base/Local Currency) Base Credit amount.
PostingVatBaseCreditTCdecimal(4)TC (Transaction Currency) Base Credit amount.
PostingVatBaseCreditCCdecimal(4)SC (Statutory Currency) Base Credit amount.
PostingVatExchangeRatedecimal(10)TC/BC Exchange Rate.
api annotation:?
PostingVatRateScaledecimal(10)Scale Factor (TC/BC).
api annotation:?
PostingVatInOutcharacterIn/Out?
api annotation:Aivalable value for this field: "INPUT" represents purchases, "OUTPUT" represents sales.
PostingVatTaxPointDatedateThe date when this posting is taken into account in the Tax sub-adminstration.
api annotation:?
PostingVatTaxTransTypecharacterTax Transaction Type?
api annotation:Available value for this field: 29 represents "AP Payment Check (Discount at Payment)", 55 represents "AP Transactions", 22 represents "AP Invoice", 18 represents "AR Invoice", 16 represents "AR Operational Invoice", 19 represents "AR Payment (Discount at Payment)", 56 represents "AR Transactions", 45 represents "Logistic Accounting - DO Shipment", 27 represents "Logistic Accounting - PO Receipt", 43 represents "Logistic Accounting - SO Shipment", 20 represents "Purchase Order", 21 represents "Purchase Order Receipt", 25 represents "Purchase Order Return"
PostingVatTransTypecharacterTransaction Type?
api annotation:Available value for this field is: ACQUISITION represents "IC Acquisition", BOTH represents "Both", EXPORT represents "Export", IN represents "IN", OUT represents "OUT", IMPORT represents "Import", INLAND-PURCHASE represents "INLAND-PURCHASE", INLAND-SALES represents "INLAND-SALES", PURCHASE represents "Inland Purchase", SALES represents "Inland Sales", SUPPLY represents "IC Supply", TRIANGULARPURCHASE represents "Triangular Purchase", TRIANGULARSALES represents "Triangular Sales".
PostingVatTaxDebitLCdecimal(4)BC (Base Currency) Tax Debit amount.
api annotation:?
PostingVatTaxDebitCCdecimal(4)SC (Statutory Currency) Tax Debit amount.
api annotation:?
PostingVatTaxDebitTCdecimal(4)TC (Transaction Currency) Tax Debit amount.
api annotation:?
PostingVatTaxCreditLCdecimal(4)BC (Base/Local) Tax Credit amount.
api annotation:?
PostingVatTaxCreditCCdecimal(4)SC (Statutory Currency) Tax Credit amount.
api annotation:?
PostingVatTaxCreditTCdecimal(4)TC (Transaction Currency) Tax Credit amount.
api annotation:?
PostingVatTaxIDFedercharacterFederal Tax?
api annotation:?
PostingVatTaxIDStatecharacterState Tax?
api annotation:?
PostingVatTaxIDMisc1characterMiscellaneous Tax 1. For reference and documentation
purposes, enter any other tax identification numbers that are useful.
api annotation:?
PostingVatTaxIDMisc2characterMiscellaneous Tax 2
PostingVatTaxIDMisc3characterMiscellaneous Tax 3
PostingVatOwnTaxIDFedercharacterOwn Federal Tax?
api annotation:?
PostingVatOwnTaxIDStatecharacterOwn State Tax?
api annotation:?
PostingVatOwnTaxIDMisc1characterOwn Miscellaneous Tax 1? For reference and documentation purposes, enter any other tax identification numbers that are useful.
api annotation:?
PostingVatOwnTaxIDMisc2characterOwn Miscellaneous Tax 2
PostingVatOwnTaxIDMisc3characterOwn Miscellaneous Tax 3
PostingVatOwnTaxDeclaratinteger
PostingVatIsReverseChargelogical
PostingVatIsAbsRetlogical
PostingVatIsSuspDellogical
TxtyTaxTypecharacter
TxclTaxClscharacterTax Class. A tax class previously defined in Tax Class Maintenance. Tax classes group addresses taxed at specific rates or that are tax-exempt and help determine the default tax environment (set of tax types) for related transactions.
api annotation:The value of Tax Class defaults to the header of transactions created for this address
TxuTaxUsagecharacterTax Usage. A tax usage code previously defined in Tax Usage Maintenance. Tax usage codes identify the normal use of items sold to this address. Common tax usages are retail, manufacturing, and industrialization.
api annotation:The value of Tax Usage defaults to the header of transactions created for this address.
TxenvTaxEnvcharacterTax Environment. A code (maximum 16 characters) that
identifies a set of tax types for a tax zone/tax class combination. On transactions, this code identifies the transaction or line-item tax environment.
api annotation:?
FromTxzTaxZonecharacterFrom Tax Zone.
api annotation:?
ToTxzTaxZonecharacterTo Tax Zone
api annotation:?
tcCurrencyCodecharacter
tdFullDebitTCdecimal(4)Amount including VAT
tdFullCreditTCdecimal(4)Amount including VAT
tdTotalVatDebitTCdecimal(4)
tdTotalVatCreditTCdecimal(4)
tcVatCodecharacterThe TaxCode for this posting. This code determines the registrations in the tax sub-ledger.
tcVatDescriptioncharacter
tcDomainCodecharacter
tcVatInOutcharacter
tcVatGroupCodecharacter
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

table tApiPostingVatDelayCIJE

Description

ApiPostingVatDelayCIJE

field namedata typedescription
Vat_IDinteger
VatRule_IDinteger
PostingLine_IDinteger
VatPeriod_IDinteger
PeriodMark_IDinteger
PostingVatDelay_IDinteger
Currency_IDinteger
Posting_IDinteger
PostingVatDelayBaseDebLCdecimal(4)BC (Base/Local Currency) Base Debit amount.
api annotation:?
PostingVatDelayBaseCredLCdecimal(4)BC (Base/Local Currency) Base Credit amount.
api annotation:?
PostingVatDelayBaseDebTCdecimal(4)TC (Trasaction Currency) Base Debit amount.
api annotation:?
PostingVatDelayBaseCredTCdecimal(4)TC (Transaction Currency) Base Credit amount.
api annotation:?
PostingVatDelayBaseDebCCdecimal(4)SC (Statutory Currency) Base Debit amount.
api annotation:?
PostingVatDelayBaseCredCCdecimal(4)SC (Statutory Currency) Base Credit amount.
PostingVatDelayTaxPntDatedateTax Point Date?
PostingVatDelayVATBalLCdecimal(4)BC (Base/Local Currency) Tax Balance.
PostingVatDelayVATOrigLCdecimal(4)BC (Base/Local Currency) Tax Original.
PostingVatDelayIsOpenlogicalOpen?
PostingVatDelayExchRatedecimal(10)Exchange Rate?
PostingVatDelayRateScaledecimal(10)Scale Factor?
PostingVatDelayTaxIDFedercharacterFederal Tax ID?
PostingVatDelayTaxIDStatecharacterState Tax ID?
PostingVatDelayTaxIDMisc1characterMiscellaneous Tax 1.
PostingVatDelayTaxIDMisc2characterMiscellaneous Tax 2.
PostingVatDelayTaxIDMisc3characterMiscellaneous Tax 3.
PostingVatDelayOwnTaxIDFedcharacterOwn Federal Tax ID?
PostingVatDelayOwnTaxIDStcharacterOwn State Tax ID?
PostingVatDelayOwnTaxIDM1characterOwn Miscellaneous Tax 1 ID.
PostingVatDelayOwnTaxIDM2characterOwn Miscellaneous Tax 2 ID.
PostingVatDelayOwnTaxIDM3characterOwn Miscellaneous Tax 3 ID.
PostingVatDelayOwnTaxDeclintegerOwn Tax Declaration.
tcVatCodecharacter
tcVatDescriptioncharacter
tdFullDebitTCdecimal(4)
tdFullCreditTCdecimal(4)
tdTotalVatDebitTCdecimal(4)
tdTotalVatCreditTCdecimal(4)
tcCurrencyCodecharacter
tcDomainCodecharacter
tcVatInOutcharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter

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