Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

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.

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

Input File Excel Template

Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.

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.

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

Table 1. 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
Table 2. 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.
Table 3. 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