OUTPUT TABLES

Error Output File

An error occurs because a condition is not met for a field being processed in an input file record. The application moves any input file records with one or more errors from the input file to an error file. An error file has the same name as the input file, except the extension is ".ERR." The error file is in the exact same format as the input file, so you can modify the error file and resubmit it. The application timestamps the TIMESTAMP field at the end of each record, indicating the most recent instance in which the file was created.

If you process an input file with the same base name as a previously processed file, the existing error files are overwritten. If you use different file names, you must eventually delete the old error files.

Record Types Description

Select the Process button to create new or update existing Receipt Header and Receipt Line tables in Costpoint from the input file. The application updates numeric values in these tables and the Purchase Order Line table according to the scenario and record type.

The only rows affected are those associated with receipts or purchase orders whose company ID matches the user's.

Record Type "RA"

If the input file's record type is "RA," the application adds the input file quantities and amounts to the original PO line amounts and creates new receipts for the receipt line. The following table shows how they are affected:

Normal Receipt

Column Description	Column ID	PO Line	Receipt Line	Receipt Header
Accepted Quantity	ACCPT_QTY	Add to ACCPTD_QTY.	Insert ACCPT_QTY.	N/A
Accepted Amount	ACCPT_AMT	Add to ACCPTD_AMT.	Insert ACCEPT_AMT.	N/A
Received Quantity	RECV_QTY	Add to RECVD_QTY.	Insert RECV_QTY.	N/A
Received Amount	RECV_AMT	Add to RECVD_AMT.	Insert RECV_AMT.	Add to Total Receipt Amount (TOT_ RECPT_ AMT).

Cancellation of Receipt (Column fields are negative numbers)

Column Description	Column ID (Negative)	PO Line	Receipt Line	Receipt Header
Accepted Quantity	ACCPT_QTY	Add to ACCPTD_QTY.	Insert ACCPT_QTY.	N/A
Accepted Amount	ACCPT_AMT	Add to ACCPTD_AMT.	Insert ACCPT_AMT.	N/A
Received Quantity	RECV_QTY	Add to RECVD_QTY.	Insert RECV_QTY.	N/A
Received Amount	RECV_AMT	Add to RECVD_AMT.	Insert RECV_AMT	Add to Total Receipt Amount (TOT_ RECPT_ AMT).

Debit Receipt

Column Description	Column ID	PO Line	Receipt Line	Receipt Header
Received Quantity	RECV_QTY	Add to RECV_QTY.	Insert RECV_QTY.	N/A
Received Amount	RECV_AMT	Add to RECV_AMT.	Insert RECV_AMT.	Update Total Receipt Amount (TOT_ RECPT_ AMT).
Rejected Quantity	REJ_QTY		Insert REJ_QTY.	N/A
Rejected for Credit Amount	REJ_CR_AMT	Add to REJ_CR_AMT.	Insert REJ_CR_AMT.	N/A
Rejected for Credit Quantity	REJ_CR_QTY	Add to REJ_CR_QTY.	Insert REJ_CR_QTY.	N/A
Rejected but Pay Amount	REJ_PAY_AMT	Add to REJ_PAY_AMT.	Insert REJ_PAY_AMT.	N/A
Rejected but Pay Quantity	REJ_PAY_QTY	Add to REJ_PAY_QTY.	Insert REJ_PAY_QTY.	N/A

Rejection

Column Description	Column ID	PO Line	Receipt Line	Receipt Header
Received Quantity	RECV_QTY	RECV_QTY	Replace RECV_QTY.	N/A
Received Amount	RECV_AMT	RECV_AMT	Replace RECV_AMT.	N/A
Rejected Quantity	REJ_QTY	N/A	Insert REJ_QTY.	N/A
Rejected for Repair Quantity	REJ_REP_QTY	REJ_REP_QTY	Replace REJ_REP_QTY.	N/A
Rejected for Repair Amount	REJ_REP_AMT	REJ_REP_AMT	Replace REJ_REP_AMT.	N/A

Rejection Void (Column fields REJ_QTY and REJ_REP_QTY are negative)

Column Description	Column ID (Negative)	PO Line	Receipt Line	Receipt Header
Accepted Quantity	ACCPT_QTY	Add to ACCPTD_QTY.	Insert ACCPT_QTY	N/A
Accepted Amount	ACCEPT_AMT	Add to ACCPTD_AMT.	Insert ACCPT_AMT	N/A
Rejected Quantity	REJ_QTY	N/A	Insert REJ_QTY	N/A
Rejected for Repair Quantity	REJ_REP_QTY	Add to REJ_REP_QTY.	Insert REJ_REP_QTY	N/A
Rejected for Repair Amount	REJ_REP_AMT	Add to REJ_REP_AMT.	Insert REJ_REP_AMT	N/A

Record Type "RL"

If the input file's record type is "RL," the system will compare the input file quantities and amounts to original receipt line quantities and amounts. It applies the difference to the PO line, and existing receipt information is replaced and changed for the receipt line. RL record type can also be used to add receipt lines that didn’t exist previously) to an existing receipt transaction. The following tables illustrate how they are affected:

The application derives all amounts by multiplying the quantity by the PO Line's Gross Unit Cost Amount (PO_LN.GROSS_UNIT_CST_AMT).

Normal Receipt

Column Description	Column ID	PO Line	Receipt Line	Receipt Header
Accepted Quantity	ACCPT_QTY	Update ACCPTD_QTY	Insert or replace ACCPT_QTY.	N/A
Accepted Amount	ACCPT_AMT	Update ACCPTD_AMT	Insert or replace ACCPT_AMT.	N/A
Received Quantity	RECV_QTY	Update RECVD_QTY	Insert or replace RECV_QTY.	N/A
Received Amount	RECV_AMT	Update RECVD_AMT	Insert or replace RECV_AMT.	Update Total Receipt Amount (TOT_RECPT _AMT).

Cancellation of Receipt (Column fields are negative numbers)

Column Description	Column ID (Negative)	PO Line	Receipt Line	Receipt Header
Accepted Quantity	ACCPT_QTY	Update ACCPTD_QTY	Replace ACCPT_QTY.	N/A
Accepted Amount	ACCPT_AMT	Update ACCPTD_AMT	Replace ACCPT_AMT.	N/A
Received Quantity	RECV_QTY	Update RECVD_QTY	Replace RECV_QTY.	N/A
Received Amount	RECV_AMT	Update RECVD_AMT	Replace RECV_AMT.	Add to Total Receipt Amount (TOT_ RECPT_ AMT).

Debit Receipt

Column Description	Column ID	PO Line	Receipt Line	Receipt Header
Received Quantity	RECV_QTY	Update RECV_QTY	Insert or replace RECV_QTY.	N/A
Received Amount	RECV_AMT	Update RECV_AMT	Insert or replace RECV_AMT.	Update Total Receipt Amount (TOT_RECPT _AMT).
Rejected Quantity	REJ_QTY	N/A	Insert or replace REJ_QTY.	N/A
Rejected for Credit Amount	REJ_CR_AMT	Update REJ_CR_AMT	Insert or replace REJ_CR_AMT.	N/A
Rejected for Credit Quantity	REJ_CR_QTY	Update REJ_CR_QTY	Insert or replace REJ_CR_QTY.	N/A
Rejected but Pay Amount	REJ_PAY_ AMT	Update REJ_PAY_AMT	Insert or replace REJ_PAY_AMT.	N/A
Rejected but Pay Quantity	REJ_PAY_ QTY	Update REJ_PAY_QTY	Insert or replace REJ_PAY_QTY.	N/A

Rejection

Column Description	Column ID	PO Line	Receipt Line	Receipt Header
Received Quantity	RECV_QTY	Update RECV_QTY	Insert or replace RECV_QTY.	N/A
Received Amount	RECV_AMT	Update RECV_AMT	Insert or replace RECV_AMT.	N/A
Rejected Quantity	REJ_QTY	N/A	Insert or replace REJ_QTY.	N/A
Rejected for Repair Quantity	REJ_REP_QTY	Update REJ_REP_QTY	Insert or replace REJ_REP_QTY.	N/A
Rejected for Repair Amount	REJ_REP_AMT	Update REJ_REP_AMT	insert or replace REJ_REP_AMT.	N/A

Rejection Void (Column fields are negative numbers)

Column Description	Column ID (Negative)	PO Line	Receipt Line	Receipt Header
Accepted Quantity	ACCPT_QTY	Update ACCPTD_QTY.	Replace ACCPT_QTY.	N/A
Accepted Amount	ACCPT_AMT	Update ACCPTD_AMT.	Replace ACCPT_AMT.	N/A
Rejected Quantity	REJ_QTY	N/A	Replace REJ_QTY	N/A
Rejected for Repair Quantity	REJ_REP_QTY	Update REJ_REP_QTY	Replace REJ_REP_QTY	N/A
Rejected for Repair Amount	REJ_REP_AMT	Update REJ_REP_AMT	Replace REJ_REP_AMT	N/A