Input File Information

Input File Excel Template

Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.

Input File Layout

The first row in every file is reserved for column headings. The program does not read the first row.

Note: If your import files were created as .csv files out of SQL and have an encode type of UTF-8-BOM, you must change the input file encode type to UTF-8 so that Costpoint will recognize the file contents and proceed with the validation and import processes.

PROJ.CSV: Manage Project User Flow

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	DFLT_PROJ_ID	Default Project	Character	30	O
3	PROJ_ID	Project	Character	30	R	I
4	PROJ_TYPE_DC	Project Type	Character	15	R	I, D
5	PROJ_NAME	Name	Character	25	R	I
6	BILL_PROJ_FL	Billable Project	Character	1	R	I, D	Y, N
7	TC_PROJ_FL	Export Project	Character	1	R	I, D	T, E, B, N
8	ORG_ID	Owning Organization	Character	20	R	I, D
9	CEIL_F_CST_RBA_CD	Funding Info, Cost Ceiling Code	Character	1	R	I, D	R, B, A, N
10	CEIL_F_FEE_RBA_CD	Funding Info, Fee Ceiling Code	Character	1	R	I, D	R, B, A, N
11	CEIL_F_TOT_RBA_CD	Funding Info, Total Ceiling Code	Character	1	R	I, D	R, B, A, N
12	CEIL_V_CST_RBA_CD	Value Info, Cost Ceiling Code	Character	1	R	I, D	R, B, A, N
13	CEIL_V_FEE_RBA_CD	Value Info, Fee Ceiling Code	Character	1	R	I, D	R, B, A, N
14	CEIL_V_TOT_RBA_CD	Value Info, Total Ceiling Code	Character	1	R	I, D	R, B, A, N
15	EMPL_ID	Project Manager (ID)	Character	12	O
16	CUST_ID	Customer	Character	12	O
17	NOTES	Notes	Character	254	O
18	S_PROJ_RPT_DC	Project Classification	Character	15	R	I, D	BID & PROPOSAL, COMMON INV, DIRECT PROJECT, INDIRECT, INTER-CO MULTI, INTER-COMPANY, IR&D, WORK IN PROCESS
19	PROJ_WORK_FRC_FL	Project Work Force Required	Character	1	R	I, D	Y, N
20	ACCT_GRP_CD	Account Group	Character	3	R	I, D
21	PROJ_ABBRV_CD	Project Abbreviation	Character	6	O/D
22	ACTIVE_FL	Active	Character	1	R	I, D	Y, N
23	ACCT_GRP_FL	Account Group - Allow Edit	Character	1	R	I, D	Y, N
24	PROJ_RPT_DC_FL	Project Classification - Allow Edit	Character	1	R	I, D	Y, N
25	PROJ_TYPE_FL	Project Type - Allow Edit	Character	1	R	I, D	Y, N
26	ORG_ID_FL	Owning Organization - Allow Edit	Character	1	R	I, D	Y, N
27	EMPL_ID_FL	Project Manager - Allow Edit	Character	1	R	I, D	Y, N
28	CUST_ID_FL	Customer - Allow Edit	Character	1	R	I, D	Y, N
29	FUND_SRCE_FL	Funding Source - Allow Edit	Character	1	R	I, D	Y, N
30	PRIME_CONTR_FL	Prime Contract No - Allow Edit	Character	1	R	I, D	Y, N
31	SUB_CONTR_FL	Subcontractor No - Allow Edit	Character	1	R	I, D	Y, N
32	PO_NO_FL	Purchase Order No - Allow Edit	Character	1	R	I, D	Y, N
33	DMS_DPS_FL	DPAS Purchasing Rating - Allow Edit	Character	1	R	I, D	Y, N
34	ICS_FL	Incurred Cost Submission Code - Allow Edit	Character	1	R	I, D	Y, N
35	CONTR_ST_MMDD_FL	Contract Year - Allow Edit	Character	1	R	I, D	Y, N
36	COM_FL	Apply Cost of Money Rates - Allow Edit	Character	1	R	I, D	Y, N
37	CAS_FL	CAS Covered	Character	1	R	I, D	Y, N
38	EDIT_WORK_FRC_FL	Project Work Force Required - Allow Edit	Character	1	R	I, D	Y, N
39	PROJ_MGR_NAME	Project Manager (Name)	Character	25	O/D
40	DFLT_ORG_ENTRY_FL	Default to Owning Org	Character	1	R	I, D	Y, N
41	TOP_LVL_WRK_FRC_FL	Use Top Level Work Force	Character	1	R	I, D	Y, N
42	ALLOW_CHARGES_FL	Allow Charging	Character	1	R	I, D	Y, N
43	LIMIT_ORGS_FL	Limit Orgs	Character	1	R	I, D	Y, N
44	LIMIT_ACCTS_FL	Limit Accounts	Character	1	R	I, D	Y, N
45	LIMIT_AO_FL	Limit which orgs can charge specific Accts	Character	1	R	I, D	Y, N
46	COM_APPLIC_FL	Apply Cost of Money Rates	Character	1	R	I, D	Y, N
47	PRIME_CONTR_ID	Prime Contract No	Character	30	O/D
48	SUBCTR_ID	Subcontractor No	Character	30	O/D
49	CUST_PO_ID	Purchase Order No	Character	30	O/D
50	DMS_DPS_CD	DPAS Purchasing Rating	Character	6	O
51	PURGED_FL	Purged Flag	Character	1	O		Y, N
52	LAST_BUD_CO_ID	Last Budget Change Order	Number	10	O
53	PROJ_LN_1_ADR	Address Line 1	Character	40	O
54	PROJ_LN_2_ADR	Address Line 2	Character	40	O
55	PROJ_LN_3_ADR	Address Line 3	Character	40	O
56	CITY_NAME	City	Character	25	O
57	MAIL_STATE_DC	State/Province	Character	15	O
58	POSTAL_CD	Zip Code	Character	10	O
59	COUNTRY_CD	Country	Character	8	O
60	PROJ_COUNTY_CD	County	Character	20	O
61	LW_DOC_CD	Lien Waiver Doc Code	Character	6	O
62	COBRA_WBS	Cobra Mapping Value	Character	59	O		Any value up to 59 characters.
63	COBRA_FL	Cobra Project	Character	1	R	I, D	Y, N
64	SFT_FL	Export to Shop Floor Time	Character	1	O		Y, N
65	MES_FL	Export to Manufacturing Execution	Character	1	O		Y, N
66	SFT_EDIT_FL	Export to Shop Floor Time – Allow Edit	Character	1	O		Y, N
67	MES_EDIT_FL	Export to Manufacturing Execution – Allow Edit	Character	1	O		Y, N
68	ACRN_SHOW_MSG_FL	ACRN Warnings With Modifications Changes	Character	1	O/D		Y, N
69	ACRN_MSG_EDIT_FL	ACRN Warnings With Modifications Changes - Allow Edit	Character	1	O/D		Y, N
70	APPLY_SAL_CAP_FL	Apply Salary Cap	Character	1	O		Y,N
71	SAL_CAP_EDIT_FL	Apply Salary Cap - Allow Edit	Character	1	O		Y,N
72	SAL_CAP_CD	Salary Cap Code	Character	15	O
73	TASK_ORDER_NO	Task Order No	Character	50	O	O
74	CNTR_ID	CTM Contract ID	Character	30	O	O
75	OPP_ID	CTM Opportunity ID	Character	32	O	O
76	TASK_ORDER_FL	Task Order No - Allow Edit	Character	1	O	O	Y,N
77	CNTR_ID_FL	CTM Contract ID - Allow Edit	Character	1	O	O	Y,N
78	OPP_ID_FL	CTM Opportunity ID - Allow Edit	Character	1	O	O	Y,N
79	TLNT_FL	Export Project Work Force to Talent	Character	1	O		Y,N
80	TLNT_EDIT_FL	Export Project Work Force to Talent - Allow Edit	Character	1	O		Y,N
81	AGENCY_ID_FL	Agency ID - Allow Edit	Character	1	R		Y,N
82	COTR_NAME_FL	Contract Officer - Allow Edit	Character	1	R		Y,N
83	ACO_NAME_FL	Administrative Officer - Allow Edit	Character	1	R		Y,N
84	PCO_NAME_FL	Procurement Officer - Allow Edit	Character	1	R		Y,N
85	CONT_REP_NAME_FL	Contractor Representative - Allow Edit	Character	1	R		Y,N
86	CONT_REP_TITLE_FL	Contractor Representative Title - Allow Edit	Character	1	R		Y,N
87	ACO_PHONE_ID_FL	Administrative Contracting Officer Phone - Allow Edit	Character	1	R		Y,N
88	ACO_FAX_ID_FL	Administrative Contracting Officer Fax - Allow Edit	Character	1	R		Y,N
89	ACO_EMAIL_ID_FL	Administrative Contracting Officer Email Address - Allow Edit	Character	1	R		Y,N
90	CONT_REP_PHONE_ID_FL	Contractor Representative Phone - Allow Edit	Character	1	R		Y,N
91	CONT_REP_FAX_ID_FL	Contractor Representative Fax - Allow Edit	Character	1	R		Y,N
92	CONT_REP_EMAIL_ID_FL	Contractor Representative Email Address - Allow Edit	Character	1	R		Y,N
93	STMT_OF_WORK_TX_FL	Statement of Work - Allow Edit	Character	1	R		Y,N
94	PROJ_LONG_NAME	Long Name	Character	120	R	I, D

PROJ_MOD.CSV: Manage Modifications

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	PROJ_MOD_DESC	Project Modification Description	Character	30	O/D
4	NOTES	Notes	Character	254	O/D
5	PROJ_START_DT	Period of Performance Start Date	Date	10	O		Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
6	PROJ_END_DT	Period of Performance End Date	Date	10	O		Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
7	PROJ_V_CST_AMT	Value Modifications - Cost	Number	17,2	R	I
8	PROJ_V_FEE_AMT	Value Modifications - Fee	Number	17,2	R	I
9	PROJ_F_CST_AMT	Funding Modifications - Cost	Number	17,2	R	I
10	PROJ_F_FEE_AMT	Funding Modifications - Fee	Number	17,2	R	I
11	PROJ_MOD_ID	ID	Character	10	O/D
12	DELIV_UNITS_QTY	Number of Units to Deliver	Number	22,8	R	I
13	EST_UNIT_CST_AMT	Estimated Cost per Unit	Number	25,10	R	I
14	UNIT_PRICE_AMT	Price per Unit	Number	25,10	R	I
15	CLIN_ID	CLIN	Character	10	O
16	EFFECT_DT	Effective Date	Date	10	R/O	I	Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings. This column is required only if the User Must Enter option is selected on the Configure Project Settings screen. If Default System Date is selected instead, you can leave this column blank and the system date defaults in the modification effective date when project modifications are imported.
17	SUBCNTR_ID	Subcontract ID	Character	30	O

PROJ_REV_SETUP.CSV: Manage Revenue Information

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	DFLT_PROJ_ID	Default Project	Character	30	O
3	PROJ_ID	Project	Character	30	R	I
4	S_REV_FORMULA_CD	Revenue Formula	Character	8	R	I, D	ETC, CPFH, CPFC, BACKLOG, NONE, CVPC, ETBBR, ETBAR, ETPL, ETD, LLR, LLRCINL, LLRCINLB, LLRCINBF, FAYTD, FAMTD, FACTD, UNIT, LLRFNLBF, CIMR, CVPCVSE, RSMNLM, LLRBFNBF, CPFCCMF, COSTIMR, EAC, ITDCPFC
5	AT_RISK_FL	Allow Revenue to Exceed Contract Value	Character	1	R	I, D	Y, N
6	AT_RISK_AMT	Revenue Exceeds Contract Value By How Much?	Number	17,2	R	I, D
7	REV_CALC_AMT	(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.)	Number	19,4	R	I, D
8	REV_TO_OWN_ORG_FL	Post Revenue to Owning or Performing Org	Character	1	R	I, D	O, P
9	UNITS_FL	Calculate Revenue on Units	Character	1	R	I, D	Y, N
10	REV_CALC1_AMT	(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.)	Number	19,4	O/D
11	REV_CALC2_AMT	(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.)	Number	19,4	O/D
12	LBR_MULT_RT	Goal Multiplier - Labor	Number	14,4	O/D
13	NLBR_MULT_RT	Goal Multiplier - Non Labor	Number	14,4	O/D
14	DISC_TYPE_CD	Discount Method	Varchar	4	R	I, D	NONE, PLC, ACCT, CUST, PROJ

PROJ_BILL_INFO.CSV: Manage Project Billing Information

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	DFLT_PROJ_ID	Default Project	Character	30	O
3	INVC_PROJ_ID	Project	Character	30	R	I
4	S_BILL_FORMULA_CD	Formula	Character	8	O		CPFH, CPFC, LLR, LLRCINL, LLRCINLB, LLRCINBF, UNIT, CIMR, COSTIMR 1443, RSMNLM, RSBFNLBF, LLRFNLBF, MANUAL, NONE.
5	BILL_CALC_AMT	(The name changes based on the billing formula. See the "Billing Formula Validation Detail" section.)	Number	19,4	R	I, D
6	CASH_BASIS_FL	Bill Cost Incurred on Cash Basis	Character	1	R	I, D	Y, N
7	S_RTNGE_BASIS_CD	Retainage - Basis for Calculation	Character	3	O		TOT, FEE, HRS
8	RTNGE_PCT_RT	Retainage - Percentage	Number	5	R	I, D
9	CUST_TERMS_KEY	Synthetic Key (System Use)	Number	10	O
10	INCM_STATE_CD	Income State	Character	2	O
11	BILL_CYCLE_CD	Billing Cycle	Character	6	O
12	BILL_GRP_CD	Billing User Group	Character	6	O
13	LAST_BILL_NO_ID	Last Bill Number	Character	15	O/D
14	BILL_FRMT_CD	Generic Billing Format	Character	6	O
15	SPPRT_SCH_FRMT_CD	Supporting Schedule Format	Character	6	O
16	PARTL_BILL_TRN_FL	Allow Transactions To Be Partially Billed	Character	1	R		Y, N
17	S_WHEN_RETAIN_CD	Retainage - Withhold On	Character	6	O/D		EACH, FINAL, FINALF
18	ALLOW_USER_EDIT_FL	Allow User to Edit Bills	Character	1	R	I, D	Y, N
19	S_1035_TYPE	Government 1035 Format Information - Print Cost Plus/Fixed Price Format or Print Using T&M Format	Character	3	O/D		CP, TM
20	ACCT_LVL_1035_NO	Roll Up Accounts to Level	Number	1	O/D	I, D	Between 1 and 8
21	S_BILL_FRMT_TYPE	Format	Character	6	R	I, D	1035, GENRIC, 1443
22	BILL_RMT_ADDR_CD	Remittance Address	Character	6	R
23	BILL_PMT_ADDR_CD	Payment Office	Character	6	O
24	BILL_DESC	Bill Heading	Character	254	O/D
25	S_INVT_BILL_CD	Bill Inventory Issues As (Cost, Units, Accounts)	Character	1	O/D	I, D	C, U, A
26	PRICE_CATLG_CD	Catalog	Character	10	O/D
27	CLIN_ID	CLIN	Character	10	O/D
28	PROGRESS_PMT_RT	Rates - Progress Payment	Number	5	O/D		Between 0 and 100
29	LIQUID_RT	Rates - Liquidation	Number	5	R
30	INIT_AWARD_DT	Initial Award Date	Date	10	O		Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
31	EST_CST_AMT	Estimate to Complete	Number	17,2	O/D
32	S_CONTR_PRICE_CD	Contract Info - Price Basis	Character	2	O/D		CC, CV, FC, FV, O
33	CONTR_OVRIDE_AMT	Other Amount	Number	17,2	O/D
34	CONTR_REP_NAME	Contract Info - Rep Name	Character	25	O/D
35	CONTR_REP_TITLE	Contract Info - Rep Title	Character	25	O/D
36	POP_FL	Limit Transactions to Period of Performance	Character	1	R	I, D	Y, N
37	CONTR_ADDR_CD	Contract Info - Address	Character	6	O
38	MAX_RTNGE_AMT	Retainage - Maximum Amount (Functional Currency)	Number	17,2	R	I, D
39	PAY_WHEN_PAID_FL	Pay When Paid	Character	1	R	I, D	Y, N
40	ALLOW_USER_ADJ_FL	Allow User to Adjust Transactions in Open Billing Detail	Character	1	R	I, D	Y, N
41	BILL_CALC1_AMT	(The name changes depending on the billing formula. See the "Billing Formula Validation Detail" section.)	Number	19,4	R	I, D
42	INCL_LAB_MLTPLR_FL	Include Labor Multiplier in Billing Rate	Character	1	O		Y, N
43	S_CRNCY_CD	Billing Currency	Character	3	R	I, D
44	RT_GRP_ID	Rate Group	Character	6	O
45	FREEZE_RT_FL	Freeze Multicurrency Rate	Character	1	R	I, D	Y, N
46	TRN_CRNCY_FL	Use Transactional Currency Billing	Character	1	O		Y, N
47	BILL_PAID_SUB_FL	Paid Subcontractor Flag	Varchar	1	O		Y, N
48	DISC_TYPE_CD	Discount Method	Varchar	4	R	I, D	NONE, PLC, ACCT, CUST, PROJ
49	DFLT_TM_PROJ_ID	T&M Project	Varchar	30	O		Valid PROJ_ID from PROJ_LAB_CAT_RT_SC table.
50	BILL_DISC_RT	Discount Percentage	Decimal	5,4	O		Number
51	SUBJ_BILL_WH_FL	Subject to Billing Withholding Flag	Character	1	R	I, D	Must be Y or N.
52	BILL_WH_CD	Billing Withholding Code	Character	10	O		If not null, must be valid BILL_WH_CD from BILL_WH_CD table.
53	PROJ_V_TOT_AMT	Value Info - Total Amount	Number	17,2	O		If not in the input file or left blank, Costpoint inserts 0.00.
54	PROJ_V_FEE_AMT	Value Info - Fee Amount	Number	17,2	O		If not in the input file or left blank, Costpoint inserts 0.00.
55	PROJ_V_CST_AMT	Value Info - Cost Amount	Number	17,2	O		If not in the input file or left blank, Costpoint inserts 0.00.
56	CEIL_F_CST_RBA_CD	Funding Info - Cost Ceil	Character	1	O		B, N If left blank, Costpoint inserts N.
57	CEIL_F_FEE_RBA_CD	Funding Info - Fee Ceil	Character	1	O		B, N If left blank, Costpoint inserts N.
58	CEIL_F_TOT_RBA_CD	Funding Info - Total Ceil	Character	1	O		B, N If left blank, Costpoint inserts N.
59	PROJ_F_TOT_AMT	Funding Info -Total Amount	Number	17,2	O		If not in the input file or left blank, Costpoint inserts 0.00.
60	PROJ_F_FEE_AMT	Funding Info - Fee Amount	Number	17,2	O		If not in the input file or left blank, Costpoint inserts 0.00.
61	PROJ_F_CST_AMT	Funding Info - Cost Amount	Number	17,2	O		If not in the input file or left blank, Costpoint inserts 0.00.
62	MUX_MAX_RTNGE_AMT	Retainage - Maximum Amount (Billing Currency)	Number	17,2	O
63	FINAL_BILL_FL	Final Billing Completed Flag	Varchar	1	O		Y, N

Note: If the SUBJ_BILL_WH_FL and BILL_WH_CD columns are not included in the input file, the project is set up with Subject to Withholding = N and no Billing Withholding Code.

PROJ_CUST_SETUP.CSV: Manage Project Billing Information - Customers Subtask

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	CUST_ID	Customer	Character	12	R	I
4	ADDR_DC	Address Code	Character	10	R	I
5	PCT_CNTRB_RT	% of Project Responsibility	Number	5	R	I
6	BANK_ACCT_ABBRV	Remittance Bank	Varchar	6	O
7	IB_BANK_ID	Intermediary Bank	Varchar	15	O

PROJ_ORG_ACCT.CSV: Link Projects/Accounts/Organizations

Column No	Column Name	Field Name	Data Type	Data Length	"R" (Required)/ "O" (Optional)/ "D" (Derived)	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	ORG_ID	Organization	Character	20	R	I
4	ACCT_ID	Account	Character	15	R	I
5	ACTIVE_FL	Active	Character	1	R	I	Y, N
6	REF_STRUC_1_ID	REF 1	Character	20	O
7	REF_STRUC_2_ID	REF 2	Character	20	O

PROJ_GOVT_CONTR.CSV: Manage Government Contract Information

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	DFLT_PROJ_ID	Default Project	Character	30	O
3	PROJ_ID	Project	Character	30	R	I
4	CST_ACCT_STD_FL	CAS Covered	Character	1	R	I, D	Y, N
5	DMS_DPS_CD	DPAS Purchasing Rating	Character	6	O/D
6	CONTR_START_MMDD	Contract Year - From - Month/Day	Date	10	O		Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
7	CONTR_END_MMDD	Contract Year - To - Month/Day	Date	10	O		Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
8	FUND_SRCE_DESC	Funding Source	Character	30	O/D
9	S_ICS_CD	Incurred Cost Submission Code	Character	4	O
10	WD_PLC_FL	Use PLC for Wage Determination	Character	1	R	I, D	Y, N
11	COTR_NAME	Contract Officer	Character	30	O
12	ACO_NAME	Admin. Officer	Character	30	O
13	PCO_NAME	Procurement Officer	Character	30	O
14	STMT_OF_WORK_TX	Statement of Work	Long		O		This column is defined as a "CLOB" data type in Oracle and "text" data type in MSS. When data entry is done via Excel using this template, you may be able to enter a maximum of 32,767 characters only. However, the actual database column can hold up to 2,147,483,647 characters.
15	AGENCY_ID	Agency ID	Character	8	O
16	ACO_PHONE_ID	ACO Phone	Character	25	O
17	ACO_FAX_ID	ACO Fax	Character	25	O
18	CONT_REP_NAME	Contractor Rep	Character	30	O
19	CONT_REP_PHONE_ID	Contractor Representative - Phone	Character	25	O
20	CONT_REP_FAX_ID	Contractor Representative - Fax	Character	25	O
21	CONT_REP_TITLE	Cont Rep Title	Character	30	O
22	GSA_PROJ_FL	Include in Aggregate Volume	Varchar	1	R	I, D	Y, N
23	GSA_EDIT_FL	Allow Edit to Include in Aggregate Volume	Varchar	1	R	I, D	Y, N
24	ACO_EMAIL_ID	Administrative Contracting Officer Email Address	Varchar	100	O
25	CONT_REP_EMAIL_ID	Contractor Representative Email Address	Varchar	100	O

PROJ_LAB_CAT.CSV: Link Project Labor Categories to Projects

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	BILL_LAB_CAT_CD	PLC	Character	6	R	I
4	BILL_LAB_CAT_DESC	Description	Character	30	O/D
5	COBRA_RSRC	Cobra Mapping Value	Character	59	O		Any value up to 59 characters.

PROJ_EMPL.CSV: Manage Employee Work Force

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	EMPL_ID	Employees	Character	12	R	I
4	OT_AUTH_FL	Overtime Authorized for Employees	Character	1	R	I	Y, N

PROJ_VEND.CSV: Manage Vendor Work Force

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	VEND_ID	Vendor	Character	12	R	I

PROJ_VEND_EMPL.CSV: Manage Vendor Employee Work Force

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	VEND_ID	Vendor	Character	12	R	I
4	VEND_EMPL_ID	Vendor Employee	Character	12	R	I

PROJ_EMPL_LAB_CAT.CSV: Manage Employee Work Force - Assign PLC to Employee Work Force subtask

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	EMPL_ID	Employee	Character	12	R	I
4	BILL_LAB_CAT_CD	PLC	Character	6	R	I
5	DFLT_FL	Defaults	Character	1	R	I

PROJ_VEND_LAB_CAT.CSV: Manage Vendor Work Force - Assign PLC to Vendor Work Force subtask

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	VEND_ID	Vendor	Character	12	R	I
4	BILL_LAB_CAT_CD	PLC	Character	6	R	I
5	DFLT_FL	Defaults	Character	1	R	I

PROJ_VEND_EMPL_PLC.CSV: Manage Vendor Employee Work Force - Assign PLC to Vendor Employee Work Force subtask

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	VEND_ID	Vendor	Character	12	R	I
4	VEND_EMPL_ID	Vendor Employee	Character	12	R	I
5	BILL_LAB_CAT_CD	PLC	Character	6	R	I
6	DFLT_FL	Defaults	Character	1	R	I

BILL_LAB_CAT.CSV: Manage Project Labor Categories (PLC)

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	BILL_LAB_CAT_CD	Lab Cat	Character	6	R	I
3	BILL_LAB_CAT_DESC	Description	Character	30	R

PROJ_LAB_CAT_MAP.CSV: Link Project Labor Categories to Projects - Link GLC to Project PLC subtask

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	GENL_LAB_CAT_CD	GLC	Character	6	R	I
4	DF_BILL_LAB_CAT_CD	PLC	Character	6	R	I

PROJ_LAB_CAT_RT_SC.CSV: Link Project Labor Category Rates to Projects

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_LC_RT_KEY	Synthetic Key (System Use)					The system populates this field when a record is added.
3	PROJ_ID	Project	Character	30	R	I
4	BILL_LAB_CAT_CD	PLC	Character	6	R	I
5	BILL_RT_AMT	Rate	Number	19,4	R	I
6	S_BILL_RT_TYPE_CD	Rate Type	Character	1	R	I
7	START_DT	Starting Date	Date	10	R	I
8	END_DT	Ending Date	Date	10	R	I
9	BILL_DISC_RT	Discount Percentage	Decimal	5,4	O, D	R	If Discount Percentage is left blank, Costpoint inserts 0.00.

PROJ_EMPL_RT_SCH.CSV: Link PLC Rates to Employee/Vendor

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	EMPL_ID	Employee	Character	12	R
4	BILL_LAB_CAT_CD	PLC	Character	6	R
5	BILL_RT_AMT	Rate	Number	19,4	R
6	S_BILL_RT_TYPE_CD	Rate Type	Character	1	R
7	START_DT	Starting Date	Date	10	O/D	I	Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
8	END_DT	Ending Date	Date	10	O/D	I	Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
9	BILL_DISC_RT	Discount Percentage	Decimal	5,4	O/D	I	If Discount Percentage is left blank, Costpoint inserts 0.00.

LAB_CAT_RT_SCH.CSV: Manage Project Labor Categories (PLC) - Billing Rates subtask

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	BILL_LAB_CAT_CD	Lab Cat	Character	6	R	I
3	BILL_RT_AMT	Rate	Number	19,4	R	I
4	START_DT	Starting Date	Date	10	O/D	I	Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
5	END_DT	Ending Date	Date	10	O/D	I	Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.
6	BILL_DISC_RT	Discount Percentage	Decimal	5,4	O/D	I	If Discount Percentage is left blank, Costpoint inserts 0.00.

TM_RT_ORDER.CSV: Manage Rate Sequence Orders

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	S_BILL_RT_TBL_CD	Rate Table	Character	6	R	I	C, PC, PEC, PVC
4	SEQ_NO	Seq No	Number	10	R	I
5	SRCE_PROJ_ID	Source Project	Character	30	O
6	TM_RT_ORDER_KEY	Synthetic Key (System Use)					The system populates this field when a record is added.

CEIL_DIR_CST.CSV: Manage Direct Cost Ceilings

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	ACCT_ID	Account	Character	15	R	I
4	S_RBA_CD	Apply to (RBA)	Character	1	R	I	R, B, A, N
5	CEIL_AMT	Functional Currency Ceiling Amount	Number	17,2	R	I
6	MUX_CEIL_AMT	Billing Currency Ceiling Amount	Number	17,2	O

CEIL_DIR_HRS.CSV: Manage Hour Ceilings

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	BILL_LAB_CAT_CD	Labor Cat	Character	6	R	I
4	CEIL_HRS	Hours Ceiling	Number	10	R	I

CEIL_BURDEN_CST.CSV: Manage Burden Cost Ceilings

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	FY_CD	Fiscal Year	Character	6	R	I
4	POOL_NO	Pool	Number	10	R	I
5	S_RBA_CD	Apply to (RBA)	Character	1	R	I	R, B, A, N
6	S_CEIL_TYPE_CD	C/O/F	Character	1	R	I	C, O, F
7	CEIL_RT	Rate Ceiling	Number	14,8	R	I
8	CEIL_COM_RT	COM Ceiling	Number	14,8	R	I
9	ACCT_ID	Account	Character	15	R	I

EMPL_CEIL.CSV: Manage Employee Hour Ceilings

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	BILL_LAB_CAT_CD	Labor Cat	Character	6	R	I
4	EMPL_ID	Employee	Character	12	R	I
5	CEIL_HRS	Hours Ceiling	Number	14,2	R	I

VEND_CEIL.CSV: Manage Vendor Hour Ceilings

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	BILL_LAB_CAT_CD	Labor Cat	Character	6	R	I
4	VEND_ID	Vendor	Character	12	R	I
5	CEIL_HRS	Hours Ceiling	Number	14,2	R	I

PROJ_BILL_INFO_SCH.CSV: Manage Project Billing Information - Detail Levels subtask

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	INVC_PROJ_ID	Project (Invoice)	Character	30	R	I
4	SPPRT_SCH_FRMT_CD	Support Schedule Format Code	Character	6	O

OVRIDE_MLT_ON_DIR.CSV: Manage Multiplier Overrides

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	S_ACCT_ID	Starting Account	Character	15	R	I
4	END_ACCT_ID	Ending Account	Character	15	R	I
5	OVRIDE_MLT_RT	Multiplier	Number	14,4	R	I
6	S_RBA_CD	Apply to (RGBA)	Character	1	R	I	R, B, G, or A

OVRIDE_FEE_ON_DIR.CSV: Manage Cost Fee Overrides

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	ACCT_ID	Account	Character	15	R	I
4	S_RBA_CD	Apply to (RBA)	Character	1	R	I	R, B, A
5	OVRIDE_FEE_RT	Fee Percent	Number	10,8	O	I	0 - 1
6	OVRIDE_FEE_HRS_AMT	Functional Currency Fee on Hours	Number	19,4	O	I
7	MUX_OVRD_FEEHR_AMT	Billing Currency Fee on Hours	Number	19,4	O	I

OVRIDE_FEE_ON_BURD.CSV: Manage Burden Fee Overrides

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	PROJ_ID	Project	Character	30	R	I
3	FY_CD	Fiscal Year	Character	6	R	I
4	POOL_NO	Pool	Number	10	R	I
5	S_RBA_CD	Apply to (RBA)	Character	1	R	I	R, B, or A
6	OVRIDE_FEE_RT	Fee Percent	Number	10,8	R	I	0 - 1

EMPL_PROJ_TS_DFLT.CSV: Manage Employee Project Timesheet Defaults

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	EMPL_ID	Employee	Character	12	R	I
3	PROJ_ID	Project	Character	30	R	I
4	APPLY_LOWER_LVL_FL	Apply to Lower Levels	Character	1	R	I	Y, N
5	ACCT_ID	Account	Character	15	O
6	ORG_ID	Organization	Character	20	O
7	REF1_ID	Reference 1	Character	20	O
8	REF2_ID	Reference 2	Character	20	O
9	REG_PAY_TYPE	Regular Pay Type	Character	3	O
10	GENL_LAB_CAT_CD	GLC	Character	6	O
11	LAB_LOC_CD	Labor Location	Character	6	O
12	WORK_COMP_CD	Worker's Comp	Character	6	O
13	BILL_LAB_CAT_CD	PLC	Character	6	O
14	WH_STATE_CD	W/H State	Varchar	2	O		State Code from STATE table.

LAB_ACCT_GRP_DFLT.CSV: Manage Labor Group Proj-Acct-Group Timesheet Defaults

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	ACCT_GRP_CD	Project Account Group	Character	3	R	I
3	LAB_GRP_TYPE	Labor Group	Character	3	R	I
4	ACCT_ID	Account	Character	15	R	I
5	ORG_ID	Organization	Character	20	O
6	REF1_ID	Reference 1	Character	20	O
7	REF2_ID	Reference 2	Character	20	O
8	REG_PAY_TYPE	Regular Pay Type	Character	3	O
9	GENL_LAB_CAT_CD	GLC	Character	6	O
10	LAB_LOC_CD	Labor Location	Character	6	R
11	WORK_COMP_ CD	Worker's Comp	Character	6	O
12	BILL_LAB_CAT_CD	PLC	Character	6	O
13	WH_STATE_CD	W/H State	Varchar	2	O		State Code from STATE table.

EMPL_ACCT_GRP_DFLT.CSV: Manage Employee Proj-Acct-Group Timesheet Defaults

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	EMPL_ID	Employee	Character	12	R	I
3	ACCT_GRP_CD	Project Account Group	Character	3	R	I
4	ACCT_ID	Account	Character	15	R	I
5	ORG_ID	Organization	Character	20	O
6	REF1_ID	Reference 1	Character	20	O
7	REF2_ID	Reference 2	Character	20	O
8	REG_PAY_TYPE	Regular Pay Type	Character	3	O
9	GENL_LAB_CAT_CD	GLC	Character	6	O
10	LAB_LOC_CD	Labor Location	Character	6	O
11	WORK_COMP_CD	Worker's Comp	Character	6	O
12	BILL_LAB_CAT_CD	PLC	Character	6	O
13	WH_STATE_CD	W/H State	Varchar	2	O		State Code from STATE table.

PROJ_TS_DFLT.CSV: Manage Project Timesheet Defaults

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	USER_ID	User ID	Character	20	R	I
2	DFLT_PROJ_ID	Default Project	Character	30	O
3	PROJ_ID	Project	Character	30	R	I
4	APPLY_LOWER_LVL_FL	Apply to Lower Levels	Character	1	R	I
5	ORG_ID	Organization	Character	20	O
6	ACCT_ID	Account	Character	15	O
7	REF1_ID	Reference 1	Character	20	O
8	REF2_ID	Reference 2	Character	20	O
9	REG_PAY_TYPE	Regular Pay Type	Character	3	O
10	GENL_LAB_CAT_CD	GLC	Character	6	O
11	LAB_LOC_CD	Labor Location	Character	6	O
12	WORK_COMP_CD	Worker's Comp	Character	6	O
13	BILL_LAB_CAT_CD	PLC	Character	6	O
14	WH_STATE_CD	W/H State	Varchar	2	O		State Code from STATE table.

PROJ_WAWF_INFO.CSV: Manage Project iRAPT Information

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	DFLT_PROJ_ID	Default Project	Character	30	O
3	PROJ_ID	Project	Character	30	R	I
4	WAWF_SEND_CAGE_CD	CAGE Code	Character	5	R	I
5	WAWF_INVC_TYPE_CD	Invoice Type	Character	5	R	I
6	WAWF_SRCE_FILE_CD	File Source	Character	1	R	I
7	WAWF_ADMIN_ID	Administration	Character	6	O
8	WAWF_PMT_OFFICE_ID	Payment Office	Character	6	O
9	WAWF_SHIP_TO_ID	Contracting Officer/Ship To	Character	6	O
10	WAWF_MARK_DELIV_ID	Mark For Delivery	Character	6	O
11	WAWF_INSPECT_ID	Inspect By	Character	6	O
12	WAWF_LOCAL_PROC_ID	Local Processing Office	Character	6	O
13	WAWF_SHIP_FROM_ID	Ship From	Character	6	O
14	WAWF_ISSUE_ID	Issue By	Character	6	O
15	WAWF_TASK_ORDER_ID	Task Order	Character	30	O
16	WAWF_LAST_INVC_FL	Final Invoice	Character	1	O
17	WAWF_ATTACHMENT	Attachment File Select	Character	100	O
18	WAWF_LAST_SHIP_FL	Final Shipment	Character	1	O
19	WAWF_COMMENTS	Mark For Delivery Comments	Character	75	O
20	WAWF_2ND_COMMENTS	Mark For Delivery Secondary Comments	Character	75	O
21	WAWF_CERT_FL	Construction Certificate, Certification, Certificate of Conformance	Character	1	O
22	WAWF_SUPPLY_SVC_CD	Type	Character	3	R	I
23	WAWF_INSPECT_PT_CD	Inspection Point	Character	1	R	I
24	WAWF_ACCEPT_PT_CD	Acceptance Point	Character	1	R	I
25	WAWF_FOB_CD	FOB	Character	1	R	I
26	WAWF_ARP_FL	Alternate Release Procedure	Character	1	O
27	WAWF_DELIV_FL	Delivery On Invoice	Character	1	O
28	WAWF_FMS_FL	FMS	Character	1	O
29	WAWF_FIN_INFO_DT	Date of Financial Info	DATE	7	O
30	WAWF_CLIN_MAP_CD	CLIN Mapping Method	Character	1	R	I
31	WAWF_DFLT_CLIN	Default CLIN	Character	10	R (if WAWF_CLIN_MAP_CD = C for default CLIN)	I
32	WAWF_MOCAS_FL	MOCAS Pay System	Varchar	1	R	I
33	WAWF_INSPECT_OTHER	Other Inspection Point	Varchar	6	O
34	WAWF_ACCEPT_OTHER	Other Acceptance Point	Varchar	6	O
35	WAWF_PREV_REQ_NO	Previous Progress Payment Request Number	Varchar	8	O
36	WAWF_CAGE_EXT_CD	CAGE Code Extension	Character	6	O
37	WAWF_DISC_CLIN_FL	Include Discounts and Taxes in CLIN Flag	Character	1	R	D
38	WAWF_UNIT_MAP_CD	Mapping Method for Units Code	Character	1	R	D
39	INSPECT_EXT_CD	iRAPT Inspected By Extension Code	Character	6	O
40	LOCAL_PROC_EXT_CD	Local Processing Office Extension Code	Character	6	O
41	SHIP_FROM_EXT_CD	Ship From Extension Code	Character	6	O
42	SHIP_TO_EXT_CD	iRAPT Ship To Extension Code	Character	6	O
43	MARK_DELIV_EXT_CD	iRAPT Mark for Delivery Extension Code	Character	6	O
44	WAWF_ATTACHMENT_FL	Use Invoice ID as Attachment Name (Y/N)	Character	1	R	D
45	WAWF_FAST_PAY_FL	FastPay Invoice Flag (Y/N)	Character	1	R	D
46	WAWF_LN_HAUL_CD	First Line Haul Mode Code	Character	1	O
47	INSPECT_OTH_EXT_CD	DoDAAC 3rd Party Inspection Extension Code	Character	6	O
48	ACCEPT_OTH_EXT_CD	DoDAAC 3rd Party Acceptance Extension Code	Character	6	O

PROJ_RPT_ID.CSV: Manage Alternate Projects

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_RPT_ID	Project Report	Varchar	30	R	I
3	PROJ_RPT_DESC	Project Report Description	Varchar	25	R	I

TOP_LVL_RPT.CSV: Manage Alternate Projects

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_RPT_ID	Project Report	Varchar	30	R	I
3	LVL_DESC	Level Description	Varchar	30	R	I
4	LVL_LEN_NO	Level Length	Smallint		R	I
5	LVL_NO	Level Number	Smallint		R	I

PROJ_RPT_PROJ.CSV: Manage Alternate Projects - Selected Projects table window

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)
1	USER_ID	User ID	Character	20	R	I
2	PROJ_RPT_ID	Project Report	Varchar	30	R	I
3	PROJ_ID	Project	Varchar	30	R	I
4	INCL_SUBPROJ_FL	Include Sub Project (Y/N)	Varchar	1	R	I

PROJ_ROLE_USER.CSV: Manage Project Roles

Column No	Column Name	Field Name	Data Type	Data Length	Required / Optional / Derived	Required In Input File (I) or Default Project (D)	Contents
1	PROJ_ID	Project ID	Varchar	30	R	I
2	ROLE_CD	Role Code	Varchar	15	R	I
3	USER_ID	User ID	Varchar	20	R	I
4	LOWER_LVL_FL	Apply to Lower Project Levels	Varchar	1	R	I	Y, N

Costpoint Online Help