field name | data type | description |
---|---|---|
CInvoice_ID | integer | |
Company_ID | integer | |
Period_ID | integer | |
Creditor_ID | integer | |
Division_ID | integer | |
Journal_ID | integer | |
LinkedCInvoice_ID | integer | |
CInvoiceCurrency_ID | integer | |
Reason_ID | integer | |
NormalPaymentCondition_ID | integer | |
BLWIGroup_ID | integer | |
OwnVatNumber_ID | integer | |
CreditorVatNumber_ID | integer | |
TransactionStartCountry_ID | integer | |
TransactionEndCountry_ID | integer | |
Project_ID | integer | |
CostCentre_ID | integer | |
Role_ID | integer | |
VatCurrency_ID | integer | |
ShipToAddress_ID | integer | |
PurchaseType_ID | integer | |
ControlGL_ID | integer | |
ReplacedCInvoice_ID | integer | |
CInvoicePostingDate | date | Posting Date. This filed indicates the date on which the invoice is to be posted. |
api annotation: | This field defaults from the invoice creation date. | |
CInvoiceType | character | Invoice 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. |
CInvoiceVoucher | integer | Voucher. 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. |
CInvoiceDate | date | Invoice 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. | |
CInvoiceTaxPointDate | date | Tax Point Date.This field indicates the date to be used in tax calculations. |
api annotation: | This field defaults from the posting date. | |
CInvoiceReference | character | Reference. 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. |
CInvoiceDescription | character | Description. A brief description of the invoice. The system generates a default description based on the Reference and Supplier Code. |
CInvoiceOriginalDebitLC | decimal(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. |
CInvoiceOriginalCreditLC | decimal(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. |
CInvoiceOriginalDebitTC | decimal(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. |
CInvoiceOriginalCreditTC | decimal(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. |
CInvoiceOriginalDebitCC | decimal(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. |
CInvoiceOriginalCreditCC | decimal(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. |
CInvoiceExchangeRate | decimal(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. |
CInvoiceRateScale | decimal(10) | Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. |
CInvoiceCCRate | decimal(10) | SC Rate. The statutory exchange rate used by the invoice. The SC Invoice Amount is calculated based on the SC rate. |
CInvoiceCCScale | decimal(10) | Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments. |
CInvoiceAllocationStatus | character | Allocation 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. |
CInvoiceIsLockPayment | logical | Lock 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 | |
CInvoiceIsInvoiceApproved | logical | Invoice Approved. This field indicates if the invoice is already approved for payment. |
api annotation: | PartialUpdate = yes - defaults to false | |
CInvoiceContact | character | Contact. 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. | |
CInvoiceTSMNumber | character | Payment 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. |
CInvoiceDueDate | date | Due 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. |
CInvoiceDiscountDueDate | date | Discount 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. |
CInvoiceVatBaseDebitLC | decimal(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. |
CInvoiceVatBaseCreditLC | decimal(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. |
CInvoiceVatBaseDebitTC | decimal(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. |
CInvoiceVatBaseCreditTC | decimal(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. |
CInvoiceVatBaseDebitCC | decimal(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. |
CInvoiceVatBaseCreditCC | decimal(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. |
CInvoiceVatDebitLC | decimal(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. |
CInvoiceVatCreditLC | decimal(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. |
CInvoiceVatDebitTC | decimal(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. |
CInvoiceVatCreditTC | decimal(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. |
CInvoiceVatDebitCC | decimal(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. |
CInvoiceVatCreditCC | decimal(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. |
CInvoiceCIText | character | CIDescription. A brief description for the SI posting. |
api annotation: | This field defaults from the CInvoiceDescription. | |
CInvoiceMFText | character | MFDescription. A brief description for the Matching posting. |
api annotation: | This field defaults from the CInvoiceDescription. | |
CInvoiceBalanceDebitLC | decimal(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. |
CInvoiceBalanceCreditLC | decimal(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. |
CInvoiceBalanceDebitTC | decimal(4) | TC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency. |
CInvoiceBalanceCreditTC | decimal(4) | TC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency. |
CInvoiceBalanceDebitCC | decimal(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. |
CInvoiceBalanceCreditCC | decimal(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. |
CInvoiceCirecClosingDate | date | SIREC Closing Date.This field displays the date on which the Unallocated Invoices account has been backed out for this invoice. |
CInvoiceIsVatDelay | logical | Tax Delay. This field indicates if the Taxes on purchase orders and supplier invoices or credit notes are delayed. |
CInvoiceIsOpen | logical | 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 | |
CInvoiceIsSelected | logical | Selected. This field indicates whether the invoice is included in a payment selection. This field is read-only. |
CInvoiceBalanceLC | decimal(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. |
CInvoiceBalanceTC | decimal(4) | Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency. |
CInvoiceBalanceCC | decimal(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. |
CInvoiceClosingDate | date | Closing Date. This field displays the date on which the open balance became zero. |
CInvoiceIsLogisticMatching | logical | Receiver Matching.This field indicates If the Receiver Matching function is enabled. This field is calculated by the system using the invoice status code. |
CInvoicePostingPeriod | integer | 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. | |
CInvoicePostingYear | integer | 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. | |
CInvoicePostingYearPeriod | integer | 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. | |
CInvoiceVatExchangeRate | decimal(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. |
CInvoiceVatRateScale | decimal(10) | Tax Rate Scale. This field indicates the scale factor applying to the tax exchange rate in use for foreign currency payments. |
CInvoiceIsTaxable | logical | Taxable. This field indicates if the invoice is taxable. This field defaults to true if the supplier is taxable. |
CInvoiceOwnVatNumber | character | 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. | |
CInvoiceCreditorVatNumber | character | Supplier 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. |
CInvoiceNonDiscAmtLC | decimal(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. |
CInvoiceNonDiscAmtCC | decimal(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. |
CInvoiceNonDiscAmtTC | decimal(4) | TC Non-discount Amount. This field display the invoice amount without discount in base currency. |
CInvoiceNonRecTaxAmtTC | decimal(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. |
CInvoiceHoldAmountTC | decimal(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. |
CInvoicePoDomain | character | PO Domain. This field indicates which domain the purchase order belongs to. |
CInvoicePoNbr | character | PO Number. This fields identifies the PO receipts which the invoice matches. |
CInvoiceIsExternal | logical | External. This field indicates if the daybook used is external. This field is calculated by the system using the daybook code. |
CInvoiceIsTaxConfirmed | logical | Tax 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 | |
CInvoiceIsTaxExcluded | logical | 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. | |
CInvoiceIsWithBank | logical | With Bank. This field indicates if the invoice has a supplier bank number specified for it. |
api annotation: | PartialUpdate = yes - defaults to true | |
CInvoiceIsDiscTaxAtInv | logical | Discount Tax at Invoice.This field indicates if the invoice has a discount for tax. |
api annotation: | PartialUpdate = yes - defaults to false | |
CInvoiceIsDiscTaxAtPaym | logical | 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 | |
CInvoiceIsInitialStatus | logical | Initial 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. | |
CInvoiceRegistrationNr | integer | Registration number. This field displays the sequential number assigned to each invoice upon initial entry in the system. |
CInvoiceCreationDate | date | Creation Date.This field indicates the invoice creation date. Thid fields is read-only. |
api annotation: | Thid fields defautls from the system date. | |
CInvoiceCommentNote | character | Comment. This field contains user's comment of the invoice. |
CInvoiceBatchNumber | character | Batch Number. This field is used to identify a group of supplier invoices created at one time using Evaluated Receipts Settlement (ERS) functions. |
CInvoiceIsERS | logical | ERS: This field indicates if the invoice is created using Evaluated Receipts Settlement (ERS) functions. |
CInvoiceDayBookSetCode | character | Daybook 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. |
CInvoiceSiteCode | character | Site. 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. |
CInvoiceIsWHT | logical | |
CInvoiceWHTTotAmtDebitTC | decimal(4) | |
CInvoiceWHTTotAmtCreditTC | decimal(4) | |
CInvoiceWHTBaseAmtDebitTC | decimal(4) | |
CInvoiceWHTBaseAmtCreditTC | decimal(4) | |
CInvoiceWHTTotAmtDebitLC | decimal(4) | |
CInvoiceWHTTotAmtCreditLC | decimal(4) | |
CInvoiceWHTBaseAmtDebitLC | decimal(4) | |
CInvoiceWHTBaseAmtCreditLC | decimal(4) | |
CInvoiceWHTTotAmtDebitCC | decimal(4) | |
CInvoiceWHTTotAmtCreditCC | decimal(4) | |
CInvoiceWHTBaseAmtDebitCC | decimal(4) | |
CInvoiceWHTBaseAmtCreditCC | decimal(4) | |
tcReasonAllocationStatus | character | Invoice 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. |
tcLocalCurrencyCode | character | Base Currency. This fields inficates the base currency used by the invoice. |
tcStatutoryCurrencyCode | character | Statutory Currency. This field indicates the statutory currency used by the invoice. |
tdCInvoiceOriginalTC | decimal(4) | Original TC Amount if Type = Invoice => CInvoiceOriginalCreditTC if Type = CreditNote => CInvoiceOriginalDebitTC |
tdCInvoiceOriginalLC | decimal(4) | Original LC Amount if Type = Invoice => CInvoiceOriginalCreditLC if Type = CreditNote => CInvoiceOriginalDebitLC |
tdCInvoiceOriginalCC | decimal(4) | Original CC Amount if Type = Invoice => CInvoiceOriginalCreditCC if Type = CreditNote => CInvoiceOriginalDebitCC |
tdTotalAmountDebitTC | decimal(4) | total debit amount in TC =>sum of the CInvoiceVatBaseDebitTC and CInvoiceVatDebitTC |
tdTotalAmountCreditTC | decimal(4) | total credit amount in TC =>sum of the CInvoiceVatBaseCreditTC and CInvoiceVatCreditTC |
tcCAJournalCode | character | Adjustment. The Journal Code for the Creditor Adjustment Posting. |
tiCAVoucher | integer | SA Voucher. Voucher of Creditor Adjusment Posting. |
tcMFJournalCode | character | Daybook. The Daybook code of the Matching Daybook used for this invoice. This field is Calculated by the system. |
tcPaymentMeansTranslated | character | Payment Instrument. This field displays the payment instrument defined for payments to this supplier from your bank account. |
tdCInvoiceVatBaseTC | decimal(4) | TC Tax Base Amount if Type = Invoice => CInvoiceVatBaseCreditTC if Type = CreditNote => CInvoiceVatBaseDebitTC |
tdCInvoiceVatBaseLC | decimal(4) | BC Tax Base Amount if Type = Invoice => CInvoiceVatBaseCreditBC if Type = CreditNote => CInvoiceVatBaseDebitBC |
tcNormalPaymentConditionType | character | 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 supplier record accosiated with the invoice. | |
tiVatCurrencyNumDec | integer | Tax Currency Number of Decimals. This field displays the deciamls of the tax currency used by the invoice. |
tlCreditorIsTaxReport | logical | Tax 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. |
tcOwnVatNumberCountryCode | character | 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. |
tcCredVatNumberCountryCode | character | Supplier 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. |
tcCInvoiceNumber | character | Invoice Number. The system generate invoice number based on the daybook code. |
tdCInvoiceOriginalAmount | decimal(2) | TC Original Amt. Calculated field for the original amount. |
tdCInvoiceOpenAmount | decimal(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. |
tiOverdueDays | integer | 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. |
tcShipToTaxZone | character | Tax 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. |
tlShipToAddressIsTaxInCity | logical | Tax 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. |
tdCInvoiceOriginalAmountLC | decimal(2) | BC Original Amount if Type = Invoice => CInvoiceOriginalCreditBC if Type = CreditNote => CInvoiceOriginalDebitBC |
tdCInvoiceOpenAmountLC | decimal(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. |
tlCInvoiceIsReferenced | logical | Referenced. This field indicates if other invoices have linked to this invoice. This field is calculated by the system. |
tlShipToCountryIsEUCountry | logical | Ship-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. |
tiShipToAddressId | integer | |
tiBusinessRelation_ID | integer | |
tcCreditorCode | character | Supplier Code. The code that identifies the supplier to be paid with this invoice. This field is calculated by the system. |
tcBusinessRelationCode | character | Business Relation.The business relation code linked to the supplier. This field is calculated by the system using the supplier code. |
tcBusinessRelationName1 | character | Business Relation Name. Calculated field displays the business relation name linked to the supplier. |
tcDivisionCode | character | Sub-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. |
tcJournalCode | character | Daybook 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. |
tcCurrencyCode | character | Currency Code.This filed identifies the currency of the invoice amount entered by the user. |
tcReasonCode | character | 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 supplier record. | |
CInvoiceCreationTimeString | character | Seconds since midnight in HH:MM:SS |
tcNormalPaymentConditionCode | character | 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 supplier record. | |
CInvoiceInvCertCertificate | character | Duplicate field from SysProperty |
tcBLWIGroupCode | character | BLWI 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. |
CInvoiceInvCertVersion | character | Version of the Certificate |
tcTransactionStartCountryCode | character | TransactionStart Country Code. This field identifies the start country of the transaction. This field is calculated by the system. |
CInvoiceInvCertKey | character | |
tcTransactionEndCountryCode | character | TransactionEnd Country Code. This field identifies the end country of the transaction. This field is calculated by the system. |
CInvoiceInvCertSignatureCurr | character | |
tcProjectCode | character | Project. The project to which this invoice is to be posted. |
CInvoiceInvCertSignaturePrev | character | |
tcCostCentreCode | character | Cost Center Code. The cost center to which this invoice is to be posted. |
CInvoiceInvCertSignatureShort | character | 4-character signature based upon the content of DInvoiceInvCertSignatureCurr |
tcRoleName | character | Role 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. |
tcVatCurrencyCode | character | Currency Code.This field identifies the currency used by the invoice for tax use. This field is calculated by the system. |
tcShipToAddressCity | character | City. The city for the ship-to address. This field is calculated by the system using the ship-to address city. |
tcShipToAddressState | character | State. The state or province for the ship-to address. This field is calculated by the system using the ship-to address. |
tcShipToAddressStreet1 | character | Address: Line one of the ship-to address details. |
tcShipToAddressStreet2 | character | Address: Line two of the ship-to address details. This field can be blank. |
tcShipToAddressStreet3 | character | Address: Line three of the ship-to address details. This field can be blank. |
tcShipToAddressTypeCode | character | Address Type: A code that identifies the type of the ship-to address. This field is calculated by the system. |
tcShipToAddressZip | character | Zip. The postal code or US zip code associated with the ship-to address. This field is calculated by the system. |
tcShipToBusinessRelationCode | character | 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 | County Code. This field identifies the county for the ship-to address. This field is calculate by the system. |
tcPurchaseTypeCode | character | Purchase 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. |
tcControlGLCode | character | Account.This field identifies the supplier control GL account. This field is calculated by the system according to the supplier. |
tlShipFromCountryIsEUCountry | logical | Ship-From is an EU Country. This field indicates if the Ship-From address is in EU country. This field is calculated by the system. |
tlControlGLIsDivisionAccount | logical | Division Account. This filed indicates if the supplier control account is defined with sub-account analysis. This field is calculated by the system. |
tlCInvoiceIsReverseBySign | logical | tlCInvoiceIsReverseBySign. 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. |
tcShipFromTaxClass | character | Ship 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. |
tcShipFromTaxUsage | character | Ship 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. |
tcShipFromTaxZone | character | Ship From Tax Zone. Calculated field identifies the tax zone of the Ship-From business relation, which is associated with the current entity. |
tcShipFromCountryCode | character | Ship 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. |
tcCInvoiceReference1 | character | Reference. The reference of other invoice linked to this invoices. This field is calculated by the system according to the linked invoice. |
tiLinkedCInvoiceVoucher | integer | 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 | 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 | 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. |
tlDaybookOnInvoice | logical | DaybookOnInvoice. 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. |
tcCInvoiceReferenceDuplicate | character | Calculated 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. |
tlCInvoiceIsForLegalDoc | logical | |
tiShipFromAddressId | integer | |
CustomShort0 | character | |
CustomShort1 | character | |
CustomShort2 | character | |
CustomShort3 | character | |
CustomShort4 | character | |
CustomShort5 | character | |
CustomShort6 | character | |
CustomShort7 | character | |
CustomShort8 | character | |
CustomShort9 | character | |
CustomCombo0 | character | |
CustomCombo1 | character | |
CustomCombo2 | character | |
CustomCombo3 | character | |
CustomCombo4 | character | |
CustomCombo5 | character | |
CustomCombo6 | character | |
CustomCombo7 | character | |
CustomCombo8 | character | |
CustomCombo9 | character | |
CustomLong0 | character | |
CustomLong1 | character | |
CustomNote | character | |
CustomDate0 | date | |
CustomDate1 | date | |
CustomDate2 | date | |
CustomDate3 | date | |
CustomDate4 | date | |
CustomInteger0 | integer | |
CustomInteger1 | integer | |
CustomInteger2 | integer | |
CustomInteger3 | integer | |
CustomInteger4 | integer | |
CustomDecimal0 | decimal(4) | |
CustomDecimal1 | decimal(4) | |
CustomDecimal2 | decimal(4) | |
CustomDecimal3 | decimal(4) | |
CustomDecimal4 | decimal(4) | |
CustomShort10 | character | |
CustomShort11 | character | |
CustomShort12 | character | |
CustomShort13 | character | |
CustomShort14 | character | |
CustomShort15 | character | |
CustomShort16 | character | |
CustomShort17 | character | |
CustomShort18 | character | |
CustomShort19 | character | |
CustomCombo10 | character | |
CustomCombo11 | character | |
CustomCombo12 | character | |
CustomCombo13 | character | |
CustomCombo14 | character | |
CustomDecimal5 | decimal(4) | |
CustomDecimal6 | decimal(4) | |
CustomDecimal7 | decimal(4) | |
CustomDecimal8 | decimal(4) | |
CustomDecimal9 | decimal(4) | |
CustomDecimal10 | decimal(4) | |
CustomDecimal11 | decimal(4) | |
CustomDecimal12 | decimal(4) | |
CustomDecimal13 | decimal(4) | |
CustomDecimal14 | decimal(4) | |
CustomDate5 | date | |
CustomDate6 | date | |
CustomDate7 | date | |
CustomDate8 | date | |
CustomDate9 | date | |
LastModifiedDate | date | |
LastModifiedTime | integer | |
LastModifiedUser | character | |
QADC01 | character | unused QAD reserved field |
QADC02 | character | unused QAD reserved field |
QADT01 | date | unused QAD reserved field |
QADD01 | decimal(10) | unused QAD reserved field |
tc_Rowid | character | |
tc_ParentRowid | character | |
tc_Status | character |