| 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. |
| tcAccountManager | character | |
| tcAddressCity | character | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tcAddressCountry | character | Country Code.This field identifies the country where this address is located. This field is mandatory and is used to determine tax defaults. |
| tcAddressState | character | Obsolete field |
| tcAddressStreet1 | character | Address: Line one of address details. This field can be blank. |
| tcAddressStreet2 | character | Address.Line two of address details. This field can be blank. |
| 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. |
| tcAdminManager | character | |
| tlBudgetCheckActualOnLine | logical | |
| tcBudgetCheckReportPeriod | character | |
| tcBudgetCode | character | |
| tcBudgetCompanyCode | character | |
| tcBudgetDescription | character | |
| tiBudgetFDSSeq | integer | |
| tcBudgetFDSType | character | |
| tcBudgetFigureWBSCode | character | |
| tcBudgetGroupCode | character | |
| tcBudgetGroupDescription | character | |
| tlBudgetGroupIsActive | logical | |
| tiBudgetInputLevelBudget | integer | |
| tiBudgetInputLevelEAC | integer | |
| tiBudgetInputLevelFin | integer | |
| tlBudgetIsAutoRollUp | logical | |
| tlBudgetIsCheckCommitOnLine | logical | |
| tlBudgetIsCompanyDependent | logical | |
| tlBudgetIsWithQuantityData | logical | |
| tcBudgetOverrunPeriod | character | |
| tcBudgetOverrunTotal | character | |
| tcBudgetOverrunYTD | character | |
| tcBudgetPeriodCode | character | |
| ttBudgetPeriodFromDate | date | |
| tiBudgetPeriodSeq | integer | |
| ttBudgetPeriodTillDate | date | |
| tcBudgetStatus | character | |
| tcBudgetVersionCode | character | |
| tcBudgetVersionComment | character | |
| ttBudgetVersionCreateDate | date | |
| tiBudgetVersionCreateTime | integer | |
| tcBudgetVersionDescription | character | |
| tdBudgetVersionFigureEacQTY | decimal(4) | |
| tdBudgetVersionFigureEacTC | decimal(4) | |
| tdBudgetVersionFigureFinQTY | decimal(4) | |
| tdBudgetVersionFigureFinTC | decimal(4) | |
| tdBudgetVersionFigureQTY | decimal(4) | |
| tdBudgetVersionFigureSEacTC | decimal(4) | |
| tdBudgetVersionFigureSFinTC | decimal(4) | |
| tdBudgetVersionFigureSTC | decimal(4) | |
| tdBudgetVersionFigureTC | decimal(4) | |
| tlBudgetVersionIsActive | logical | |
| tdBudgetVersionPercCompletion | decimal(3) | |
| tcBudgetWBSCode | character | |
| tcBudgetWBSComment | character | |
| tcBudgetWBSCostRevenue | character | |
| tcBudgetWBSCostType | character | |
| tcBudgetWBSFDSCode | character | |
| tcBudgetWBSFDSDefault | character | |
| tcBudgetWBSFDSFromCode | character | |
| tcBudgetWBSFDSList | character | |
| tcBudgetWBSFDSToCode | character | |
| tdBudgetWBSItemAmountTC | decimal(4) | |
| ttBudgetWBSItemCallOffDate | date | |
| tdBudgetWBSItemCallOffQTY | decimal(4) | |
| tdBudgetWBSItemCostTC | decimal(4) | |
| tcBudgetWBSItemDescription | character | |
| ttBudgetWBSItemFromDelDate | date | |
| ttBudgetWBSItemInitiationDate | date | |
| tcBudgetWBSItemOriginType | character | |
| tdBudgetWBSItemQTY | decimal(4) | |
| ttBudgetWBSItemTillDelDate | date | |
| tdBudgetWBSItemUnitCostPrice | decimal(10) | |
| tcBudgetWBSOverrunPeriod | character | |
| tcBudgetWBSOverrunTotal | character | |
| tcBudgetWBSOverrunYTD | character | |
| tdBudgetWBSPercOfComp | decimal(3) | |
| tdBudgetWBSSeq | decimal(0) | |
| tcBudgetWBSStatus | character | |
| 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. |
| tcBusinessRelationName1 | character | |
| tcController | character | |
| tcCurrencyCode | character | |
| tcCurrencyDescription | character | |
| tiCurrencyNumberOfDecimals | integer | |
| tcDebtorCode | character | |
| tcDivisionCode | character | |
| tcDivisionDescription | character | |
| tcIndustryCode | character | |
| tcItemCode | character | |
| tcItemDescription1 | character | |
| tcMainProjectCode | character | |
| tcMainProjectDescription | character | |
| tcPaymentConditionCode | character | |
| tcPenholderCompanyCode | character | |
| tcPriceListCode | character | |
| tiProject_ID | integer | |
| tcProjectCode | character | |
| tdProjectContractAmountTC | decimal(4) | |
| ttProjectContractDate | date | |
| tcProjectContractReference | character | |
| tcProjectDescription | character | |
| ttProjectEndDate | date | |
| tcProjectGroupCode | character | |
| tcProjectGroupDescription | character | |
| tlProjectGroupIsActive | logical | |
| tlProjectIsAltRevProdCalc | logical | |
| tlProjectIsTemplate | logical | |
| tlProjectIsWithSaf | logical | |
| tcProjectManager | character | |
| tcProjectPriceTypeCode | character | |
| tdProjectRevCodeBaseAmountLC | decimal(4) | |
| tdProjectRevCodeBaseQTY | decimal(4) | |
| tdProjectRevCodePercentage | decimal(2) | |
| tdProjectRevCodeUnitCostLC | decimal(10) | |
| tcProjectRevenueRecogType | character | |
| ttProjectStartDate | date | |
| tcProjectStatusCode | character | |
| tcProjectStatusDescription | character | |
| tlProjectStatusIsActive | logical | |
| tcProjectStatusSystemStatus | character | |
| tcProjectSystemStatus | character | |
| tcProjectTypeCode | character | |
| tcRegionCode | character | |
| tcRevenueCode | character | |
| tcSafCode | character | |
| tcSafConceptCode | character | |
| tcSafConceptDescription | character | |
| tlSafConceptIsActive | logical | |
| tcSafDescription | character | |
| tlSafIsActive | logical | |
| tcSiteAddressCity | character | City. The city for this address. This field can be used to decide the tax zone of the address. |
| tcSiteAddressCountry | character | Country Code.This field identifies the country where this address is located. This field is mandatory and is used to determine tax defaults. |
| tcSiteAddressState | character | Obsolete field |
| tcSiteAddressStreet1 | character | |
| tcSiteAddressStreet2 | character | Address.Line two of address details. This field can be blank. |
| tcSiteAddressZip | 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. |
| tcTemplateProjectCode | character | |
| tcTemplateProjectDescription | character | |
| tcUnitCode | character | |
| tcUnitDescription | character | |
| 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