INPUT FILE INFORMATION

Column No

Column Name

Costpoint 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

Character

20

R

I

2

DFLT_PROJ_ID

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

20

O/D

48

SUBCTR_ID

Subcontractor No

Character

20

O/D

49

CUST_PO_ID

Purchase Order No

Character

20

O/D

50

DMS_DPS_CD

DPAS Purchasing Rating

Character

6

O

51

PURGED_FL

Character

1

O

Y, N

52

LAST_BUD_CO_ ID

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_FL

Cobra Program

Character

1

R

I, D

Y, N

63

COBRA_WBS

Cobra Mapping Value

Character

59

O

Any value up to 59 characters.

64

SFT_FL

Export to Shop Floor Time

Character

1

O

Y, N

65

SFT_EDIT_FL

Export to Shop Floor Time – Allow Edit

Character

1

O

Y, N

66

MES_FL

Export to Manufacturing Execution

Character

1

O

Y, N

67

MES_EDIT_FL

Export to Manufacturing Execution – Allow Edit

Character

1

O

Y, N

Column No

Column Name

Costpoint     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

Character

20

R

I

2

PROJ_ID

Project

Character

30

R

I

3

PROJ_MOD_ DESC

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

14

R

I

8

PROJ_V_FEE_ AMT

Value Modifications — Fee

Number

14

R

I

9

PROJ_F_CST_ AMT

Funding Modifications — Cost

Number

14

R

I

10

PROJ_F_FEE_ AMT

Funding Modifications — Fee

Number

14

R

I

11

PROJ_MOD_ID

ID

Character

10

O/D

12

DELIV_UNITS_ QTY

Number of Units to Deliver

Number

14

R

I

13

EST_UNIT_CST_ AMT

Estimated Cost per Unit

Number

14

R

I

14

UNIT_PRICE_ AMT

Price per Unit

Number

14

R

I

15

CLIN_ID

CLIN

Character

10

O

16

EFFECT_DT

Effective Date

Date

10

R

I

Date format must match the Microsoft Windows format defined in Control Panel/Regional Settings.

Column No

Column Name

Costpoint 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

Character

20

R

I

2

DFLT_PROJ_ID

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

14

R

I, D

7

REV_CALC_ AMT

(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.)

Number

14

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

14

O/D

11

REV_CALC2_ AMT

(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.)

Number

14

O/D

12

LBR_MULT_RT

Goal Multiplier — Labor

Number

14

O/D

13

NLBR_MULT_ RT

Goal Multiplier — Non Labor

Number

14

O/D

14

DISC_TYPE_CD

Discount Method

Varchar

4

R

I, D

NONE, PLC, ACCT, CUST, PROJ

Column No

Column Name

Costpoint     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

Character

20

R

I

2

DFLT_PROJ_ID

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

10

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

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

14

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

14

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

Number

14

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

10

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.

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint       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

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

Column No

Column Name

Costpoint     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

Character

20

R

I

2

DFLT_PROJ_ID

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

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

Column No

Column Name

Costpoint 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

Character

20

R

I

2

DFLT_PROJ_ID

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

WAWF 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

WAWF Ship To Extension Code

Character

6

O

43

MARK_DELIV_EXT_CD

WAWF 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

49

WAWF_SUBMIT_DT

Date Financial Information Submitted to Government

DATE

10

O

Column No

Column Name

Costpoint     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

Character

20

R

I

2

BILL_LAB_ CAT_CD

Lab Cat

Character

6

R

I

3

BILL_LAB_CAT_DESC

Description

Character

30

R

Column No

Column Name

Costpoint     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

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.

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint     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

Character

20

R

I

2

PROJ_ID

Project

Character

30

R

I

3

VEND_ID

Vendor

Character

12

R

I

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint     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

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

4

BILL_LAB_CAT_CD

PLC

Character

6

R

I

5

DFLT_FL

Defaults

Character

1

R

I

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint    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

Character

20

R

I

2

PROJ_ID

Project

Character

30

R

I

3

BILL_LAB_CAT_CD

PLC

Character

6

R

I

4

BILL_RT_AMT

Rate

Number

10

R

I

5

S_BILL_RT_ TYPE_CD

Rate Type

Character

1

R

I

6

START_DT

Starting Date

Date

10

R

I

7

END_DT

Ending Date

Date

10

R

I

8

BILL_DISC_RT

Discount Percentage

Decimal

10, 4

O, D

R

If Discount Percentage is left blank, Costpoint inserts 0.00.

Column No

Column Name

Costpoint     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

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

10

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

10,4

O/D

I

If Discount Percentage is left blank, Costpoint inserts "0.00."

Column No

Column Name

Costpoint     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

Character

20

R

I

2

BILL_LAB_CAT_CD

Lab Cat

Character

6

R

I

3

BILL_RT_AMT

Rate

Number

10

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

10,4

O/D

I

If Discount Percentage is left blank, Costpoint inserts 0.00.

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint     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

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

Ceiling Amount

Number

10

R

I

Column No

Column Name

Costpoint     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

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

Column No

Column Name

Costpoint     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

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

10

R

I

8

CEIL_COM_RT

COM Ceiling

Number

10

R

I

9

ACCT_ID

Account

Character

15

R

I

Column No

Column Name

Costpoint 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

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

10

R

I

Column No

Column Name

Costpoint    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

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

10

R

I

Column No

Column Name

Costpoint    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

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

Character

6

O

Column No

Column Name

Costpoint    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

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

R

I

6

S_RBA_CD

Apply to (RGBA)

Character

1

R

I

R, B, G, or A

Column No

Column Name

Costpoint 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

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

O

I

0 - 1

6

OVRIDE_FEE_HRS _AMT

Fee on Hours

Number

14,4

O

I

Column No

Column Name

Costpoint     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

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

R

I

0 - 1

Column No

Column Name

Costpoint     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

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.

Column No

Column Name

Costpoint     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

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.

Column No

Column Name

Costpoint     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

Character

20

R

I

2

EMPL_ID

Employee

Character

12

R

I

3

ACCT_GRP_CD

Project Account Group

Character

3

R

I

ACCT_GRP_CD

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