About This Guide > Project
  
Project
Project
 
 
Field Name
Label
Col-Label
Format
Dec
 
AdminRespUsr_ID
Responsible
 
9999999999
 
 
BudgetGroup_ID
Budget Group
 
9999999999
 
 
BusinessRelation_ID
Business Relation
 
9999999999
 
 
COAMaskProjProfile_ID
COA Mask Profile
 
9999999999
 
 
ControllerUsr_ID
Login
 
9999999999
 
 
Currency_ID
Currency
Curr
9999999999
 
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
Debtor_ID
Customer
 
9999999999
 
 
Division_ID
Link to Division
 
9999999999
 
 
DivisionProfile_ID
Sub-Account Profile
 
9999999999
 
 
ExchangeRateType_ID
Exchange Rate Type
Rate Type
9999999999
 
 
Industry_ID
Link to Industry
 
9999999999
 
 
InvoiceAddress_ID
City
 
9999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
MainProject_ID
Main Project
 
9999999999
 
 
ObsoletePriceList_ID
Link to Price List
 
9999999999
 
 
ObsoleteRevenueRecogType
Revenue Recognition Type
 
x(20)
 
 
PaymentCondition_ID
Credit Terms
Cred Trm
9999999999
 
 
PenholderCompany_ID
Link to Company
 
9999999999
 
 
Project_ID
Record ID
 
9999999999
 
 
ProjectCode
Project
 
x(8)
 
 
ProjectContractAmountTC
TC Contract Amount
 
->>>,>>>,>>>,>>9.99
4
 
ProjectContractDate
Contract Date
 
99/99/9999
 
 
ProjectContractReference
Contract Reference
Contract Ref
x(40)
 
 
ProjectDateRevised
Date Revised
Project Date Revised
99/99/9999
 
 
ProjectDescription
Description
 
x(24)
 
 
ProjectEndDate
End Date
 
99/99/9999
 
 
ProjectGroup_ID
Project Group
 
9999999999
 
 
ProjectIsAltRevProdCalc
Alt Production Calculation
 
yes/no
 
 
ProjectIsStructFromGL
Retrieve SAF Structure from GL
Retrieve Structure from GL
yes/no
 
 
ProjectIsTemplate
Save as Template
Template
yes/no
 
 
ProjectIsWithSaf
SAF Enabled
SAF
yes/no
 
 
ProjectManagerUsr_ID
Project Administrator
Project Administrator
9999999999
 
 
ProjectOriginalCompletDate
Original Completion Date
Proj Orig Comp Date
99/99/9999
 
 
ProjectPriceTypeCode
Price Type
 
x(20)
 
 
ProjectRevisedCompletDate
Revised Completion Date
Proj Rev Comp Date
99/99/9999
 
 
ProjectSafSetOnByUsr_ID
Link to Usr
 
->,>>>,>>9
 
 
ProjectSafSetOnOnDate
SAF Set on Date
 
99/99/9999
 
 
ProjectStartDate
Start Date
 
99/99/9999
 
 
ProjectStatus_ID
Status Code
 
9999999999
 
 
ProjectSystemStatus
System Status
 
x(20)
 
 
ProjectTypeCode
Project Type
 
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Region_ID
Region
 
9999999999
 
 
SalesRespUsr_ID
Login
 
9999999999
 
 
SharedSet_ID
Link to SharedSet
 
9999999999
 
 
SiteAddress_ID
Address
 
9999999999
 
 
TemplateProject_ID
Template Code
 
9999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AdmUsrIdx
no
AdminRespUsr_ID
yes
no
 
BudgetGroup
no
BudgetGroup_ID
yes
no
 
BusRelIdx
no
BusinessRelation_ID
yes
no
 
COAMaskProfileIdx
no
COAMaskProjProfile_ID
yes
no
 
Code
no
ProjectCode
yes
no
 
ContolUsrIdx
no
ControllerUsr_ID
yes
no
 
CurrencyIdx
no
Currency_ID
yes
no
 
DebtorIdx
no
Debtor_ID
yes
no
 
DivIdx
no
Division_ID
yes
no
 
DivProfileIdx
no
DivisionProfile_ID
yes
no
 
ExRateTypeIdx
no
ExchangeRateType_ID
yes
no
 
IndustryIdx
no
Industry_ID
yes
no
 
InvAddrIdx
no
InvoiceAddress_ID
yes
no
 
IsTemplate
no
ProjectIsTemplate
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 
MainPrjIdx
no
MainProject_ID
yes
no
 
PayCondIdx
no
PaymentCondition_ID
yes
no
 
PenHoldCyIdx
no
PenholderCompany_ID
yes
no
 ∗
Prim
yes
Project_ID
yes
no
 
PrjManUsrIdx
no
ProjectManagerUsr_ID
yes
no
 
PrjSafOnUsrIdx
no
ProjectSafSetOnByUsr_ID
yes
no
 
PrjStatIdx
no
ProjectStatus_ID
yes
no
 
ProjectGroup
no
ProjectGroup_ID
yes
no
 
ProjectSystemStatus
no
ProjectSystemStatus
yes
no
 
RegionIdx
no
Region_ID
yes
no
 
SalesRepUsrIdx
no
SalesRespUsr_ID
yes
no
 
SharedSet
no
SharedSet_ID
yes
no
 
SharedSetAndCode
yes
SharedSet_ID
yes
no
 
 
 
ProjectCode
yes
no
 
SiteAddrIdx
no
SiteAddress_ID
yes
no
 
TemplatePrjIdx
no
TemplateProject_ID
yes
no