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: Reference No | Alpha 10 (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
|
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| PRLSET1 |
COMPANY
REC-NUMBER
LINE-NBR
|
|
|
| PRLSET10 |
COMPANY
REC-NUMBER
LINE-NBR
|
|
Subset |
| Where | | STATUS |
= | 5 | |
| Or | | STATUS |
= | 6 | |
|
|
| PRLSET11 |
COMPANY
MATCH-OBJ-ID
MATCH-SEQ-NBR
REC-NUMBER
LINE-NBR
|
|
|
| PRLSET12 |
COMPANY
REC-NUMBER
MATCH-DTL-KEY
PO-LINE-NBR
LINE-NBR
|
|
|
| PRLSET13 |
COMPANY
REC-DATE
PO-CODE
PO-NUMBER
ITEM
VENDOR
VEN-ITEM
LOCATION
REFERENCE-NO
STATUS
ITEM-TYPE
REC-NUMBER
LINE-NBR
|
|
|
| PRLSET14 |
MANUF-ID
COMPANY
LOCATION
REC-DATE
ST-FACILITY
MANUF-NBR
REC-NUMBER
LINE-NBR
|
|
Subset |
| Where | | MANUF-ID |
!= | Zeroes | |
|
|
| PRLSET15 |
COMPANY
REC-NUMBER
VEN-ITEM
PO-LINE-NBR
LINE-NBR
|
|
|
| PRLSET2 |
COMPANY
REC-NUMBER
ITEM
BIN
PO-LINE-NBR
LINE-NBR
|
|
|
| PRLSET3 |
COMPANY
REC-NUMBER
LINE-NBR
|
|
Subset |
| Where | | FULLY-DELIV |
= | "N" | |
| And | | STATUS |
= | 1 | |
|
|
| PRLSET4 |
COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
LOCATION
MATCH-DTL-KEY
PO-LINE-NBR
REC-NUMBER
LINE-NBR
|
|
|
| PRLSET5 |
COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
PO-LINE-NBR
UPDATE-DATE*
UPDATE-TIME*
REC-NUMBER
LINE-NBR
|
|
KeyChange, Subset |
| Where | | STATUS |
> | Zeroes | |
|
|
| PRLSET6 |
COMPANY
REC-NUMBER
PO-LINE-NBR
LINE-NBR
|
|
|
| PRLSET7 |
COMPANY
LOCATION
ITEM
UPDATE-DATE*
UPDATE-TIME*
REC-NUMBER
LINE-NBR
|
|
|
| PRLSET8 |
COMPANY
REC-NUMBER-A
LINE-NBR
|
|
|
| PRLSET9 |
COMPANY
ITEM
LOCATION
REC-NUMBER
LINE-NBR
|
|
|
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 |
|
| 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 |
|
