Project Metadata

GET {{base_url}}/metadata/project

Use this endpoint to retrieve the Project metadata.

The metadata describes the fields in each table of the database for the record and describes whether or not the table is a custom table and whether or not it has a grid ID. Each field describes whether or not the field is required, the data type, the default value, whether or not it is updateable, and other useful minimums, limits, and maximum details.

For more information, see Metadata Reference.

HEADERS

The type of content supported by the API endpoint. | | Authorization | string | | Required.

The type of authorization supported by the API endpoint. |

RESPONSES

status: OK

{"PR":{"Keys":"WBS1,WBS2,WBS3","TableName":"PR","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"[AUTONUMBER]","Hidden":false,"Required":true,"Updateable":false,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"Phase Number","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"Task Number","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3},{"FieldName":"SiblingWBS1","FieldType":"WBS1","Caption":"Linked Project","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"SiblingWBS1Name","FieldType":"String","Caption":"SiblingWBS1Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"PreAwardWBS1","FieldType":"String","Caption":"Pre-Award Project Number","DefaultValue":"","Hidden":true,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"ChargeType","FieldType":"Dropdown","Caption":"Charge Type","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"CodeTable":"CFGChargeType","LimitToList":true},{"FieldName":"SubLevel","FieldType":"Checkbox","Caption":"Sub Level","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Principal","FieldType":"Employee","Caption":"Principal-In-Charge","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"ProjMgr","FieldType":"Employee","Caption":"Project Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"Supervisor","FieldType":"Employee","Caption":"Supervisor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"ClientID","FieldType":"Client","Caption":"Client","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"OwnerClientID","FieldType":"Client","Caption":"OwnerClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"OwnerContactID","FieldType":"Contact","Caption":"OwnerContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"EstConstructionCost","FieldType":"Numeric","Caption":"Est Construction Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"PublicNoticeDate","FieldType":"Date","Caption":"Public Notice Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CustomCurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"LabBillTable","FieldType":"Numeric","Caption":"Lab Bill Table","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LabCostTable","FieldType":"Numeric","Caption":"Lab Cost Table","DefaultValue":"3","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AllocMethod","FieldType":"Dropdown","Caption":"Allocation Method","DefaultValue":"c","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"e":"Spread Evenly Across Time Scale","s":"Allocate All Fees to Estimated Start Date","c":"Allocate All Fees to Close Date","t":"Allocate All Fees to Estimated Completion Date","d":"Use Fee Allocation Grid with Specific Dates","r":"Use Revenue Forecasts"},"LimitToList":true},{"FieldName":"AllocMethodDescription","FieldType":"String","Caption":"AllocMethodDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Timescale","FieldType":"Dropdown","Caption":"Time Scale","DefaultValue":"d","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"d":"Daily","w":"Weekly","b":"Biweekly","s":"Semi-Monthly","m":"Monthly","q":"Quarterly","y":"Yearly"},"LimitToList":true},{"FieldName":"TimescaleDescription","FieldType":"String","Caption":"TimescaleDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"IQLastUpdate","FieldType":"Datetime","Caption":"IQ Last Update Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CLAddress","FieldType":"String","Caption":"Address Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"Fee","FieldType":"Currency","Caption":"Compensation","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllow","FieldType":"Currency","Caption":"Reimbursable Allowance","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ConsultFee","FieldType":"Currency","Caption":"Direct Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BudOHRate","FieldType":"Numeric","Caption":"Budgeted Overhead Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"RevType","FieldType":"Dropdown","Caption":"Laborx","DefaultValue":"B","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"MultAmt","FieldType":"Numeric","Caption":"Multiplier or Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MaxValue":9999999999999},{"FieldName":"Org","FieldType":"Org","Caption":"Organization","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":11},{"FieldName":"Org1","FieldType":"Org","Caption":"Org1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org1Name","FieldType":"Org","Caption":"Org1Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org2","FieldType":"Org","Caption":"Org2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org2Name","FieldType":"Org","Caption":"Org2Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org3","FieldType":"Org","Caption":"Org3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org3Name","FieldType":"Org","Caption":"Org3Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org4","FieldType":"Org","Caption":"Org4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org4Name","FieldType":"Org","Caption":"Org4Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org5","FieldType":"Org","Caption":"Org5","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org5Name","FieldType":"Org","Caption":"Org5Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"UnitTable","FieldType":"UnitTable","Caption":"Unit Table","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"StartDate","FieldType":"Date","Caption":"Actual Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"EndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PctComp","FieldType":"Numeric","Caption":"Overall % Complete","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MinValue":0,"MaxValue":100},{"FieldName":"LabPctComp","FieldType":"Numeric","Caption":"Labor % Complete","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MinValue":0,"MaxValue":100},{"FieldName":"ExpPctComp","FieldType":"Numeric","Caption":"Expense % Complete","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MinValue":0,"MaxValue":100},{"FieldName":"BillableWarning","FieldType":"Dropdown","Caption":"Billable Message","DefaultValue":"N","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"N":"None","W":"Warning","E":"Error"},"LimitToList":true},{"FieldName":"BillableWarningDescription","FieldType":"String","Caption":"BillableWarningDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Memo","FieldType":"Memo","Caption":"Additional Details","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BudgetedFlag","FieldType":"Dropdown","Caption":"Type of Validation","DefaultValue":"N","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"N":"None","W":"Warning","E":"Error"},"LimitToList":true},{"FieldName":"BudgetedFlagDescription","FieldType":"String","Caption":"BudgetedFlagDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BudgetedLevels","FieldType":"Dropdown","Caption":"Labor Code Levels","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5,"Codes":{"1":"[Labcd Level 1]","2":"[Labcd Level 2]","3":"[Labcd Level 3]","4":"[Labcd Level 4]","5":"[Labcd Level 5]"},"LimitToList":true},{"FieldName":"BillWBS1","FieldType":"WBS1","Caption":"BillWBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"BillWBS2","FieldType":"WBS2","Caption":"BillWBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"BillWBS3","FieldType":"WBS3","Caption":"BillWBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"XCharge","FieldType":"Dropdown","Caption":"XCharge","DefaultValue":"G","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"N":"None","G":"Global","P":"Project"},"LimitToList":true},{"FieldName":"XChargeMethod","FieldType":"Dropdown","Caption":"Rate Method","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Codes":{"0":"Multiplier","1":"Billing Terms"},"LimitToList":true},{"FieldName":"XChargeMult","FieldType":"Numeric","Caption":"Multiplier","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"Closed","FieldType":"Numeric","Caption":"Closed","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReadOnly","FieldType":"Numeric","Caption":"ReadOnly","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DefaultEffortDriven","FieldType":"Numeric","Caption":"DefaultEffortDriven","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DefaultTaskType","FieldType":"Numeric","Caption":"DefaultTaskType","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"VersionID","FieldType":"Numeric","Caption":"VersionID","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"PrimaryLimitContacts","FieldType":"Checkbox","Caption":"Limit contacts to selected primary client","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CLBillingAddr","FieldType":"String","Caption":"Address Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"LongName","FieldType":"String","Caption":"Long Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"Address1","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address2","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address3","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"State","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"Zip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"County","FieldType":"Dropdown","Caption":"County","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGCounty","LimitToList":false},{"FieldName":"Country","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"FederalInd","FieldType":"Checkbox","Caption":"Federal Project","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ProjectType","FieldType":"Dropdown","Caption":"Project Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGProjectType","LimitToList":true},{"FieldName":"Responsibility","FieldType":"Dropdown","Caption":"Responsibility","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGPRResponsibility","LimitToList":true},{"FieldName":"Referable","FieldType":"Checkbox","Caption":"Referable","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"EstCompletionDate","FieldType":"Date","Caption":"Estimated Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ActCompletionDate","FieldType":"Date","Caption":"Actual Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ActEstCompletionDate","FieldType":"Date","Caption":"Actual or Estimated Completion","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContractDate","FieldType":"Date","Caption":"Contract Awarded Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BidDate","FieldType":"Date","Caption":"Bid Submitted Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ComplDateComment","FieldType":"String","Caption":"Completion Comments","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"FirmCost","FieldType":"Currency","Caption":"Our Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FirmCostComment","FieldType":"String","Caption":"Our Cost Comment","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"TotalProjectCost","FieldType":"Currency","Caption":"Total Project Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TotalCostComment","FieldType":"String","Caption":"Total Project Cost Comment","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"ClientConfidential","FieldType":"Checkbox","Caption":"Confidential Client","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ClientAlias","FieldType":"String","Caption":"Alias","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"BillingClientID","FieldType":"Client","Caption":"Client","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"BillingContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"BillingLimitContacts","FieldType":"Checkbox","Caption":"Limit contacts to selected billing client","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Phone","FieldType":"String","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"Fax","FieldType":"String","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"EMail","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateUserName","FieldType":"User","Caption":"CreateUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUserName","FieldType":"User","Caption":"ModUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Locale","FieldType":"Dropdown","Caption":"Payroll Tax Locale","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGLOCALE","LimitToList":true},{"FieldName":"BudgetSource","FieldType":"Dropdown","Caption":"Budgeted Source","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"B":"Budget Worksheet","P":"Project Planning"},"LimitToList":true},{"FieldName":"BudgetLevel","FieldType":"Dropdown","Caption":"Budgeted Level","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"E":"Employee Only","L":"Labor Code Only","B":"Both"},"LimitToList":true},{"FieldName":"ProfServicesComplDate","FieldType":"Date","Caption":"Professional Services Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ConstComplDate","FieldType":"Date","Caption":"Construction Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProjectCurrencyCode","FieldType":"Dropdown","Caption":"Project Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"BillingCurrencyCode","FieldType":"Dropdown","Caption":"Billing Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"RestrictChargeCompanies","FieldType":"Checkbox","Caption":"Restrict Charge Companies","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ProjectExchangeRate","FieldType":"Numeric","Caption":"Project Exchange Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":10},{"FieldName":"BillingExchangeRate","FieldType":"Numeric","Caption":"Billing Exchange Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":10},{"FieldName":"FeeBillingCurrency","FieldType":"Currency","Caption":"Compensation - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Allowance - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ConsultFeeBillingCurrency","FieldType":"Currency","Caption":"Direct Consultantzs - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PORMBRate","FieldType":"Numeric","Caption":"Reimbursable Multiplier","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MaxValue":9999999999999},{"FieldName":"POCNSRate","FieldType":"Numeric","Caption":"Consultant Multiplier","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MaxValue":9999999999999},{"FieldName":"PlanID","FieldType":"String","Caption":"PlanID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"TKCheckRPDate","FieldType":"Checkbox","Caption":"Check Project Plan Start and End Dates","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ICBillingLab","FieldType":"Dropdown","Caption":"Multiplier","DefaultValue":"G","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"G":"Global","P":"[WBS1]"},"LimitToList":true},{"FieldName":"ICBillingLabMethod","FieldType":"Dropdown","Caption":"Rate Method","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Codes":{"0":"Multiplier","1":"Billing Terms","2":"Rate Table","3":"By Category","4":"By [Labor Code]"},"LimitToList":true},{"FieldName":"ICBillingLabMethodDescription","FieldType":"String","Caption":"ICBillingLabMethodDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ICBillingLabMult","FieldType":"Numeric","Caption":"Labor Billing - Multiplier","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MaxValue":9999999999999},{"FieldName":"ICBillingLabTableNo","FieldType":"Numeric","Caption":"Rate Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ICBillingLabTableNo_RateTable","FieldType":"Dropdown","Caption":"Intercompany Labor Billing Rate Table - Rate Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"BTRRT","LimitToList":true},{"FieldName":"ICBillingLabTableNo_CategoryTable","FieldType":"Dropdown","Caption":"Intercompany Labor Billing Rate Table - Category Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"BTRCT","LimitToList":true},{"FieldName":"ICBillingLabTableNo_LaborCode","FieldType":"Dropdown","Caption":"Intercompany Labor Billing Rate Table - Labor Code Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"BTRLT","LimitToList":true},{"FieldName":"ICBillingExp","FieldType":"Dropdown","Caption":"Apply Rate Method at this Level","DefaultValue":"G","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"G":"Global","P":"[WBS1]"},"LimitToList":true},{"FieldName":"ICBillingExpMethod","FieldType":"Dropdown","Caption":"Rate Method","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Codes":{"0":"Multiplier","1":"Billing Terms","5":"By [Account]","6":"Expense Category","7":"By [Vendor]"},"LimitToList":true},{"FieldName":"ICBillingExpMethodDescription","FieldType":"String","Caption":"ICBillingExpMethodDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ICBillingExpMult","FieldType":"Numeric","Caption":"Multiplier","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2,"MaxValue":9999999999999},{"FieldName":"ICBillingExpTableNo","FieldType":"Numeric","Caption":"Rate Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ICBillingExpTableNo_Account","FieldType":"Dropdown","Caption":"Intercompany Expense Billing - Account Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"BTEA","LimitToList":true},{"FieldName":"ICBillingExpTableNo_CategoryTable","FieldType":"Dropdown","Caption":" Intercompany Expense Billing – Category Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"BTEC","LimitToList":true},{"FieldName":"ICBillingExpTableNo_Vendor","FieldType":"Dropdown","Caption":"Intercompany Expense Billing - Vendor Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"BTEV","LimitToList":true},{"FieldName":"TKCheckRPPlannedHrs","FieldType":"Checkbox","Caption":"Check Project Plan Planned Hours","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"BillByDefaultConsultants","FieldType":"Dropdown","Caption":"Consultants","DefaultValue":"E","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"N":"No","Y":"Yes","E":"Expense Code"},"LimitToList":true},{"FieldName":"BillByDefaultOtherExp","FieldType":"Dropdown","Caption":"Other Expenses","DefaultValue":"E","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"N":"No","Y":"Yes","E":"Expense Code"},"LimitToList":true},{"FieldName":"BillByDefaultORTable","FieldType":"Numeric","Caption":"Override Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PhoneFormat","FieldType":"String","Caption":"Phone Format","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FaxFormat","FieldType":"String","Caption":"FaxFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"RevType2","FieldType":"Dropdown","Caption":"Consultant","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"RevType3","FieldType":"Dropdown","Caption":"Reimb","DefaultValue":"N","Hidden":true,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"RevType4","FieldType":"Dropdown","Caption":"Revenue Method 4","DefaultValue":"N","Hidden":true,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"RevType5","FieldType":"Dropdown","Caption":"Revenue Method 5","DefaultValue":"N","Hidden":true,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"RevUpsetCategoryToAdjust","FieldType":"Numeric","Caption":"Category to Adjust","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RevUpsetLimits","FieldType":"Checkbox","Caption":"Enable Overall Revenue Limit","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RevUpsetWBS2","FieldType":"WBS2","Caption":"Phase to Adjust","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"RevUpsetWBS3","FieldType":"WBS3","Caption":"Task to Adjust","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"RevUpsetIncludeComp","FieldType":"Checkbox","Caption":"Compensation","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RevUpsetIncludeCons","FieldType":"Checkbox","Caption":"Direct Consultant","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RevUpsetIncludeReimb","FieldType":"Checkbox","Caption":"Reimbursable Allowance","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"FeeFunctionalCurrency","FieldType":"Currency","Caption":"Compensation - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Allowance - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ConsultFeeFunctionalCurrency","FieldType":"Currency","Caption":"Direct Consultantzs - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RevenueMethod","FieldType":"Dropdown","Caption":"Basis","DefaultValue":"U","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"U":"Upset Limits","C":"Revenue Method"},"LimitToList":true},{"FieldName":"Biller","FieldType":"Employee","Caption":"Biller","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"FeeDirLab","FieldType":"Currency","Caption":"Direct Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TotalDirectFees","FieldType":"Numeric","Caption":"Direct Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"TotalDirectFeesBilling","FieldType":"Numeric","Caption":"Direct Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"TotalDirectFeesFunc","FieldType":"Numeric","Caption":"Direct Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"FeeDirExp","FieldType":"Currency","Caption":"Direct Expenses","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowExp","FieldType":"Currency","Caption":"Reimbursable Expense","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowCons","FieldType":"Currency","Caption":"Reimbursable Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirLabBillingCurrency","FieldType":"Currency","Caption":"Direct Labor - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirExpBillingCurrency","FieldType":"Currency","Caption":"Direct Expenses - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowExpBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Expense - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowConsBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Consultantzs - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirLabFunctionalCurrency","FieldType":"Currency","Caption":"Direct Labor - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirExpFunctionalCurrency","FieldType":"Currency","Caption":"Direct Expenses - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowExpFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Expense - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowConsFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Consultantzs - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Total","FieldType":"Numeric","Caption":"Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"TotalBilling","FieldType":"Numeric","Caption":"Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"TotalFunc","FieldType":"Numeric","Caption":"Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"RevUpsetIncludeCompDirExp","FieldType":"Checkbox","Caption":"Rev Upset Include Comp DirExp","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RevUpsetIncludeReimbCons","FieldType":"Checkbox","Caption":"Rev Upset Include Reimb Cons","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"OurRole","FieldType":"Dropdown","Caption":"Responsibility","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20,"CodeTable":"CFGPRResponsibility","LimitToList":true},{"FieldName":"ServProCode","FieldType":"Dropdown","Caption":"Service Profile","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGServiceProfile","LimitToList":true},{"FieldName":"FESurchargePct","FieldType":"Numeric","Caption":"FE Surcharge Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FESurcharge","FieldType":"Numeric","Caption":"FE Surcharge","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FEAddlExpensesPct","FieldType":"Numeric","Caption":"FE Add lExpenses Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FEAddlExpenses","FieldType":"Numeric","Caption":"FE Add lExpenses","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FEOtherPct","FieldType":"Numeric","Caption":"FE Other Pct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FEOther","FieldType":"Numeric","Caption":"FE Other","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProjectTemplate","FieldType":"Dropdown","Caption":"Ajera Project Template","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGProjectTemplate","LimitToList":true},{"FieldName":"AjeraSync","FieldType":"Checkbox","Caption":"Sync to Ajera","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"AjeraSpentLabor","FieldType":"Numeric","Caption":"Ajera Spent Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraSpentReimbursable","FieldType":"Numeric","Caption":"Ajera Spent Reimbursable","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraSpentConsultant","FieldType":"Numeric","Caption":"Ajera Spent Consultant","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraCostLabor","FieldType":"Numeric","Caption":"Ajera Cost Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraCostReimbursable","FieldType":"Numeric","Caption":"Ajera Cost Reimbursable","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraCostConsultant","FieldType":"Numeric","Caption":"Ajera Cost Consultant","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraWIPLabor","FieldType":"Numeric","Caption":"Ajera WIP Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraWIPReimbursable","FieldType":"Numeric","Caption":"Ajera WIP Reimbursable","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraWIPConsultant","FieldType":"Numeric","Caption":"Ajera WIP Consultant","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraBilledLabor","FieldType":"Numeric","Caption":"Ajera Billed Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraBilledReimbursable","FieldType":"Numeric","Caption":"Ajera Billed Reimbursable","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraBilledConsultant","FieldType":"Numeric","Caption":"Ajera Billed Consultant","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraReceivedLabor","FieldType":"Numeric","Caption":"Ajera Received Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraReceivedReimbursable","FieldType":"Numeric","Caption":"Ajera Received Reimbursable","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraReceivedConsultant","FieldType":"Numeric","Caption":"Ajera Received Consultant","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TLInternalKey","FieldType":"String","Caption":"TLInternalKey","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"TLProjectID","FieldType":"String","Caption":"TLProjectID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"TLProjectName","FieldType":"String","Caption":"TLProjectName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"TLChargeBandInternalKey","FieldType":"String","Caption":"TLChargeBandInternalKey","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"TLChargeBandExternalCode","FieldType":"String","Caption":"TLChargeBandExternalCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":14},{"FieldName":"TLSyncModDate","FieldType":"Date","Caption":"TLSyncModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Stage","FieldType":"Dropdown","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGProjectStage","LimitToList":true},{"FieldName":"IQID","FieldType":"String","Caption":"IQ Record","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"SFID","FieldType":"String","Caption":"SF Record","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":18},{"FieldName":"SFLastModifiedDate","FieldType":"Datetime","Caption":"SF Last Update Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Revenue","FieldType":"Currency","Caption":"Estimated Fee","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"WeightedRevenue","FieldType":"Currency","Caption":"Weighted Fee","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Probability","FieldType":"Dropdown","Caption":"Probability","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGProbability","LimitToList":true},{"FieldName":"TotalContractValue","FieldType":"Currency","Caption":"Owner Value","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"Source","FieldType":"Dropdown","Caption":"Source","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGOpportunitySource","LimitToList":true},{"FieldName":"OpenDate","FieldType":"Date","Caption":"Opened","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CloseDate","FieldType":"Date","Caption":"Won/Lost Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClosedReason","FieldType":"Dropdown","Caption":"Won/Lost Reason","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGOpportunityClosedReason","LimitToList":true},{"FieldName":"ClosedReasonDescription","FieldType":"String","Caption":"ClosedReasonDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClosedNotes","FieldType":"Memo","Caption":"Won/Lost Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProposalManager","FieldType":"Employee","Caption":"Proposal Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"MarketingCoordinator","FieldType":"Employee","Caption":"Marketing Coordinator","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"BusinessDeveloperLead","FieldType":"Employee","Caption":"Business Development Lead","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"MasterContract","FieldType":"Dropdown","Caption":"Master Contract","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGMasterContract","LimitToList":true},{"FieldName":"NAICS","FieldType":"Dropdown","Caption":"NAICS","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGNAICS","LimitToList":true},{"FieldName":"Solicitation","FieldType":"String","Caption":"Solicitation #","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"CompetitionType","FieldType":"Dropdown","Caption":"Government Competition Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGCompetitionType","LimitToList":true},{"FieldName":"ContractTypeGovCon","FieldType":"Dropdown","Caption":"Government Contract Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGContractTypeGovCon","LimitToList":true},{"FieldName":"AwardType","FieldType":"Dropdown","Caption":"Government Award Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGAwardType","LimitToList":true},{"FieldName":"PeriodOfPerformance","FieldType":"Numeric","Caption":"Period of Performance (PoP)","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":0},{"FieldName":"Duration","FieldType":"String","Caption":"Duration","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"EstStartDate","FieldType":"Date","Caption":"Estimated Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EstEndDate","FieldType":"Date","Caption":"EstEndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AvailableForCRM","FieldType":"Checkbox","Caption":"CRM Users","DefaultValue":"Y","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1},{"FieldName":"ReadyForApproval","FieldType":"Checkbox","Caption":"Accounting Users","DefaultValue":"Y","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1},{"FieldName":"UtilizationScheduleFlg","FieldType":"Dropdown","Caption":"Capacity Calculation","DefaultValue":"N","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"N":"Excluded from Scheduled and Utilization","Y":"Included in Scheduled and Utilization","S":"Included in Scheduled"},"LimitToList":true},{"FieldName":"UtilizationScheduleFlgDescription","FieldType":"String","Caption":"UtilizationScheduleFlgDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReadyForProcessing","FieldType":"Checkbox","Caption":"Approved for Use in Processing","DefaultValue":"Y","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":40},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"CodeTable":"CFGProjectStatus","LimitToList":true},{"FieldName":"BillByDefault","FieldType":"Dropdown","Caption":"Bill by Default","DefaultValue":"C","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"Y":"Yes","N":"No","C":"Category"},"LimitToList":true},{"FieldName":"BillByDefaultDescription","FieldType":"String","Caption":"BillByDefaultDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CostRateMeth","FieldType":"Dropdown","Caption":"Cost Method","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"0":"None","1":"From Labor Rate Table","2":"From Category Rate Table","3":"From [Labor Code] Table","4":"From [Employee] Pay Rate"},"LimitToList":true},{"FieldName":"PayRateMeth","FieldType":"Dropdown","Caption":"Pay Method","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"0":"None","1":"From Labor Rate Table","2":"From Category Rate Table","3":"From [Labor Code] Table","4":"From [Employee] Pay Rate"},"LimitToList":true},{"FieldName":"PayRateTableNo","FieldType":"Numeric","Caption":"Pay Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CostRateTableNo","FieldType":"Numeric","Caption":"Cost Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CostRateTableNo_LaborRate","FieldType":"Dropdown","Caption":"Cost Method - Labor Rate Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGCOSTRT","LimitToList":true},{"FieldName":"PayRateTableNo_LaborRate","FieldType":"Dropdown","Caption":"Pay Method - Labor Rate Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGPAYRT","LimitToList":true},{"FieldName":"CostRateTableNo_CategoryRate","FieldType":"Dropdown","Caption":"Cost Method - Category Rate Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGCOSTCT","LimitToList":true},{"FieldName":"PayRateTableNo_CategoryRate","FieldType":"Dropdown","Caption":"Pay Method - Category Rate Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGPAYCT","LimitToList":true},{"FieldName":"CostRateTableNo_LaborCode","FieldType":"Dropdown","Caption":"Cost Method - Labor Code Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGCOSTLT","LimitToList":true},{"FieldName":"PayRateTableNo_LaborCode","FieldType":"Dropdown","Caption":"Pay Method - Labor Code Table","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGPAYLT","LimitToList":true},{"FieldName":"LineItemApproval","FieldType":"Checkbox","Caption":"Line Item Approval","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"LineItemApprovalEK","FieldType":"Checkbox","Caption":"Apply Expense Approval Condition","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RequireComments","FieldType":"Dropdown","Caption":"Require Comments for Hours","DefaultValue":"C","Hidden":false,"Required":true,"Updateable":true,"MaxLength":1,"Codes":{"C":"Company","Y":"Yes","N":"No"},"LimitToList":true},{"FieldName":"CopyBillingTerms","FieldType":"String","Caption":"CopyBillingTerms","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CopyChildren","FieldType":"String","Caption":"CopyChildren","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CopyPlan","FieldType":"String","Caption":"CopyPlan","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"PlanOutlineNumber","FieldType":"String","Caption":"PlanOutlineNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"PlanStartDate","FieldType":"Date","Caption":"Plan Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PlanEndDate","FieldType":"Date","Caption":"Plan End Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SourceType","FieldType":"String","Caption":"SourceType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"SourceWbs1","FieldType":"String","Caption":"SourceWbs1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"SourceWbs2","FieldType":"String","Caption":"SourceWbs2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"SourceWbs3","FieldType":"String","Caption":"SourceWbs3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"_transType","FieldType":"String","Caption":"_transType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LostTo","FieldType":"Firm","Caption":"Lost To","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"_canRead","FieldType":"String","Caption":"_canRead","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"_rowType","FieldType":"String","Caption":"_rowType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PIMID","FieldType":"String","Caption":"PIM","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ClientName","FieldType":"Client","Caption":"Primary Client Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ClientAddress","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"ClientCityStateZip","FieldType":"String","Caption":"ClientCityStateZip","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"ClientPrimaryAddress","FieldType":"String","Caption":"Primary Client Primary Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"ClientPhone","FieldType":"String","Caption":"Primary Client Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"OrgName","FieldType":"String","Caption":"Organization","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"ContactName","FieldType":"String","Caption":"Primary Contact Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":75},{"FieldName":"ContactLastName","FieldType":"String","Caption":"Primary Contact Last","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"ContactFirstName","FieldType":"String","Caption":"Primary Contact First","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":25},{"FieldName":"ContactWorkPhone","FieldType":"Phone","Caption":"Primary Contact Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactWorkPhoneFormat","FieldType":"String","Caption":"Primary Contact Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactHomePhone","FieldType":"Phone","Caption":"Primary Contact Home","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactHomePhoneFormat","FieldType":"String","Caption":"Primary Contact Home Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactCellPhone","FieldType":"Phone","Caption":"Primary Contact Mobile","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactCellPhoneFormat","FieldType":"String","Caption":"Primary Contact Cell Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactEmail","FieldType":"String","Caption":"Primary Contact Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"ContactPager","FieldType":"Phone","Caption":"Primary Contact Pager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactFax","FieldType":"Phone","Caption":"Primary Contact Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactSuffix","FieldType":"Dropdown","Caption":"Primary Contact Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20,"CodeTable":"CFGSuffix","LimitToList":true},{"FieldName":"ContactSalutation","FieldType":"Dropdown","Caption":"Primary Contact Prefix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGPrefix","LimitToList":true},{"FieldName":"ContactTitle","FieldType":"Dropdown","Caption":"Primary Contact Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGContactTitle","LimitToList":false},{"FieldName":"ContactBusinessAddress","FieldType":"String","Caption":"Primary Contact Business Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactHomeAddress","FieldType":"String","Caption":"Primary Contact Other/Home Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactMailingAddress","FieldType":"String","Caption":"Primary Contact Mailing Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AssociatedContactFirmType","FieldType":"String","Caption":"AssociatedContactFirmType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AssociatedContactFirmRole","FieldType":"String","Caption":"AssociatedContactFirmRole","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProjMgrName","FieldType":"Employee","Caption":"Project Manager Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"ProjMgrPhone","FieldType":"String","Caption":"Project Manager Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ProjMgrPhoneFormat","FieldType":"String","Caption":"ProjMgrPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ProjMgrEmail","FieldType":"String","Caption":"Project Manager Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"ProjMgrTitle","FieldType":"Dropdown","Caption":"Project Manager Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"PrincipalName","FieldType":"Employee","Caption":"Principal-In-Charge Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"PrincipalPhone","FieldType":"String","Caption":"Principal-In-Charge Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"PrincipalPhoneFormat","FieldType":"String","Caption":"PrincipalPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"PrincipalEmail","FieldType":"String","Caption":"Principal Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"PrincipalTitle","FieldType":"Dropdown","Caption":"Principal-In-Charge Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"SupervisorName","FieldType":"Employee","Caption":"Supervisor Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"SupervisorPhone","FieldType":"String","Caption":"Supervisor Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"SupervisorPhoneFormat","FieldType":"String","Caption":"SupervisorPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"SupervisorEmail","FieldType":"String","Caption":"Supervisor Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"SupervisorTitle","FieldType":"Dropdown","Caption":"Supervisor Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"BillerName","FieldType":"Employee","Caption":"Biller Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"BillerPhone","FieldType":"String","Caption":"Biller Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"BillerPhoneFormat","FieldType":"String","Caption":"BillerPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"BillerEmail","FieldType":"String","Caption":"Biller Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"BillerTitle","FieldType":"Dropdown","Caption":"Biller Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"StageStep","FieldType":"String","Caption":"Stage Step","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"NAICSDescription","FieldType":"String","Caption":"NAICSDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"NAICSDescriptionConcat","FieldType":"String","Caption":"NAICSDescriptionConcat","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CompetitionTypeDescription","FieldType":"String","Caption":"CompetitionTypeDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProposalManagerName","FieldType":"Employee","Caption":"Proposal Manager Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"ProposalManagerPhone","FieldType":"String","Caption":"Proposal Manager Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProposalManagerPhoneFormat","FieldType":"String","Caption":"ProposalManagerPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ProposalManagerEmail","FieldType":"String","Caption":"Proposal Manager Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProposalManagerTitle","FieldType":"Dropdown","Caption":"Proposal Manager Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"ProposalManagerLocation","FieldType":"String","Caption":"Proposal Manager Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"MarketingCoordinatorName","FieldType":"Employee","Caption":"Marketing Coordinator Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"MarketingCoordinatorPhone","FieldType":"String","Caption":"Marketing Coordinator Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"MarketingCoordinatorPhoneFormat","FieldType":"String","Caption":"MarketingCoordinatorPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"MarketingCoordinatorEmail","FieldType":"String","Caption":"Marketing Coordinator Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"MarketingCoordinatorTitle","FieldType":"Dropdown","Caption":"Marketing Coordinator Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"MarketingCoordinatorLocation","FieldType":"String","Caption":"Marketing Coordinator Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BusinessDeveloperLeadName","FieldType":"Employee","Caption":"Business Developer Lead Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"BusinessDeveloperLeadPhone","FieldType":"String","Caption":"Business Developer Lead Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BusinessDeveloperLeadPhoneFormat","FieldType":"String","Caption":"BusinessDeveloperLeadPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"BusinessDeveloperLeadEmail","FieldType":"String","Caption":"Business Developer Lead Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BusinessDeveloperLeadTitle","FieldType":"Dropdown","Caption":"Business Developer Lead Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGEmployeeTitle","LimitToList":false},{"FieldName":"BusinessDeveloperLeadLocation","FieldType":"String","Caption":"Business Developer Lead Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DaysOpen","FieldType":"Numeric","Caption":"Days Open","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"Decimals":0},{"FieldName":"LostToName","FieldType":"String","Caption":"LostToName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"StageDescription","FieldType":"String","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"key","FieldType":"String","Caption":"key","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":75},{"FieldName":"parentId","FieldType":"String","Caption":"parentId","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":75},{"FieldName":"WBSNumber","FieldType":"String","Caption":"Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":false,"MaxLength":75},{"FieldName":"Level1Name","FieldType":"String","Caption":"Project Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"Level2Name","FieldType":"String","Caption":"Phase Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"Level3Name","FieldType":"String","Caption":"Task Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"Level1Number","FieldType":"String","Caption":"Level1Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"Level2Number","FieldType":"String","Caption":"Level2Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"Level3Number","FieldType":"String","Caption":"Level3Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"WBS1ReadyForProcessing","FieldType":"String","Caption":"WBS1ReadyForProcessing","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"HasPhoto","FieldType":"Numeric","Caption":"Image Uploaded","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PhotoModDate","FieldType":"Datetime","Caption":"PhotoModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingClientName","FieldType":"Client","Caption":"Billing Client Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"BillingClientAddress","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"BillingClientCityStateZip","FieldType":"String","Caption":"Billing Client City State Zip","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"BillingClientCountry","FieldType":"Dropdown","Caption":"Billing Client Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"FW_CFGCOUNTRY","LimitToList":true},{"FieldName":"BillingClientsPhone","FieldType":"String","Caption":"BillingClientsPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingClientsPhoneFormat","FieldType":"String","Caption":"BillingClientsPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"BillingClientContact","FieldType":"Contact","Caption":"Billing Client Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingClientEmail","FieldType":"String","Caption":"Billing Client Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingClientPhone","FieldType":"String","Caption":"Billing Client Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingClientPhoneFormat","FieldType":"String","Caption":"BillingClientPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"BillingClientMobilePhone","FieldType":"String","Caption":"Billing Client Mobile Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"BillingClientMobilePhoneFormat","FieldType":"String","Caption":"BillingClientMobilePhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"OwnerName","FieldType":"String","Caption":"Owner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OwnerAddress","FieldType":"String","Caption":"Owner Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"OwnerCityStateZip","FieldType":"String","Caption":"OwnerCityStateZip","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"OwnerPhone","FieldType":"String","Caption":"Owner Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OwnerPhoneFormat","FieldType":"String","Caption":"OwnerPhoneFormat","DefaultValue":"##-#########","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"RevUpsetWBS2Name","FieldType":"String","Caption":"RevUpsetWBS2Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RevUpsetWBS2SubLevel","FieldType":"String","Caption":"RevUpsetWBS2SubLevel","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"RevUpsetWBS3Name","FieldType":"String","Caption":"RevUpsetWBS3Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"_RecordAccess","FieldType":"String","Caption":"_RecordAccess","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"_RecordAccessParent","FieldType":"String","Caption":"_RecordAccessParent","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"_RecordAccessTopLevel","FieldType":"String","Caption":"_RecordAccessTopLevel","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"_isStructureEditable","FieldType":"Checkbox","Caption":"_isStructureEditable","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"IsUserAnEmployee","FieldType":"String","Caption":"IsUserAnEmployee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBSInTable","FieldType":"String","Caption":"WBSInTable","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasFees","FieldType":"String","Caption":"HasFees","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasJtd","FieldType":"String","Caption":"HasJtd","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasPlanData","FieldType":"String","Caption":"HasPlanData","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasRevenue","FieldType":"String","Caption":"HasRevenue","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false},{"FieldName":"HasDefaultReference","FieldType":"String","Caption":"HasDefaultReference","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasBillingTerms","FieldType":"Checkbox","Caption":"HasBillingTerms","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OrgStatus","FieldType":"String","Caption":"OrgStatus","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"IsMainWBS1","FieldType":"String","Caption":"IsMainWBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"IsBillingGroupWBS1","FieldType":"String","Caption":"IsBillingGroupWBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LaborCode1","FieldType":"Checkbox","Caption":"Department","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LaborCode2","FieldType":"Checkbox","Caption":"Phasex","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LaborCode3","FieldType":"Checkbox","Caption":"Service","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LaborCode4","FieldType":"Checkbox","Caption":"Staff","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LaborCode5","FieldType":"Checkbox","Caption":"Labor Code Level 5","DefaultValue":"N","Hidden":true,"Required":false,"Updateable":true},{"FieldName":"PurchaseOrderIncludeSelectionCodes","FieldType":"Dropdown","Caption":"Purchase Order to Include","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false,"MaxLength":1,"Codes":{"O":"Open","C":"Closed","A":"All"},"LimitToList":true},{"FieldName":"CRMHours","FieldType":"Numeric","Caption":"Hours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CustNewNumericField","FieldType":"Numeric","Caption":"New Numeric Field","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"Decimals":2,"MinValue":0,"MaxValue":5},{"FieldName":"desc_CustLocation","FieldType":"String","Caption":"Location Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustLocation","FieldType":"WBS1","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":10},{"FieldName":"desc_CustBillingCareOf","FieldType":"String","Caption":"Billing Care Of Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustBillingCareOf","FieldType":"Contact","Caption":"Billing Care Of","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_CustDarwin","FieldType":"String","Caption":"Darwin Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustDarwin","FieldType":"WBS1","Caption":"Darwin","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":10},{"FieldName":"CustStartDate","FieldType":"Date","Caption":"Start Date","DefaultValue":"2018-12-17","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_CustAccountNumber","FieldType":"String","Caption":"Account Number Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustAccountNumber","FieldType":"Account","Caption":"Account Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":6},{"FieldName":"Custnewcurrencytype","FieldType":"Currency","Caption":"new currency type","DefaultValue":"500","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MinValue":500,"MaxValue":50000},{"FieldName":"CustCurrencyfromStandard","FieldType":"Currency","Caption":"Currency from Standard","DefaultValue":"1000","Hidden":false,"Required":true,"Updateable":true,"CustomField":true,"MinValue":1000,"MaxValue":10000},{"FieldName":"CustProj","FieldType":"Numeric","Caption":"ProjNumTest","DefaultValue":"3","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"Decimals":0},{"FieldName":"desc_CustContactPersonUDF","FieldType":"String","Caption":"Contact Person UDF Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustContactPersonUDF","FieldType":"Employee","Caption":"Contact Person UDF","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5},{"FieldName":"desc_custCaptureManager","FieldType":"String","Caption":"[OPP] Capture Manager Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custCaptureManager","FieldType":"Employee","Caption":"[OPP] Capture Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5},{"FieldName":"custDate","FieldType":"Date","Caption":"[OPP] Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_custLeadConsultant","FieldType":"String","Caption":"[OPP] Lead Consultant Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custLeadConsultant","FieldType":"Firm","Caption":"[OPP] Lead Consultant","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":32},{"FieldName":"desc_custProposalManager","FieldType":"String","Caption":"[OPP] Proposal Manager Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custProposalManager","FieldType":"Employee","Caption":"[OPP] Proposal Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5},{"FieldName":"desc_custTechnicalWriter","FieldType":"String","Caption":"[OPP] Technical Writer Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custTechnicalWriter","FieldType":"Employee","Caption":"[OPP] Technical Writer","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5},{"FieldName":"custUDF","FieldType":"String","Caption":"[OPP] UDF","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTAcronym","FieldType":"String","Caption":"[OPP] Acronym","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTAgency","FieldType":"String","Caption":"[OPP] Agency","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTComments","FieldType":"Memo","Caption":"[OPP] Comments","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTCompetitionType","FieldType":"String","Caption":"[OPP] Competition Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTContractType","FieldType":"String","Caption":"[OPP] Contract Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTCurrentStatus","FieldType":"Memo","Caption":"[OPP] Current Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTDepartment","FieldType":"String","Caption":"[OPP] Department","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTDuration","FieldType":"String","Caption":"[OPP] Duration","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTEstimatedValue","FieldType":"Numeric","Caption":"[OPP] Estimated Value ($K)","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"Decimals":0},{"FieldName":"custINPUTLastUpdate","FieldType":"Date","Caption":"[OPP] IQ Analyst Update","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTID","FieldType":"String","Caption":"[OPP] IQ ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTAgencyWebsite","FieldType":"URL","Caption":"[OPP] IQ Opportunity Link","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTLastGovWinUpdate","FieldType":"Date","Caption":"[OPP] Last IQ Sync","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTNAICSCode","FieldType":"String","Caption":"[OPP] NAICS Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTPotentialBidders","FieldType":"Memo","Caption":"[OPP] Potential Bidders","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTPrimaryOffering","FieldType":"String","Caption":"[OPP] Primary Offering","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTProcurementActivity","FieldType":"Memo","Caption":"[OPP] Procurement Activity","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTProgramDescription","FieldType":"Memo","Caption":"[OPP] Program Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTProgramName","FieldType":"String","Caption":"[OPP] Program Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTSolicitationNumber","FieldType":"String","Caption":"[OPP] Solicitation Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTSummary","FieldType":"Memo","Caption":"[OPP] Summary","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_custExteriorAttributes","FieldType":"String","Caption":"Exterior Attributes Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custExteriorAttributes","FieldType":"Dropdown","Caption":"Exterior Attributes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true},{"FieldName":"CustField2","FieldType":"String","Caption":"Field 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"CustField3","FieldType":"String","Caption":"Field 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custNoofFloors","FieldType":"Numeric","Caption":"No. of Floors","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"Decimals":0},{"FieldName":"CustOtherinfo","FieldType":"String","Caption":"Other info","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"desc_custPropManager","FieldType":"String","Caption":"Prop. Manager Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custPropManager","FieldType":"Employee","Caption":"Prop. Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5}],"Caption":"Projects","CustomTableName":"ProjectCustomTabFields"},"PRAWARDS":{"Keys":"WBS1,WBS2,WBS3,RecordID","TableName":"PRAWARDS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"Institution","FieldType":"String","Caption":"Institution","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"AwardDate","FieldType":"Date","Caption":"Awarded","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Awards"},"PRDESCRIPTIONS":{"Keys":"WBS1,WBS2,WBS3,DescCategory","TableName":"PRDESCRIPTIONS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"DescCategory","FieldType":"Dropdown","Caption":"Category","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":50,"CodeTable":"CFGDescriptionCategory","LimitToList":true},{"FieldName":"DescCategoryDescription","FieldType":"String","Caption":"Category Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Description","FieldType":"Memo","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2147483647},{"FieldName":"DefaultInd","FieldType":"Checkbox","Caption":"Default","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Descriptions"},"PRPROJECTCODES":{"Keys":"WBS1,WBS2,WBS3,ProjectCode","TableName":"PRPROJECTCODES","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"ProjectCode","FieldType":"Dropdown","Caption":"ProjectCode","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":4,"CodeTable":"CFGProjectCode","LimitToList":true},{"FieldName":"Fees","FieldType":"Currency","Caption":"Fees","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Seq","FieldType":"Numeric","Caption":"Seq","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"ProjectCodeSF330","FieldType":"Dropdown","Caption":"ProjectCodeSF330","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":4,"CodeTable":"CFGProjectCode","LimitToList":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":75},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Project Codes"},"PRPROPOSALS":{"Keys":"WBS1,CustomPropID","TableName":"CustomProposal","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"CustomPropID","FieldType":"String","Caption":"CustomPropID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Name","FieldType":"String","Caption":"Proposals - Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"FieldName":"Number","FieldType":"String","Caption":"Proposals - Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"ProposalManager","FieldType":"Employee","Caption":"Proposal Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"ProposalManagerName","FieldType":"String","Caption":"ProposalManagerName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProposalManagerNamefl","FieldType":"String","Caption":"ProposalManagerNamefl","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DueDate","FieldType":"Date","Caption":"Proposals - Due Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DateAdvertised","FieldType":"Date","Caption":"Proposals - Date Advertised","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"SubmittalDate","FieldType":"Date","Caption":"Proposals - Submittal Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AwardDate","FieldType":"Date","Caption":"Proposals - Award Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Org","FieldType":"Org","Caption":"Proposals - Org","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":11},{"FieldName":"OrgName","FieldType":"String","Caption":"OrgName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClientID","FieldType":"Client","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ClientName","FieldType":"String","Caption":"ClientName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"ProjectName","FieldType":"String","Caption":"ProjectName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Proposals - Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGProposalStatus","LimitToList":true},{"FieldName":"Source","FieldType":"Dropdown","Caption":"Proposals - Source","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGProposalSource","LimitToList":true},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30,"CodeTable":"CFGProposalType","LimitToList":true},{"FieldName":"Fee","FieldType":"Currency","Caption":"Proposals - Fee","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Notes","FieldType":"Memo","Caption":"Proposals - Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DisplayCreator","FieldType":"String","Caption":"Creator","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DisplayModUser","FieldType":"String","Caption":"DisplayModUser","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProposalType","FieldType":"Dropdown","Caption":"Proposal Type","DefaultValue":"Custom","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30,"Codes":{"Custom":"Custom","SF330":"SF330","Legacy":"Legacy Proposal"},"LimitToList":true},{"FieldName":"LinkedSF330","FieldType":"String","Caption":"LinkedSF330","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32}],"Caption":"Proposals"},"PRCONTACTASSOC":{"Keys":"WBS1,ContactID","TableName":"PRCONTACTASSOC","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"ContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ContactName","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Role","FieldType":"Dropdown","Caption":"Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGContactRole","LimitToList":true},{"FieldName":"RoleDescription","FieldType":"Memo","Caption":"Role Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PrimaryInd","FieldType":"Checkbox","Caption":"Primary","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"TeamStatus","FieldType":"Dropdown","Caption":"Team Status","DefaultValue":"Proposed","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"Proposed":"Proposed","Active":"Active"},"LimitToList":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AjeraSync","FieldType":"Checkbox","Caption":"Sync to Ajera","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ContactLastName","FieldType":"String","Caption":"Last","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"ContactFirstName","FieldType":"String","Caption":"First","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":25},{"FieldName":"ContactBusPhone","FieldType":"Phone","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactBusPhoneFormat","FieldType":"String","Caption":"Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactHomePhone","FieldType":"Phone","Caption":"Home","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactHomePhoneFormat","FieldType":"String","Caption":"Home Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactCellPhone","FieldType":"Phone","Caption":"Mobile","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactCellPhoneFormat","FieldType":"String","Caption":"Cell Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactPager","FieldType":"Phone","Caption":"Pager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactFax","FieldType":"Phone","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"ContactEmail","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"ContactSuffix","FieldType":"Dropdown","Caption":"Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20,"CodeTable":"CFGSuffix","LimitToList":true},{"FieldName":"ContactSalutation","FieldType":"Dropdown","Caption":"Prefix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGPrefix","LimitToList":true},{"FieldName":"ContactTitle","FieldType":"Dropdown","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGContactTitle","LimitToList":false},{"FieldName":"FirmID","FieldType":"Client","Caption":"Firm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32}],"Caption":"Contacts"},"EMPROJECTASSOC":{"Keys":"RecordID","TableName":"EMPROJECTASSOC","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"RecordID","FieldType":"String","Caption":"Record Id","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"Role","FieldType":"Dropdown","Caption":"Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGEmployeeRole","LimitToList":true},{"FieldName":"RoleDescription","FieldType":"Memo","Caption":"Role Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TeamStatus","FieldType":"Dropdown","Caption":"Team Status","DefaultValue":"Proposed","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"Proposed":"Proposed","Active":"Active"},"LimitToList":true},{"FieldName":"StartDate","FieldType":"Date","Caption":"StartDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"EndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CRMHours","FieldType":"Numeric","Caption":"CRMHours","DefaultValue":"0","Hidden":true,"Required":false,"Updateable":false,"Decimals":2},{"FieldName":"EmployeeName","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EmployeeLastName","FieldType":"String","Caption":"Last Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"EmployeeFirstName","FieldType":"String","Caption":"First Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":25},{"FieldName":"EmployeeBusPhone","FieldType":"Phone","Caption":"Work Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"EmployeeBusPhoneFormat","FieldType":"String","Caption":"Work Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"EmployeeCellPhone","FieldType":"Phone","Caption":"Mobile","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"EmployeeCellPhoneFormat","FieldType":"String","Caption":"Mobile Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"EmployeeFax","FieldType":"Phone","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"EmployeeEmail","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"EmployeeSuffix","FieldType":"Dropdown","Caption":"Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGSuffix","LimitToList":true},{"FieldName":"EmployeeSalutation","FieldType":"Dropdown","Caption":"Prefix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGPrefix","LimitToList":true},{"FieldName":"EmployeeTitle","FieldType":"Dropdown","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGEmployeeTitle","LimitToList":false}],"Caption":"Employees"},"CONTRACTCREDIT":{"Keys":"WBS1,ContractNumber,Employee","TableName":"CONTRACTCREDIT","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContractNumber","FieldType":"String","Caption":"Contract Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"EmployeeName","FieldType":"String","Caption":"Employee Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PercentCredit","FieldType":"Numeric","Caption":"Percent","DefaultValue":"0","Hidden":false,"Required":true,"Updateable":true,"Decimals":2,"MinValue":0}],"Caption":"Contract Credit"},"PRCOMPETITION":{"Keys":"RecordID","TableName":"PRCOMPETITIONASSOC","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"ClientID","FieldType":"Client","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"clName","FieldType":"String","Caption":"Firms","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Strengths","FieldType":"Memo","Caption":"Strengths","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Weakness","FieldType":"Memo","Caption":"Weaknesses","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Notes","FieldType":"Memo","Caption":"Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Incumbent","FieldType":"Checkbox","Caption":"Incumbent","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1}],"Caption":"Competition"},"CONTRACTDETAILS":{"Keys":"WBS1,WBS2,WBS3,ContractNumber","TableName":"CONTRACTDETAILS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContractNumber","FieldType":"String","Caption":"Contract Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS1Name","FieldType":"String","Caption":"WBS1Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"Phase Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS2Name","FieldType":"String","Caption":"WBS2Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"Task Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3Name","FieldType":"String","Caption":"WBS3Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FunctionalCurrencyCode","FieldType":"Dropdown","Caption":"Functional Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"FeeDirLab","FieldType":"Currency","Caption":"Direct Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirExp","FieldType":"Currency","Caption":"Direct Expense","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Fee","FieldType":"Currency","Caption":"Compensation","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ConsultFee","FieldType":"Currency","Caption":"Direct Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowExp","FieldType":"Currency","Caption":"Reimbursable Expense","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowCons","FieldType":"Currency","Caption":"Reimbursable Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllow","FieldType":"Currency","Caption":"Reimbursable Allowance","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Total","FieldType":"Currency","Caption":"Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirLabBillingCurrency","FieldType":"Currency","Caption":"Direct Labor - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirExpBillingCurrency","FieldType":"Currency","Caption":"Direct Expenses - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeBillingCurrency","FieldType":"Currency","Caption":"Compensation - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ConsultFeeBillingCurrency","FieldType":"Currency","Caption":"Direct Consultantzs - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowExpBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Expense - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowConsBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Consultantzs - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Allowance - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TotalBillingCurrency","FieldType":"Currency","Caption":"Total - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirLabFunctionalCurrency","FieldType":"Currency","Caption":"Direct Labor - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeDirExpFunctionalCurrency","FieldType":"Currency","Caption":"Direct Expenses - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FeeFunctionalCurrency","FieldType":"Currency","Caption":"Compensation - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ConsultFeeFunctionalCurrency","FieldType":"Currency","Caption":"Direct Consultantzs - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowExpFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Expense - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowConsFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Consultantzs - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReimbAllowFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Allowance - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TotalFunctionalCurrency","FieldType":"Currency","Caption":"Total - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TotalDirectFees","FieldType":"Currency","Caption":"Direct Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalDirectFeesBilling","FieldType":"Currency","Caption":"Direct Consultantzs Billing","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalDirectFeesFunc","FieldType":"Currency","Caption":"Direct Consultantzs Functional","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SubLevel","FieldType":"String","Caption":"SubLevel","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"key","FieldType":"String","Caption":"key","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"parentId","FieldType":"String","Caption":"parentId","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBSNumber","FieldType":"String","Caption":"WBSNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"depth","FieldType":"Numeric","Caption":"depth","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReadyForProcessing","FieldType":"Checkbox","Caption":"ReadyForProcessing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContractDescription","FieldType":"String","Caption":"ContractDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DummyRow","FieldType":"Checkbox","Caption":"DummyRow","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"_RecordAccess","FieldType":"Checkbox","Caption":"_RecordAccess","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"hasChildren","FieldType":"Checkbox","Caption":"hasChildren","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Contract Details"},"CONTRACTS":{"Keys":"WBS1,ContractNumber","TableName":"CONTRACTS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContractNumber","FieldType":"String","Caption":"Contract Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":30},{"FieldName":"ContractDescription","FieldType":"String","Caption":"ContractDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"ContractStatus","FieldType":"Dropdown","Caption":"Contract Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGContractStatus","LimitToList":true},{"FieldName":"ContractStatusDesc","FieldType":"String","Caption":"Contract Status Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeIncludeInd","FieldType":"Checkbox","Caption":"Include in Fees","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RequestDate","FieldType":"Date","Caption":"Request Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ApprovedDate","FieldType":"Date","Caption":"Approved Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Period","FieldType":"Dropdown","Caption":"Period","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Codes":{"0":"History","200605":"5/2006","200606":"6/2006","200607":"7/2006","200608":"8/2006","200609":"9/2006","200610":"10/2006","200611":"11/2006","200612":"12/2006","200701":"1/2007","200702":"2/2007","200703":"3/2007","200704":"4/2007","200705":"5/2007","200706":"6/2007","200707":"7/2007","200708":"8/2007","200709":"9/2007","200710":"10/2007","200711":"11/2007","200712":"12/2007"},"LimitToList":true},{"FieldName":"ContractType","FieldType":"Dropdown","Caption":"Contract Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGContractType","LimitToList":true},{"FieldName":"ContractTypeDesc","FieldType":"String","Caption":"Contract Type Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeDirLab","FieldType":"Currency","Caption":"Direct Labor","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeDirExp","FieldType":"Currency","Caption":"Direct Expense","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Fee","FieldType":"Currency","Caption":"Compensation","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConsultFee","FieldType":"Currency","Caption":"Direct Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowExp","FieldType":"Currency","Caption":"Reimbursable Expense","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowCons","FieldType":"Currency","Caption":"Reimbursable Consultantzs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllow","FieldType":"Currency","Caption":"Reimbursable Allowance","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Total","FieldType":"Currency","Caption":"Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeDirLabBillingCurrency","FieldType":"Currency","Caption":"Direct Labor - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeDirExpBillingCurrency","FieldType":"Currency","Caption":"Direct Expenses - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeBillingCurrency","FieldType":"Currency","Caption":"Compensation - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConsultFeeBillingCurrency","FieldType":"Currency","Caption":"Direct Consultantzs - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowExpBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Expense - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowConsBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Consultantzs - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowBillingCurrency","FieldType":"Currency","Caption":"Reimbursable Allowance - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalBillingCurrency","FieldType":"Currency","Caption":"Total - Billing Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeDirLabFunctionalCurrency","FieldType":"Currency","Caption":"Direct Labor - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeDirExpFunctionalCurrency","FieldType":"Currency","Caption":"Direct Expenses - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FeeFunctionalCurrency","FieldType":"Currency","Caption":"Compensation - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConsultFeeFunctionalCurrency","FieldType":"Currency","Caption":"Direct Consultantzs - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowExpFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Expense - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowConsFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Consultantzs - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReimbAllowFunctionalCurrency","FieldType":"Currency","Caption":"Reimbursable Allowance - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalFunctionalCurrency","FieldType":"Currency","Caption":"Total - Functional Currency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Notes","FieldType":"String","Caption":"Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true}],"Caption":"Contracts"},"MKTCAMPAIGNPROJECTASSOC":{"Keys":"WBS1,WBS2,WBS3,CampaignID","TableName":"MKTCAMPAIGNPROJECTASSOC","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"CampaignID","FieldType":"Mkt","Caption":"CampaignID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CampaignName","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"CampaignMgr","FieldType":"Employee","Caption":"CampaignMgr","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"CampaignMgrName","FieldType":"String","Caption":"marketing campaign Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGCampaignType","LimitToList":true},{"FieldName":"TypeDescription","FieldType":"String","Caption":"Type Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGCampaignStatus","LimitToList":true},{"FieldName":"RecordStatus","FieldType":"Dropdown","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGCampaignRecStatus","LimitToList":true},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Marketing Campaigns"},"Activity":{"Keys":"ActivityID","TableName":"Activity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ClientID","FieldType":"Firm","Caption":"Firms","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ContactID","FieldType":"Contact","Caption":"Primary Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"CreateEmployee","FieldType":"Employee","Caption":"Create Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"CampaignID","FieldType":"Mkt","Caption":"Marketing Campaign","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CompletionInd","FieldType":"Checkbox","Caption":"Completed","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"isTask","FieldType":"Checkbox","Caption":"Is task item","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"isCalendar","FieldType":"Checkbox","Caption":"Is calendar item","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"Activity","Hidden":false,"Required":true,"Updateable":true,"MaxLength":15,"CodeTable":"CFGActivityType","LimitToList":true},{"FieldName":"acType","FieldType":"String","Caption":"acType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":15},{"FieldName":"TypeName","FieldType":"String","Caption":"Type Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Subject","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":255},{"FieldName":"StartDate","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StartDateObj","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InstanceStartDate","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Priority","FieldType":"Dropdown","Caption":"Priority","DefaultValue":"Medium","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"High":"High","Medium":"Medium","Low":"Low"},"LimitToList":true},{"FieldName":"PriorityDesc","FieldType":"Dropdown","Caption":"PriorityDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"LimitToList":true},{"FieldName":"EndDate","FieldType":"Datetime","Caption":"End Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDateObj","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Duration","FieldType":"Numeric","Caption":"Duration","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PrivateInd","FieldType":"Checkbox","Caption":"Private","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ReminderInd","FieldType":"String","Caption":"Reminder","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ReminderUnit","FieldType":"Numeric","Caption":"ReminderUnit","DefaultValue":"15","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReminderMinHrDay","FieldType":"String","Caption":"ReminderMinHrDay","DefaultValue":"Minutes","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"ReminderDate","FieldType":"Datetime","Caption":"Reminder Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ShowTimeAs","FieldType":"Dropdown","Caption":"Show Time As","DefaultValue":"Busy","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20,"Codes":{"Busy":"Busy","Free":"Free","Outoftheoffice":"Out of the office","Tentative":"Tentative"},"LimitToList":true},{"FieldName":"AllDayEventInd","FieldType":"Checkbox","Caption":"All Day Event","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"LeadID","FieldType":"String","Caption":"LeadID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Owner","FieldType":"Employee","Caption":"Owner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"OwnerName","FieldType":"String","Caption":"OwnerName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":45},{"FieldName":"ClientName","FieldType":"String","Caption":"ClientName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"ContactName","FieldType":"String","Caption":"ContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":45},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":8},{"FieldName":"VendorName","FieldType":"String","Caption":"VendorName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactIDForVendor","FieldType":"Contact","Caption":"Vendor Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ContactNameForVendor","FieldType":"String","Caption":"ContactNameForVendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactPhoneForVendor","FieldType":"String","Caption":"ContactPhoneForVendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"VendorContactName","FieldType":"String","Caption":"VendorContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProjName","FieldType":"String","Caption":"ProjName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":80},{"FieldName":"MktName","FieldType":"String","Caption":"MktName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Location","FieldType":"String","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Notes","FieldType":"Memo","Caption":"Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"HasNotes","FieldType":"String","Caption":"HasNotes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"RP","FieldType":"String","Caption":"RP","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrenceInd","FieldType":"Checkbox","Caption":"Repeats","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrType","FieldType":"String","Caption":"Repeats","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"RecurrDailyFreq","FieldType":"Numeric","Caption":"Days","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrDailyWeekDay","FieldType":"String","Caption":"Repeat","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrWeeklySun","FieldType":"String","Caption":"Sun","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyMon","FieldType":"String","Caption":"Mon","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyTue","FieldType":"String","Caption":"Tue","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyWed","FieldType":"String","Caption":"Wed","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyThu","FieldType":"String","Caption":"Thu","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyFri","FieldType":"String","Caption":"Fri","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklySat","FieldType":"String","Caption":"Sat","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrMonthlyFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurInd","FieldType":"String","Caption":" ","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrMonthlyOccur","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyMonth","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrEndType","FieldType":"String","Caption":"Ends","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrStartDate","FieldType":"Date","Caption":"Recurrence Starts","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrEndDate","FieldType":"Date","Caption":"Recurrence Ends","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TaskCompletionDate","FieldType":"Date","Caption":"Task Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrID","FieldType":"String","Caption":"RecurrID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OutlookType","FieldType":"String","Caption":"OutlookType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecurrYearlyOccurInd","FieldType":"String","Caption":" ","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccur","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccurDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccurMonth","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"MaxOccurences","FieldType":"Numeric","Caption":"MaxOccurences","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"UpdateID","FieldType":"String","Caption":"UpdateID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReadID","FieldType":"String","Caption":"ReadID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryClient","FieldType":"Client","Caption":"Primary Firm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"Attendees","FieldType":"Contact","Caption":"Attendees","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Associations","FieldType":"Firm","Caption":"Associations","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"EndDateSort","FieldType":"String","Caption":"EndDateSort","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EndDateFilter","FieldType":"String","Caption":"EndDateFilter","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConversationID","FieldType":"String","Caption":"Conversation ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateUserName","FieldType":"User","Caption":"CreateUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUserName","FieldType":"User","Caption":"ModUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SingleOccurrenceDateTime","FieldType":"Datetime","Caption":"Single occurrence date time ","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ActivityTypeFlag","FieldType":"String","Caption":"Activity type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ParentMaxOccurences","FieldType":"Numeric","Caption":"ParentMaxOccurences","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrStartDate","FieldType":"Date","Caption":"ParentRecurrStartDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrEndDate","FieldType":"Date","Caption":"ParentRecurrEndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrEndType","FieldType":"String","Caption":"ParentRecurrEndType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrType","FieldType":"String","Caption":"ParentRecurrType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OccurrenceDate","FieldType":"Datetime","Caption":"OccurrenceDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ExceptionType","FieldType":"String","Caption":"ExceptionType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TimeZoneOffset","FieldType":"Numeric","Caption":"TimeZoneOffset","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true}],"Caption":"Activity"},"PRMILESTONE":{"Keys":"RecordID","TableName":"PRMILESTONE","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Code","FieldType":"Dropdown","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CodeTable":"CFGProjectMilestone","LimitToList":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Notes","FieldType":"Memo","Caption":"Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"SystemInd","FieldType":"String","Caption":"SystemInd","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"WBSName","FieldType":"String","Caption":"WBSName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WBSLongName","FieldType":"String","Caption":"WBSLongName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"EndDate","FieldType":"Date","Caption":"End Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true}],"Caption":"Milestones"},"PRINVOICE":{"Keys":null,"TableName":"PRINVOICE","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"MainWBS1","FieldType":"WBS1","Caption":"MainWBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"ClientID","FieldType":"String","Caption":"Billing\u003cbr/\u003eClient","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingClientName","FieldType":"String","Caption":"Billing\u003cbr/\u003eClient","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceNumber","FieldType":"String","Caption":"Invoice","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceDate","FieldType":"Date","Caption":"Invoice\u003cbr/\u003eDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LinkCompany","FieldType":"String","Caption":"LinkCompany","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ICBillInvoice","FieldType":"String","Caption":"ICBillInvoice","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DaysOutstanding","FieldType":"Numeric","Caption":"Days\u003cbr/\u003eOut","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreditMemoRefNo","FieldType":"String","Caption":"Credit Memo Ref No","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreditMemoRefNoTransDate","FieldType":"Date","Caption":"Credit Memo Ref No Transaction Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceAmt","FieldType":"Currency","Caption":"Invoice\u003cbr/\u003eTotal","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaidAmt","FieldType":"Currency","Caption":"Amount\u003cbr/\u003ePaid","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RetainageAmt","FieldType":"Currency","Caption":"Retainage","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalARAmt","FieldType":"Currency","Caption":"Total Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RetainerAmt","FieldType":"Currency","Caption":"Applied\u003cbr/\u003eRetainer","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TaxAmt","FieldType":"Currency","Caption":"Total\u003cbr/\u003eTax","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InterestAmt","FieldType":"Currency","Caption":"Interest\u003cbr/\u003eAmount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreditMemoAmt","FieldType":"Currency","Caption":"Credit\u003cbr/\u003eMemos","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DueAmt","FieldType":"Currency","Caption":"Amount\u003cbr/\u003eDue","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ICCompany","FieldType":"String","Caption":"ICCompany","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DetailsFlg","FieldType":"String","Caption":"DetailsFlg","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvHasCreditMemo","FieldType":"String","Caption":"Invoince Has Credit Memo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CommentFlg","FieldType":"String","Caption":"Comment Flag","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ViewFlg","FieldType":"String","Caption":"View\u003cbr/\u003eInvoice","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Edited","FieldType":"String","Caption":"Edited","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FinalInvoiceFileID","FieldType":"String","Caption":"FinalInvoiceFileID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FileName","FieldType":"String","Caption":"FileName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"PRINVOICE"},"PRINVOICESUMMARY":{"Keys":null,"TableName":"PRINVOICESUMMARY","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"HasInvoice","FieldType":"String","Caption":"Invoice","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasComment","FieldType":"String","Caption":"Comment","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Approve","FieldType":"String","Caption":"Approve","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Reject","FieldType":"String","Caption":"Reject","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceTotal","FieldType":"Currency","Caption":"Invoice Total","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceNumber","FieldType":"String","Caption":"Invoice Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceDate","FieldType":"Date","Caption":"Invoice Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Invoice Summary"},"PRARAGING":{"Keys":null,"TableName":"PRARAGING","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"BilledAmt","FieldType":"Currency","Caption":"Billed Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReceivedAmt","FieldType":"Currency","Caption":"Received Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RetainageAmt","FieldType":"Currency","Caption":"Retainage Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalARAmt","FieldType":"Currency","Caption":"Total Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AROver30","FieldType":"Currency","Caption":"AROver30","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AROver45","FieldType":"Currency","Caption":"AROver45","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AROver60","FieldType":"Currency","Caption":"AROver60","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AROver90","FieldType":"Currency","Caption":"AROver90","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AROver120","FieldType":"Currency","Caption":"AROver120","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false}],"Caption":"PRARAGING"},"PRFILELINKS":{"Keys":"LinkID,WBS1,WBS2,WBS3","TableName":"PRFileLinks","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"LinkID","FieldType":"String","Caption":"LinkID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"String","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"FieldName":"FilePath","FieldType":"String","Caption":"File Path","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":255},{"FieldName":"Graphic","FieldType":"Checkbox","Caption":"Graphic","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Links"},"FW_ATTACHMENTS":{"Keys":"PKey,FileID","TableName":"FW_ATTACHMENTS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":36},{"FieldName":"Key1","FieldType":"String","Caption":"Key1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Key2","FieldType":"WBS2","Caption":"Key2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Key3","FieldType":"WBS3","Caption":"Key3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS1","FieldType":"String","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3},{"FieldName":"CategoryCode","FieldType":"Dropdown","Caption":"Category","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":15,"CodeTable":"FW_CFGAttachmentCategory","LimitToList":true},{"FieldName":"CategoryDescription","FieldType":"String","Caption":"Category Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"FileName","FieldType":"String","Caption":"File Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":250},{"FieldName":"FileDescription","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":500},{"FieldName":"FileSize","FieldType":"Numeric","Caption":"File Size","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Application","FieldType":"String","Caption":"Application","DefaultValue":"Projects","Hidden":false,"Required":false,"Updateable":true,"MaxLength":250},{"FieldName":"ContentType","FieldType":"String","Caption":"Content Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":200},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Files"},"CLENDORPROJECTASSOC":{"Keys":"WBS1,WBS2,WBS3,ClientID","TableName":"CLENDORPROJECTASSOC","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"PKey","FieldType":"Numeric","Caption":"PKey","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClientID","FieldType":"Firm","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Role","FieldType":"Dropdown","Caption":"Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGClientRole","LimitToList":true},{"FieldName":"RoleDescription","FieldType":"Memo","Caption":"RoleDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TeamStatus","FieldType":"Dropdown","Caption":"Team Status","DefaultValue":"Proposed","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"Proposed":"Proposed","Active":"Active"},"LimitToList":true},{"FieldName":"Address","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"Address1","FieldType":"String","Caption":"Address Line 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Address2","FieldType":"String","Caption":"Address Line 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"State","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"Country","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"ZIP","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"CompleteAddress","FieldType":"String","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DisplayAddress","FieldType":"String","Caption":"Display Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryInd","FieldType":"Checkbox","Caption":"Primary","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ClientConfidential","FieldType":"Checkbox","Caption":"Client Confidential","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ClientInd","FieldType":"Checkbox","Caption":"Client","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"VendorInd","FieldType":"Checkbox","Caption":"Vendor","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ClientName","FieldType":"String","Caption":"ClientName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AddressPhone","FieldType":"String","Caption":"AddressPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RoleName","FieldType":"String","Caption":"RoleName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CostAmount","FieldType":"Numeric","Caption":"CostAmount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecordType","FieldType":"Dropdown","Caption":"RecordType","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"Codes":{"Vendor":"Vendor","Client":"Client"},"LimitToList":true},{"FieldName":"IsClient","FieldType":"String","Caption":"IsClient","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"IsSubconsultant","FieldType":"String","Caption":"IsSubconsultant","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WebSite","FieldType":"String","Caption":"WebSite","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Firms"},"PREMP":{"Keys":"WBS1,WBS2,WBS3,RecordID","TableName":"PREMP","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"RecordID","FieldType":"String","Caption":"RecordID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"PrimaryInd","FieldType":"Checkbox","Caption":"PrimaryInd","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Role","FieldType":"String","Caption":"Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"RoleDescription","FieldType":"String","Caption":"Role Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CFGRoleDescription","FieldType":"String","Caption":"CFG Role Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"lfName","FieldType":"String","Caption":"lfName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"flName","FieldType":"String","Caption":"flName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"ctName","FieldType":"String","Caption":"ctName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"FirmName","FieldType":"String","Caption":"FirmName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"FirmID","FieldType":"Client","Caption":"FirmID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Title","FieldType":"String","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"Phone","FieldType":"String","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"Address1","FieldType":"String","Caption":"Address1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"State","FieldType":"String","Caption":"State","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Zip","FieldType":"String","Caption":"Zip","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"email","FieldType":"String","Caption":"email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"RecordType","FieldType":"String","Caption":"RecordType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"StartDate","FieldType":"Date","Caption":"StartDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"EndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CRMHours","FieldType":"Numeric","Caption":"CRMHours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Employee","FieldType":"String","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"AjeraSync","FieldType":"String","Caption":"AjeraSync","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"TeamStatus","FieldType":"Dropdown","Caption":"Team Status","DefaultValue":"Proposed","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"Proposed":"Proposed","Active":"Active"},"LimitToList":true}],"Caption":"Employees"},"PRCHARGECOMPANIES":{"Keys":"WBS1,WBS2,WBS3,Company","TableName":"PRCHARGECOMPANIES","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Company","FieldType":"Company","Caption":"Company","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":14},{"FieldName":"FirmName","FieldType":"String","Caption":"FirmName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":42}],"Caption":"Charge Companies"},"PRLABORCODE":{"Keys":"TaskID","TableName":"PNTASK","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"TaskID","FieldType":"String","Caption":"TaskID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"LaborCode","FieldType":"String","Caption":"LaborCode","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBSType","FieldType":"String","Caption":"WBSType","DefaultValue":"LBCD","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"PlanID","FieldType":"String","Caption":"PlanID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"ParentOutlineNumber","FieldType":"String","Caption":"ParentOutlineNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OutlineNumber","FieldType":"String","Caption":"OutlineNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OutlineLevel","FieldType":"Numeric","Caption":"OutlineLevel","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StartDate","FieldType":"Datetime","Caption":"StartDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ActualStart","FieldType":"Datetime","Caption":"ActualStart","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BaselineStart","FieldType":"Datetime","Caption":"BaselineStart","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EarlyStart","FieldType":"Datetime","Caption":"EarlyStart","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LateStart","FieldType":"Datetime","Caption":"LateStart","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ScheduledStart","FieldType":"Datetime","Caption":"ScheduledStart","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Datetime","Caption":"EndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ActualFinish","FieldType":"Datetime","Caption":"ActualFinish","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BaselineFinish","FieldType":"Datetime","Caption":"BaselineFinish","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EarlyFinish","FieldType":"Datetime","Caption":"EarlyFinish","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LateFinish","FieldType":"Datetime","Caption":"LateFinish","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ScheduledFinish","FieldType":"Datetime","Caption":"ScheduledFinish","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"String","Caption":"CreateUser","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"CreateDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUser","FieldType":"String","Caption":"ModUser","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"ModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProjMgr","FieldType":"String","Caption":"ProjMgr","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ChargeType","FieldType":"String","Caption":"ChargeType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProjectType","FieldType":"String","Caption":"ProjectType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Status","FieldType":"String","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Org","FieldType":"String","Caption":"Org","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"_rowType","FieldType":"String","Caption":"_rowType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"PNTASK"},"EB":{"Keys":"WBS1,WBS2,WBS3,Account,Vendor","TableName":"EB","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"Phase Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"Task Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3},{"FieldName":"Account","FieldType":"Account","Caption":"Account","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":6},{"FieldName":"AccountName","FieldType":"String","Caption":"Account Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"FieldName":"AccountType","FieldType":"Numeric","Caption":"Accounttype","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Vendor","DefaultValue":" ","Hidden":false,"Required":false,"Updateable":true,"MaxLength":8},{"FieldName":"VendorName","FieldType":"String","Caption":"Vendor Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"FieldName":"Pct","FieldType":"Numeric","Caption":"% Complete","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"BillBud","FieldType":"Numeric","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BillEACAmt","FieldType":"Numeric","Caption":"EAC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BillETCAmt","FieldType":"Numeric","Caption":"ETC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StartDate","FieldType":"Date","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"End Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"JTDSpentBill","FieldType":"Currency","Caption":"JTD Spent","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AmtBud","FieldType":"Numeric","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EACAmt","FieldType":"Numeric","Caption":"EAC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ETCAmt","FieldType":"Numeric","Caption":"ETC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"JTDSpentCost","FieldType":"Currency","Caption":"JTD Spent","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Actual","FieldType":"Checkbox","Caption":"Actual","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"JTDAdded","FieldType":"Checkbox","Caption":"JTDAdded","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BudgetedLessJTDCost","FieldType":"Currency","Caption":"Budgeted Less JTD Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BudgetedLessJTDBill","FieldType":"Currency","Caption":"Budgeted Less JTD Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false}],"Caption":"ExpenseBudget"},"LB":{"Keys":"WBS1,WBS2,WBS3,LaborCode","TableName":"LB","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"Phase Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"Task Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":3},{"FieldName":"LaborCode","FieldType":"LABCD","Caption":"Labor Code","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"LaborCodeName","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"FieldName":"Pct","FieldType":"Numeric","Caption":"% Complete","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":2},{"FieldName":"HrsBud","FieldType":"Numeric","Caption":"Hours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Rate","FieldType":"Numeric","Caption":"Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"AmtBud","FieldType":"Numeric","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EACHrs","FieldType":"Numeric","Caption":"EAC Hrs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EACAmt","FieldType":"Numeric","Caption":"EAC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ETCHrs","FieldType":"Numeric","Caption":"ETC Hrs","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ETCAmt","FieldType":"Numeric","Caption":"ETC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StartDate","FieldType":"Date","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDate","FieldType":"Date","Caption":"End Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"JTDHours","FieldType":"Numeric","Caption":"JTD Hours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"JTDSpentCost","FieldType":"Currency","Caption":"JTD Spent","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillRate","FieldType":"Numeric","Caption":"Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"BillBud","FieldType":"Numeric","Caption":"Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BillEACAmt","FieldType":"Numeric","Caption":"EAC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BillETCAmt","FieldType":"Numeric","Caption":"ETC Amt","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"JTDSpentBill","FieldType":"Currency","Caption":"JTD Spent","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Actual","FieldType":"Checkbox","Caption":"Actual","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"JTDAdded","FieldType":"Checkbox","Caption":"JTDAdded","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BudgetedLessJTDCost","FieldType":"Currency","Caption":"Budgeted Less JTD Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BudgetedLessJTDBill","FieldType":"Currency","Caption":"Budgeted Less JTD Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false}],"Caption":"LaborBudget"},"AR":{"Keys":"WBS1,WBS2,WBS3,Invoice","TableName":"AR","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3},{"FieldName":"Invoice","FieldType":"String","Caption":"Invoice","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"FieldName":"UnpaidInvoice","FieldType":"String","Caption":"Invoice (unpaid)","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"FieldName":"Period","FieldType":"Numeric","Caption":"Period","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaidPeriod","FieldType":"Numeric","Caption":"PaidPeriod","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceDate","FieldType":"Date","Caption":"InvoiceDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvBalanceSourceCurrency","FieldType":"Currency","Caption":"InvBalanceSourceCurrency","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"IsPaid","FieldType":"String","Caption":"IsPaid","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Invoices"},"PRREVENUE":{"Keys":"RevAllocID,WBS1,WBS2,WBS3","TableName":"PRREVENUE","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"RevAllocID","FieldType":"String","Caption":"RevAllocID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"FieldName":"RevenueDate","FieldType":"Date","Caption":"Revenue Date","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"RevenueAmt","FieldType":"Numeric","Caption":"Revenue Amount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Decimals":4},{"FieldName":"PercentRevenue","FieldType":"Numeric","Caption":"Percent Revenue","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5,"Decimals":2},{"FieldName":"CreateUser","FieldType":"String","Caption":"Create User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUser","FieldType":"String","Caption":"Modified User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true}],"Caption":"PRREVENUE"},"PRLABOR":{"Keys":"LaborID,WBS1","TableName":"PRLABOR","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"LaborID","FieldType":"String","Caption":"Labor ID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"FieldName":"EstimateHrs","FieldType":"Numeric","Caption":"Estimated Hours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15,"Decimals":0},{"FieldName":"EstimateCost","FieldType":"Currency","Caption":"Estimated Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"EstimateBill","FieldType":"Currency","Caption":"Estimated Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"CostRate","FieldType":"Currency","Caption":"Cost Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"BillingRate","FieldType":"Currency","Caption":"Billing Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"Category","FieldType":"Numeric","Caption":"Category","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"SeqNo","FieldType":"Numeric","Caption":"Sequence Number","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"GenericResourceID","FieldType":"String","Caption":"Generic Resource ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"GenericResourceName","FieldType":"String","Caption":"Generic Resource Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"String","Caption":"Create User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUser","FieldType":"String","Caption":"Modified User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true}],"Caption":"PRLABOR"},"PREXPENSE":{"Keys":"ExpenseID,WBS1","TableName":"PREXPENSE","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ExpenseID","FieldType":"String","Caption":"Expense ID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Account","FieldType":"Account","Caption":"Account Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":6},{"FieldName":"AccountName","FieldType":"String","Caption":"Account Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OppExpCost","FieldType":"Currency","Caption":"Estimated Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"OppExpBill","FieldType":"Currency","Caption":"Estimated Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"DirectAcctFlg","FieldType":"Dropdown","Caption":"Direct Account Flag","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"Y":"Y","N":"N"},"LimitToList":true},{"FieldName":"SeqNo","FieldType":"Numeric","Caption":"Sequence Number","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"CreateUser","FieldType":"String","Caption":"Create User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUser","FieldType":"String","Caption":"Modified User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Billable","FieldType":"String","Caption":"Direct Account Flag","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1}],"Caption":"PREXPENSE"},"PRUNIT":{"Keys":"UnitID,WBS1","TableName":"PRUNIT","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"UnitID","FieldType":"String","Caption":"Unit ID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Unit","FieldType":"Unit","Caption":"Unit","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"UnitName","FieldType":"String","Caption":"Unit Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"UnitTable","FieldType":"UnitTable","Caption":"Unit Table","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"PlannedQty","FieldType":"Numeric","Caption":"Planned Quantity","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15,"Decimals":0},{"FieldName":"PlannedCost","FieldType":"Currency","Caption":"Estimated Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"PlannedBill","FieldType":"Currency","Caption":"Estimated Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"CostRate","FieldType":"Currency","Caption":"Cost Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"BillingRate","FieldType":"Currency","Caption":"Billing Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DirectAcctFlg","FieldType":"String","Caption":"Direct Account Flag","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"SeqNo","FieldType":"Numeric","Caption":"Sequence Number","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"CreateUser","FieldType":"String","Caption":"Create User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUser","FieldType":"String","Caption":"Modified User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true}],"Caption":"PRUNIT"},"PRCONSULTANT":{"Keys":"ConsultantID,WBS1","TableName":"PRCONSULTANT","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ConsultantID","FieldType":"String","Caption":"Consultantz ID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Account","FieldType":"Account","Caption":"Account Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":6},{"FieldName":"AccountName","FieldType":"String","Caption":"Account Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OppConCost","FieldType":"Currency","Caption":"Estimated Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"OppConBill","FieldType":"Currency","Caption":"Estimated Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"Digits":15},{"FieldName":"DirectAcctFlg","FieldType":"Dropdown","Caption":"Direct Account Flag","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"Y":"Y","N":"N"},"LimitToList":true},{"FieldName":"SeqNo","FieldType":"Numeric","Caption":"Sequence Number","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"CreateUser","FieldType":"String","Caption":"Create User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ModUser","FieldType":"String","Caption":"Modified User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Billable","FieldType":"String","Caption":"Billable","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"PRCONSULTANT"},"PRESTIMATEANALYSIS":{"Keys":"WBS1","TableName":"PRESTIMATEANALYSIS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalCost","FieldType":"Currency","Caption":"Total Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TotalBill","FieldType":"Currency","Caption":"Total Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"GrossMargin","FieldType":"Currency","Caption":"Gross Margin","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"GrossMarginPercent","FieldType":"Currency","Caption":"Gross Margin Percentage","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false}],"Caption":"PRESTIMATEANALYSIS"},"PRESTIMATESUMMARY":{"Keys":"WBS1","TableName":"PRESTIMATESUMMARY","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"RowType","FieldType":"String","Caption":"RowType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PlannedHours","FieldType":"Numeric","Caption":"Planned Hours","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CostRate","FieldType":"Numeric","Caption":"Cost Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PlannedCost","FieldType":"Currency","Caption":"Planned Cost","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PlannedBill","FieldType":"Currency","Caption":"Planned Bill","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PlannedCostDirect","FieldType":"Currency","Caption":"Planned Cost - Direct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PlannedBillDirect","FieldType":"Currency","Caption":"Planned Bill - Direct","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PlannedCostReimbursable","FieldType":"Currency","Caption":"Planned Cost - Reimbursable","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PlannedBillReimbursable","FieldType":"Currency","Caption":"Planned Bill - Reimbursable","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingRate","FieldType":"Numeric","Caption":"Billing Rate","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false}],"Caption":"PRESTIMATESUMMARY"},"Projects_Custtestcompany":{"Keys":"Seq,WBS1,WBS2,WBS3","CustomTable":true,"TableName":"Projects_Custtestcompany","GridID":"Custtestcompany","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"desc_Custtest","FieldType":"String","Caption":"test Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"Custtest","FieldType":"Org","Caption":"test","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":11}],"Caption":"test company"},"Projects_INPUTAddedBy":{"Keys":"Seq,WBS1,WBS2,WBS3","CustomTable":true,"TableName":"Projects_INPUTAddedBy","GridID":"custAddedBy","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"desc_CustINPUTName","FieldType":"String","Caption":"Name Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustINPUTName","FieldType":"Employee","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":5}],"Caption":"[OPP] Added By"},"Projects_INPUTKeyContacts":{"Keys":"Seq,WBS1,WBS2,WBS3","CustomTable":true,"TableName":"Projects_INPUTKeyContacts","GridID":"custINPUTKeyContacts","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"custINPUTContactType","FieldType":"String","Caption":"Contact Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTEmail","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTFirstName","FieldType":"String","Caption":"First Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTLastName","FieldType":"String","Caption":"Last Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTPhone","FieldType":"String","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custINPUTTitle","FieldType":"String","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"[OPP] Key Contacts"},"Projects_RCETEST":{"Keys":"Seq,WBS1,WBS2,WBS3","CustomTable":true,"TableName":"Projects_RCETEST","GridID":"custRCETEST","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"[OPP] RCETEST"},"Projects_KeyDates":{"Keys":"Seq,WBS1,WBS2,WBS3","CustomTable":true,"TableName":"Projects_KeyDates","GridID":"custKeyDates","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"WBS1","FieldType":"WBS1","Caption":"WBS1","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":" ","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"custINPUTDate","FieldType":"Date","Caption":"Date (IQ Estimate)","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custINPUTMilestone","FieldType":"String","Caption":"Milestone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"[OPP] Key Dates"}}