| field name | data type | description |
|---|---|---|
| tc_Rowid | character | |
| tcAddressCity | character | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tcAddressCityComp | character | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tcAddressStreet1 | character | |
| tcAddressStreet1Comp | character | |
| tcAddressStreet2 | character | |
| tcAddressStreet2Comp | character | |
| 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. |
| tcAddressZipComp | 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. |
| tiBankStateAlloc_ID | integer | |
| tdBankStateAllocBankAmountTC | decimal(4) | |
| tiBankStateLine_ID | integer | |
| tdBankStateLineAmountTC | decimal(4) | |
| tcBankStateLineDescription | character | |
| tcBankStateLineInformation | character | |
| ttBankStateLinePostingDate | date | |
| 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. | |
| tcBusinessRelationName1Comp | character | |
| tcCurrencyCode | character | |
| tcCurrencyCodeBankLine | character | |
| tcCurrencyCodeLC | character | |
| tcCurrencyCodePosting | character | |
| tiCurrencyNumberOfDecimals | integer | |
| tiCurrencyNumberOfDecimalsPost | integer | |
| tcGLCode | character | A code identifying the GL account. |
| tcJournalCode | character | |
| tcJournalCodeReference | character | |
| tcLastModifiedUser | character | |
| tiPeriodYear | integer | |
| tiPeriodYearReference | integer | |
| ttPostingDate | date | |
| tiPostingLine_ID | integer | |
| 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. | |
| tdPostingLineCreditTC | 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. | |
| tdPostingLineDebitTC | decimal(4) | |
| 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. | |
| tiPostingVoucher | integer | |
| tiPostingYear | integer | |
| tiSegmentSeq | integer | |
| tcVatNumberIdentity | character | |
| tcVatNumberIdentityComp | character | Obsolete field |
| tiVoucherReference | 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. |
| tiDollarAmount | integer | |
| tiCentAmount | integer | |
| tcDollarCurrency | character | |
| tcCentCurrency | character | |
| tcAmountInWords | 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 |
|---|---|---|
| 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