Purpose: To house information interfaced into the PO system by program PO100
or PO23.
Business rules:
- All quantity and cost fields on this record will be represented in the
unit-of-measure found in the field ENTERED-UOM.
- Currently the PO system is not allowed to order goods in a
unit-of-measure different from the value found in the field ENTERED-UOM.
- One or more AP invoice lines pertaining to a single POLINESRC record
can be approved in AP20 in different unit of measures.
Rick Bibeau
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
PLS-COMPANY
Element: Company | Numeric 4
Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
|
|
PLS-PO-CODE
Element: Po Code | Alpha 4
This is the purchase order code.
|
|
PLS-PO-NUMBER
Element: Po Number | Alpha 14 (Right Justified)
This field contains the number
representing the purchase order.
|
|
PLS-PO-RELEASE
Element: Po Release | Numeric 4
Used to identify a purchase order
release (created from a Blanket or
Standing order).
|
|
PLS-LINE-NBR
Element: Line Nbr | Numeric 6
This field contains the line number.
|
|
PLS-ORIGIN-CD
Element: Origin Code | Alpha 2
System origin code
IC = Inventory Control
CX = Case Carts
OE = Order Entry
RQ = Requisitions
PO = Purchase Order
PH = Pharmacy
SS = Strategic Sourcing |
|
PLS-OPER-COMPANY
Element: Oper Company | Numeric 4
|
|
PLS-SOURCE-DOC-A
Element: Source Doc A | Alpha 10 (Right Justified)
This is the source document number if
the document number in the source system
is alphanumeric.
|
|
PLS-SOURCE-DOC-N
Element: Source Doc N | Numeric 8
This is the source document number if
the document number in the source system
is numeric.
|
|
PLS-SRC-LINE-NBR
Element: Src Line Nbr | Numeric 6
This is the line number the item was on
in the source document.
|
|
PLS-REQ-LOCATION
Element: Req Location | Alpha 5
The location requisitioning items.
This location can be an inventory or
noninventory location.
|
|
PLS-REQUESTER
Element: Requester | Alpha 10 (Lower Case)
This is the person who requested this
requisition.
|
|
PLS-DELIVER-TO
Element: Deliver To | Alpha 30 (Lower Case)
This field can be used to specify where
to deliver the items. This field prints
on the delivery ticket when you run
Delivery Ticket Print program.
|
|
PLS-REQ-DEL-DATE
Element: Date | Numeric 8 (yyyymmdd)
This field displays the system date
when this was created.
|
|
PLS-ALLOC-PRI
Element: Alloc Pri | Numeric 2
This is the priority the originator
assigned to this item order. The
priority may be used to determine who
has items delivered first if multiple
source documents exist for a single
purchase order line, and a partial
receipt takes place.
|
|
PLS-QUANTITY
Element: Quantity | Signed 13.4
This field contains the desired
quantity and is represented in the
unit-of-measure found in the field
ENT-UOM.
|
|
PLS-DELIVERED-QTY
Element: Delivered Qty | Signed 13.4
This is the quantity that has been
issued or transferred to the requesting
location. This quantity is updated by
Delivery Ticket Print.
|
|
PLS-PROCESSED-QTY
Element: Processed Qty | Signed 13.4
This indicates the quantity that has
been approved to be paid to a vendor to
date. This field is populated at the
time of AP Invoice Release in the
unit-of-measure represented by
ENTERED-UOM.
|
|
PLS-ENTERED-UOM
Element: Uom | Alpha 4
This is the valid unit of measure of
the entered quantity. This value will
originate from outside Purchase Order,
and will not be updated by Purchase
Order or Accounts Payable.
|
|
PLS-ENT-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.
|
|
PLS-BL-INVC-QTY
Element: Bl Invc Qty | Signed 13.4
Billed Invoice quantity. This field
represents the quantity that has been
billed to the customer to date. This
field is populated by OE129 (Daily
Shipment Journal). The value of this
field is represented in the
unit-of-measure found in the field
ENTERED-UOM.
|
|
PLS-BILL-UNIT-CST
Element: Intl Cost | Signed 18.5
This field contains the last actual unit
cost approved to be paid to the vendor.
This field is populated at the time an
AP invoice has been approved to be paid.
This cost is represented in the
unit-of-measure found in ENTERED-UOM and
is in GL company base currency.
|
|
PLS-OE-RQ-ALPHA
Element: Oe Rq Alpha | Derived
|
|
PLS-SOURCE-DOC
Element: Source Doc | Derived
The source from which this record
was created.
|
|
| NAME |
KEY FIELDS |
DESCRIPTION / SUBSET CONDITION |
USED IN |
| PLSSET1 |
COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
ORIGIN-CD
OPER-COMPANY
SOURCE-DOC-N
SOURCE-DOC-A
SRC-LINE-NBR
|
|
|
| PLSSET10 |
COMPANY
REQ-LOCATION
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
ORIGIN-CD
OPER-COMPANY
SOURCE-DOC-A
SOURCE-DOC-N
SRC-LINE-NBR
|
|
|
| PLSSET2 |
OPER-COMPANY
ORIGIN-CD
SOURCE-DOC-N
SRC-LINE-NBR
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
|
|
Subset |
| Where | | SOURCE-DOC-N |
!= | Zeroes | |
|
|
| PLSSET3 |
OPER-COMPANY
SOURCE-DOC-N
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
|
|
Subset |
| Where | | ORIGIN-CD |
= | "CX" | |
|
|
| PLSSET4 |
COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
ALLOC-PRI
REQ-DEL-DATE
ORIGIN-CD
OPER-COMPANY
SOURCE-DOC-A
SOURCE-DOC-N
REQ-LOCATION
SRC-LINE-NBR
|
|
KeyChange, Subset |
| Where | | QUANTITY |
> | DELIVERED-QTY | |
| And | | PROCESSED-QTY |
= | Zeroes | |
| And | ( | ORIGIN-CD |
= | "RQ" | |
| Or | | ORIGIN-CD |
= | "PO" | |
| Or | | ORIGIN-CD |
= | "IC" | ) |
|
|
| PLSSET5 |
COMPANY
OPER-COMPANY
SOURCE-DOC-N
SOURCE-DOC-A
SRC-LINE-NBR
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
|
|
Subset |
| Where | | QUANTITY |
> | DELIVERED-QTY | |
| And | | PROCESSED-QTY |
= | Zeroes | |
| And | ( | ORIGIN-CD |
= | "RQ" | |
| Or | | ORIGIN-CD |
= | "PO" | ) |
|
|
| PLSSET6 |
COMPANY
SOURCE-DOC-A
SRC-LINE-NBR
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
|
|
Subset |
| Where | | ORIGIN-CD |
= | "PO" | |
|
|
| PLSSET7 |
COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
ORIGIN-CD
SOURCE-DOC-N
SRC-LINE-NBR
|
|
Subset |
| Where | ( | ORIGIN-CD |
= | "OE" | ) |
| Or | ( | ORIGIN-CD |
= | "RQ" | ) |
|
|
| PLSSET8 |
COMPANY
REQUESTER
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
OPER-COMPANY
SOURCE-DOC-N
SRC-LINE-NBR
|
|
KeyChange, Subset |
| Where | | QUANTITY |
> | DELIVERED-QTY | |
| And | | PROCESSED-QTY |
= | Zeroes | |
| And | ( | ORIGIN-CD |
= | "RQ" | |
| Or | | ORIGIN-CD |
= | "PO" | ) |
|
|
| PLSSET9 |
COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
ORIGIN-CD
OPER-COMPANY
SOURCE-DOC-A
SOURCE-DOC-N
SRC-LINE-NBR
|
|
|
