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 PO258 OE229
OE88.1 RQ140 RQ230 RQ240 RQ300 RQ35.1
RQ40.1 RQ41.1 RQ42.1 RQ44.1 RQ44.2 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
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 IC28.1 MA180 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
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE111 OE113 OE114 OE116 OE129
OE13.2 OE13.3 OE13.5 OE13.6 OE14.4 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE810 OE830
OE90.1 OE90.2 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POID.1 POIE.1 POII.1 POIJ.1
RQ10.1 RQ10.2 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLS-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP25.1
resource type = V. Identifies the HR AP25.2 AP26.1
company if the resource type = E. It is AP27.1 AP30.4
blank for type A, P or Q resources. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
Element: PO Number This field contains the number AP131 AP25.1
representing the purchase order. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-PO-RELEASE Numeric 4 AP125 AP126
Element: PO Release NumUsed to identify a purchase order AP131 AP25.1
release (created from a Blanket or AP25.2 AP26.1
Standing order). AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-ORIGIN-CD Alpha 2 AP125 AP126
Element: Origin Code This field identifies the system that AP131 AP25.1
created this record. AP25.2 AP26.1
IC = Inventory Control AP27.1 AP30.4
CX = Case Carts BL120 BL122
OE = Order Entry BL130 BL20.1
RQ = Requisitions BL20.3 BL21.2
PO = Purchase Order BL21.5 BL29.1
PH = Pharmacy BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-OPER-COMPANY Numeric 4 AP125 AP126
Element: Oper Company AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-SOURCE-DOC-A Alpha 10 (Right Justified) AP125 AP126
Element: Source Doc A This is the source document number if AP131 AP25.1
the document number in the source system AP25.2 AP26.1
is alphanumeric. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-SOURCE-DOC-N Numeric 8 AP125 AP126
Element: Source Doc N This is the source document number if AP131 AP25.1
the document number in the source system AP25.2 AP26.1
is numeric. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-SRC-LINE-NBR Numeric 6 AP125 AP126
Element: Src Line Nbr This is the line number the item was on AP131 AP25.1
in the source document. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-REQ-LOCATION Alpha 5 AP125 AP126
Element: To Location The location requisitioning items. AP131 AP25.1
This location can be an inventory or AP25.2 AP26.1
noninventory location. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-REQUESTER Alpha 10 (Lower Case) AP125 AP126
Element: Requester This is the person who requested this AP131 AP25.1
requisition. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-DELIVER-TO Alpha 30 (Lower Case) AP125 AP126
Element: Deliver To NamThis field can be used to specify where AP131 AP25.1
to deliver the items. This field prints AP25.2 AP26.1
on the delivery ticket when you run AP27.1 AP30.4
Delivery Ticket Print program. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-REQ-DEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Date This is the date that the originator AP131 AP25.1
would like to receive the goods. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-ALLOC-PRI Numeric 2 AP125 AP126
Element: Alloc Pri This is the priority the originator AP131 AP25.1
assigned to this item order. The AP25.2 AP26.1
priority may be used to determine who AP27.1 AP30.4
has items delivered first if multiple BL120 BL122
source documents exist for a single PO BL130 BL20.1
line, and a partial receipt takes place. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the desired AP131 AP25.1
quantity and is represented in the AP25.2 AP26.1
unit-of-measure found in the field AP27.1 AP30.4
ENT-UOM. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-DELIVERED-QTY Signed 13.4 AP125 AP126
Element: Delivered QuanThis is the quantity that has been AP131 AP25.1
issued or transferred to the requesting AP25.2 AP26.1
location. This quantity is updated by AP27.1 AP30.4
Delivery Ticket Print. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-PROCESSED-QTY Signed 13.4 AP125 AP126
Element: Processed Qty This indicates the quantity that has AP131 AP25.1
been approved to be paid to a vendor to AP25.2 AP26.1
date. This field is populated at the AP27.1 AP30.4
time of AP Invoice Release in the BL120 BL122
unit-of-measure represented by BL130 BL20.1
ENTERED-UOM. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-ENTERED-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis is the valid Unit Of Measure of the AP131 AP25.1
entered QUANTITY. This value will AP25.2 AP26.1
originate from outside the PO system, AP27.1 AP30.4
and will not be updated by PO or AP. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-ENT-UOM-MULT Signed 13.7 AP125 AP126
Unit of Measure This is the multiplier that relates the AP131 AP25.1
Multiplier entered UOM to stock UOM. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
PLS-BL-INVC-QTY Signed 13.4 OE129
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 18.5 AP125 AP126
Element: Intl Cost This field contains the last actual unit AP131 AP25.1
cost approved to be paid to the vendor. AP25.2 AP26.1
This field is populated at the time an AP27.1 AP30.4
AP invoice has been approved to be paid. BL120 BL122
This cost is represented in the BL130 BL20.1
unit-of-measure found in ENTERED-UOM and BL20.3 BL21.2
is in GL company base currency. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
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
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE111
OE113 OE114
OE116 OE129
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
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 AP25.1
PO-NUMBER AP25.2 AP26.1
PO-RELEASE AP27.1 AP30.4
LINE-NBR BL120 BL122
ORIGIN-CD BL130 BL20.1
OPER-COMPANY BL20.3 BL21.2
SOURCE-DOC-N BL21.5 BL29.1
SOURCE-DOC-A BL29.2 BL520
SRC-LINE-NBR BL820 BL92.1
IC28.1 IC282
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
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 AP25.1
SOURCE-DOC-N AP25.2 AP26.1
SRC-LINE-NBR AP27.1 AP30.4
PO-CODE BL120 BL122
PO-NUMBER BL130 BL20.1
PO-RELEASE BL20.3 BL21.2
LINE-NBR BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
PLSSET3 OPER-COMPANY Subset AP125 AP126
SOURCE-DOC-N Where ORIGIN-CD = "CX" AP131 AP25.1
PO-CODE AP25.2 AP26.1
PO-NUMBER AP27.1 AP30.4
PO-RELEASE BL120 BL122
LINE-NBR BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
PLSSET4 COMPANY KeyChange, Subset AP125 AP126
PO-CODE Where QUANTITY > DELIVERED-QTY AP131 AP25.1
PO-NUMBER And PROCESSED-QTY = Zeroes AP25.2 AP26.1
PO-RELEASE And (ORIGIN-CD = "RQ" AP27.1 AP30.4
LINE-NBR Or ORIGIN-CD = "PO" BL120 BL122
ALLOC-PRI* Or ORIGIN-CD = "IC" ) BL130 BL20.1
REQ-DEL-DATE BL20.3 BL21.2
ORIGIN-CD BL21.5 BL29.1
OPER-COMPANY BL29.2 BL520
SOURCE-DOC-A BL820 BL92.1
SOURCE-DOC-N IC28.1 MA180
REQ-LOCATION MA530 MA531
SRC-LINE-NBR MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
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 AP25.1
PO-NUMBER Or (ORIGIN-CD = "RQ" ) AP25.2 AP26.1
PO-RELEASE AP27.1 AP30.4
LINE-NBR BL120 BL122
ORIGIN-CD BL130 BL20.1
SOURCE-DOC-N BL20.3 BL21.2
SRC-LINE-NBR BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
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 AP25.1
PO-NUMBER problems. AP25.2 AP26.1
PO-RELEASE KeyChange AP27.1 AP30.4
LINE-NBR BL120 BL122
ORIGIN-CD BL130 BL20.1
OPER-COMPANY BL20.3 BL21.2
SOURCE-DOC-A BL21.5 BL29.1
SOURCE-DOC-N BL29.2 BL520
SRC-LINE-NBR BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
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
|