Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Item and Line Charge Type File Data Layout

The following table is the sequence of the fields to be exported and their source Costpoint column name for the Item and Line Charge Type file ("ITM_MMDDYYHHMMT.TXT").

Costpoint Table Costpoint Column Costpoint Column Name Data Type Data Size
EPROCURE_EXP_LOG EP_CUST_ID eProcurement Customer ID Integer 9
ITEM / LN_CHG_TYPE ITEM_ID / LN_CHG_TYPE Item ID / Line Charge Type VARCHAR 30
ITEM LAST_RVSN_ID Revision VARCHAR 3
ITEM / LN_CHG_TYPE DFLT_UM_CD / UM_CD Unit of Measure VARCHAR 3
ITEM ACTIVE_FL Active (Y/N) VARCHAR 1
ITEM / LN_CHG_TYPE ITEM_DESC / LN_CHG_DESC Item Description / Line Charge Description VARCHAR 60/30
ITEM S_ITEM_TYPE Item Type VARCHAR 1
ITEM COMM_CD Commodity VARCHAR 8
ITEM / LN_CHG_TYPE IND_CLASS_CD Industry Class VARCHAR 6
PART CAGE_FLD CAGE VARCHAR 6
PART INVT_FL Inventory (Y/N) VARCHAR 1
PART NSN_ID National Stock Number VARCHAR 20
PART MIL_SPEC_ID Mil Spec Code VARCHAR 20
PART CERT_OF_CNFRM_FL Certificate of Conformance Required (Y/N) VARCHAR 1
PART SRCE_INSP_FL Source Inspection Required (Y/N) VARCHAR 1
PART QC_REQD_FL QC Required (Y/N) VARCHAR 1
LN_CHG_TYPE S_MATCH_CD AP Matching VARCHAR 1