This file contains purchase order receiving line item detail and status
information.
FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PRL-COMPANY Element: Company | Numeric 4 The company number.
|
|
PRL-REC-NUMBER Element: Rec Number | Numeric 10 The receiver number. Assigned when
this receiving information was added.
|
|
PRL-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number.
|
|
PRL-REC-NUMBER-A Element: Rec Number A | Alpha 10 (Right Justified)
|
|
PRL-REFERENCE-NO Element: Upn2 Nbr | Alpha 25 (Right Justified)
|
|
PRL-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number
representing the purchase order.
|
|
PRL-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
PRL-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code.
|
|
PRL-PO-LINE-NBR Element: Line Nbr | Numeric 6 The purchase order line number this
record is associated with.
|
|
PRL-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
PRL-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description.
|
|
PRL-ITEM-TYPE Element: Item Type | Alpha 1 This field identifies the line item
type.
I = Inventoried N = Non-stock S = Service X = Special |
|
PRL-VEN-ITEM Element: Item | Alpha 32 This field contains the item
identifier.
|
|
PRL-LOCATION Element: Location | Alpha 5 This field contains a valid stock
location within the company inventory.
|
|
PRL-PROCESS-LEVEL Element: Process Level | Alpha 5 This field contains the process level,
which is the reporting hierarchy below
company.
|
|
PRL-ENT-REC-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
PRL-ENT-REC-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
PRL-ENT-RUOM-MULT Element: Uom Mult | Signed 13.7 This multiplier is used to convert
entered unit of measure quantity down to
stock unit of measure.
|
|
PRL-REJECT-QTY Element: Quantity | Signed 13.4 The rejected quantity for this
receiving.
|
|
PRL-ORIG-REC-QTY Element: Quantity | Signed 13.4 Any adjustment to the original received
quantity is accumulated in the Entered
Received Quantity field. This quantity
is the original quantity when this
receiver was first released.
|
|
PRL-CATCH-WT-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
PRL-ORIG-UNIT-CST Element: Intl Cost | Signed 18.5
|
|
PRL-MATCH-UNIT-CST Element: Intl Cost | Signed 18.5
|
|
PRL-BIN Element: Bin | Alpha 7 This field contains a storage area for
an item or any number of items.
|
|
PRL-CANCEL-BO-FL Element: All Flag | Alpha 1 This flag indicates whether the
backordered quantity is to be canceled
and the line is to be considered closed.
N = No Y = Yes |
|
PRL-INSP-REQ-FL Element: All Flag | Alpha 1 This flag indicates whether this item
has to be inspected when received via
purchase order.
N = No Y = Yes |
|
PRL-DETAIL-BAL-FL Element: All Flag | Alpha 1 This flag is set to Yes when all items
received for this line have bins, serial
numbers, and/or lots/sublots assigned if
necessary.
Y = Yes N = No |
|
PRL-STATUS Element: Status | Numeric 1 Current receiving status for this line.
0 = Entered 1 = Released/Inspected 5 = Released/Requires Inspection 6 = Released/Unreleased Inspection |
|
PRL-BUYER-MSG-FLAG Element: Buyer Msg Flag | Alpha 1 Indicates whether a buyer message exists
for this receiving line.
Y = Yes N = No |
|
PRL-LAST-POT-SEQ Element: Last Pot Seq | Numeric 6
|
|
PRL-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record
was updated.
|
|
PRL-UPDATE-TIME Element: Update Time | Numeric 6 This field contains the system time
when the record was updated.
|
|
PRL-REC-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date
when this was created.
|
|
PRL-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code.
|
|
PRL-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice.
|
|
PRL-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice.
|
|
PRL-MSDS-FLAG Element: All Flag | Alpha 1
N = No Y = Yes |
|
PRL-MSDS-VERSION Element: Msds Version | Alpha 4 The version number of the most recent
MSDS that was received.
|
|
PRL-MSDS-DOCUMENT Element: Msds Document | Alpha 30 The document number from the most
recent MSDS that was received.
|
|
PRL-MATCH-CLASS Element: Match Class | Alpha 10
|
|
PRL-MATCHED-QTY Element: Rec Qty | Signed 13.4 This is the total quantity to date
received for this ordered item.
|
|
PRL-MATCH-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
|
|
PRL-MATCH-DTL-KEY Element: Match Dtl Key | Alpha 85
|
|
PRL-OPEN-TO-MATCH Element: Open To Match | Signed 13.4 This is the open to match quantity in
VPRI UOM.
|
|
PRL-ARCHIVE-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
PRL-ARCH-WO-QTY Element: Arch Wo Qty | Signed 13.4
|
|
PRL-VPRI-QUANTITY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
PRL-VPRI-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
PRL-VPRI-UOM-MULT Element: Uom Mult | Signed 13.7 This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
|
|
PRL-BUOM-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
PRL-VBUY-UOM Element: Uom | Alpha 4 This field contains the valid stock
unit of measure for this item.
|
|
PRL-VBUY-UOM-MULT Element: Uom Mult | Signed 13.7 This field contains the multiplier for
converting this unit of measure to the
stock unit of measure.
|
|
PRL-CHARGEBACK-QTY Element: Chargeback Qty | Signed 13.4
|
|
PRL-WRITE-OFF-QTY Element: Write Off Qty | Signed 13.4
|
|
PRL-MATCH-SEQ-NBR Element: Match Seq Nbr | Numeric 4
|
|
PRL-TAX-UNIT-CST Element: Intl Cost | Signed 18.5
|
|
PRL-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing
specific tax information. This must be
valid Tax Code.
|
|
PRL-EXTENDED-AMT Element: Intl Amt | Signed 18.2
|
|
PRL-RETURN-NUMBER Element: Return Number | Numeric 10 This is the number assigned to the
return for purposes of referencing the
return internally and with the customer
or vendor.
|
|
PRL-RET-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number.
|
|
PRL-FULLY-DELIV Element: Fully Deliv | Alpha 1
Y = Yes N = No |
|
PRL-REC-ALLOC-QTY Element: Rec Alloc Qty | Signed 13.4 This is the portion of the entered
received quantity that has been
allocated by the automatic allocation
from receiving process. (Allocation by
other processes is not tracked here)
|
|
PRL-TAX-USAGE-CD Element: Tax Usage Cd | Alpha 10 The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
|
|
PRL-INTRASTAT-NBR Element: Intrastat Nbr | Numeric 12 The number assigned by the Intrastat
system to a transaction that involves
Intrastat reporting after it has been
added.
|
|
PRL-MANUF-ID Element: Manuf Id | Numeric 4 A unique idenitifier for a manufacturer
|
|
PRL-MANUF-NBR Element: Manuf Nbr | Alpha 35 This is the identifier that the
manufacturer has assigned to an item.
|
|
PRL-ST-FACILITY Element: St Facility | Alpha 15 A unique identifier for a ship to
facility.
|
|
PRL-CATCH-WGT-COST Element: Intl Cost | Signed 18.5
|
|
PRL-COMMODITY-CODE Element: Commodity Code | Alpha 35
|
|
PRL-CHARGE-QTY Element: Quantity | Signed 13.4 This field contains the desired
quantity.
|
|
PRL-SUBSTITUTE Element: Substitute | Derived
|
|
PRL-PROD-TAX-CAT Element: Prod Tax Cat | Alpha 15
|
|
PRL-GTIN Element: Gtin | Numeric 14
|
|
PRL-EAM-OPER-NBR Element: Operation Nbr | Numeric 4
|
|
PRL-EAM-SEQ-NBR Element: Seq Nbr | Numeric 4
|
|
PRL-EAM-WO-NBR Element: Work Order | Numeric 8
|
|
PRL-CREATED-BY Element: Operator | Alpha 10
|
|
PRL-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd)
|
|
PRL-LAST-UPDT-TIME Element: Time | Numeric 8
|
|
PRL-LAST-UPDATE-BY Element: Operator | Alpha 10
|
|
PRL-GLBL-LINE-TYPE Element: Glbl Line Type | Alpha 15
|
|
PRL-FREIGHT-TOT Element: Freight Total | Signed 18.2
|
|
PRL-INSURANCE-TOT Element: Insurance Tot | Signed 18.2
|
|
PRL-CSTMS-TOT Element: Cstms Total | Signed 18.2
|
|
PRL-OTHER-AOC-TOT Element: Other Aoc Tot | Signed 18.2
|
|
PRL-TEMP-HOLD Element: Temp Hold | Alpha 1
S = Sent for Approval A = Approved by Engine " " |
|
RELATION NAME |
RELATED FILE |
INTEGRITY RULES / FIELD MATCH |
Apcompany |
APCOMPANY |
Required
|
Apinvoice |
APINVOICE |
Not Required
PRL-COMPANY | -> | API-COMPANY |
PRL-VENDOR | -> | API-VENDOR |
PRL-MATCH-OBJ-ID | -> | API-MATCH-OBJ-ID |
PRL-INVOICE | -> | API-INVOICE |
PRL-SUFFIX | -> | API-SUFFIX |
Zeroes | -> | API-CANCEL-SEQ |
|
Buyer Message |
POMESSAGE |
Not Required, Delete Cascades
PRL-COMPANY | -> | POM-COMPANY |
PRL-REC-NUMBER | -> | POM-REC-NUMBER |
PRL-LINE-NBR | -> | POM-LINE-NBR |
|
Icbin |
ICBIN |
Required
When | | PRL-BIN | != | Spaces | |
And | | PRL-BIN | != | "*" | |
PRL-COMPANY | -> | ICB-COMPANY |
PRL-LOCATION | -> | ICB-LOCATION |
PRL-BIN | -> | ICB-BIN |
|
Iccategory |
ICCATEGORY |
Required
PRL-COMPANY | -> | ICA-COMPANY |
PRL-LOCATION | -> | ICA-LOCATION |
ITL-GL-CATEGORY | -> | ICA-GL-CATEGORY |
|
Iccompany |
ICCOMPANY |
Required
|
Iclocation |
ICLOCATION |
Required
PRL-COMPANY | -> | ICL-COMPANY |
PRL-LOCATION | -> | ICL-LOCATION |
|
Ictrans |
ICTRANS |
Required
PRL-COMPANY | -> | ICT-COMPANY |
PRL-LOCATION | -> | ICT-LOCATION |
"PO" | -> | ICT-DOC-TYPE |
"PO" | -> | ICT-SYSTEM-CD |
PRL-REC-NUMBER-A | -> | ICT-DOCUMENT |
Zeroes | -> | ICT-SHIPMENT-NBR |
PRL-LINE-NBR | -> | ICT-LINE-NBR |
Zeroes | -> | ICT-COMPONENT-SEQ |
|
Itemloc |
ITEMLOC |
Required
PRL-COMPANY | -> | ITL-COMPANY |
PRL-LOCATION | -> | ITL-LOCATION |
PRL-ITEM | -> | ITL-ITEM |
|
Itemmast |
ITEMMAST |
Required
When | | PRL-ITEM-TYPE | = | "I" | |
Or | | PRL-ITEM-TYPE | = | "N" | |
ICC-ITEM-GROUP | -> | ITE-ITEM-GROUP |
PRL-ITEM | -> | ITE-ITEM |
|
Macompany |
MACOMPANY |
Required
|
Pocompany |
POCOMPANY |
Required
|
Poline |
POLINE |
Required
PRL-COMPANY | -> | PLI-COMPANY |
PRL-PO-NUMBER | -> | PLI-PO-NUMBER |
PRL-PO-RELEASE | -> | PLI-PO-RELEASE |
PRL-PO-CODE | -> | PLI-PO-CODE |
PRL-PO-LINE-NBR | -> | PLI-LINE-NBR |
|
Porbod |
PORBOD |
Not Required
PRL-COMPANY | -> | PBE-COMPANY |
PRL-REC-NUMBER | -> | PBE-REC-NUMBER |
|
Poreceive |
PORECEIVE |
Required
PRL-COMPANY | -> | POR-COMPANY |
PRL-REC-NUMBER | -> | POR-REC-NUMBER |
|
Purchorder |
PURCHORDER |
Required
PRL-COMPANY | -> | PCR-COMPANY |
PRL-PO-CODE | -> | PCR-PO-CODE |
PRL-PO-NUMBER | -> | PCR-PO-NUMBER |
PRL-PO-RELEASE | -> | PCR-PO-RELEASE |
|
Vendloc |
APVENLOC |
Required
CPY-VENDOR-GROUP | -> | VLO-VENDOR-GROUP |
PRL-VENDOR | -> | VLO-VENDOR |
PLI-PURCH-FR-LOC | -> | VLO-LOCATION-CODE |
|
Vendor |
APVENMAST |
Required
CPY-VENDOR-GROUP | -> | VEN-VENDOR-GROUP |
POR-VENDOR | -> | VEN-VENDOR |
|