INPUT FILES

Input files must be either an ASCII fixed-length text file with the file extension .DAT, that is, filename.DAT, or a comma-separated file with the file extension .CSV, that is, filename.CSV, to upload successfully. Each record in an input file must be on a separate line. Field sizes and validations are the same for both .CSV and .DAT formats, except that fields in comma-separated formats are separated by commas, and fields in ASCII formats are padded by spaces and/or zeros. If a condition is not met for a field that is being processed in an input file record, an error will occur and an error file will be created. Refer to the Output Tables topic for additional information on error output files.

After the process completes, the Input file is renamed with the extension .OLD and saved in the same directory.

Input File Layout

Every position in an ASCII fixed-length format input file (.DAT) must be filled with the appropriate number of either characters or spaces for a given column before you enter data for the next column. It is not necessary to zero fill numbers; you can use spaces to maintain the proper format. Numeric fields should be right justified; character fields should be left justified. Once you have entered the last character of meaningful data for the input file, it is not necessary to fill the remaining column lines with spaces.

For example, if the maximum line length (that is, the entire input file) is a possible total of 759 characters and the last character of meaningful data is in position 480 (that is, the Reason Code), you do not need to add the remaining 270 spaces. However, if the Packing Slip ID (beginning at position 23 on the input file) is only seven characters long, you must include the Packing Slip ID plus eight additional spaces before entering the PO Number in position number 38.

The following table presents the input file fields in the order required.

Input file fields that are defined as dates in Costpoint must be 10 characters and formatted as "MM/DD/YYYY," with a two-character month (01-12), a two-character day (01-31) and a four-character year. Input file field types are alphanumeric or characters (VARCHAR), numeric (DECIMAL, SMALLINT, and INTEGER), and date. The Starting and Ending Position columns below indicate the number of characters allowed for each field in a fixed-length input file.

Field Name	Costpoint Column	Field Type, Max Length	Starting Position	Ending Position	Required, Optional, or Not Used	Notes
Record Type	N/A	Character, 2	1	2	Required	Must be "RL" or "RA." "RL" changes existing receipt information; "RA" creates new receipts.
Receipt ID	RECPT_ID	Character, 10	3	12	Required	Warehouse ID and Receipt ID must be unique if record type is "RA." Must exist for "RL" record types.
Receipt Date	RECPT_DT	Date, 10 (MM/DD/YYYY)	13	22	Optional	Defaults to current system date if missing or invalid. If entered, must be within an open accounting period.
Packing Slip ID	PS_ID	Character, 15	23	37	Optional	From input file if entered. Packing slip number is required if Require Packing Slip check box is selected on the Configure Receiving Settings screen, for the user’s company.
PO Number	PO_ID	Character, 10	38	47	Required	Must exist in PO Header (PO_HDR) and PO Line (PO_LN) tables.
PO Line Number	PO_LN_NO	Numeric, 4	48	51	Required	Must exist in PO line (PO_LN) table.
PO Release Number	PO_RLSE_NO	Numeric, 3	52	54	Required	Must exist in and PO Line (PO_LN) tables.
PO Change Order Number	PO_CHNG_ORD_NO	Numeric, 3	55	57	Not used	From PO.
Receipt Line Description	RECPT_LN_DESC	Character, 60	58	117	Not used	From PO Line.
Fiscal Year Code	FY_CD	Character, 5	118	122	Not used	Looks up from receipt date.
Period Number	PD_NO	Numeric, 2	123	124	Not used	Looks up from receipt date.
Subperiod	SUB_PD_NO	Numeric, 2	125	126	Not used	Looks up from receipt date.
Received Quantity	RECV_QTY	Numeric, 16/Decimal, 14,4 (+9999999999.9999)	127	142	Optional	If record type is "RL," Accepted Quantity + Rejected Quantity cannot exceed Received Quantity.
Unit of Measure		Character, 3	143	145	Not used	From PO Line U/M.
Received Amount	RECV_AMT	Numeric, 16/Decimal 14,2 (+999999999999.99)	146	161	Optional	Calculated from Received Quantity * Net Unit Cost Amount on PO line.
Accepted Amount	ACCPT_AMT	Numeric, 16/Decimal 14,2 (+999999999999.99)	162	177	Optional	Calculated from Accepted Quantity * Net Unit Cost Amount on PO line.
Accepted Location ID	ACCPT_LOC_ID	Character, 15	178	192	Not used
Accepted Quantity	ACCPT_QTY	Numeric, 16/Decimal 14,4 (+9999999999.9999)	193	208	Optional	If not entered, will be set to zero.
Material Handler Employee ID	MATL_HNDLR_EMPL_ID	Character, 12	209	220	Required	Must be an active employee ID on the Manage Employee Information screen.
Inspection Accepted Amount		Numeric, 16 (+999999999999.99)	221	236	Not used	Calculated from Insp Accept Qty * Net Unit Cost Amount on PO line.
Inspection Accepted Quantity		Numeric, 16 (+9999999999.9999)	237	252	Not used
Inventory Abbreviation Code	INVT_ABBRV_ CD	Character, 6	253	258	Optional	Must exist in INVT_ABBRV_CD with company ID matching that of the user. (Note – currently not validated against PO_LN).
Item ID	ITEM_ID	Character, 30	259	288	Not used	Uses PO Line item. **Input File with Fixed Legth File Format only allows 30 characters while the Input File with Delimited File Format allows up to 50 characters.
Item Revision ID	ITEM_RVSN_ID	Character, 3	289	291	Not used	Uses PO Line revision. **Input File with Fixed Legth File Format only allows 3 characters while the Input File with Delimited File Format allows up to 10 characters.
Non-inventory Receiving Location Field	NINVT_RECV_ LOC_FLD	Character, 15	292	306	Optional
Receiving Location ID	RECV_LOC_ID	Character, 15	307	321	Not used	If entered, must be in Warehouses Location (WHSE_LOC) table.
Rejected Amount	REJ_AMT	Numeric, 16/Decimal, 14,2 (+999999999999.99)	322	337	Optional	Calculated from Rejected Quantity * Net Unit Cost Amount on PO line.
Rejected Credit Amount	REJ_CR_AMT	Numeric, 16/Decimal, 14,2 (+999999999999.99)	338	353	Optional	Calculated from Rejected Credit Quantity * Net Unit Cost Amount on PO line.
Rejected Credit Quantity	REJ_CR_QTY	Numeric, 16/Decimal, 14,4 (+9999999999.9999)	354	369	Optional	Input file value is used only if Rejection Order/Payment Disposition = “C” or blank (in which case it defaults to “C”). Otherwise, or if not in input file, set to zero.
Rejected Location ID		Character, 15	370	384	Not used
Rejected Pay Amount	REJ_PAY_AMT	Numeric, 16/Decimal, 14,2 (+999999999999.99)	385	400	Optional	Calculated from Rejected but Pay Quantity * Net Unit Cost Amount on PO line.
Rejected Pay Quantity	REJ_PAY_QTY	Numeric, 16/Decimal, 14,4 (+9999999999.9999)	401	416	Optional	Input file value is used only if Rejection Order/Payment Disposition = “P”. Otherwise, or if not in input file, set to zero.
Rejected Quantity	REJ_QTY	Numeric, 16/Decimal, 14,4 (+9999999999.9999)	417	432	Optional	If entered, must equal the Rejected Credit Qty or Rejected Pay Qty or Rejected Replace Qty, depending upon the Rejection Order/Payment Disposition of C (or blank), P or R, respectively.
Rejected for Repair Amount	REJ_REP_AMT	Numeric, 16/Decimal, 14,2 (+999999999999.99)	433	448	Optional	Calculated from Rejected for Repair Quantity * Net Unit Cost Amount on PO line.
Rejected Repair Quantity	REJ_REP_QTY	Numeric, 16/Decimal, 14,4 (+9999999999.9999)	449	464	Optional	Input file value is used only if Rejection Order/Payment Disposition = “R”. Otherwise, or if not in input file, set to zero.
Returned Material Authorization No.	RMA_NO_ID	Character, 15	465	479	Optional
Reason Code	RSN_CD	Character, 1	480	480	Optional	If entered, must be on Manage Vendor Rejection Reasons screen. This will be set to null if there are no rejections.
Rejection Order/Payment Disposition	S_OP_REJ_ DISPN_CD	Character, 1	481	481	Optional	Determined by rejection quantity. Will be set to null if there are no rejections.
Rejection Disposition	S_REJ_DISPN_ CD	Character, 1	482	482	Optional	If not entered, will default to "R." Will be set to null if there are no rejections.
Reason When Used code	S_RSN_WH_USED_CD	Character, 1	483	483	Not used	Always populate with an "R."
Traveler Printed Flag	TRVLR_PRNTD_FL	Character, 1	484	484	Not used	Program sets to "N."
User Revision Field	USER_RVSN_ FLD	Character, 3	485	487	Not used	Populated from PO_LN
Warehouse ID	WHSE_ID	Character, 8	488	495	Optional	If entered, must exist in Warehouse (WHSE) table.
Comment Field	COMMENT_NT	Character, 254	496	749	Optional
Time Stamp	TIMESTAMP	Date, 10 (MM/DD/YYYY)	750	759	Not used	Costpoint timestamps

Input Costpoint Database Tables

Input tables are used for validations and/or obtaining current Costpoint information. The application accesses the following Costpoint tables:

Item	(ITEM)
Purchase Order Header	(PO_HDR)
Purchase Order Line	(PO_LN)
Receipts Header	(RECPT_HDR)
Unit of Measure	(UM)
Subperiod	(SUB_PD)
Employee	(EMPL)
Warehouse	(WHSE)
Warehouse Locations	(WHSE_LOC)

The PO Header, Receipt Header, Employee, Warehouse, and Warehouse Location table information is validated for the user's company ID.

ITEM table information is also validated for the user’s company ID, based on the setting of the Separate Items by Company flag at the Corporate Settings block of Configure Product Definition Settings. If the check box is selected, Costpoint validates item information for the user’s company. If the check box is cleared, Costpoint does not perform this validation.

Input Files/Output Costpoint Database Tables

The following tables (Purchase Order Line, Receipt Header, and Receipt Line) indicate which columns are modified when information is added or updated during the upload process. Only rows associated with the user's company ID are affected. If the record type is "RA," input file quantities and amounts are used to update the original PO line amounts.

If the record type is "RL," input file quantities and amounts are compared to original receipt line quantities and amounts. The difference is applied to the PO line. RL type records can also be used to add to an existing receipt transaction, receipt lines that didn’t exist previously.

Purchase Order Line (PO_LN)

Costpoint Column Description	Costpoint Column ID	Column Type	ASCII Format	Max Length	Notes
Received Quantity	RECVD_QTY	DECIMAL	NUMERIC	14,4	Updated based on input file, if entered. Otherwise, no change. If Receiving Settings has Overshipments = Prevent Entry of Receipts, and PO line does not allow overshipments, PO line Received Qty – Reject/Replace qty cannot exceed the PO line Order Qty. If Receiving Settings has Overshipments = Prevent Entry of Receipts, and PO line allow overshipments within certain tolerance limits, PO line Received Qty – Reject/Replace qty can exceed the PO line Order Qty, but only up to the tolerance limit allowed.
Accepted Quantity	ACCPTD_QTY	DECIMAL	NUMERIC	14,4	Updated based on input file, if entered. Otherwise, no change.
Received Amount	RECVD_AMT	DECIMAL	NUMERIC	14,2
Accepted Amount	ACCPTD_AMT	DECIMAL	NUMERIC	14,2
Rejected Repair Quantity	REJ_REP_QTY	DECIMAL	NUMERIC	14,4	Updated based on input file, if entered. Otherwise, no change.
Rejected Pay Quantity	REJ_PAY_QTY	DECIMAL	NUMERIC	14,4	Updated based on input file, if entered. Otherwise, no change.
Rejected for Credit Quantity	REJ_CR_QTY	DECIMAL	NUMERIC	14,4	Updated based on input file, if entered. Otherwise, no change.
Rejected for Repair Amount	REJ_REP_AMT	DECIMAL	NUMERIC	14,2
Rejected but Pay Amount	REJ_PAY_AMT	DECIMAL	NUMERIC	14,2
Rejected for Credit Amount	REJ_CR_AMT	DECIMAL	NUMERIC	14,2
Transaction Received Amount	TRN_RECVD_AMT	DECIMAL	NUMERIC	14,2	Updated based on RECPT_LN.TRN_RECV_AMT.
Transaction Accepted Amount	TRN_ACCPTD_AMT	DECIMAL	NUMERIC	14,2	Updated based on RECPT_LN. TRN_ACCPT_AMT.
Transaction Rejected - Replace Amount	TRN_REJ_REP_AMT	DECIMAL	NUMERIC	14.2	Updated based on RECPT_LN. TRN_REJ_REP_AMT.
Transaction Rejected - Pay Amount	TRN_REJ_PAY_AMT	DECIMAL	NUMERIC	14,2	Updated based on RECPT_LN. TRN_REJ_PAY_AMT
Transaction Rejected - Credit Amount	TRN_REJ_CR_AMT	DECIMAL	NUMERIC	14,2	Updated based on RECPT_LN. TRN_REJ_CR_AMT

Receipt Header (RECPT_HDR)

Costpoint Column Description	Costpoint Column ID	Column Type	ASCII Format	Max Length	Notes
Receipt ID	RECPT_ID	VARCHAR	ALPHANUMERIC	10	From Input file.
PO ID	PO_ID	VARCHAR	ALPHANUMERIC	10	From Input File. PO/PO Release combination must be in PO Header table (PO_HDR). The user's company ID should match the company ID assigned to the PO Header row for the corresponding PO ID.
PO Change Order Number	PO_CHNG_ORD_NO	SMALLINT	NUMERIC	2	Loaded from PO Header table (PO_HDR. PO_CHNG_ORD_NO).
PO Release Number	PO_RLSE_NO	SMALLINT	NUMERIC	2	From input file. PO/PO Release combination must be in PO Header table (PO_HDR). The user's company ID should match the company ID assigned to the PO Header row.
Packing Slip ID	PS_ID	VARCHAR	ALPHANUMERIC	15	Packing slip number is required if Require Packing Slip check box is selected on the Configure Receiving Settings screen. Receiving Settings filters user's company ID.
Receipt Date	RECPT_DT	DATE	NUMERIC (MM-DD-YYYY)	10	From input file if entered. Will default to current system date if missing or invalid. Must be within an open accounting period.
Material Handler Employee ID	MATL_HNDLR_EMPL_ID	VARCHAR	ALPHANUMERIC	12	From input file. Must be an active employee ID on the Manage Employee Information screen. The user's company ID should match the company ID assigned to the Employee row.
Offsite Receiver ID	OFFSITE_RECVR_ID	VARCHAR	ALPHANUMERIC	12	Defaults to “RECPTS UPLD”.
Receipt Comment	RECPT_ COMMENT_NT	VARCHAR	ALPHANUMERIC	254	From input file, if entered. Otherwise, no change.
Total Receipt Amount	TOT_RECPT_AMT	DECIMAL	NUMERIC	14,2	Cumulative total of Received Amounts for each Receipt Line.
Time Stamp	TIME_ STAMP	DATE	NUMERIC (MM/DD/YYYY)	10	Program timestamps with current system date.
Company ID	COMPANY_ID	VARCHAR	ALPHANUMERIC	10	Load user's company ID.
Euro to Functional Currency Rate	EUR_TO_FUNC_RT	DECIMAL	NUMERIC	14,7	From PO_HDR. EUR_TO_FUNC_RT.
Rate Group ID	RATE_GRP_ID	VARCHAR	ALPHANUMERIC	6	From PO_HDR. RATE_GRP_ID.
Transaction Currency Code	TRN_CRNCY_CD	VARCHAR	ALPHANUMERIC	3	From PO_HDR. TRN_CRNCY_CD.
Transaction Currency Date	TRN_CRNCY_DT	SMALLDATETIME			From PO_HDR. TRN_CRNCY_DT.
Transaction Freeze Rate Flag	TRN_FREEZE_RT_FL	VARCHAR	ALPHANUMERIC	1	From PO_HDR. TRN_FREEZE_RT_FL.
Transaction to Euro Conversion Rate	TRN_TO_EUR_RT	DECIMAL	NUMERIC	14,7	From PO_HDR. TRN_TO_EUR_RT.
Transaction Currency to Euro Rate Flag	TRN_TO_EUR_RT_FL	VARCHAR	ALPHANUMERIC	1	From PO_HDR. TRN_TO_EUR_RT_FL.
Transaction Total Receipt Amount	TRN_TOT_RECPT_AMT	DECIMAL	NUMERIC	14,2	Sum of RECPT_LN. TRN_TOT_RECPT_AMT.

Receipt Line (RECPT_LN)

Costpoint Column Description	Costpoint Column ID	Column Type	ASCII Format	Max Length	Notes
PO ID	PO_ID	VARCHAR	ALPHANUMERIC	10	From input file. PO/PO Release combination must be in the PO Header table (PO_HDR). The user's company ID should match the company ID assigned to the PO Header row for the corresponding PO ID.
PO Release Number	PO_RLSE_NO	SMALLINT	NUMERIC	2	From input file. PO/PO Release combination must be in the PO Header table (PO_HDR). The user's company ID should match the company ID assigned to the PO Header row.
Receipt Line Description	RECPT_LN_DESC	VARCHAR	ALPHANUMERIC	60	From corresponding PO Line (PO_LN.PO_LN_DESC)
Fiscal Year Code	FY_CD	VARCHAR	ALPHANUMERIC	5	By default, the FY associated with the Receipt Date in the receipt header, whether entered or derived.
Period Number	PD_NO	SMALLINT	NUMERIC	2	By default, the Period associated with the Receipt Date in the receipt header, whether entered or derived.
Subperiod Number	SUB_PD_NO	SMALLINT	NUMERIC	2	By default, the Sub Period associated with the Receipt Date in the receipt header, whether entered or derived.
Received Quantity	RECV_QTY	DECIMAL	NUMERIC	14,4	From input file, if entered. If Receiving Settings has Overshipments set to Prevent Entry of Receipts, and the PO line does not allow overshipments, then PO line Received Qty – Reject/Replace qty cannot exceed the PO line Order Qty. If Receiving Settings has Overshipments set to Prevent Entry of Receipts, and the PO line allows overshipments within certain tolerance limits, PO line Received Qty – Reject/Replace qty can exceed the PO line Order Qty, but only up to the tolerance limit allowed.
Receiving Unit of Measure Code	RECV_UM_CD	VARCHAR	ALPHANUMERIC	3	From corresponding PO line (PO_LN.PO_LN_UM_CD).
Received Amount	RECV_AMT	DECIMAL	NUMERIC	14,2	From input file. Otherwise, calculated from Received Quantity * Net Unit Cost Amount on PO line.
Accepted Amount	ACCPT_AMT	DECIMAL	NUMERIC	14,2	From input file. Otherwise, calculated from Accepted Quantity * Net Unit Cost Amount on PO line.
Accepted Location ID	ACCPT_LOC_ID	VARCHAR	ALPHANUMERIC	15	The user's company ID should match the company ID assigned to the Warehouse Locations (WHSE_LOC) table row. Defaults to Null.
Accepted Quantity	ACCPT_QTY	DECIMAL	NUMERIC	14,4	If not entered, this value is set to zero.
Inspection Accepted Amount	INSP_ACCPT_ AMT	DECIMAL	NUMERIC	14,2	Defaults to Zero.
Inspection Accepted Quantity	INSP_ACCPT_QTY	DECIMAL	NUMERIC	14,4	Defaults to Zero.
Inventory Abbreviation Code	INVT_ABBRV_CD	VARCHAR	ALPHANUMERIC	6	The user's company ID must match that of the company ID for the row of the INVT_ABBRV_CD. Defaults to Null.
Item ID	ITEM_ID	VARCHAR	ALPHANUMERIC	30	From PO Line (PO_LN.ITEM_ID).
Item Revision ID	ITEM_RVSN_ID	VARCHAR	ALPHANUMERIC	3	From PO Line (PO_LN.ITEM_RVSN_ID)
Non-inventory Receiving Location Field	NINVT_RECV_LOC_FLD	VARCHAR		15	From input file, if entered. Otherwise, space.
Receiving Location ID	RECV_LOC_ID	VARCHAR	ALPHANUMERIC	15	The WHSE_LOC row's company ID must match that of the user's. Defaults to Null.
Rejected Amount	REJ_AMT	DECIMAL	NUMERIC	14,2	From input file. Otherwise, calculated from Rejected Quantity * Net Unit Cost Amount on PO line.
Rejected for Credit Amount	REJ_CR_AMT	DECIMAL	NUMERIC	14,2	From input file. Otherwise, calculated from Rejected Credit Quantity * Net Unit Cost Amount on PO line.
Rejected for Credit Quantity	REJ_CR_QTY	DECIMAL	NUMERIC	14,4	From input file only if Rejection Order/Payment Disposition = “C” or blank (in which case it defaults to “C”). Otherwise, or if not in input file, set to zero.
Rejection Location ID	REJ_LOC_ID	VARCHAR	ALPHANUMERIC	15	WHSE_LOC row's Company ID must match that of the user's. Defaults to Null.
Rejected but Pay Amount	REJ_PAY_AMT	DECIMAL	NUMERIC	14,2	From input file. Otherwise, calculated from Rejected but Pay Quantity * Net Unit Cost Amount on PO line.
Rejected but Pay Quantity	REJ_PAY_QTY	DECIMAL	NUMERIC	14,4	From input file only if Rejection Order/Payment Disposition = “P”. Otherwise, or if not in input file, set to zero.
Rejected Quantity	REJ_QTY	DECIMAL	NUMERIC	14,4	From input file. Otherwise, if not entered, will be set to zero.
Rejected for Repair Amount	REJ_REP_AMT	DECIMAL	NUMERIC	14,2	From input file. Otherwise, calculated from Rejected for Repair Quantity * Net Unit Cost Amount on PO line.
Rejected for Repair Quantity	REJ_REP_QTY	DECIMAL	NUMERIC	14,4	From input file only if Rejection Order/Payment Disposition = “R”. Otherwise, or if not in input file, set to zero.
Returned Material Authorization No.	RMA_NO_ID	VARCHAR	ALPHANUMERIC	15	From input file, if entered. Else, space.
Reason Code	RSN_CD	VARCHAR	ALPHANUMERIC	1	From input file, if entered. Otherwise, null. Must be on the Manage Vendor Rejection Reasons screen. Set to null if there are no rejections. The user's company ID should match the company ID assigned to the Reason Code.
Order/Payment Rejection Disposition Code	S_OP_REJ_DISPN_CD	VARCHAR	ALPHANUMERIC	1	From input file, if entered. Else defaults to “C” (Credit Due) if Rejected Qty is not zero. Will be set to null if there are no rejections.
Rejected Disposition Code	S_REJ_DISPN_CD	VARCHAR	ALPHANUMERIC	1	From input file. If not entered, defaults to "R" (Repair/Replacement Required) if Rejected Qty is not zero. Set to null if there are no rejections.
Reason Where-Used Code	S_RSN_WH_USED_CD	VARCHAR	ALPHANUMERIC	1	Defaults to “R” (Vendor Rejection Reasons)
Traveler Printed Flag	TRVLR_PRNTD_FL	VARCHAR	ALPHANUMERIC	1	Default is "N" for new receipts.
User Revision Field	USER_RVSN_FLD	VARCHAR	ALPHANUMERIC	3	Defaults from PO Line (PO_LN. USER_RVSN_FLD).
Warehouse ID	WHSE_ID	VARCHAR	ALPHANUMERIC	8	Must exist in Warehouse (WHSE) table if entered. Defaults to Null.
Time Stamp	TIME_STAMP	DATE	ALPHANUMERIC (MM/DD/YYYY)	10	Defaults to current system date.
Asset Auto-Created Flag	FA_AUTOCR_FL	VARCHAR		1	Default is "N" for new receipts.
Modified By (User ID)	MODIFIED_BY	VARCHAR		18	Receipt Upload (RECPTS UPLD).
Material Review Board Amount	MRB_AMT	DECIMAL	NUMERIC	14,2	0
Material Review Board Quantity	MRB_QTY	DECIMAL	NUMERIC	14,4	0
PO Desired Date	PO_DESIRED_DT	DATE	NUMERIC (MM/DD/YYYY)	10	From PO Line (PO_LN.DESIRED_DT).
PO Due Date	PO_DUE_DT	DATE	NUMERIC (MM/DD/YYYY)	10	From PO Line (PO_LN.DUE_DT).
PO Line Key	PO_LN_KEY	INTEGER		4	Retrieve using PO ID/PO Line Number/PO Release Number/PO Change Order Number.
Posted Amount	PSTD_AMT	DECIMAL	NUMERIC	14,2	0
Posted Quantity	PSTD_QTY	DECIMAL	NUMERIC	14,4	0
Receipt Key	RECPT_KEY	INTEGER		4	From Receipt Header.
Rowversion	ROWVERSION	SMALLINT		2	0
Voucher Amount	VCHR_AMT	DECIMAL	NUMERIC	14,2	0
Vouchered Quantity	VCHR_QTY	DECIMAL	NUMERIC	14,4	0
Transaction Accepted Amount	TRN_ACCPT_AMT	DECIMAL	NUMERIC	14,2	Calculated: ACCPT_QTY * PO_LN.TRN_NET_UN_CST_AMT
Transaction Inspection Acceptance Amount	TRN_INSP_ACCPT_AMT	DECIMAL	NUMERIC	14,2	0
Transaction Material Review Board Amount	TRN_MRB_AMT	DECIMAL	NUMERIC	14,2	0
Transaction Posted Amount	TRN_PSTD_AMT	DECIMAL	NUMERIC	14,2	0
Transaction Received Amount	TRN_RECV_AMT	DECIMAL	NUMERIC	14,2	Calculated: RECV_QTY * PO_LN.TRN_NET_UN_CST_AMT
Transaction Rejected Amount	TRN_REJ_AMT	DECIMAL	NUMERIC	14,2	Calculated: REJ_QTY * PO_LN.TRN_NET_UN_CST_AMT
Transaction Rejected - Credit Amount	TRN_REJ_CR_AMT	DECIMAL	NUMERIC	14,2	Calculated: REJ_CR_QTY * PO_LN.TRN_NET_UN_CST_AMT
Transaction Rejected - Pay Amount	TRN_REJ_PAY_AMT	DECIMAL	NUMERIC	14,2	Calculated: REJ_PAY_QTY * PO_LN.TRN_NET_UN_CST_AMT
Transaction Rejected - Replace Amount	TRN_REJ_REP_AMT	DECIMAL	NUMERIC	14,2	Calculated: REJ_REP_QTY * PO_LN.TRN_NET_UN_CST_AMT
Transaction Vouchered Amount	TRN_VCHR_AMT	DECIMAL	NUMERIC	14,2	0