INPUT FILE AND ERROR FILE LAYOUT

The Input File is a fixed-length, ASCII file. The Error File, which contains records that were not processed from the Input File, has the same name as the Input File, but with an .ERR extension. After processing is complete, the Input File is renamed with an .OLD extension. The Error File layout is the same as the Input File layout.

You must fill every position in the Input File with the appropriate number of either characters or spaces for a given column before entering data in the next column. You need not use leading zeros; you can use spaces to maintain the proper format. Numeric fields should be right-justified; character fields should be left-justified.

End every row with a carriage return and a line feed.

PO Header Record Format (PO_HDR)

Name	Costpoint Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(PH)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Change Order Number	PO_CHNG_ORD_NO	Number 3	16	18	Required	(999)
Buyer ID	BUYER_ID	Character 12	19	30	Required	Must be existing in the Manage Buyers screen for the user 's logged in Company ID
Vendor ID	VEND_ID	Character 12	31	42	Required	if entered, must be a existing in the Manage Vendors screen and must not be a PAYROLL Vendor or On-Hold Status
Vendor Address Code	ADDR_DC	Character 10	43	52	*Optional
Branch Location ID	BRNCH_LOC_ID	Character 12	53	64	*Optional
Branch Address Code	BRNCH_ADDR_DC	Character 10	65	74	*Optional	If not in the input file, system will pull info from BUYER.BRNCH_ADDR_DC
Bill To Location ID	BILL_TO_LOC_ID	Character 12	75	86	*Optional	If not in the input file, the system will pull from BUYER.BILL_TO_LOC_ID
Bill To Address Code	BILL_TO_ADDR_DC	Character 10	87	96	*Optional	If not in the input file, the system will pull info from BUYER.BILL_TO_ADDR_DC
Default Save Changes Flag	N/A	Character 1	97	97	(Not used; leave one space.)	(Y or N)
PO Status	S_PO_STATUS_TYPE	Character 1	98	98	Optional	Must be C (Closed), O (Open), P (Pending), or V (Void).
Terms Code	TERMS_DC	Character 15	99	113	Optional	if not provided in the input file, system will pull the information from the VEND.TERMS _DC
FOB (Free on Board)	FOB_FLD	Character 15	114	128	Optional
Change Date	CHNG_DT	Date 10	129	138	Optional	(MM/DD/YYYY)
Procurement Type	PROCURE_TYPE_CD	Character 2	139	140	Optional	if entered, must be existing on the Manage Procurement Types screen
Timestamp		Date 10	141	150	Not used	(MM/DD/YYYY)
PO Type	S_PO_TYPE	Character 1	151	151	Optional	If entered, must be P (Purchase Order), B (Blanket), S (Subcontract Retainage), R (Release) GFM/GFE Order (G) Subcontractor Agreement (A), Subcontractor Agreement Blanket (K), or Subcontractor Agreement Release (L)
CIS Code	CIS_CD	Character 6	152	157	Optional
Create Change Order	N/A	Character 1	158	158	Optional	Can be Y or N. Default is N. If this value is Y, PO must already exist in Costpoint. Change Order Number must be greater than current Change Order.
Transaction Currency	TRN_CRNCY_CD	Character 3	159	161	Optional	If not provided in the input file, the system will pull information from the VEND.DFLT_TRN_CRNCY_CD; If it is not available, system will pull the information from MU_SETTINGS.DFLT_TR_S_CRNCY_CD.
Rate Group	RATE_GRP_ID	Character 6	162	167	Optional	If not provided in the input file, the system will pull information from the VEND.DFLT_RT_GRP_ID; If it is not available, system will pull the information from MU_SETTINGS.DFLT_RT_GRP_ID.
Rate Date	TRN_CRNCY_DT	Date	168	177	Optional	MM/DD/YYYY
US Citizenship Required	US_CITIZEN_FL	Varchar (1)	178	178	Optional	Applies only if PO type is not A, K or L. Else, null.
ITAR Authorization Required	ITAR_AUTH_FL	Varchar (1)	179	179	Optional	Applies only if PO type is not A, K or L. Else, null.
Security Clearance System ID	SEC_CLR_CD	Varchar (6)	180	185	Optional	Applies only if PO type is not A, K or L. Else, null.
Issuing Agency	AGENCY_NAME	Varchar (30)	186	215	Optional	Applies only if PO type is not A, K or L. Else, null.
Subcontract ID	PO_HDR.SUBCNTR.ID	Varchar (30)	216	245	Optional
NAICS Code	NAICS_CD	Character 15	246	660	Optional

* The Vendor Address, Branch Location, Bill to Location, and Bill To Address are all required in the Address subtask of the Manage Purchase Orders screen. If you do not provide the vendor's Address Code in the input file, Costpoint loads the default Order Address on the Manage Vendors screen. If you do not provide the Branch Location, Branch Address, Bill To Location, and Bill To Address in the input file, Costpoint populates each field by default from the Buyer table, and verifies that valid values can be found for the given vendor and/or buyer.

PO Text Record (PO_TEXT)

Name	Costpoint Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(HT)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
Sequence Number	SEQ_NO	Number 4	16	19	Required	(9999)
Text Code	TEXT_CD	Character 10	20	29	Required	This must exist in the PO Standard Text table and the Standard Text-Where Used table with a code of P (Purchase Order). P or P1-P8 (depending on PO Type of the purchase order).
Text Revision	TXT_CD_RVSN_NO	Number 5	30	34	Optional	If not provided in the input file, system will default the latest active revision for the company. This must exist in the PO Standard Text table and the Standard Text-Where Used table with a code of P (Purchase Order). P or P1-P8 (depending on PO Type of the purchase order).

PO Header Notes Record (PO_HDR_NOTES)

Name	Costpoint Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(PN)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Header Notes	PO_HDR_TX	Character 1,000	16	1,015	Required

PO Line Record (PO_LN, PO_LN_ACCT, PO_LN_CHG)

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(PL)
PO ID	PO_ID (all tables)	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO (all tables)	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Line Number	PO_LN_NO/PO_LN_KEY (all tables)	Number 4	16	19	Required	(9999)
PO Line Description	PO_LN.PO_LN_DESC	Character 60	20	79	Optional
Quantity Ordered	PO_LN.ORD_QTY	Number 14	80	93	Required. If PO Type is S, this field will not be used.	(999999999.9999)
Order Date	PO_LN.ORD_DT	Date 10	94	103	Optional	(MM/DD/YYYY)
Due Date	PO_LN.DUE_DT	Date 10	104	113	Optional	(MM/DD/YYYY)
Desired Date	PO_LN.DESIRED_DT	Date 10	114	123	Optional	(MM/DD/YYYY)
Discount Rate	PO_LN.DISC_PCT_RT	Number 11	124	134	Optional. If PO Type is S, this field will not be used.	(99.99999999) The value can range from 0 to 1.
Receipt Tol Percent	PO_LN.RECPT_TOL_PCT_RT	Number 11	135	145	Optional	(99.99999999)
Gross Unit Cost	PO_LN.TRN_GR_UN_CST_AMT	Number 13	146	158	Required. If PO Type is S, this field is not used.	(99999999.9999)
Net Unit Cost	Net Unit Cost	Number 13	159	171	Not used; leave 13 spaces.	(99999999.9999)
Extended Cost	PO_LN.TRN_PO_LN_EXT_AMT	Number 16	172	187	Optional; This field will be required if PO Type is S.	(-999999999999.99)
Total Line Cost	Total Line Cost	Number 16	188	203	Not used; leave 16 spaces.	(-999999999999.99)
Sales Tax	PO_LN.TRN_SALES_TAX_AMT	Number 16	204	219	Optional	(-999999999999.99)
Ship ID	PO_LN.SHIP_ID	Character 20	220	239	Required	Required if item entered is a Part, Good or if Taxable = "Y". Value must be an valid and active Ship id in the SHIP_ID table for the user's company ID.
Status	PO_LN.S_LN_STATUS_TYPE	Character 1	240	240	Required	Must be C (Closed); O (Open); P (Pending); or V (Void).
Auto Voucher Flag	PO_LN.AUTO_VCHR_FL	Character 1	241	241	Optional	Valid values are Y (Yes) or N (No); If not provided, system will pull information from the VEND.AUTO_VCHR_FL
Commitment Type	PO_LN.S_PO_COMMIT_TYPE	Character 1	242	242	Optional	Valid values are D (Amount), Q (Quantity), or E (Excluded)
Taxable Flag	PO_LN. TAXABLE_FL	Character 1	243	243	Optional	Valid values are Y (Yes) or N (No)
Deliver To	PO_LN.DEL_TO_FLD	Character 25	244	268	Optional
Misc. Line Charge Type	PO_LN.MISC_LN_CHG_TYPE	Character 6	269	274	Optional
Requisition ID	PO_LN.RQ_ID	Character 10	275	284	Optional	Required if PO_SETTINGS.S_REQD_REQ_ID_CD = A or V
Manufacturer Part ID	PO_LN.MANUF_PART_ID	Character 30	285	314	Optional
Manufacturer Revision ID	PO_LN.MANUF_PART_RVSN_ID	Character 3	315	317	Optional
Vendor Part ID	PO_LN.VEND_PART_ID	Character 30	318	347	Optional
Vendor Revision ID	PO_LN.VEND_PART_RVSN_ID	Character 3	348	350	Optional
Cert Of Conf Flag	PO_LN.CERT_ OF_CNFRM_FL	Character 1	351	351	Optional
QC Required Flag	PO_LN.QC_REQD_FL	Character 1	352	352	Optional
Source Insp Flag	PO_LN.SRCE_INSP_FL	Character 1	353	353	Optional
Overshipment Flag	PO_LN.OVRSHP_ALLOW_FL	Character 1	354	354	Optional
Match Type	PO_LN.S_MATCH_TYPE	Character 1	355	355	Optional
Project	PO_LN_ACCT.PROJ_ID	Character 30	356	385	Optional
Org	PO_LN_ACCT ORG ID	Character 20	386	405	Optional
Account	PO_LN_ACCT.ACCT_ID	Character 15	406	420	Optional
Project Abbrev	PO_LN_ACCT.PROJ_ABBRV_CD	Character 6	421	426	Optional
Org Abbrev	PO_LN_ACCT.ORG_ABBRV_CD	Character 6	427	432	Optional
Proj/Acct Abbrev	PO_LN_ACCT.PROJ_ACCT_ABBRV_CD	Character 6	433	438	Optional
Line Charge Type 1	PO_LN_CHG.LN_CHG_TYPE	Character 6	439	444	Optional
Line Charge Cost 1	PO_LN_CHG.TRN_CHG_CST_AMT	Number 16	445	460	Optional	(-999999999999.99)
Line Charge Type 2	PO_LN_CHG.LN_CHG_TYPE	Character 6	461	466	Optional
Line Charge Cost 2	PO_LN_CHG.TRN_CHG_CST_AMT	Number 16	467	482	Optional	(-999999999999.99)
Unit of Measure Code	PO_LN.PO_LN_UM_CD	Character 3	483	485	Optional
Date/Time Stamp	Date/Time Stamp	Date 10	486	495	Not used; leave 10 spaces.	(MM/DD/YYYY)
Reference 1	PO_LN_ACCT.REF_STRUC_1_ID	Character 20	496	515	Optional
Reference 2	PO_LN_ACCT.REF_STRUC_2_ID	Character 20	516	535	Optional
Order Reference ID	PO_LN.ORDER_REF_ID	Character 10	536	545	Optional
Item	PO_LN.ITEM_ID	Character 30 (Character 50)	546	575	Optional	For fixed length file format, limit to 30 characters. For delimited file format, increase field size to 50.
Item Revision	PO_LN.ITEM_RVSN_ID and USER_RVSN_FLD	Character 3 Character (10)	576	578	Optional	For fixed length file format, limit to 3 characters. For delimited file format, increase field size to 10.
Order Reference Type	PO_LN.S_ORD_REF_TYPE_CD	Character 1	579	579	Optional
Order Reference Line No	PO_LN.ORDER_REF_LN_NO	Number 4	580	583	Optional
Industry Class Code	PO_LN.IND_CLASS_CD	Character 8	584	591	Optional
CIS Withholding Flag	PO_LN.CIS_WH_FL	Character 1	592	592	Optional
Inventory Abbreviation Code	PO_LN.INVT_ABBRV_CD	Character 6 (Character 20)	593	598	Optional	For fixed length file format, limit to 6 characters. For delimited file format, increase field size to 20.
Requisition Line Key	RQ_LN_KEY	Integer 10	599	608	Optional
Warehouse ID	PO_LN.WHSE_ID	Character 8	609	616	Optional
Completed Work Retention Pct	PO_LN.COMPLT_RET_PCT	Number 10,8	617	626	Optional
Stored Materials Retention Pct	PO_LN.STORED_RET_PCT	Number 10,8	627	636	Optional
Mil Spec ID	PO_LN.MIL_SPEC_ID	Character 20	637	656	Optional
Match Option	PO_LN.S_MATCH_CD	Character 5	657	661	Optional
US Citizenship Required	US_CITIZEN_FL	Varchar (1)	662	662	Optional	Applies only if PO type is not A, K or L. Else, null.
ITAR Authorization Required	ITAR_AUTH_FL	Varchar (1)	663	663	Optional	Applies only if PO type is not A, K or L. Else, null.
Security Clearance System ID	SEC_CLR_CD	Varchar (6)	664	669	Optional	Applies only if PO type is not A, K or L. Else, null.
Issuing Agency	AGENCY_NAME	Varchar (30)	670	699	Optional	Applies only if PO type is not A, K or L. Else, null.
NAICS Code	NAICS_CD	Character 15	700	714	Optional	Applies only if PO type is not A, K or L. Else, null.

PO Line Notes Record (PO_LN_NOTES)

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(LN)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Line Number	PO_LN_NO/PO_LN_KEY	Number 4	16	19	Required	(999)
PO Line Text	PO_LN_TX	Character 1,000	20	1,019	Required

PO Line Text Record (PO_LN_TEXT)

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(LT)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Line Number	PO_LN_NO/PO_LN_KEY	Number 4	16	19	Required	(9999)
Text Code	TEXT_CD	Character 10	20	29	Required
Text Source Code	S_TEXT_SRCE_CD	Character 1	30	30	Required
Sequence Number	SEQ_NO	Number 4	31	34	Required	(9999)
Text Revision	TXT_CD_RVSN_NO	Number 5	35	39	Optional	If not provided in the input file, system will default the latest active revision for the company. This must exist in the PO Standard Text table and the Standard Text-Where Used table with a code of P (Purchase Order). P or P1-P8 (depending on PO Type of the purchase order).

PO Header SCI/SAP Security Codes

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(HC)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
Code		Varchar 6	16	21	Required

PO Header SOW

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(HS)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
SOW ID	SOW ID	Varchar 50	16	65	Required
SOW Rev	SOW_RVSN_ID	Varchar 10	66	75	Optional	If value is not provided, assume it to be ‘space’.

PO Line SCI/SAP Security Codes

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(LC)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
Code	SCISAP_CLR_CD	Varchar 6	16	21	Required

PO Line SOW

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(LS)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
SOW ID	SOW_ID	Varchar 50	16	65	Required
SOW Rev	SOW_RVSN_ID	Varchar 10	66	75	Optional	If value is not provided, assume it to be ‘space’.

PO Line Resource

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(LR)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Line Number		Number 4	16	19	Required	(999)
Resource Line Number	LINE_NO	Varchar 10	20	29	Required
Resource Description	RESOURCE_DESC	Varchar 60	90	149	Conditionally Required	Required only if a valid Service ID/Rev is not provided.
Service ID	ITEM_ID	Varchar 50	30	79	Optional
Service Revision	ITEM_RVSN_ID	Varchar 10	80	89	Optional
Number of Resources	NO_OF_RESOURCES	Number 10	150	159	Optional
Total Hours	HRS	Number 15	160	174	Optional	(9999999999.9999)
Hourly Rate	TRN_LAB_RT_AMT	Number 15	175	179	Optional	(9999999999.9999)
PLC	BILL_LAB_CAT_CD	Varchar 6	180	185	Optional
GLC	GENL_LAB_CAT_CD	Varchar 6	186	191	Optional
City	CITY_NAME	Varchar 25	192	216	Optional
State/Province	MAIL_STATE_DC	Varchar 15	217	231	Optional
Postal Code	POSTAL_CD	Varchar 10	232	241	Optional
Country	COUNTRY_CD	Varchar 8	242	249	Optional

PO Line Resource Vendor Employees

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type	N/A	Character 2	1	2	Required	(LR)
PO ID	PO_ID	Character 10	3	12	Required
PO Release Number	PO_RLSE_NO	Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Line Number		Number 4	16	19	Required	(999)
Resource Line Number	LINE_NO	Varchar 10	20	29	Required	Required
Vendor Employee ID	VEND_EMPL_ID	Varchar 12	30	41	Required

PO Line Delivery Schedule

Name	Costpoint Table/Column	Number of Characters	Starting Position	Ending Position	Required/ Optional	Format
Record Type		Character 2	1	2	Required	(DS)
PO ID		Character 10	3	12	Required
PO Release Number		Number 3 (Number 5)	13	15	Required	(999) For fixed-length file format, this is limited to 3 digits. For delimited file format, you can use up to 5 digits. The allowable 5-digit PO release number for delimited file is up to 99999 for Oracle database users and 32767 for MSS database users.
PO Line Number		Number 4	16	19	Required	(9999)
Order Quantity		Number 14	24	37	Required	(999999999.9999)
Due Date		Date	38	47	Required	(MM/DD/YYYY)
Desired Date		Date	48	57	Required	(MM/DD/YYYY)
Original Due Date		Date	58	68	Required	(MM/DD/YYYY)