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	13	15	Required	(999)
PO Change Order Number	PO_CHNG_ORD_NO	Number 3	16	18	Required	(999)
Buyer ID	BUYER_ID	Character 12	19	30	Required
Vendor ID	VEND_ID	Character 12	31	42	Required
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	Pull from BUYER.BRNCH_ADDR_DC
Bill To Location ID	BILL_TO_LOC_ID	Character 12	75	86	*Optional	Pull from BUYER.BILL_TO_LOC_ID
Bill To Address Code	BILL_TO_ADDR_DC	Character 10	87	96	*Optional	Pull 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
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
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), or R (Release).
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
Rate Group	RATE_GRP_ID	Character 6	162	167	Optional
Rate Date	TRN_CRNCY_DT	Date	168	177	Optional	MM/DD/YYYY

* 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	13	15	Required	(999)
Sequence Number	SEQ_NO	Number 4	16	19	Required	(9999)
Text Code	TEXT_CD	Character 10	20	29	Required

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	13	15	Required	(999)
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	13	15	Required	(999)
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
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
Commitment Type	PO_LN.S_PO_COMMIT_TYPE	Character 1	242	242	Optional
Taxable Flag	PO_LN. TAXABLE_FL	Character 1	243	243	Optional
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	546	575	Optional
Item Revision	PO_LN.ITEM_RVSN_ID and USER_RVSN_FLD	Character 3	576	578	Optional
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	593	598	Optional
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

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	13	15	Required	(999)
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	13	15	Required	(999)
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)