POLINESRC FILE
PO Line Source
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
REFERENCED BY
POCP.1 POI7.1 RQ140 RQ230 RQ300 RQ40.1
RQ41.1 RQ42.1 RQ44.1 RQ44.2 WH110 WH120
WH130
UPDATED BY
POID.1 POIJ.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLS-COMPANY Numeric 4 POCP.1 POID.1
Company The company number represents an POIJ.1
established company and is entered on
all function codes.
PLS-PO-CODE Alpha 4 POCP.1 POID.1
Po Code This is the purchase order code. POIJ.1
PLS-PO-NUMBER Alpha 14 (Right Justified) POCP.1 POID.1
PO Number This field contains the number POIJ.1
representing the purchase order.
PLS-PO-RELEASE Numeric 4 POCP.1 POID.1
PO Release Number Used to identify a purchase order POIJ.1
release (created from a Blanket or
Standing order).
PLS-LINE-NBR Numeric 6 POCP.1 POID.1
Line Number This field contains the line number. POIJ.1
PLS-ORIGIN-CD Alpha 2 POCP.1 POID.1
Origin Code This field identifies the system that POIJ.1
created this record.
IC = Inventory Control
CX = Case Carts
OE = Order Entry
RQ = Requisitions
PO = Purchase Order
PLS-OPER-COMPANY Numeric 4 POCP.1 POID.1
Oper Company POIJ.1
PLS-SOURCE-DOC-A Alpha 10 (Right Justified) POCP.1 POID.1
Source Doc A This is the source document number if POIJ.1
the document number in the source system
is alphanumeric.
PLS-SOURCE-DOC-N Numeric 8 POCP.1 POID.1
Source Doc N This is the source document number if POIJ.1
the document number in the source system
is numeric.
PLS-SRC-LINE-NBR Numeric 6 POCP.1 POID.1
Src Line Nbr This is the line number the item was on POIJ.1
in the source document.
PLS-REQ-LOCATION Alpha 5 POCP.1 POID.1
To Location The location requisitioning items. POIJ.1
This location can be an inventory or
noninventory location.
PLS-REQUESTER Alpha 10 (Lower Case) POCP.1 POID.1
Requester This is the person who requested this POIJ.1
requisition.
PLS-DELIVER-TO Alpha 30 (Lower Case) POCP.1 POID.1
Deliver To Name This field can be used to specify where POIJ.1
to deliver the items. This field prints
on the delivery ticket when you run
Delivery Ticket Print program.
PLS-REQ-DEL-DATE Numeric 8 (yyyymmdd) POCP.1 POID.1
Requested Delivery This is the date that the originator POIJ.1
Date would like to receive the goods.
PLS-ALLOC-PRI Numeric 2 POCP.1 POID.1
Alloc Pri This is the priority the originator POIJ.1
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 PO
line, and a partial receipt takes place.
PLS-QUANTITY Signed 13.4 POCP.1 POID.1
Quantity This field contains the desired POIJ.1
quantity and is represented in the
unit-of-measure found in the field
ENT-UOM.
PLS-DELIVERED-QTY Signed 13.4 POCP.1 POID.1
Delivered Quantity This is the quantity that has been POIJ.1
issued or transferred to the requesting
location. This quantity is updated by
Delivery Ticket Print.
PLS-PROCESSED-QTY Signed 13.4 POCP.1 POID.1
Processed Qty This indicates the quantity that has POIJ.1
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 Alpha 4 POCP.1 POID.1
Entered Unit of This is the valid Unit Of Measure of the POIJ.1
Measure entered QUANTITY. This value will
originate from outside the PO system,
and will not be updated by PO or AP.
PLS-ENT-UOM-MULT Signed 13.7 POCP.1 POID.1
Entered UOM This is the multiplier that relates the POIJ.1
Multiplier entered UOM to stock UOM.
PLS-BL-INVC-QTY Signed 13.4
Bl Invc Qty 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 Signed 13.5 POCP.1 POID.1
Bill Unit Cst This field contains the last actual unit POIJ.1
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 Derived
Oe Rq Alpha
PLS-SOURCE-DOC Derived
Source Document The source from which this record
was created.
POLINESRC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLSSET1 COMPANY POCP.1 POI7.1
PO-CODE POID.1 POIJ.1
PO-NUMBER
PO-RELEASE
LINE-NBR
ORIGIN-CD
OPER-COMPANY
SOURCE-DOC-N
SOURCE-DOC-A
SRC-LINE-NBR
PLSSET2 OPER-COMPANY Subset POCP.1 POIJ.1
ORIGIN-CD Where SOURCE-DOC-N != Zeroes RQ140 RQ230
SOURCE-DOC-N RQ300 RQ40.1
SRC-LINE-NBR RQ41.1 RQ42.1
PO-CODE RQ44.1 RQ44.2
PO-NUMBER WH110 WH120
PO-RELEASE
LINE-NBR
PLSSET3 OPER-COMPANY Subset POCP.1 POIJ.1
SOURCE-DOC-N Where ORIGIN-CD = "CX"
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
PLSSET4 COMPANY KeyChange, Subset POCP.1 POID.1
PO-CODE Where QUANTITY > DELIVERED-QTY POIJ.1
PO-NUMBER And PROCESSED-QTY = Zeroes
PO-RELEASE And (ORIGIN-CD = "RQ"
LINE-NBR Or ORIGIN-CD = "PO"
ALLOC-PRI* Or ORIGIN-CD = "IC" )
REQ-DEL-DATE
ORIGIN-CD
OPER-COMPANY
SOURCE-DOC-A
SOURCE-DOC-N
REQ-LOCATION
SRC-LINE-NBR
PLSSET5 COMPANY Subset WH130
OPER-COMPANY Where QUANTITY > DELIVERED-QTY
SOURCE-DOC-N And PROCESSED-QTY = Zeroes
SOURCE-DOC-A And (ORIGIN-CD = "RQ"
SRC-LINE-NBR Or ORIGIN-CD = "PO" )
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
PLSSET6 COMPANY Subset
SOURCE-DOC-A Where ORIGIN-CD = "PO"
SRC-LINE-NBR
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
PLSSET7 COMPANY Subset
PO-CODE Where (ORIGIN-CD = "OE" )
PO-NUMBER Or (ORIGIN-CD = "RQ" )
PO-RELEASE
LINE-NBR
ORIGIN-CD
SOURCE-DOC-N
SRC-LINE-NBR
POLINESRC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Coline COLINE Required
When PLS-ORIGIN-CD = "OE"
PLS-COMPANY -> COL-COMPANY
PLS-SOURCE-DOC-N -> COL-ORDER-NBR
PLS-LINE-NBR -> COL-LINE-NBR
Cxprefitem CXPREFITEM Required
When PLS-ORIGIN-CD = "CX"
PLS-OPER-COMPANY -> CPI-COMPANY
PLS-SOURCE-DOC-N -> CPI-IF-REF-NBR
Poline POLINE Required
PLS-COMPANY -> PLI-COMPANY
PLS-PO-NUMBER -> PLI-PO-NUMBER
PLS-PO-RELEASE -> PLI-PO-RELEASE
PLS-PO-CODE -> PLI-PO-CODE
PLS-LINE-NBR -> PLI-LINE-NBR
Purchorder PURCHORDER Required
PLS-COMPANY -> PCR-COMPANY
PLS-PO-CODE -> PCR-PO-CODE
PLS-PO-NUMBER -> PCR-PO-NUMBER
PLS-PO-RELEASE -> PCR-PO-RELEASE
Reqline REQLINE Required
When PLS-ORIGIN-CD = "RQ"
PLS-OPER-COMPANY -> RLN-COMPANY
PLS-SOURCE-DOC-N -> RLN-REQ-NUMBER
PLS-SRC-LINE-NBR -> RLN-LINE-NBR
|
