 |
Lawson Insight Technical Documentation |
|
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
PO254 PO330 PO54.1 PO54.2 PO54.3 PO54.4
POCP.1 POI7.1 POIG.1 POIM.1 IC142 RQ140
RQ230 RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 WH110 WH120 WH25.1 WH25.2
WH130
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 IC28.1 MA180 MA43.9 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.3 MA67.1
MA67.2 MA70.1 MAI1.1 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
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-PO-CODE Alpha 4 AP125 AP126
Po Code This is the purchase order code. AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-PO-NUMBER Alpha 14 (Right Justified) AP125 AP126
PO Number This field contains the number AP131 AP25.1
representing the purchase order. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-PO-RELEASE Numeric 4 AP125 AP126
PO Release Number Used to identify a purchase order AP131 AP25.1
release (created from a Blanket or AP25.2 AP26.1
Standing order). AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-ORIGIN-CD Alpha 2 AP125 AP126
Origin Code This field identifies the system that AP131 AP25.1
created this record. AP25.2 AP26.1
IC = Inventory Control AP27.1 IC28.1
CX = Case Carts MA180 MA43.9
OE = Order Entry MA530 MA531
RQ = Requisitions MA60.2 MA60.3
PO = Purchase Order MA60.5 MA61.1
PH = Pharmacy MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-OPER-COMPANY Numeric 4 AP125 AP126
Oper Company AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-SOURCE-DOC-A Alpha 10 (Right Justified) AP125 AP126
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 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-SOURCE-DOC-N Numeric 8 AP125 AP126
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 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-SRC-LINE-NBR Numeric 6 AP125 AP126
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 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-REQ-LOCATION Alpha 5 AP125 AP126
To Location The location requisitioning items. AP131 AP25.1
This location can be an inventory or AP25.2 AP26.1
noninventory location. AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-REQUESTER Alpha 10 (Lower Case) AP125 AP126
Requester This is the person who requested this AP131 AP25.1
requisition. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-DELIVER-TO Alpha 30 (Lower Case) AP125 AP126
Deliver To Name This 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 IC28.1
Delivery Ticket Print program. MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-REQ-DEL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Requested Delivery This is the date that the originator AP131 AP25.1
Date would like to receive the goods. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-ALLOC-PRI Numeric 2 AP125 AP126
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 IC28.1
has items delivered first if multiple MA180 MA43.9
source documents exist for a single PO MA530 MA531
line, and a partial receipt takes place. MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-QUANTITY Signed 13.4 AP125 AP126
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 IC28.1
ENT-UOM. MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-DELIVERED-QTY Signed 13.4 AP125 AP126
Delivered Quantity This 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 IC28.1
Delivery Ticket Print. MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-PROCESSED-QTY Signed 13.4 AP125 AP126
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 IC28.1
time of AP Invoice Release in the MA180 MA43.9
unit-of-measure represented by MA530 MA531
ENTERED-UOM. MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-ENTERED-UOM Alpha 4 AP125 AP126
Entered Unit of This is the valid Unit Of Measure of the AP131 AP25.1
Measure entered QUANTITY. This value will AP25.2 AP26.1
originate from outside the PO system, AP27.1 IC28.1
and will not be updated by PO or AP. MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-ENT-UOM-MULT Signed 13.7 AP125 AP126
Entered UOM This is the multiplier that relates the AP131 AP25.1
Multiplier entered UOM to stock UOM. AP25.2 AP26.1
AP27.1 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
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 AP125 AP126
Bill Unit Cst 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 IC28.1
AP invoice has been approved to be paid. MA180 MA43.9
This cost is represented in the MA530 MA531
unit-of-measure found in ENTERED-UOM and MA60.2 MA60.3
is in GL company base currency. MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 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
POCP.1 POI3.1
POID.1 POIE.1
POII.1 POIJ.1
RQ10.1 RQ10.2
WH20.2 WH20.7
PLS-RQSRC-MACHINE Alpha 6
Rqsrc Machine
PLS-PAR-ORDER-ID Alpha 20
Par Order Id
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 AP125 AP126
PO-CODE AP131 AP25.1
PO-NUMBER AP25.2 AP26.1
PO-RELEASE AP27.1 IC28.1
LINE-NBR MA180 MA43.9
ORIGIN-CD MA530 MA531
OPER-COMPANY MA60.2 MA60.3
SOURCE-DOC-N MA60.5 MA61.1
SOURCE-DOC-A MA66.3 MA67.1
SRC-LINE-NBR MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 IC142
PO-CODE IC28.1 MA180
PO-NUMBER MA43.9 MA530
PO-RELEASE MA531 MA60.2
LINE-NBR MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
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 IC28.1
PO-RELEASE MA180 MA43.9
LINE-NBR MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 IC28.1
LINE-NBR Or ORIGIN-CD = "PO" MA180 MA43.9
ALLOC-PRI* Or ORIGIN-CD = "IC" ) MA530 MA531
REQ-DEL-DATE MA60.2 MA60.3
ORIGIN-CD MA60.5 MA61.1
OPER-COMPANY MA66.3 MA67.1
SOURCE-DOC-A MA67.2 MA70.1
SOURCE-DOC-N MAI1.1 PO100
REQ-LOCATION PO101 PO122
SRC-LINE-NBR PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 IC28.1
LINE-NBR MA180 MA43.9
ORIGIN-CD MA530 MA531
SOURCE-DOC-N MA60.2 MA60.3
SRC-LINE-NBR MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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 IC28.1
LINE-NBR MA180 MA43.9
ORIGIN-CD MA530 MA531
OPER-COMPANY MA60.2 MA60.3
SOURCE-DOC-A MA60.5 MA61.1
SOURCE-DOC-N MA66.3 MA67.1
SRC-LINE-NBR MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
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
|