Inventory Abbreviation File Data Layout

When you run the process Export eProcurement Inventory Abbreviation, a delimited text file is created.

The following is the sequence of the fields to be exported and their source Costpoint column name for the Inventory Abbreviation file ("IA_MMDDYYHHMMT.TXT").

Costpoint Table Costpoint Column Costpoint Column Name Data Type Data Size
EPROCURE_EXP_LOG EP_CUST_ID eProcurement Customer ID Integer 9
INVT_ABBRV_CD INV_ABBRV_CD Inventory Abbreviation VARCHAR 6
INVT_ABBRV_CD INV_ABBRV_NAME Inventory Abbreviation Name VARCHAR 25
INVT_ABBRV_CD S_ACTIVE_CD Active (Y/N) VARCHAR 1
INVT_ABBRV_CD PROJ_ID Project ID VARCHAR 30
INVT_ABBRV_CD ACCT_ID Account ID VARCHAR 15
INVT_ABBRV_CD ORG_ID Organization ID VARCHAR 20