Lawson Insight Technical Documentation |
|
POLINESRC
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
IC282 PO223 PO254 PO285 PO330 PO54.1
PO54.2 PO54.3 PO54.4 PO58.2 PO58.1 POCP.1
POI7.1 POIG.1 POIM.1 MM280 MM80.1 MM80.2
PO258 POIF.1 RQ140 RQ230 RQ240 RQ300
RQ35.1 RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2
RQD1.1 RQIF.1 WH110 WH120 WH130 WH132
WH190 WH25.1 WH25.2 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 WH33.5 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WHD2.1
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC28.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POD0.1 POI3.1
POID.1 POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3
RQIE.1 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLS-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP131 AP20.1
established company and is entered on AP20.2 AP20.3
all function codes. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP131 AP20.1
representing the purchase order. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed to identify a purchase order AP131 AP20.1
release (created from a Blanket or AP20.2 AP20.3
Standing order). AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-ORIGIN-CD Alpha 2 AP125 AP126
Element: Add On Cost CoIC = Inventory Control AP131 AP20.1
CX = Case Carts AP20.2 AP20.3
OE = Order Entry AP20.4 AP20.5
RQ = Requisitions AP20.7 AP23.1
PO = Purchase Order AP25.1 AP25.2
PH = Pharmacy AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-OPER-COMPANY Numeric 4 AP125 AP126
Element: Oper Company AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-SOURCE-DOC-A Alpha 10 (Right Justified) AP125 AP126
Element: Source Doc A This is the source document number if AP131 AP20.1
the document number in the source system AP20.2 AP20.3
is alphanumeric. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-SOURCE-DOC-N Numeric 8 AP125 AP126
Element: Source Doc N This is the source document number if AP131 AP20.1
the document number in the source system AP20.2 AP20.3
is numeric. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-SRC-LINE-NBR Numeric 6 AP125 AP126
Element: Src Line Nbr This is the line number the item was on AP131 AP20.1
in the source document. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-REQ-LOCATION Alpha 5 AP125 AP126
Element: Location Code AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-REQUESTER Alpha 10 (Lower Case) AP125 AP126
Element: Requester This is the person who requested this AP131 AP20.1
requisition. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-DELIVER-TO Alpha 30 (Lower Case) AP125 AP126
Element: Deliver To NamThis field can be used to specify where AP131 AP20.1
to deliver the items. This field prints AP20.2 AP20.3
on the delivery ticket when you run AP20.4 AP20.5
Delivery Ticket Print program. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-REQ-DEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-ALLOC-PRI Numeric 2 AP125 AP126
Element: Alloc Pri This is the priority the originator AP131 AP20.1
assigned to this item order. The AP20.2 AP20.3
priority may be used to determine who AP20.4 AP20.5
has items delivered first if multiple AP20.7 AP23.1
source documents exist for a single PO AP25.1 AP25.2
line, and a partial receipt takes place. AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the desired AP131 AP20.1
quantity and is represented in the AP20.2 AP20.3
unit-of-measure found in the field AP20.4 AP20.5
ENT-UOM. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-DELIVERED-QTY Signed 13.4 AP125 AP126
Element: Delivered QuanThis is the quantity that has been AP131 AP20.1
issued or transferred to the requesting AP20.2 AP20.3
location. This quantity is updated by AP20.4 AP20.5
Delivery Ticket Print. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-PROCESSED-QTY Signed 13.4 AP125 AP126
Element: Processed Qty This indicates the quantity that has AP131 AP20.1
been approved to be paid to a vendor to AP20.2 AP20.3
date. This field is populated at the AP20.4 AP20.5
time of AP Invoice Release in the AP20.7 AP23.1
unit-of-measure represented by AP25.1 AP25.2
ENTERED-UOM. AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-ENTERED-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis is the valid Unit Of Measure of the AP131 AP20.1
entered QUANTITY. This value will AP20.2 AP20.3
originate from outside the PO system, AP20.4 AP20.5
and will not be updated by PO or AP. AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-ENT-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure AP131 AP20.1
Multiplier AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-BL-INVC-QTY Signed 13.4
Element: 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 AP125 AP126
Element: Bill Unit Cst This field contains the last actual unit AP131 AP20.1
cost approved to be paid to the vendor. AP20.2 AP20.3
This field is populated at the time an AP20.4 AP20.5
AP invoice has been approved to be paid. AP20.7 AP23.1
This cost is represented in the AP25.1 AP25.2
unit-of-measure found in ENTERED-UOM and AP26.1 AP27.1
is in GL company base currency. AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO25.1 PO25.5
PO25.6 PO25.7
PO27.2 PO29.1
PO30.1 PO30.2
PO30.3 PO300
...
PLS-OE-RQ-ALPHA Derived
Element: Oe Rq Alpha
PLS-SOURCE-DOC Derived
Element: Source DocumenThe source from which this record
was created.
POLINESRC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLSSET1 COMPANY AP125 AP126
PO-CODE AP131 AP20.1
PO-NUMBER AP20.2 AP20.3
PO-RELEASE AP20.4 AP20.5
LINE-NBR AP20.7 AP23.1
ORIGIN-CD AP25.1 AP25.2
OPER-COMPANY AP26.1 AP27.1
SOURCE-DOC-N AP30.4 API1.1
SOURCE-DOC-A IC28.1 IC282
SRC-LINE-NBR MA180 MA41.2
MA41.7 MA43.1
MA43.2 MA43.3
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
...
PLSSET10 COMPANY KeyChange PO258 PO58.1
REQ-LOCATION PO58.2
PO-CODE
PO-NUMBER
PO-RELEASE
LINE-NBR
ORIGIN-CD
OPER-COMPANY
SOURCE-DOC-A
SOURCE-DOC-N
SRC-LINE-NBR
PLSSET2 OPER-COMPANY Subset AP125 AP126
ORIGIN-CD Where SOURCE-DOC-N != Zeroes AP131 AP20.1
SOURCE-DOC-N AP20.2 AP20.3
SRC-LINE-NBR AP20.4 AP20.5
PO-CODE AP20.7 AP23.1
PO-NUMBER AP25.1 AP25.2
PO-RELEASE AP26.1 AP27.1
LINE-NBR AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLSSET3 OPER-COMPANY Subset AP125 AP126
SOURCE-DOC-N Where ORIGIN-CD = "CX" AP131 AP20.1
PO-CODE AP20.2 AP20.3
PO-NUMBER AP20.4 AP20.5
PO-RELEASE AP20.7 AP23.1
LINE-NBR AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLSSET4 COMPANY KeyChange, Subset AP125 AP126
PO-CODE Where QUANTITY > DELIVERED-QTY AP131 AP20.1
PO-NUMBER And PROCESSED-QTY = Zeroes AP20.2 AP20.3
PO-RELEASE And (ORIGIN-CD = "RQ" AP20.4 AP20.5
LINE-NBR Or ORIGIN-CD = "PO" AP20.7 AP23.1
ALLOC-PRI* Or ORIGIN-CD = "IC" ) AP25.1 AP25.2
REQ-DEL-DATE AP26.1 AP27.1
ORIGIN-CD AP30.4 API1.1
OPER-COMPANY IC28.1 MA180
SOURCE-DOC-A MA41.2 MA41.7
SOURCE-DOC-N MA43.1 MA43.2
REQ-LOCATION MA43.3 MA43.9
SRC-LINE-NBR MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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 AP125 AP126
PO-CODE Where (ORIGIN-CD = "OE" ) AP131 AP20.1
PO-NUMBER Or (ORIGIN-CD = "RQ" ) AP20.2 AP20.3
PO-RELEASE AP20.4 AP20.5
LINE-NBR AP20.7 AP23.1
ORIGIN-CD AP25.1 AP25.2
SOURCE-DOC-N AP26.1 AP27.1
SRC-LINE-NBR AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
PLSSET8 COMPANY KeyChange, Subset
REQUESTER Where QUANTITY > DELIVERED-QTY
PO-CODE And PROCESSED-QTY = Zeroes
PO-NUMBER And (ORIGIN-CD = "RQ"
PO-RELEASE Or ORIGIN-CD = "PO" )
LINE-NBR
OPER-COMPANY
SOURCE-DOC-N
SRC-LINE-NBR
PLSSET9 COMPANY This key was added to allow alternate AP125 AP126
PO-CODE file access for correcting DBAPIERROR AP131 AP20.1
PO-NUMBER problems. AP20.2 AP20.3
PO-RELEASE KeyChange AP20.4 AP20.5
LINE-NBR AP20.7 AP23.1
ORIGIN-CD AP25.1 AP25.2
OPER-COMPANY AP26.1 AP27.1
SOURCE-DOC-A AP30.4 API1.1
SOURCE-DOC-N IC28.1 MA180
SRC-LINE-NBR MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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-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
|