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.
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.
| 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.
| 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 |
| 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. |
| 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 |