| 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 |
|---|---|---|
| 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. |
| tlInvoiceIsMatched | logical | InvoiceIsMatched |
| ttprh_rcp_date | date | |
| tiprh_line | integer | |
| tdReceiptAmount | decimal | |
| tcprh_vend | character | |
| tcprh_receiver | character | |
| tcprh_part | character | |
| tcprh_nbr | character | |
| tcprh_um | character | |
| tcMatchType | character | |
| ttPostingDate | date | The accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod). |
| 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. | |
| ttAPMatchingDate | date | |
| tlCInvoiceIsLogisticMatching | 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. |
| tiPvoID | integer | |
| tiPvodLineID | integer | |
| tiPostingYear | integer | The GL calendar year for the posting. |
| 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. | |
| 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. |
| 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. | |
| tiCInvoice_ID | integer | |
| tiAPMatchingLn_ID | integer | |
| 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. |
| tdCInvoiceOriginalDebitLC | 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. |
| tdCInvoiceOriginalDebitCC | 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. |
| 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. |
| tdCInvoiceOriginalCreditLC | 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. |
| tdCInvoiceOriginalCreditCC | 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. |
| tdAPMatchingLnMatchUnitPrice | decimal(10) | |
| tdAPMatchingLnMatchQty | decimal(10) | |
| tdAPMatchingLnMatchAmtTC | decimal(4) | |
| tdAPMatchingLnMatchAmtLC | decimal(4) | |
| tcPvoDomain | character | |
| tcPostingJournal | character | A daybook code (maximum eight characters). |
| tcMatchingType | character | |
| tcCreditorCode | character | |
| tcCountryDescription | character | |
| tcCountryCode | character | |
| 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. |
| tcCinvoiceJournal | character | A daybook code (maximum eight characters). |
| tcCInvoiceCurrency | character | |
| tcCInvoiceAllocationStatus | 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. |
| tcBusinessRelationName | 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. |
| tcAPMatchingStatus | character | |
| tcAPMatchingLnPvodIntRef | character | |
| tcAPMatchingLnPvodGLCode | character | |
| tcAPMatchingLnPvodCompCode | character | APMatchingLnPvodCompCode |
| tcAddressZip | character | Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank. |
| tcAddressName | character | Name. The full name of this particular address. The name of a headoffice address is the same as the name of the business relationship and can not be modified. |
| api annotation: | PartialUpdate = yes - defaults to the name of the businessRelation. | |
| tcAddressCounty | character | Obsolete field |
| tcAddressCity | character | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tiProject_ID | integer | |
| tiPostingLine_ID | integer | |
| tiPosting_ID | integer | |
| tiGL_ID | integer | |
| tiDivision_ID | integer | |
| tiCostCentre_ID | integer | |
| tiCInvoicePosting_ID | integer | |
| tdPostingLineDebitTC | decimal(4) | |
| 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. | |
| tdPostingLineDebitCC | decimal(4) | |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLineDebitTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, enter the correct value for this field. | |
| tdPostingLineCreditTC | decimal(4) | |
| 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. | |
| tdPostingLineCreditCC | decimal(4) | |
| api annotation: | Partial Update = yes - it will get a default value depending on the value of PostingLinCreditTC, PostingLineCCRate & PostingLineCCScale. SC Amount = TC Amount * Exchange rate (TC/SC) * Scale Factor (TC/SC). If Partial Update is false, you should enter the correct value for this field | |
| tcProjectCode | character | |
| tcGLCode | character | A code identifying the GL account. |
| tcDivisionCode | character | |
| tcCurrencyCode | character | |
| tcCostCentreCode | character | Cost Center: A code that identifies the cost center. |
| tiCurrencyNumberOfDecimals | integer | |
| tiQtyNumDec | integer | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| 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 | |
| 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 |
| field name | data type | description |
|---|---|---|
| tcCode | character | |
| tcText | character |
QadFinancials