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 | |