| field name | data type | description |
|---|
| Project_ID | integer | |
| MainProject_ID | integer | |
| Division_ID | integer | |
| SalesRespUsr_ID | integer | |
| AdminRespUsr_ID | integer | |
| ProjectManagerUsr_ID | integer | |
| TemplateProject_ID | integer | |
| ExchangeRateType_ID | integer | |
| Currency_ID | integer | |
| BudgetGroup_ID | integer | |
| SharedSet_ID | integer | |
| BusinessRelation_ID | integer | |
| Debtor_ID | integer | |
| SiteAddress_ID | integer | |
| InvoiceAddress_ID | integer | |
| Industry_ID | integer | |
| Region_ID | integer | |
| PenholderCompany_ID | integer | |
| PaymentCondition_ID | integer | |
| DivisionProfile_ID | integer | |
| ControllerUsr_ID | integer | |
| ProjectStatus_ID | integer | |
| ProjectGroup_ID | integer | |
| ProjectSafSetOnByUsr_ID | integer | |
| COAMaskProjProfile_ID | integer | |
| ProjectCode | character | |
| ProjectDescription | character | |
| ProjectIsWithSaf | logical | |
| ProjectOriginalCompletDate | date | |
| ProjectRevisedCompletDate | date | |
| ProjectDateRevised | date | |
| ProjectIsStructFromGL | logical | Flag indicating if the Saf Structure should be retrieved from GL |
| ProjectIsTemplate | logical | |
| ProjectStartDate | date | |
| ProjectEndDate | date | |
| ProjectTypeCode | character | |
| ProjectContractAmountTC | decimal(4) | |
| ProjectContractReference | character | |
| ProjectContractDate | date | |
| ProjectPriceTypeCode | character | |
| ObsoleteRevenueRecogType | character | |
| ProjectIsAltRevProdCalc | logical | |
| ProjectSystemStatus | character | |
| ProjectSafSetOnOnDate | date | |
| ObsoletePriceList_ID | integer | |
| tcAddressStreet31 | character | |
| tcAddressStreet3 | character | |
| tcBudgetGroupCode | character | |
| tcCurrencyCode | character | |
| tcTemplateProjectCode | character | |
| tcExchangeRateTypeCode | character | |
| tcBusinessRelationCode | character | |
| tcDebtorCode | character | |
| tcMainProjectCode | character | |
| tcRegionCode | character | |
| tcSiteAddressCity | character | |
| tcSiteAddressState | character | |
| tcSiteAddressStreet1 | character | |
| tcSiteAddressStreet2 | character | |
| tcSiteAddressTypeCode | character | |
| tcSiteAddressZip | character | |
| tcSiteBusinessRelationCode | character | |
| tcSiteCountryCode | character | |
| tcInvoiceAddressCity | character | |
| tcInvoiceAddressState | character | |
| tcInvoiceAddressStreet1 | character | |
| tcInvoiceAddressStreet2 | character | |
| tcInvoiceAddressTypeCode | character | |
| tcInvoiceAddressZip | character | |
| tcInvoiceBusinessRelationCode | character | |
| tcInvoiceCountryCode | character | |
| tcPenholderCompanyCode | character | |
| tcPaymentConditionCode | character | |
| tlIsUsedInPosting | logical | |
| tcCountryCode | character | |
| tcDivisionProfileCode | character | |
| tcProjectStatusCode | character | |
| tcProjectGroupCode | character | |
| tcProjectManagerUsrLogin | character | |
| tcSalesRespUsrLogin | character | |
| tcAdminRespUsrLogin | character | |
| tcControllerUsrLogin | character | |
| tcProjectSafSetOnByUsrLogin | character | |
| tiCOAMaskProj_ID | integer | |
| tcCOAMaskProjCode | character | |
| 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) | |
| 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 | |
QadFinancials