Detailed Table Specifications

This section defines the data element in each table to be loaded or updated by the preprocessor.

Receipt Header (RECPT_HDR)

Column Name	Costpoint Column Name	Source	Validations/Notes
Auto Issue Flag	AUTO_ISSUE_FL		N
Company ID	COMPANY_ID		Current user's company.
Default Receiving Location ID	DFLT_RECV_LOC_ID		Null
Default Rejection Location ID	DFLT_REJ_LOC_ID		Null
Progress Payment Number	DRAW_RQST_NO	From input file.	If you do not enter a value in the input file, the default maximum is PO_LN.DRAW_RQST_NO + 1.
Current Date/Time	ENTR_DTT		Current date and time.
Current User ID	ENTR_USER_ID		Current user's User ID.
Euro to Functional Rate	EUR_TO_FUNC_RT	PO_HDR.EUR_TO_FUNC_RT
Employee	MATL_HNDLR_EMPL_ID	From input file.	If you do not enter a value in the input file, the default is the Default Employee from the Import Subcontract PO Status Updates screen. Employee status should be active and valid.
Current User ID	MODIFIED_BY		Current user's User ID.
Non-inventory Receiving Location Flag	NINVT_RECV_LOC_FLD		Space.
Offsite Receiver ID	OFFSITE_RECVR_ID		Space.
PO Change Order Number	PO_CHNG_ORD_NO	PO_HDR.PO_CHNG_ORD_NO
Purchase Order ID	PO_ID	From input file.
PO Release Number	PO_RLSE_NO	PO_HDR.PO_RLSE_NO
Prime Contract Period	PRIME_CONTRACT_PD	From input file.	If not in input file, default to Null.
Packing Slip ID	PS_ID		Space
Rate Group ID	RATE_GRP_ID	PO_HDR.RATE_GRP_ID	Allow null value.
Receipt Comments Notes	RECPT_COMMENT_NT		Space.
Receipt Date	RECPT_DT	From input file.	Status Update Date
Receipt ID	RECPT_ID	From input file. Otherwise, auto-assign.	Status Update ID. If you do not enter a value in the input file, the system auto-assigns by incrementing the last PO Receipt transaction from WHSE_LAST_TRANS table for the corresponding Warehouse (Assign (LAST_INVT_TRN_ID + 1) for S_INVT_TRN_TYPE = R). If you do not use Costpoint Inventory, the system will auto-assign by incrementing the Last receipt ID in the Configure Receiving Settings screen in Costpoint Receiving (RECV_SETTINGS.LAST_RECPT_ID + 1).
Receipt Key	RECPT_KEY	System generated.
Rowversion	ROWVERSION	Derive.	Initially 0 Increment by 1 if updated. Allow null value.
Traveler Type	S_TRVLR_TYPE		This is not used. Subcontract POs are not included in Receipt Travelers.
Current Date/Time	TIME_STAMP		Current date and time.
Total Receipt Amount	TOT_RECPT_AMT		Sum of PO_LN.RECVD_AMT for all PO lines.
Transaction Currency Code	TRN_CRNCY_CD	PO_HDR.TRN_CRNCY_CD
Transaction Currency Date	TRN_CRNCY_DT	PO_HDR.TRN_CRNCY_DT
Transaction Currency Freeze Rate Flag	TRN_FREEZE_RT_FL	PO_HDR.TRN_FREEZE_RT_FL
Transaction to Euro Currency Rate	TRN_TO_EUR_RT	PO_HDR.TRN_TO_EUR_RT
Transaction to Euro Currency Rate Flag	TRN_TO_EUR_RT_FL	PO_HDR.TRN_TO_EUR_RT_FL
Total Receipt Amount	TRN_TOT_RECPT_AMT		Sum of PO_LN.TRN_RECVD_AMT for all PO lines. Value is in transaction currency.
Voucher Key	VCHR_KEY		Null
Warehouse ID	WHSE_ID	From input file.	If not in input file, default to Null.

Receipt Line (RECPT_LN)

Column Name	Costpoint Column Name	Source	Validations/Notes
Accepted Amount	ACCPT_AMT	PO_LN.ACCPTD_AMT
Accepted Location ID	ACCPT_LOC_ID		Null
Accepted Quantity	ACCPT_QTY		0
Autocreate Fixed Assets Flag	FA_AUTOCR_FL		N
Fiscal Year	FY_CD		Null
Incremental Completed Work Amount	INC_COMPLT_AMT	Calculate.	RECPT_LN.INC_COMPLT_AMT (this update) + [PO_LN.COMPLT_AMT (this update) - PO_LN.COMPLT_AMT (previous update)].
Incremental Completed Work Retention Amount	INC_CP_RET_AMT	Calculate.	RECPT_LN.INC_CP_RET_AMT (this update) + [PO_LN.COMPLT_RET_AMT (this update) - PO_LN.COMPLT_RET_AMT (previous update)]
Incremental Requested Work Amount	INC_RQSTD_AMT	Calculate.	RECPT_LN.INC_RQSTD_AMT (this update) + [PO_LN.RQSTD_AMT (this update) - PO_LN.RQSTD_AMT (previous update)].
Incremental Stored Work Amount	INC_STORED_AMT	Calculate.	RECPT_LN.INC_STORED_AMT (this update) + [PO_LN.STORED_AMT (this update) - PO_LN.STORED_AMT (previous update)].
Incremental Stored Retention Work Amount	INC_ST_RET_AMT	Calculate.	RECPT_LN.INC_ST_RET_AMT (this update) + [PO_LN.STORED_RET_AMT (this update) - PO_LN.STORED_RET_AMT (previous update)].
Inspected and Accepted Amount	INSP_ACCPT_AMT		0
Inspected and Accepted Quantity	INSP_ACCPT_QTY		0
Inventory Abbreviation Code	INVT_ABBRV_CD		Null
Item ID	ITEM_ID	PO_LN.ITEM_ID
Item Key	ITEM_KEY	PO_LN.ITEM_KEY
Item Revision ID	ITEM_RVSN_ID	PO_LN.ITEM_RVSN_ID
Modified By	MODIFIED_BY		Current User ID
Materials Requirement Board Amount	MRB_AMT		0
Materials Requirement Board Quantity	MRB_QTY		0
Non-inventory Receiving Location	NINVT_RECV_LOC_FLD		0
Period	PD_NO		Null
Purchase Order Desired Date	PO_DESIRED_DT	PO_LN.DESIRED_DT	Same as PO_LN.DUE_DT.
PO Due Date	PO_DUE_DT	PO_LN.DUE_DT
Purchase Order ID	PO_ID	PO_LN.PO_ID
Purchase Order Line Key	PO_LN_KEY	PO_LN.PO_LN_KEY
PO Original Due Date	PO_ORIG_DUE_DT	PO_LN.PO_ORIG_DUE_DT	Same as PO_LN.DUE_DT.
PO Release Number	PO_RLSE_NO	PO_LN.PO_RLSE_NO
Posted Amount	PSTD_AMT		0
Posted Quantity	PSTD_QTY		0
Receipt Key	RECPT_KEY	RECPT_HDR.RECPT_KEY	RECPT_HDR
Receipt Line Description	RECPT_LN_DESC	PO_LN.PO_LN_DESC
Received Amount	RECV_AMT	PO_LN.RECVD_AMT
Receiving Location ID	RECV_LOC_ID		Null
Received Quantity	RECV_QTY		0
Receiving Unit of Measure Code	RECV_UM_CD		Null
Rejected Amount	REJ_AMT		0
Reject but Credit Amount	REJ_CR_AMT		0
Reject but Credit Quantity	REJ_CR_QTY		0
Rejection Location ID	REJ_LOC_ID		Null
Reject but Pay Amount	REJ_PAY_AMT		0
Reject but Pay Quantity	REJ_PAY_QTY		0
Rejected Quantity	REJ_QTY		0
Reject but Repair Amount	REJ_REP_AMT		0
Reject but Repair Quantity	REJ_REP_QTY		0
RMA Number	RMA_NO_ID		Space
Rowversion	ROWVERSION	Derived from system.	Initially 0. Increment by 1 if updated.
Reason Code	RSN_CD		Null
Subperiod	SUB_PD_NO		Null
	S_OP_REJ_DISPN_CD		Null
Rejection Disposition Code	S_REJ_DISPN_CD		Null
Where Used Code	S_RSN_WH_USED_CD		Null
Current Date/Time	TIME_STAMP		Current Date/Time
Accepted Amount	TRN_ACCPT_AMT	PO_LN.TRN_ACCPTD_AMT
Incremental Completed Work Amount	TRN_INC_COMPLT_AMT	Calculate.	RECPT_LN.TRN_INC_COMPLT_AMT (this update) + [PO_LN.TRN_COMPLT_AMT (this update) - PO_LN.TRN_COMPLT_AMT (previous update)].
Incremental Completed Work Retention Amount	TRN_INC_CP_RET_AMT	Calculate.	RECPT_LN.TRN_INC_CP_RET_AMT (this update) + [PO_LN.TRN_COMPLT_RET_AMT (this update) - PO_LN.TRN_COMPLT_RET_AMT (previous update)].
Incremental Requested Work Amount	TRN_INC_RQSTD_AMT	Calculate.	RECPT_LN.TRN_INC_RQSTD_AMT (this update) + [PO_LN.TRN_RQSTD_AMT (this update) - PO_LN.TRN_RQSTD_AMT (previous update)].
Incremental Stored Work Amount	TRN_INC_STORED_AMT	Calculate.	RECPT_LN.TRN_INC_STORED_AMT (this update) + [PO_LN.TRN_STORED_AMT (this update) - PO_LN.TRN_STORED_AMT (previous update)].
Incremental Stored Retention Work Amount	TRN_INC_ST_RET_AMT	Calculate.	RECPT_LN.TRN_INC_ST_RET_AMT (this update) + [PO_LN.TRN_STORED_RET_AMT (this update) - PO_LN.TRN_STORED_RET_AMT (previous update)].
Inspected and Accepted Amount	TRN_INSP_ACCPT_AMT		0
Materials Requirement Board Amount	TRN_MRB_AMT		0
Posted Amount	TRN_PSTD_AMT		0
Received Amount	TRN_RECV_AMT	PO_LN.TRN_RECVD_AMT
Rejected Amount	TRN_REJ_AMT		0
Reject but Credit Amount	TRN_REJ_CR_AMT		0
Reject but Pay Amount	TRN_REJ_PAY_AMT		0
Reject but Replace Amount	TRN_REJ_REP_AMT		0
Voucher Amount	TRN_VCHR_AMT		Initially 0.
Traveler Printed Flag	TRVLR_PRNTD_FL		N
User Revision	USER_RVSN_FLD		Space
Voucher Amount	VCHR_AMT		Initially 0.
Voucher Quantity	VCHR_QTY		0
Warehouse ID	WHSE_ID	From input file.	If not in input file, default to Null.

PO Line (PO_LN)

Column Name	Costpoint Column Name	Source	Validations/Notes
Accepted Amount	ACCPTD_AMT	Calculate.	COMPLT_AMT + STORED_AMT
Accepted Quantity	ACCPTD_QTY		No change.
Approval Date	APPRVL_DT		No change.
Approval User ID	APPRVL_USER_ID		No change.
Auto Voucher Flag	AUTO_VCHR_FL		No change.
Award Quote ID	AWARD_QT_ID		No change.
Bill Cycle	BILL_CYCLE_CD		No change.
Bill Cycle Payment Amount	BILL_CYCLE_PAY_AMT		No change.
Blanket Balance Amount	BLKT_BAL_AMT		No change.
Blanket PO Line Key	BLKT_PO_LN_KEY		No change.
Blanket PO Release Number	BLKT_PO_RLSE_NO		No change.
BOM Configuration ID	BOM_CONFIG_ID		No change.
Certificate of Conformance Flag	CERT_OF_CNFRM_FL		No change.
CIS Withholding Flag	CIS_WH_FL		No change.
Client Line Item Number	CLIN_ID		No change.
Commodity Code	COMM_CD		No change.
Completed Amount	COMPLT_AMT	Converted.	TRN_COMPLT_AMT * Exchange Rate
Cpm	COMPLT_PCT		The calculation is Completed Work Amt / Subcontract Order Amt, using new values from input file, if available. If new values are not available, the program will use existing PO line values. If value is zero, will default from Input File (Percent Complete). Otherwise, no change.
Completed Work Retention Amount	COMPLT_RET_AMT	Converted.	TRN_COMPLT_RET_AMT * Exchange Rate
Completed Work Retention Percent	COMPLT_RET_PCT		The calculation is Completed Work Retention Amt / Completed Work Amt, using updated values, if available. If updated values are not available, the program will use existing PO line values. If value is zero, will default from Input File (Completed Work Retention Pct). Otherwise, no change.
Deliver To	DEL_TO_FLD		No change.
Desired Date	DESIRED_DT		No change.
Discount Percent	DISC_PCT_RT		No change.
Drop Shipment Flag	DROP_SHIP_FL		No change.
Due Date	DUE_DT		No change.
Gross Unit Cost Amount	GROSS_UNIT_CST_AMT		No change.
Industry Classification Code	IND_CLASS_CD		No change.
Inventory Abbreviation Code	INVT_ABBRV_CD		No change.
Issue Flag	ISSUE_FL		No change.
Item ID	ITEM_ID		No change.
Item Key	ITEM_KEY		No change.
Item Revision	ITEM_RVSN_ID		No change.
Last Vouchered Date	LAST_VCHRD_DT		No change.
Leadtime Days	LT_DAYS_NO		No change.
Manufacturer ID	MANUF_ID		No change.
Manufacturer Part ID	MANUF_PART_ID		No change.
Manufacturer Part Revision ID	MANUF_PART_RVSN_ID		No change.
Military Spec ID	MIL_SPEC_ID		No change.
Minimum Quantity	MIN_QTY		No change.
Miscellaneous Line Charge Type	MISC_LN_CHG_TYPE		No change.
Current User	MODIFIED_BY		Current user's User ID.
Net Unit Cost Amount	NET_UNIT_CST_AMT		No change.
NSN ID	NSN_ID		No change.
Operation ID	OP_ID		No change.
Order Reference	ORDER_REF_ID		No change.
Order Reference Line Key	ORDER_REF_LN_KEY		No change.
Order Reference Line Number	ORDER_REF_LN_NO		No change.
Order Reference Release	ORDER_REF_RLSE_NO		No change.
Order Date	ORD_DT		No change.
Order Quantity	ORD_QTY		No change.
Original Due Date	ORIG_DUE_DT		No change.
Overshipment Allowed	OVRSHP_ALLOW_FL		No change.
Period of Performance End Date	PERF_END_DT		No change.
Period of Performance Start Date	PERF_START_DT		No change.
Planner ID	PLANNER_ID		No change.
PO ID	PO_ID		No change.
PO Line Charge Amount	PO_LN_CHG_AMT		No change.
PO Line Charge Tax Amount	PO_LN_CHG_TAX_AMT		No change.
PO Line Close Date	PO_LN_CLOSE_DT		No change.
PO Line Description	PO_LN_DESC		No change.
PO Line Expedited Notes	PO_LN_EXPDT_NOTES		No change.
PO Line Extended Amount	PO_LN_EXT_AMT		No change.
PO Line Internal Notes	PO_LN_INT_NOTES		No change.
PO Line Key	PO_LN_KEY		No change.
PO Line Number	PO_LN_NO		No change.
PO Line Total Amount	PO_LN_TOT_AMT		No change.
PO Line Unit of Measure Code	PO_LN_UM_CD		No change.
	PO_RLSE_NO		No change.
Procurement Type	PROCURE_TYPE_CD		No change.
Posted Amount	PSTD_AMT		No change.
Posted Quantity	PSTD_QTY		No change.
QC Required Flag	QC_REQD_FL		No change.
Recovery Amount	RECOVERY_AMT		No change.
Recovery Percent	RECOVERY_RT		No change.
Receipt Tolerance Percentage Rate	RECPT_TOL_PCT_RT		No change.
Received Amount	RECVD_AMT		Equal to PO_LN.ACCPTD_AMT.
Received Quantity	RECVD_QTY		No change.
Rejected but Credit Amount	REJ_CR_AMT		No change.
Rejected but Credit Quantity	REJ_CR_QTY		No change.
Rejected but Pay Amount	REJ_PAY_AMT		No change.
Rejected but Pay Quantity	REJ_PAY_QTY		No change.
Rejected but Repair Amount	REJ_REP_AMT		No change.
Rejected but Repair Quantity	REJ_REP_QTY		No change.
Rowversion	ROWVERSION		Last Rowversion + 1. Allow null value.
Requested Amount	RQSTD_AMT	Converted.	TRN_RQSTD_AMT * Exchange Rate
Requisition ID	RQ_ID		No change.
Requisition Line Key	RQ_LN_KEY		No change.
Sales Tax Amount	SALES_TAX_AMT		No change.
Sales Tax Rate	SALES_TAX_RT		No change.
Ship ID	SHIP_ID		No change.
Ship Via	SHIP_VIA_FLD		No change.
Sales Order Line	SO_LN_COMP_KEY		No change.
Source Inspection Flag	SRCE_INSP_FL		No change.
Stored Material Amount	STORED_AMT	Converted.	TRN_STORED_AMT * Exchange Rate
Stored Material Retention Amount	STORED_RET_AMT	Converted.	TRN_STORED_RET_AMT * Exchange Rate
Stored Material Retention Percent	STORED_RET_PCT		The calculation is Stored Materials Retention Amt / Stored Materials Amt, using updated values, if available. If updated values are not available, the program will use existing PO line values. If value is zero, default from Input File (Stored Materials Retention Pct). Otherwise, no change.
Subline Number	SUBLINE_NO		No change.
Small Business Classification Code	S_CL_SM_BUS_CD		No change.
Line Status Type	S_LN_STATUS_TYPE		If the status update transaction line creates a condition for the PO line whereby Stored Materials Amount is zero AND (Completed Work Amount – Completed Work Retention Amt = Subcontract Order Amount), change the status of the PO line to System Closed ("S"). If you change a status update transaction line and either of the above conditions is no longer true, change the status of the PO line to Open ("O") (warning message generated), if it was previously System Closed ("S"). You cannot change PO lines with a status of Closed ("C").
Match Code	S_MATCH_CD		No change.
Match Option Code	S_MATCH_OPT_CD		No change.
Sales Order Cost Type	S_OE_CST_TYPE_CD		No change.
Order Reference Type	S_ORD_REF_TYPE_CD		No change.
PO Commitment Type	S_PO_COMMIT_TYPE		No change.
PO Line Type	S_PO_LN_TYPE		No change.
Purchase Agreement Code	S_PURCH_AGRMT_CD		No change.
Taxable Flag	TAXABLE_FL		No change.
Current Date/Time	TIME_STAMP		Current date and time.
Total Released Amount	TOT_RLSED_AMT		No change.
Total Released Quantity	TOT_RLSED_QTY		No change.
Accepted Amount	TRN_ACCPTD_AMT	Calculate.	TRN_COMPLT_AMT + TRN_STORED_AMT. Value is in transaction currency.
Billing Cycle Amount	TRN_BILL_CYCLE_ AMT		No change.
Blanket Balance Amount	TRN_BLKT_BAL_AMT		No change.
Completed Amount	TRN_COMPLT_AMT	From Input File.	If no value is in the input file, the calculation will be Percent Complete * Subcontract Order Amt, using updated values, if available. If updated values are not available, the program will use existing PO line values. Value is in transaction currency.
Completed Work Retention Amount	TRN_COMPLT_RET_AMT	From Input File.	If no value is in the input file, the calculation will be Completed Work Amt * Completed Work Retention Pct, using updated values, if available. If updated values are not available, the program will use existing PO line values. Value is in transaction currency.
Gross Unit Cost Amount	TRN_GR_UN_CST_AMT		No change.
Line Charge Amount	TRN_LN_CHG_AMT		No change.
Line Charge Tax Amount	TRN_LN_CHG_TAX_AMT		No change.
Net Unit Cost Amount	TRN_NET_UN_CST_AMT		No change.
PO Line Extended Amount	TRN_PO_LN_EXT_AMT		No change.
PO Line Total Amount	TRN_PO_LN_TOT_AMT		No change.
Posted Amount	TRN_PSTD_AMT		No change.
Recovery Amount	TRN_RECOVERY_AMT		No change.
Received Amount	TRN_RECVD_AMT	PO_LN.TRN_ACCPTD_AMT.
Rejected but Credit Amount	TRN_REJ_CR_AMT		No change.
Rejected but Pay Amount	TRN_REJ_PAY_AMT		No change.
Rejected but Repair Amount	TRN_REJ_REP_AMT		No change.
Requested Amount	TRN_RQSTD_AMT	From Input File.	If not in input file, no change. Value in Transaction Currency.
Sales Tax Amount	TRN_SALES_TAX_AMT		No change.
Stored Amount	TRN_STORED_AMT	From Input File.	If value is not in the input file, no change. Value is in transaction currency.
Stored Materials Retention Amount	TRN_STORED_RET_AMT	From Input File.	If no value is in the input file, the calculation will be Stored Material Amt * Stored Materials Retention Pct, using updated values, if available. If updated values are not available, the program will use existing PO line values. Value is in transaction currency.
Total Released Amount	TRN_TOT_RLSED_AMT		No change.
Vouchered Amount	TRN_VCHRD_AMT		No change.
User Revision	USER_RVSN_FLD		No change.
Vouchered Amount	VCHRD_AMT		No change.
Vouchered Quantity	VCHRD_QTY		No change.
Voucher Received Flag	VCHR_RCV_FL		No change.
Vendor Part ID	VEND_PART_ID		No change.
Vendor Part Revision ID	VEND_PART_RVSN_ID		No change.
Warehouse ID	WHSE_ID		No change.

PO Header (PO_HDR)

Column Name	Costpoint Column Name	Source	Validations/Notes
PO Status Type	S_PO_STATUS_TYPE		If changes in the status of the PO lines results in all lines of the PO having a status of S, or Cor V, change the status of the PO header to S (System Closed). If the user modifies a status update transaction line which changes the status of the PO line from S (System Closed) to O (Open), if the PO header was previously S, change it to O.

Column Name

Costpoint Column Name

Source

Validations/Notes

PO Status Type

S_PO_STATUS_TYPE

If changes in the status of the PO lines results in all lines of the PO having a status of S, or Cor V, change the status of the PO header to S (System Closed).

If the user modifies a status update transaction line which changes the status of the PO line from S (System Closed) to O (Open), if the PO header was previously S, change it to O.

Parent Topic:

Import Subcontract Retainage PO Status Updates