When you run the export eProcurement project/account/org process, the system generates 10 files. The file data layout of each are the following:
Below is the sequence of the fields to be exported and their source Costpoint column name for the Project Edit file ("PROJ_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
PROJ_EDIT |
PROJ_ID |
Project ID |
VARCHAR |
30 |
|
PROJ_EDIT |
PROJ_ABBRV_CD |
Project Abbreviation |
VARCHAR |
6 |
|
PROJ_EDIT |
PROJ_NAME |
Project Name |
VARCHAR |
25 |
|
PROJ |
DMS_DPS_CD |
DPAS Rating |
VARCHAR |
6 |
|
PROJ |
PRIME_CONTR_ID |
Prime Contract ID |
VARCHAR |
20 |
|
PROJ_EDIT |
PROJ_START_DT |
Project Start Date |
DATE |
|
|
PROJ_EDIT |
PROJ_END_DT |
Project End Date |
DATE |
|
|
PROJ_EDIT |
ACTIVE_FL |
Active (Y/N) |
VARCHAR |
1 |
|
PROJ_EDIT |
LIMIT_ORGS_FL |
Limit Organizations |
VARCHAR |
1 |
|
PROJ_EDIT |
ORG_ID |
Organization ID |
VARCHAR |
20 |
|
PROJ_EDIT |
ALLOW_CHARGES_FL |
Allow Charges (Y/N) |
VARCHAR |
1 |
|
PROJ_EDIT |
LIMIT_ACCTS_FL |
Limit Accounts |
VARCHAR |
1 |
|
PROJ_EDIT |
LIMIT_AO_FL |
Limit Accounts to Orgs |
VARCHAR |
1 |
|
PROJ_EDIT |
ACCT_GRP_CD |
Account Group |
VARCHAR |
6 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Accounts file ("ACCT_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
ACCT |
ACCT_ID |
Account |
VARCHAR |
15 |
|
ACCT |
ACCT_NAME |
Account Name |
VARCHAR |
25 |
|
ACCT |
PROJ_REQD_FL |
Project Required (Y/N) |
VARCHAR |
1 |
|
ACCT |
ACTIVE_FL |
Active (Y/N) |
VARCHAR |
1 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Org Edit file ("ORG_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
ORG |
ORG_ID |
Organization |
VARCHAR |
20 |
|
ORG |
ORG_ABBRV_CD |
Organization Abbreviation |
VARCHAR |
6 |
|
ORG |
ORG_NAME |
Organization Name |
VARCHAR |
25 |
|
ORG |
ACTIVE_FL |
Active (Y/N) |
VARCHAR |
1 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Org/Account file ("ORGA_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
ORG_ACCT |
ORG_ID |
Organization |
VARCHAR |
20 |
|
ORG_ACCT |
ACCT_ID |
Account |
VARCHAR |
15 |
|
ORG_ACCT |
ACTIVE_FL |
Active (Y/N) |
VARCHAR |
1 |
|
ORG_ACCT |
FY_CD_FR |
From Fiscal Year |
VARCHAR |
6 |
|
ORG_ACCT |
FY_CD_TO |
To Fiscal Year |
VARCHAR |
6 |
|
ORG_ACCT |
PD_NO_FR |
From Period Number |
SMALLINT |
|
|
ORG_ACCT |
PD_NO_TO |
To Period Number |
SMALLINT |
|
Below is the sequence of the fields to be exported and their source Costpoint column name for the Account Groups file ("ACCTGS_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
ACCT_GRP_SETUP |
ACCT_GRP_CD |
Account Group |
VARCHAR |
3 |
|
ACCT_GRP_SETUP |
ACCT_ID |
Account |
VARCHAR |
15 |
|
ACCT_GRP_SETUP |
S_ACCT_FUNC_DC |
Project Account Function |
VARCHAR |
15 |
|
ACCT_GRP_SETUP |
ACTIVE_FL |
Active (Y/N) |
VARCHAR |
1 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Project/Account Wildcards file ("PROJAW_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
PROJ_ACCT_WILDCARD |
PROJ_ID_S |
Project ID |
VARCHAR |
30 |
|
PROJ_ACCT_WILDCARD |
ACCT_ID_S |
Account ID |
VARCHAR |
15 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Project/Organization Wildcards file ("PROJOW_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
PROJ_ORG_WILDCARD |
PROJ_ID_S |
Project ID |
VARCHAR |
30 |
|
PROJ_ORG_WILDCARD |
ORG_ID_S |
Organization ID |
VARCHAR |
20 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Project/Organization/Account Table file ("POA_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
PROJ_ORG_ACCT |
PROJ_ID |
Project ID |
VARCHAR |
30 |
|
PROJ_ORG_ACCT |
ORG_ID |
Organization ID |
VARCHAR |
20 |
|
PROJ_ORG_ACCT |
ACCT_ID |
Account ID |
VARCHAR |
15 |
|
PROJ_ORG_ACCT |
ACTIVE_FL |
Active Flag |
VARCHAR |
1 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Project Controls file ("PROJC_MMDDYYHHMMR.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
eProcurement Customer ID |
Integer |
9 |
|
PROJ_CNTL |
CONTROL_IDX |
Control Number |
VARCHAR |
1 |
|
PROJ_CNTL |
AUTO_ADD_ORGS_FL |
Automatically Add Organizations |
VARCHAR |
1 |
|
PROJ_CNTL |
POP_EDIT_FL |
Period of Performance Edit |
VARCHAR |
1 |
Below is the sequence of the fields to be exported and their source Costpoint column name for the Project Controls file ("SUBP_MMDDYYHHMMT.TXT"):
|
Costpoint Table |
Costpoint Column |
Costpoint Column Name |
Data Type |
Data Size |
|
EPROCURE_EXP_LOG |
EP_CUST_ID |
EProcurement Customer ID |
Integer |
9 |
|
SUB_PD |
FY_CD |
Fiscal Year |
VARCHAR |
6 |
|
SUB_PD |
PD_NO |
Period Number |
SMALLINT |
|
|
SUB_PD |
SUB_PD_NO |
Subperiod Number |
SMALLINT |
|
|
SUB_PD |
SUB_PD_END_DT |
Subperiod End Date |
DATE |
|
|
SUB_PD |
S_STATUS_CD |
Status |
VARCHAR |
1 |