| field name | data type | description |
|---|---|---|
| tiCInvoice_ID | integer | |
| tdprh_rcvd | decimal(10) | |
| tdprh_pur_cost | decimal(10) | |
| tdAPMatchingLnMatchUnitPrice | decimal(10) | |
| tdAPMatchingLnMatchQty | decimal(10) | |
| tcprh_um | character | |
| tcprh_part | character | |
| tcprh_nbr | character | |
| tcprh_curr | character | |
| tcAPMatchingLnPvodIntRef | character | |
| tcCurrencyCode | 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 | |
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date |
| field name | data type | description |
|---|---|---|
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| ti_Sequence | integer | Use this data item to add as a field in public temp-tables. |
| tcSortByName | character | |
| ttCInvoicePostingDate | 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. | |
| ttCInvoiceDueDate | 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. |
| ttCInvoiceDiscountDueDate | 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. |
| ttCInvoiceDate | 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. | |
| tlCInvoiceIsInitialStatus | 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. | |
| tiCInvoicePostingYear | 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. | |
| tdPostingLineDebitLC | decimal(4) | |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineExchangeRate and PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update = false, enter the correct value into this field. | |
| tdPostingLineCreditLC | decimal(4) | |
| api annotation: | Partial Update = yes - it will get a default value depends on the value of PostingLineCreditTC, PostingLineExchangeRate & PostingLineRateScale. BC Amount = TC Amount * Exchange rate (TC/BC) * Scale Factor (TC/BC). If Partial Update is false, enter a value for this field. | |
| tdCInvoiceOriginalDebitTC | 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. |
| tdCInvoiceOriginalCreditTC | 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. |
| tdCInvoiceNonDiscAmtTC | decimal(4) | TC Non-discount Amount. This field display the invoice amount without discount in base currency. |
| tdCInvoiceHoldAmountTC | 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. |
| tdCInvoiceBalanceTC | decimal(4) | Balance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency. |
| tcPurchaseTypeCode | character | |
| tcProjectCode | character | |
| tcPostingLineText | character | |
| api annotation: | Value for this field defaults to blank. Note: if a new record is created through the user interface, the default value is as same as the value of "PostingText" of tPosting. | |
| tcPostingJournalCode | character | A daybook code (maximum eight characters). |
| tcGLCode | character | A code identifying the GL account. |
| tcDivisionCode | character | |
| tcCurrencyCode | character | |
| tcCreditorTypeCode | character | |
| tcCreditorCode | character | |
| tcCostCentreCode | character | Cost Center: A code that identifies the cost center. |
| tcCompanyCode | character | |
| tcCInvoiceReference | 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. |
| tcCInvoicePostingType | character | 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. |
| tcCInvoicePoDomain | character | PO Domain. This field indicates which domain the purchase order belongs to. |
| tcBusinessRelationName1 | character | Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers. |
| api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | |
| tcBusinessRelationCode | character | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| tiPosting_ID | integer | |
| tiCInvoice_ID | integer | |
| tcCInvoicePoNbr | character | PO Number. This fields identifies the PO receipts which the invoice matches. |
| tcUsrLogin | character | |
| tiCInvoiceVoucher | 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. |
| tcJournalCode | character | A daybook code (maximum eight characters). |
| tcPostingCompanyCode | character | |
| tcPostingCurrencyCode | character | |
| tcCurrencyBC | character | |
| tcProjectDescription | character | |
| tcGLDescription | character | A description of the GL account. |
| tcDivisionDescription | character | |
| tcCostCentreDescription | character | Description: a brief description of the cost center. |
| tiPostingVoucher | integer | Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code). |
| api annotation: | In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record. | |
| tiPostingYear | integer | The GL calendar year for the posting. |
| 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 | |
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date |
| field name | data type | description |
|---|---|---|
| ti_Sequence | integer | Use this data item to add as a field in public temp-tables. |
| tcBusinessFieldLabel | character | |
| tcBusinessFieldName | character | BusinessFieldName |
| tcOperator | character | Operator |
| tcParameterValue | character | ParameterValue |
| field name | data type | description |
|---|---|---|
| tcCompanyCode | character | |
| tcCurrLC | character | |
| tcDateFormat | character | |
| tiDecCC | integer | |
| tcDecimalFormat | character | |
| tiDecLC | integer | |
| tcDecTC | character | |
| tiDocLayoutMode | integer | |
| tcExtraInfo | character | |
| tiFilterMode | integer | |
| tiPageBreakMode | integer | |
| tcReportTitle | character | |
| tiSummaryMode | integer | |
| tcUser | character | |
| tcDomainCode | character | |
| tcCompanyDescription | character | |
| tcUserLogin | character | Current User login ID |
| tlShadeAltLines | logical |
| field name | data type | description |
|---|---|---|
| tcCode | character | |
| tcText | character |
QadFinancials