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 record (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 takes note of the value of the TIMESTAMP field at the end of each record, indicating the most recent instance in which the file was created. 

Note: 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

Click 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:

Table 1. 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	*ACCEPT_AMT	Add to ACCPTD_AMT and TRN_ACCPTD_AMT	Insert ACCPT_AMT and TRN_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 and TRN_RECVD_AMT	Insert RECV_AMT and TRN_RECV_AMT	Add to TOT_RECPT_AMT and TRN_TOT_RECPT_AMT

Table 2. Cancellation of Receipt — Accepted Quantity (ACCPT_QTY) and Received Quantity (RECV_QTY) 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	ACCEPT_AMT	Add to ACCPTD_AMT and TRN_ACCPTD_AMT	Insert ACCPT_AMT and TRN_ACCPT_AMT	N/A
Received Quantity	RECV_QTY	Add to RECVD_QTY	Insert RECV_QTY	N/A
Received Amount	RECV_AMT	Add to RECV_AMT and TRN_RECVD_AMT	Insert RECV_AMT and TRN_RECV_AMT	Add to TOT_ RECPT_AMT and TRN_TOT_RECPT_AMT

Table 3. 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 RECVD_AMT and TRN_RECVD_AMT	Insert RECV_AMT and TRN_RECV_AMT	N/A
Rejected Quantity	REJ_QTY	N/A	Insert REJ_QTY	N/A
Rejected for Credit Amount	REJ_CR_AMT	Add to REJ_CR_AMT and TRN_REJ_CR_AMT	Insert REJ_CR_AMT and TRN_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 and TRN_REJ_PAY_AMT	Insert REJ_PAY_AMT and TRN_REJ_PAY_AMT	N/A
Rejected but Pay Quantity	REJ_PAY_QTY	Add to REJ_PAY_QTY	Insert REJ_PAY_QTY	N/A

Table 4. Rejection

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 RECVD_AMT and TRN_RECVD_AMT	Insert RECV_AMT and TRN_RECV_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 and TRN_REJ_REP_AMT	Insert REJ_REP_AMT and TRN_REJ_REP_AMT	N/A

Table 5. Rejection Void — Column fields Rejected Quantity (REJ_QTY) and Rejected for Repair Quantity (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	ACCPT_AMT	Add to ACCPTD_AMT and TRN_ACCPTD_AMT	Insert ACCPT_AMT and TRN_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 and TRN_REJ_PAY_AMT	Insert REJ_REP_AMT and TRN_REJ_PAY_AMT	N/A

Note: All amounts are derived by multiplying the quantity by PO_LN.NET_UNIT_CST_AMT (for functional currency amounts) and by PO_LN.TRN_NET_UN_CST_AMT (for transaction currency amounts).

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:

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

Table 6. 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	*ACCEPT_AMT	*Update ACCPTD_AMT and TRN_ACCPTD_AMT	Insert or replace ACCPT_AMT and TRN_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 and TRN_RECVD_AMT	Insert or replace RECV_AMT and TRN_RECV_AMT	Update TOT_RECPT _AMT and TRN_TOT_RECPT_AMT

Table 7. Cancellation of Receipt — the Column Fields Accepted Quantity (ACCPT_QTY) and Received Quantity (RECV_QTY) 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	ACCEPT_AMT	*Update ACCPTD_AMT and TRN_ACCPTD_AMT	Replace ACCPT_AMT and TRN_ACCPT_AMT	N/A
Received Quantity	RECV_QTY	*Update RECVD_QTY	Replace RECV_QTY	N/A
Received Amount	RECV_AMT	*Update RECVD_AMT and TRN_RECVD_AMT	Replace RECV_AMT and TRN_RECV_AMT	Add to TOT_ RECPT_ AMT and TRN_TOT_RECPT_AMT

Table 8. Debit Receipt

Column Description	Column ID	PO Line	Receipt Line	Receipt Header
Received Quantity	RECV_QTY	*Update RECVD_QTY	Insert or replace RECV_QTY	N/A
Received Amount	RECV_AMT	*Update RECVD_AMT and TRN_RECVD_AMT	Insert or replace RECV_AMT and TRN_RECV_AMT	*Update Total Receipt Amount (TOT_RECPT _AMT) and TRN_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 and TRN_REJ_CR_AMT	Insert or replace REJ_CR_AMT and TRN_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 and TRN_REJ_PAY_AMT	Insert or replace REJ_PAY_AMT and TRN_REJ_PAY_AMT	N/A
Rejected but Pay Quantity	REJ_PAY_QTY	*Update REJ_PAY_QTY	Insert or replace REJ_PAY_QTY	N/A

Table 9. 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 RECVD_AMT and TRN_RECVD_AMT	Insert or replace RECV_AMT and TRN_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 and TRN_REJ_REP_AMT	Insert or replace REJ_REP_AMT and TRN_REJ_REP_AMT	N/A

Table 10. Rejection Void — the Column Fields Rejected Quantity (REJ_QTY) and Rejected for Repair Quantity (REJ_REP_QTY) 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 and TRN_ACCPTD_AMT	Replace ACCPT_AMT and TRN_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 and TRN_REJ_REP_AMT	Replace REJ_REP_AMT and TRN_REJ_REP_AMT	N/A

* - The algorithm to update the fields with * are the following:

• The existing column from RECPT_LN is subtracted from the existing column on the PO_LN
• The new amount or quantity from the input file is added to the PO_LN column
• The same algorithm is used with TOT_RECPT_AMT and TRN_TOT_RECPT_AMT on the RECPT_HDR

All amounts are derived by multiplying the quantity by PO_LN.NET_UNIT_CST_AMT (for functional currency amounts) and by PO_LN.TRN_NET_UN_CST_AMT (for transaction currency amounts).