| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoice_ID | integer | yes | Record ID |
| Company_ID | integer | yes | Link to Company |
| Period_ID | integer | yes | Link to Period |
| Debtor_ID | integer | yes | Link to Debtor |
| Division_ID | integer | no | Sub-Account |
| Journal_ID | integer | yes | Daybook Code |
| LinkedDInvoice_ID | integer | no | Voucher |
| DInvoiceCurrency_ID | integer | yes | Currency Code |
| Reason_ID | integer | yes | Invoice Status Code |
| NormalPaymentCondition_ID | integer | yes | Credit Terms Code |
| DeliveryCond_ID | integer | no | Link to DeliveryCond |
| OwnVatNumber_ID | integer | no | Link to VatNumber |
| DebtorVatNumber_ID | integer | no | Link to VatNumber |
| TransactionStartCountry_ID | integer | no | Country Code |
| TransactionEndCountry_ID | integer | no | Country Code |
| Project_ID | integer | no | Project |
| CostCentre_ID | integer | no | Cost Center |
| VatCurrency_ID | integer | no | Tax Declaration Currency |
| ShipFromAddress_ID | integer | no | Address |
| ShipToAddress_ID | integer | no | City |
| SoldToDebtor_ID | integer | yes | Customer Code |
| ControlGL_ID | integer | yes | Account |
| Bill_ID | integer | no | Link to Bill |
| DInvoicePostingDate | date | yes | Posting Date. This field displays the date the sales-related invoice was generated by Invoice Post and Print. This field is updated when the invoice is validated and saved. |
| api annotation: | This field defaults from the invoice creation date. | ||
| DInvoiceType | character(20) | yes | Invoice 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. |
| api annotation: | PartialUpdate = yes - defaults to Invoice | ||
| value list: | {&INVOICETYPES} | ||
| DInvoiceVoucher | integer | yes | Voucher.This field displays the numeric identifier assigned to the posting. When the daybook of the journal entry is charged(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. |
| DInvoiceDate | date | yes | Invoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period. The system uses the invoice date with the credit terms to calculate due date and discount date. |
| api annotation: | This field defaults to the DInvoicePostingDate. | ||
| DInvoiceTaxPointDate | date | yes | Tax Point Date. The date to be used in tax calculations. For sales-related invoices, this field displays the tax calculation date on the associated order. |
| api annotation: | This field defaults to DInvoicePostingDate. | ||
| DInvoiceDescription | character(40) | no | Description. A brief description of the invoice. This field is mandatory. |
| DInvoiceOriginalDebitLC | decimal(4) | no | 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. |
| DInvoiceOriginalCreditLC | decimal(4) | no | 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. |
| DInvoiceOriginalDebitTC | decimal(4) | no | 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. |
| DInvoiceOriginalCreditTC | decimal(4) | no | 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. |
| DInvoiceOriginalDebitCC | decimal(4) | no | 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. |
| DInvoiceOriginalCreditCC | decimal(4) | no | 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. |
| DInvoiceExchangeRate | decimal(10) | yes | Exchange Rate. The accounting 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. |
| DInvoiceRateScale | decimal(10) | no | Scale Factor.This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. The exchange rate is multiplied by the scale factor to determine the actual exchange rate. |
| api annotation: | The value for the scale factor defaults from the exchange rate definition, but it can be modified. | ||
| DInvoiceCCRate | decimal(10) | no | SC Rate. The statutory exchange rate used by the invoice. The SC Invoice Amount is calculated based on the SC rate. |
| DInvoiceCCScale | decimal(10) | no | Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments. |
| DInvoiceContact | character(40) | no | Contact. The contact name for the customer. |
| DInvoiceIsPaymentAllowed | logical | yes | CN Payment Allowed. This field applies to only credit notes;otherwise, it is read-only. Selecting the field indicates that the customer credit note can be included in a payment selection. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| DInvoiceTSMNumber | character(40) | no | Payment Reference. This field contains a reference number to identify a customer payment for this invoice. Normally this could be a unique transaction structured message (TSM) number. The TSM is a standard reference numbering system for electronic transfers,used by many banks. |
| DInvoiceDueDate | date | yes | Due Date. This field displays the date when payment is due, calculated by the system based on the credit terms and the invoice date. User can modify the due date without affecting the credit terms. If the credit terms have a base date specified, this is used in the due date calculations rather than the invoice creation date. |
| DInvoiceDiscountDueDate | date | no | Discount Due Date. This field displays the last date a discount applies, calculated by the system based on the credit terms and the invoice date. You can modify the due date without affecting the credit terms. If the credit terms have a base date specified, this is used in the due date calculations rather than the invoice creation date. |
| DInvoiceBillDate | date | no | Bill Date |
| DInvoiceVatBaseDebitLC | decimal(4) | no | 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. |
| DInvoiceVatBaseCreditLC | decimal(4) | no | 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. |
| DInvoiceVatBaseDebitTC | decimal(4) | no | 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. |
| DInvoiceVatBaseCreditTC | decimal(4) | no | 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. |
| DInvoiceVatBaseDebitCC | decimal(4) | no | 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. |
| DInvoiceVatBaseCreditCC | decimal(4) | no | 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. |
| DInvoiceVatDebitLC | decimal(4) | no | 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. |
| DInvoiceVatCreditLC | decimal(4) | no | 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. |
| DInvoiceVatDebitTC | decimal(4) | no | 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. |
| DInvoiceVatCreditTC | decimal(4) | no | 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. |
| DInvoiceVatDebitCC | decimal(4) | no | 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. |
| DInvoiceVatCreditCC | decimal(4) | no | 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. |
| DInvoiceDIText | character(40) | yes | CIDescription. A brief description for the SI posting. |
| api annotation: | This field defaults from the DInvoiceDescription. | ||
| DInvoiceBalanceDebitLC | decimal(4) | no | 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. |
| DInvoiceBalanceCreditLC | decimal(4) | no | 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. |
| DInvoiceBalanceDebitTC | decimal(4) | no | TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. |
| DInvoiceBalanceCreditTC | decimal(4) | no | TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. |
| DInvoiceBalanceDebitCC | decimal(4) | no | 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. |
| DInvoiceBalanceCreditCC | decimal(4) | no | 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. |
| DInvoiceIsOpen | logical | no | Open.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 | ||
| DInvoiceCombinedStatus | character(20) | no | This field is obsoleted. |
| DInvoiceIsSelected | logical | no | Selected. This field indicates whether the invoice is included in a payment selection. This field is read-only. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| DInvoiceBalanceLC | decimal(4) | no | 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. |
| DInvoiceBalanceTC | decimal(4) | no | Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency. |
| DInvoiceBalanceCC | decimal(4) | no | 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. |
| DInvoiceReminderCount | integer | no | Reminder Counter. This field displays the reminder level that applies to this invoice. |
| value list: | {&REMINDER-LEVELS} | ||
| DInvoiceClosingDate | date | no | Closing Date. This field displays the date on which the open balance became zero. |
| DinvoiceLastReminderDate | date | no | Last Reminder Date.Date of last Customer Reminder Letter. |
| DInvoiceIsVatDelay | logical | no | Tax Delay. This field indicates if the Taxes on purchase orders and customer invoices or credit notes are delayed. |
| DInvoicePostingPeriod | integer | yes | GL 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. | ||
| DInvoicePostingYear | integer | yes | Year.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. | ||
| DInvoicePostingYearPeriod | integer | yes | Year/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. | ||
| DInvoiceVatExchangeRate | decimal(10) | no | 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. |
| DInvoiceVatRateScale | decimal(10) | no | Tax Rate Scale. This field indicates the scale factor applying to the tax exchange rate in use for foreign currency payments. |
| DInvoiceCommentNote | character(2000) | no | Comment. This field contains user's comment of the invoice. |
| DInvoicePaymentDate | date | no | Expected Payment Date.This field displays the date when payment is expected to be received. The expected payment date is used in cash flow reporting. If you manually change the due date to a date later than the expected payment date, this date is automatically updated. |
| api annotation: | This field defaults to the due date when the invoice is created. | ||
| DInvoiceOwnVatNumber | character(40) | no | Own 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. | ||
| DInvoiceDebtorVatNumber | character(40) | no | Customer Tax Number. This field indicates the tax number used by the customer The value for this field is the State Tax ID of the headoffice address of the business relation associated with the customer. |
| DInvoiceIsTaxable | logical | yes | Taxable. This field indicates if the invoice is taxable. |
| api annotation: | This field defaults to true if the customer is taxable. | ||
| DInvoiceBatch | character(8) | no | Batch Number. This field is used to identify a group of customer invoices created at one time using Evaluated Receipts Settlement (ERS) functions. |
| DInvoiceSalesAmt | decimal(4) | no | Sales Amount. This field indicates the amount for which the salespersons should receive commission credit. This is normally the invoice total minus any non-commissioned charges such as freight or tax. |
| api annotation: | This defaults from the order and is the only field that can be modified in this tab. | ||
| DInvoicePurchaseOrder | character(22) | no | Purchase Order.If a purchase order number was recorded on the original sales order, it displays in this field. This number indicates the original number of the document that initiated the sale, and can be useful when communicating with the customer. |
| DInvoiceSlsPsn1 | character(8) | no | Salesperson 1.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | ||
| DInvoiceSlsPsn2 | character(8) | no | Salesperson 2.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | ||
| DInvoiceSlsPsn3 | character(8) | no | Salesperson 3.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | ||
| DInvoiceSlsPsn4 | character(8) | no | Salesperson 4.This field displays the salesperson specified on the order to receive commission and quota credit for the order. |
| api annotation: | The commission percentage defaults from the salesperson record. | ||
| DInvoiceComm1 | decimal(2) | no | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | ||
| DInvoiceComm2 | decimal(2) | no | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | ||
| DInvoiceComm3 | decimal(2) | no | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | ||
| DInvoiceComm4 | decimal(2) | no | Salesperson Commission. This field displays the commission percentage each salesperson receives. |
| api annotation: | For invoices posted from sales orders, this field defaults from the associated sales order. For manually created invoices, commission defaults from Salesperson Commission Detail, if rates have been defined for the customer; otherwise, from the salesperson record. | ||
| DInvoiceGraceDays | integer | no | Grace Days. This field indicates the number of days to be added to the financial due date of the invoice, after which interest charges are calculated. |
| api annotation: | This field default to zero. | ||
| DInvoiceDiscPercentage | decimal(2) | no | Discount Percentage. This field indicates the discount percentage that can be given when the invoice is paid before the discount due date. |
| DInvoiceLateInt | decimal(2) | no | This field is obsoleted. |
| DInvoiceMarginAmountTC | decimal(4) | no | Margin Amount. This field is not used in Financial's module. It is updated in Operational (Invoice post and print and is equal to Line total + discount amount - total extended cost). |
| DInvoiceIsExternal | logical | yes | External. This field indicates if the daybook used is external. This field is calculated by the system using the daybook code. |
| DInvoiceShipToCode | character(8) | no | Ship-To Code.The code that identifies the address receiving the items being invoiced. you can change it to another valid ship-to defined for the business relation in Customer Ship-To Create. The system uses the tax detail for the ship-from and ship-to addresses to select the correct tax environment for tax calculation. For the ship-from, this is the headoffice address of the business relation. For the ship-to, the tax details defined for the customer record are used. |
| api annotation: | This field defaults from the sold-to address. | ||
| DInvoiceIsTaxExcluded | logical | yes | Tax 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. PartialUpdate = yes - defaults to false | ||
| DInvoiceIsWithBank | logical | yes | With Bank. This field indicates if the invoice has a customer bank number specified for it. |
| api annotation: | PartialUpdate = yes - defaults to true | ||
| DInvoiceLastFinChargeDate | date | no | Last Finance Charge Date. Date last finance charge was applied |
| DInvoiceIsDiscTaxAtInv | logical | yes | Discount Tax at Invoice.This field indicates if the invoice has a discount for tax. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| DInvoiceIsDiscTaxAtPaym | logical | yes | Discount 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 | ||
| DInvoiceNonDiscAmtTC | decimal(4) | no | TC Non-discount Amount. This field display the invoice amount without discount in base currency. |
| DInvoiceNonDiscAmtLC | decimal(4) | no | 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. |
| DInvoiceNonDiscAmtCC | decimal(4) | no | 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. |
| DInvoiceCreationDate | date | no | Creation Date |
| DInvoiceCreationTimeString | character(10) | no | Seconds since midnight in HH:MM:SS |
| DInvoiceInvCertCertificate | character(16) | no | Duplicate field from SysProperty |
| DInvoiceInvCertVersion | character(8) | no | Version of the Certificate |
| DInvoiceInvCertKey | character(128) | no | Invoice Certification Key |
| DInvoiceInvCertSignatureCurr | character(256) | no | Signature Current Invoice |
| DInvoiceInvCertSignaturePrev | character(256) | no | Signature Previous Invoice |
| DInvoiceInvCertSignatureShort | character(4) | no | 4-character signature based upon the content of DInvoiceInvCertSignatureCurr |
| DInvoiceIsWithDeduction | logical | yes | With Deduction |
| DInvoiceSalesOrderList | character(255) | no | Sales Orders |
| DInvoiceShipperList | character(255) | no | Shippers |
| DInvoiceLegalDocumentList | character(255) | no | Legal Documents |
| DInvoiceGoldenTaxInvoiceList | character(255) | no | Golden Tax Invoices |
| tdDInvoiceOriginalTC | decimal(4) | no | Original TC Amount if Type = Invoice => DInvoiceOriginalDebitTC if Type = CreditNote => DInvoiceOriginalCreditTC |
| tdDInvoiceOriginalLC | decimal(4) | no | Original LC Amount if Type = Invoice => DInvoiceOriginalDebitLC if Type = CreditNote => DInvoiceOriginalCreditLC |
| tcLocalCurrencyCode | character(3) | no | Base Currency. This fields inficates the base currency used by the invoice. |
| tdTotalAmountCreditTC | decimal(4) | no | total credit amount in TC =>sum of the DInvoiceVatBaseCreditTC and DInvoiceVatCreditTC |
| tdTotalAmountDebitTC | decimal(4) | no | total debit amount in TC =>sum of the DInvoiceVatBaseDebitTC and DInvoiceVatDebitTC |
| tiVatCurrencyNumDec | integer | no | This field is obsoleted. |
| tiOverdueDays | integer | no | Overdue 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. |
| tcDInvoiceNumber | character(50) | no | Invoice Number. The system generate invoice number based on the daybook code. |
| tdDInvoiceOriginalAmount | decimal(2) | no | TC Original Amt. Calculated field for the original amount. |
| tdDInvoiceOpenAmount | decimal(2) | no | 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. |
| tlDInvoiceIsReferenced | logical | no | Referenced. This field indicates if other invoices have linked to this invoice. This field is calculated by the system. |
| tdDInvoiceOriginalAmountLC | decimal(2) | no | BC Original Amount if Type = Invoice => CInvoiceOriginalCreditBC if Type = CreditNote => CInvoiceOriginalDebitBC |
| tdDInvoiceOpenAmountLC | decimal(2) | no | 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. |
| tiShipFromAddressId | integer | no | |
| tcPayFormatTypePayInstrument | character(20) | no | Payment Instrument. This field displays the payment instrument defined for payments to this customer from your bank account. |
| tdTotalAmountWithTaxesTC | decimal(4) | no | TC Amount With Taxes.This field holds the total invoice amount with taxes in TC (necessary for excluded tax). |
| tiBusinessRelation_ID | integer | yes | |
| tcBusinessRelationCode | character(20) | yes | Business Relation.The business relation code linked to the customer. This field is calculated by the system using the customer code. |
| tcBusinessRelationName1 | character(36) | yes | Business Relation Name. Calculated field displays the business relation name linked to the customer. |
| tcDebtorCode | character(8) | yes | Customer Code. The code that identifies the customer to be paid with this invoice. This field is calculated by the system. |
| tdDebtorHighCredit | decimal(4) | yes | High Credit.This field displays the highest amount of credit extended to this customer to date,which is equivalent to the largest AR balance so far reported. The amount is recalculated with each revision of the customer credit limit. |
| tdDebtorSalesOrderBalance | decimal(4) | yes | Balance of Sales Orders.This field displays the total amount of customer sales orders generated in all entities. The following types of orders are included: Discrete sales orders, both confirmed and unconfirmed Pending invoices Return Material Authorizations from Service/Support Management |
| tcDivisionCode | character(8) | no | Sub-Account Code. This field displays the code of sub-account if the customer control account is defined with sub-account analysis. This sub-account applies to all invoice posting lines. This field can be blank. |
| tcJournalCode | character(8) | yes | Daybook Code. This field identifies an internal daybook that matches the invoice type: customer invoice, invoice correction, credit note, or credit note correction. This field is calculated by the system. |
| tiLinkedDInvoiceVoucher | integer | no | Voucher. The numeric identifier assigned to the posting linked to this invoice. This field is calculated by the system according to the linked invoice. |
| tcLinkedJournalCode | character(8) | no | Daybook 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. |
| tiLinkedPeriodYear | integer | no | GL 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. |
| tcCurrencyCode | character(3) | yes | Currency Code.This filed identifies the currency of the invoice amount entered by the user. |
| tcReasonCode | character(20) | yes | Invoice 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 customer record. | ||
| tcNormalPaymentConditionCode | character(8) | yes | Credit 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 customer record. | ||
| tcTransactionStartCountryCode | character(3) | no | TransactionStart Country Code. This field identifies the start country of the transaction. This field is calculated by the system. |
| tcTransactionEndCountryCode | character(3) | no | TransactionEnd Country Code. This field identifies the end country of the transaction. This field is calculated by the system. |
| tcProjectCode | character(8) | no | Project. The project to which this invoice is to be posted. |
| tcCostCentreCode | character(4) | no | Cost Center Code. The cost center to which this invoice is to be posted. |
| tcVatCurrencyCode | character(3) | no | Currency Code.This field identifies the currency used by the invoice for tax use. This field is calculated by the system. |
| tcShipFromAddressCity | character(30) | no | City. The city for the ship-from address. This field is calculated by the system using the ship-from address city. |
| tcShipFromAddressState | character(20) | no | State. The state or province for the ship-from address. This field is calculated by the system using the ship-from address. |
| tcShipFromAddressStreet1 | character(36) | no | Address: Line one of the ship-from address details. |
| tcShipFromAddressStreet2 | character(36) | no | Address: Line two of the ship-from address details. This field can be blank. |
| tcShipFromAddressStreet3 | character(36) | no | Address: Line three of the ship-from address details. This field can be blank. |
| tcShipFromAddressTypeCode | character(20) | no | Address Type: A code that identifies the type of the ship-from address. This field is calculated by the system. |
| tcShipFromAddressZip | character(10) | no | Zip. The postal code or US zip code associated with the ship-from address. This field is calculated by the system. |
| tcShipFromBusinessRelationCode | character(20) | no | Business Relation. This field identifies the Business relation of the ship-from address. This field is calculated by the system according to the ship-from address. |
| tcShipFromCountryCode | character(3) | no | County Code. This field identifies the county for the ship-from address. This field is calculate by the system. |
| tcShipToAddressCity | character(30) | no | City. The city for the ship-to address. This field is calculated by the system using the ship-to address city. |
| tcShipToAddressState | character(20) | no | State. The state or province for the ship-to address. This field is calculated by the system using the ship-to address. |
| tcShipToAddressStreet1 | character(36) | no | Address: Line one of the ship-to address details. |
| tcShipToAddressStreet2 | character(36) | no | Address: Line two of the ship-to address details. This field can be blank. |
| tcShipToAddressStreet3 | character(36) | no | Address: Line three of the ship-to address details. This field can be blank. |
| tcShipToAddressTypeCode | character(20) | no | Address Type: A code that identifies the type of the ship-to address. This field is calculated by the system. |
| tcShipToAddressZip | character(10) | no | Zip. The postal code or US zip code associated with the ship-to address. This field is calculated by the system. |
| tcShipToBusinessRelationCode | character(20) | no | Business 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. |
| tcShipToCountryCode | character(3) | no | County Code. This field identifies the county for the ship-to address. This field is calculate by the system. |
| tcSoldToDebtorCode | character(8) | yes | Sold To Customer Code. This code identifies the sold-to customer who received the items being invoiced. The sold-to address displays on the printed invoice. |
| api annotation: | On a new manually created invoice, the code entered for the Customer on the General tab displays by default. | ||
| tcControlGLCode | character(8) | yes | Account.This field identifies the customer control GL account. This field is calculated by the system according to the customer. |
| tcDAJournalCode | character(20) | no | Adjustment.Journal Code for the Debtor Adjustment Posting. |
| tiDAVoucher | integer | no | SA Voucher. Voucher of Debtor Adjusment Posting. |
| tcOwnVatNumberCountryCode | character(20) | no | Own 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. |
| tcNormalPaymentConditionType | character(20) | yes | Credit 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 customer record accosiated with the invoice. | ||
| tcShipFromTaxIdState | character(40) | no | Ship-From Tax ID State. Ship-From State Tax. |
| tcDebVatNumberCountryCode | character(20) | no | Customer Tax Number Country Code. This field indicates the tax number Country of the customer. This field is calculated by the system according to the customer Tax Number. |
| tlShipFromCountryIsEUCountry | logical | no | Ship-To is an EU Country. This field indicates if the customer's Ship-To address is in EU country. This field is calculated by the system according to the ship-to address. |
| tcShipFromTaxZone | character(16) | no | Ship From Tax Zone. Calculated field identifies the tax zone of the Ship-From business relation, which is associated with the current entity. |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| CustomShort10 | character(20) | no | Custom Short Field |
| CustomShort11 | character(20) | no | Custom Short Field |
| CustomShort12 | character(20) | no | Custom Short Field |
| CustomShort13 | character(20) | no | Custom Short Field |
| CustomShort14 | character(20) | no | Custom Short Field |
| CustomShort15 | character(20) | no | Custom Short Field |
| CustomShort16 | character(20) | no | Custom Short Field |
| CustomShort17 | character(20) | no | Custom Short Field |
| CustomShort18 | character(20) | no | Custom Short Field |
| CustomShort19 | character(20) | no | Custom Short Field |
| CustomCombo10 | character(20) | no | Custom Combo Field |
| CustomCombo11 | character(20) | no | Custom Combo Field |
| CustomCombo12 | character(20) | no | Custom Combo Field |
| CustomCombo13 | character(20) | no | Custom Combo Field |
| CustomCombo14 | character(20) | no | Custom Combo Field |
| CustomDecimal5 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal6 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal7 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal8 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal9 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal10 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal11 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal12 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal13 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal14 | decimal(4) | no | Custom Decimal Field |
| CustomDate5 | date | no | Custom Date Field |
| CustomDate6 | date | no | Custom Date Field |
| CustomDate7 | date | no | Custom Date Field |
| CustomDate8 | date | no | Custom Date Field |
| CustomDate9 | date | no | Custom Date Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | no | empty string |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoiceBank_ID | integer | yes | Record ID |
| DInvoice_ID | integer | yes | Link to DInvoice |
| BankNumber_ID | integer | yes | Formatted Bank Account No |
| DInvoiceBankToPayTC | decimal(4) | no | TC Payment Amount. This field displays the payment amount in the transaction currency. |
| tcOwnBankNumber | character(20) | no | Own Bank Number. This field displays the account number that receives payments from this customer. This number is defined on the customer record, and is normally the default bank account number for the entity you are currently working in. |
| tcPayFormatTypeCode | character(20) | no | Payment Format. The payment format you have defined for payments from your bank to this customer. The value of the field can only be the formats initially defined for the account. This field is calculated by the system. |
| tlDInvoiceIsReferenced | logical | no | Referenced. This field indicates if other invoices have linked to this invoice. This field is calculated by the system. |
| tcPayFormatTypePayInstrument | character(20) | no | Payment Instrument. The payment instrument defined for payments to this customer from your bank account. This field is calculated by the system. |
| tlValidatePayment | logical | no | Validate the payment when the dinvoicebank amount is changed : when you come from payment selection it is false, otherwise true. |
| tcBankNumber | character(40) | yes | Bank Number. The customer bank account number. This field is mandatory when the payment instrument for the customer is electronic. This field is calculated by the system. |
| tcBankNumberExtension | character(20) | yes | Extension. 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. |
| tcBankNumberFormatted | character(40) | yes | Formatted Number. This field displays the customer bank account number, formatted according to the validation you applied. This field is calculated by the system. |
| tcBankNumberSwiftCode | character(40) | yes | SWIFT 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. |
| tcBankNumberValidation | character(20) | yes | Validation. This field identifies the bank format validation for the customer 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. |
| tiBankPayFormat_ID | integer | yes | |
| tcBusinessRelationCode | character(20) | yes | Business Relation Code. This field displays the business relation for the customer's bank, and contains bank addressing information. This field is calculated by the system. |
| tiParentObject_ID | integer | yes | |
| tcCompanyCode | character(20) | no | Entity Code. This field identifies the entity in which you are working in. |
| tcOwnGLCode | character(20) | no | Own Gl Account.The default customer bank account configured for the customer. If you have configured multiple accounts for this customer, 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. |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoice.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoiceBankPayCode_ID | integer | yes | Record ID |
| DInvoiceBank_ID | integer | yes | Link to DInvoiceBank |
| PayFormatCode_ID | integer | no | Link to PayFormatCode |
| PayFormatGroup_ID | integer | no | Link to PayFormatGroup |
| DInvoiceBankPayCodeValue | character(40) | no | Attribute Value.The value of 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. | ||
| tcPayFormatGroupCode | character(20) | no | PayFormat Attribute level. This field indicates which level the new attributes belongs to. |
| tlPayFormatGroupIsMandatory | logical | no | Mandatory. This field indicates if the new field added by the user is mandatory for input. |
| tcPayFormatCode | character(20) | no | Payment Format. The name of a new attribute of the payment Format. This field is defined in payment format maintenance. |
| tcPayFormatGroupDataType | character(20) | no | Data Type. This field indicates the data type of the attribute added by the user. |
| tcPayFormatGroupInputOption | character(20) | no | Input Option. This field indicates if a payment attribute value can be entered manually (editable) or has to be selected from a list (selectable). |
| tcPayFormatGroupDescription | character(20) | no | Attribute Name Description. This field displays the description of the Attribute added by the user. |
| tcPayFormatCodeDescription | character(20) | no | Attribute Description. A brief description of the attribute. |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoiceBank.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoiceDeduction_ID | integer | yes | Record ID |
| DInvoice_ID | integer | yes | Link to DInvoice |
| DeductionCatLine_ID | integer | yes | Link to DeductionCatLine |
| ApprovePosting_ID | integer | no | Link to ApprovePosting |
| RejectPosting_ID | integer | no | Link to RejectPosting |
| PaidDInvoice_ID | integer | no | Link to PaidDInvoice |
| DInvoiceDeductionTC | decimal(4) | yes | Deduction TC |
| DInvoiceDeductionLC | decimal(4) | yes | Deduction BC |
| DInvoiceDeductionCC | decimal(4) | yes | Deduction SC |
| DInvoiceDeductionStatus | character(40) | no | Deduction Status |
| DInvoiceDeductionComment | character(2000) | no | Comment |
| DInvoiceDeductionApRejCom | character(80) | no | Approve/Reject Comment |
| DInvoiceDeductionApRejDate | date | no | Approve/Reject Date |
| DInvoiceDeductionCreateDate | date | no | Create Date |
| DInvoiceDeductionSequence | integer | no | Sequence |
| DInvoiceDeductionCustRef | character(20) | no | Customer Reference |
| DInvoiceDeductionPromotionCode | character(20) | no | Promotion Code |
| tcDeductionCatCode | character(20) | no | |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| CustomShort0 | character(20) | no | |
| CustomShort1 | character(20) | no | |
| CustomShort2 | character(20) | no | |
| CustomShort3 | character(20) | no | |
| CustomShort4 | character(20) | no | |
| CustomShort5 | character(20) | no | |
| CustomShort6 | character(20) | no | |
| CustomShort7 | character(20) | no | |
| CustomShort8 | character(20) | no | |
| CustomShort9 | character(20) | no | |
| CustomCombo0 | character(20) | no | |
| CustomCombo1 | character(20) | no | |
| CustomCombo2 | character(20) | no | |
| CustomCombo3 | character(20) | no | |
| CustomCombo4 | character(20) | no | |
| CustomCombo5 | character(20) | no | |
| CustomCombo6 | character(20) | no | |
| CustomCombo7 | character(20) | no | |
| CustomCombo8 | character(20) | no | |
| CustomCombo9 | character(20) | no | |
| CustomLong0 | character(255) | no | |
| CustomLong1 | character(255) | no | |
| CustomNote | character(2000) | no | |
| CustomDate0 | date | no | |
| CustomDate1 | date | no | |
| CustomDate2 | date | no | |
| CustomDate3 | date | no | |
| CustomDate4 | date | no | |
| CustomInteger0 | integer | no | |
| CustomInteger1 | integer | no | |
| CustomInteger2 | integer | no | |
| CustomInteger3 | integer | no | |
| CustomInteger4 | integer | no | |
| CustomDecimal0 | decimal(4) | no | |
| CustomDecimal1 | decimal(4) | no | |
| CustomDecimal2 | decimal(4) | no | |
| CustomDecimal3 | decimal(4) | no | |
| CustomDecimal4 | decimal(4) | no | |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoice.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoiceMovement_ID | integer | yes | Record ID |
| DInvoice_ID | integer | yes | Link to DInvoice |
| PostingLine_ID | integer | yes | Link to PostingLine |
| Company_ID | integer | no | Link to Company |
| Period_ID | integer | no | Link to Period |
| Debtor_ID | integer | no | Link to Debtor |
| DInvoiceMovementType | character(20) | yes | CInvoiceMovementType. "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). |
| DInvoiceMovementYearPeriod | integer | no | Year/GL Period. This field indicates the accounting year and period for the invoice's movement. |
| DInvoiceMovementDiscountTC | decimal(4) | no | CInvoiceMovementDiscountTC. The amount of payment discount in TC. |
| DInvoiceMovementPostDate | date | no | Posting Date. The Posting Date of the Invoice's movement. |
| DInvoiceMovementIsForDraft | logical | yes | For 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. |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoice.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoiceOpInfo_ID | integer | yes | Record ID |
| DInvoice_ID | integer | yes | Link to DInvoice |
| DInvoiceOpInfoType | character(20) | yes | Type. The type of the OpInfo Records. ValuesList: SALESORDER, SHIPPER. |
| value list: | {&DINVOICEOPINFOTYPES} | ||
| DInvoiceOpInfoCode | character(20) | yes | Identifier. This field identifies an opinfo record. |
| DInvoiceOpInfoDescription | character(40) | no | Description. A brief description for the OpInfo information. |
| DInvoiceOpInfoGTDocNbr | character(20) | no | Golden Tax Document Number |
| DInvoiceOpInfoGTUpdateType | character(20) | no | Golden Tax Update Type |
| CustomShort0 | character(20) | no | Custom Short Field |
| CustomShort1 | character(20) | no | Custom Short Field |
| CustomShort2 | character(20) | no | Custom Short Field |
| CustomShort3 | character(20) | no | Custom Short Field |
| CustomShort4 | character(20) | no | Custom Short Field |
| CustomShort5 | character(20) | no | Custom Short Field |
| CustomShort6 | character(20) | no | Custom Short Field |
| CustomShort7 | character(20) | no | Custom Short Field |
| CustomShort8 | character(20) | no | Custom Short Field |
| CustomShort9 | character(20) | no | Custom Short Field |
| CustomCombo0 | character(20) | no | Custom Combo Field |
| CustomCombo1 | character(20) | no | Custom Combo Field |
| CustomCombo2 | character(20) | no | Custom Combo Field |
| CustomCombo3 | character(20) | no | Custom Combo Field |
| CustomCombo4 | character(20) | no | Custom Combo Field |
| CustomCombo5 | character(20) | no | Custom Combo Field |
| CustomCombo6 | character(20) | no | Custom Combo Field |
| CustomCombo7 | character(20) | no | Custom Combo Field |
| CustomCombo8 | character(20) | no | Custom Combo Field |
| CustomCombo9 | character(20) | no | Custom Combo Field |
| CustomLong0 | character(255) | no | Custom Long Field |
| CustomLong1 | character(255) | no | Custom Long Field |
| CustomNote | character(2000) | no | Custom Note Field |
| CustomDate0 | date | no | Custom Date Field |
| CustomDate1 | date | no | Custom Date Field |
| CustomDate2 | date | no | Custom Date Field |
| CustomDate3 | date | no | Custom Date Field |
| CustomDate4 | date | no | Custom Date Field |
| CustomInteger0 | integer | no | Custom Integer Field |
| CustomInteger1 | integer | no | Custom Integer Field |
| CustomInteger2 | integer | no | Custom Integer Field |
| CustomInteger3 | integer | no | Custom Integer Field |
| CustomInteger4 | integer | no | Custom Integer Field |
| CustomDecimal0 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal1 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal2 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal3 | decimal(4) | no | Custom Decimal Field |
| CustomDecimal4 | decimal(4) | no | Custom Decimal Field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoice.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoicePosting_ID | integer | yes | Record ID |
| DInvoice_ID | integer | yes | Link to DInvoice |
| Posting_ID | integer | yes | Link to Posting |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoice.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoiceStage_ID | integer | yes | Record ID |
| DInvoice_ID | integer | yes | Link to DInvoice |
| PaymentConditionStaged_ID | integer | no | Credit Terms Code |
| DInvoiceStageDueDate | date | yes | Due Date. The date when this stage should end. |
| DInvoiceStagePercentage | decimal(10) | no | Percentage. CInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for. |
| DInvoiceStageAmountTC | decimal(4) | yes | TC Amount. CInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage. |
| DInvoiceStageAmountLC | decimal(4) | yes | BC Amount. CInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage. |
| DInvoiceStageAmountCC | decimal(4) | no | SC Amount. CInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage. |
| DInvoiceStageAmtAppliedTC | decimal(4) | no | TC Applied Amount. CInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage. |
| DInvoiceStageDiscDate | date | no | CInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given. |
| DInvoiceStageDiscPerc | decimal(3) | no | CInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given. |
| DInvoiceStageIsSelected | logical | no | Used to indicate if a customer invoice stage is included on a payment selection. |
| tcPaymentConditionCode | character(8) | no | Credit Terms Code. This field idetifies the Credit Term used in this stage. |
| tcPaymentConditionDescript | character(40) | no | Description. This field displays the description of the Credit Term used in this stage. |
| tdPaymentConditionPercentage | decimal(3) | no | Discount Percentage. This field indicates the discount rate used in the stage. This field is calculated using the Credit Term. |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoice.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | mnd. | description |
|---|---|---|---|
| DInvoiceVat_ID | integer | yes | Record ID |
| DInvoice_ID | integer | yes | Link to DInvoice |
| Vat_ID | integer | no | Domain |
| NormalTaxGL_ID | integer | no | Normal Tax Account |
| NormalTaxDivision_ID | integer | no | Normal Tax Sub-Account |
| AbsRetTaxGL_ID | integer | no | Absorbed Tax Account |
| AbsRetTaxDivision_ID | integer | no | Absorbed Tax Sub-Account |
| SuspDelTaxGL_ID | integer | no | Suspended Tax Account |
| SuspDelTaxDivision_ID | integer | no | Suspended Tax Sub-Account |
| PostingVat_ID | integer | no | Link to PostingVat |
| DInvoiceVatVatBaseDebitLC | decimal(4) | no | 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. |
| DInvoiceVatVatBaseCreditLC | decimal(4) | no | 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. |
| DInvoiceVatVatBaseDebitTC | decimal(4) | no | 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. |
| DInvoiceVatVatBaseCreditTC | decimal(4) | no | 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. |
| DInvoiceVatVatBaseDebitCC | decimal(4) | no | 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. |
| DInvoiceVatVatBaseCreditCC | decimal(4) | no | 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. |
| DInvoiceVatVatDebitLC | decimal(4) | no | 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. |
| DInvoiceVatVatCreditLC | decimal(4) | no | 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. |
| DInvoiceVatVatDebitTC | decimal(4) | no | 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. |
| DInvoiceVatVatCreditTC | decimal(4) | no | 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. |
| DInvoiceVatVatDebitCC | decimal(4) | no | 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. |
| DInvoiceVatVatCreditCC | decimal(4) | no | 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. |
| DInvoiceVatIsTaxable | logical | yes | Taxable. This field indicates if the invoice is taxable. |
| api annotation: | This field defaults to true if the customer is taxable. | ||
| DInvoiceVatIsUpdAllow | logical | yes | Update 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. |
| DInvoiceVatIsAbsRet | logical | yes | Retained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government. |
| DInvoiceVatIsAccrRcpUs | logical | yes | Accrue at Receipt/Usage. Tax is accrued at receipt. This is a parameter of the tax rate code in GTM. |
| DInvoiceVatTaxTrType | character(2) | no | Tax transaction type. This is a parameter of the tax rate code in GTM. |
| DInvoiceVatIsRevCharge | logical | no | Reverse Charge.This field indicates if the invoice tax is of type Reverse Charge. |
| DInvoiceVatUILinkedRowID | character(30) | no | Linked Row |
| DInvoiceVatSequence | integer | no | Sequence.The sequentiel number of the tax line on the invoice. |
| api annotation: | PartialUpdate = yes - defaults to 1 | ||
| DInvoiceVatNTBaseDebitTC | decimal(4) | no | 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. |
| DInvoiceVatNTBaseCreditTC | decimal(4) | no | 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. |
| DInvoiceVatIsSuspDel | logical | yes | CInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| DInvoiceVatSuspDelTaxAmtTC | decimal(4) | no | Tax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency. |
| TxuTaxUsage | character(8) | no | Tax Usage. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax usage being applied, if any. Select a different tax class if necessary. |
| api annotation: | This field defaults from the customer,and can be modified. | ||
| TxenvTaxEnv | character(16) | no | Tax Environment. This field is automatically calculated based on the customer and ship-to address details, and can be modified. |
| TxclTaxCls | character(3) | no | Tax Class. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax class being applied, if any. |
| api annotation: | This field default from the customer, and can be modified. | ||
| TxtyTaxType | character(16) | no | Tax Type. This field displays the tax type, which defaults from the tax environment. |
| tdDInvoiceVatVatBaseDebitVC | decimal(4) | no | This field is obsoleted. |
| tdDInvoiceVatVatBaseCreditVC | decimal(4) | no | This field is obsoleted. |
| tdDInvoiceVatVatDebitVC | decimal(4) | no | This field is obsoleted. |
| tdDInvoiceVatVatCreditVC | decimal(4) | no | This field is obsoleted. |
| tlIsRecalculateTax | logical | no | Recalc. 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. |
| tcDomainCode | character(8) | no | Domain. This field displays the doamin of the invoice (the current domain). |
| tcVatInOut | character(20) | no | Tax In/Out. Indication if the tax in Input (tax on purchases) or Output (tax on sales). |
| api annotation: | PartialUpdate = yes - defaults to output | ||
| tcVatCode | character(20) | no | Tax Code. This field displays the code of the tax rate, based on the tax environment for the combination of customer and ship-to address. |
| tcNormalTaxGLCode | character(8) | no | Normal Tax Account. This field indicates the Gl account for tax use. The Tax accounts are defined for the current domain in Domain/Account Control. |
| tcNormalTaxDivisionCode | character(8) | no | Normal Tax Sub-Account. This field indicates the sub-account if the customer control account is defined with sub-account analysis. |
| tcAbsRetTaxGLCode | character(8) | no | Retained 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. |
| tcAbsRetTaxDivisionCode | character(8) | no | Retained 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. |
| tcSuspDelTaxGLCode | character(8) | no | Delayed Tax Account. This field indicates the GL account used to handle the delayed tax. |
| tcSuspDelTaxDivisionCode | character(8) | no | Delayed Tax Sub-Account. This field indicates the sub-account used to handle the delayed tax. |
| tlIsAvataxTaxLine | logical | no | Is the tax line a Avatax tax line i.e. using tax method 40 |
| LastModifiedDate | date | no | Last Modified Date |
| LastModifiedTime | integer | no | Last Modified Time |
| LastModifiedUser | character(20) | no | Last Modified User |
| QADC01 | character(40) | no | unused QAD reserved field |
| QADC02 | character | no | unused QAD reserved field |
| QADT01 | date | no | unused QAD reserved field |
| QADD01 | decimal(10) | no | unused QAD reserved field |
| tc_Rowid | character | yes | primary index |
| tc_ParentRowid | character | yes | = tDInvoice.tc_Rowid |
| tc_Status | character | no | update status |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |
| field name | data type | description |
|---|---|---|
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| tc_ParentRowid | character | |
| tc_Status | character |