POLINESRC

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


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 POI7.1 POIF.1 POIG.1 POIM.1 MM280
RQ300

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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-PO-CODE
Element: Po Code		Alpha 4
This is the purchase order code.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-PO-NUMBER
Element: Po Number		Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-PO-RELEASE
Element: Po Release		Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-OPER-COMPANY
Element: Oper Company		Numeric 4
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-SRC-LINE-NBR
Element: Src Line Nbr		Numeric 6
This is the line number the item was on in the source document.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-REQ-LOCATION
Element: Req Location		Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-REQUESTER
Element: Requester		Alpha 10 (Lower Case)
This is the person who requested this requisition.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-REQ-DEL-DATE
Element: Date		Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
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.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PLS-OE-RQ-ALPHA
Element: Oe Rq Alpha		Derived
PLS-SOURCE-DOC
Element: Source Doc		Derived
The source from which this record was created.


POLINESRC FILE INDEX

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
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
ICI9.1 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA43.7 MAI1.1
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
KeyChange
PLSSET2 OPER-COMPANY
ORIGIN-CD
SOURCE-DOC-N
SRC-LINE-NBR
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
Subset
WhereSOURCE-DOC-N !=Zeroes
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PLSSET3 OPER-COMPANY
SOURCE-DOC-N
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
Subset
WhereORIGIN-CD ="CX"
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
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
WhereQUANTITY >DELIVERED-QTY
AndPROCESSED-QTY =Zeroes
And(ORIGIN-CD ="RQ"
OrORIGIN-CD ="PO"
OrORIGIN-CD ="IC")
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PLSSET5 COMPANY
OPER-COMPANY
SOURCE-DOC-N
SOURCE-DOC-A
SRC-LINE-NBR
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
Subset
WhereQUANTITY >DELIVERED-QTY
AndPROCESSED-QTY =Zeroes
And(ORIGIN-CD ="RQ"
OrORIGIN-CD ="PO")
PLSSET6 COMPANY
SOURCE-DOC-A
SRC-LINE-NBR
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
Subset
WhereORIGIN-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")
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PLSSET8 COMPANY
REQUESTER
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
OPER-COMPANY
SOURCE-DOC-N
SRC-LINE-NBR
KeyChange, Subset
WhereQUANTITY >DELIVERED-QTY
AndPROCESSED-QTY =Zeroes
And(ORIGIN-CD ="RQ"
OrORIGIN-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
KeyChange
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


POLINESRC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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-SRC-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

File created: Wed Jun 08 20:50:51 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.