POLINESRC – PO Line Source

System
Purchase Order (PO)
Prefix
PLS
Primary key
COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBR, ORIGIN-CD, OPER-COMPANY, SOURCE-DOC-N, SOURCE-DOC-A, SRC-LINE-NBR
Fields
25
Updated by
221 programs
Referenced by
36 programs

POLINESRC is the PO Line Source table in Lawson Purchase Order (prefix PLS). It is indexed by COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBR, ORIGIN-CD, OPER-COMPANY, SOURCE-DOC-N, SOURCE-DOC-A, SRC-LINE-NBR (PLSSET1); alternate indexes: PLSSET10, PLSSET2, PLSSET3, PLSSET4, PLSSET5, PLSSET6, PLSSET7, PLSSET8 and 1 more. It is related 1:1 to COLINE, CXPREFITEM, POLINE, PURCHORDER and REQLINE. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 213 more and referenced by CX55.1, IC282, ICI9.1, MA540, MM280, MM80.1, MM80.2, PO135 and 28 more. The table has 25 fields, 10 indexes and 5 documented relations.

About POLINESRC

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

Fields (25)

Column = COBOL field name without the PLS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PLS-COMPANY PK
COMPANY
Numeric 4Identifies 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 +52 more (list truncated in source)
PLS-PO-CODE PK
PO_CODE
Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLS-PO-NUMBER PK
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 +52 more (list truncated in source)
PLS-PO-RELEASE PK
PO_RELEASE
Numeric 4Used 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 +52 more (list truncated in source)
PLS-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLS-ORIGIN-CD PK
ORIGIN_CD
Alpha 2System 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 +52 more (list truncated in source)
PLS-OPER-COMPANY PK
OPER_COMPANY
Numeric 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLS-SOURCE-DOC-A PK
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 +52 more (list truncated in source)
PLS-SOURCE-DOC-N PK
SOURCE_DOC_N
Numeric 8This 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 +52 more (list truncated in source)
PLS-SRC-LINE-NBR PK
SRC_LINE_NBR
Numeric 6This 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 +52 more (list truncated in source)
PLS-REQ-LOCATION
REQ_LOCATION
Alpha 5The 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 +52 more (list truncated in source)
PLS-REQUESTER
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 +52 more (list truncated in source)
PLS-DELIVER-TO
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 +52 more (list truncated in source)
PLS-REQ-DEL-DATE
REQ_DEL_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 +52 more (list truncated in source)
PLS-ALLOC-PRI
ALLOC_PRI
Numeric 2This 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 +52 more (list truncated in source)
PLS-QUANTITY
QUANTITY
Signed 13.4This 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 +52 more (list truncated in source)
PLS-DELIVERED-QTY
DELIVERED_QTY
Signed 13.4This 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 +52 more (list truncated in source)
PLS-PROCESSED-QTY
PROCESSED_QTY
Signed 13.4This 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 +52 more (list truncated in source)
PLS-ENTERED-UOM
ENTERED_UOM
Alpha 4This 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 +52 more (list truncated in source)
PLS-ENT-UOM-MULT
ENT_UOM_MULT
Signed 13.7This 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 +52 more (list truncated in source)
PLS-BL-INVC-QTY
BL_INVC_QTY
Signed 13.4Billed 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
BILL_UNIT_CST
Signed 18.5This 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 +52 more (list truncated in source)
PLS-OE-RQ-ALPHA
OE_RQ_ALPHA
Derived
PLS-SOURCE-DOC
SOURCE_DOC
DerivedThe source from which this record was created.
PLS-GLBL-LINE-TYPE
GLBL_LINE_TYPE
Alpha 15

Indexes (10)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PLSSET1COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBR, ORIGIN-CD, OPER-COMPANY, SOURCE-DOC-N, SOURCE-DOC-A, SRC-LINE-NBRPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLSSET10COMPANY, REQ-LOCATION, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBR, ORIGIN-CD, OPER-COMPANY, SOURCE-DOC-A, SOURCE-DOC-N, SRC-LINE-NBRKeyChangePO22.2, PO22.3, PO22.4, PO22.5, PO223, PO254, PO258, PO54.1 +5 more
PLSSET2OPER-COMPANY, ORIGIN-CD, SOURCE-DOC-N, SRC-LINE-NBR, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBRSubsetWhere SOURCE-DOC-N != ZeroesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLSSET3OPER-COMPANY, SOURCE-DOC-N, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBRSubsetWhere ORIGIN-CD = "CX"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLSSET4COMPANY, 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-NBRKeyChange, SubsetWhere QUANTITY > DELIVERED-QTY And PROCESSED-QTY = Zeroes And (ORIGIN-CD = "RQ" Or ORIGIN-CD = "PO" Or ORIGIN-CD = "IC")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLSSET5COMPANY, OPER-COMPANY, SOURCE-DOC-N, SOURCE-DOC-A, SRC-LINE-NBR, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBRSubsetWhere QUANTITY > DELIVERED-QTY And PROCESSED-QTY = Zeroes And (ORIGIN-CD = "RQ" Or ORIGIN-CD = "PO")WH130
PLSSET6COMPANY, SOURCE-DOC-A, SRC-LINE-NBR, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBRSubsetWhere ORIGIN-CD = "PO"
PLSSET7COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBR, ORIGIN-CD, SOURCE-DOC-N, SRC-LINE-NBRSubsetWhere (ORIGIN-CD = "OE") Or (ORIGIN-CD = "RQ")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLSSET8COMPANY, REQUESTER, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBR, OPER-COMPANY, SOURCE-DOC-N, SRC-LINE-NBRKeyChange, SubsetWhere QUANTITY > DELIVERED-QTY And PROCESSED-QTY = Zeroes And (ORIGIN-CD = "RQ" Or ORIGIN-CD = "PO")
PLSSET9COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, LINE-NBR, ORIGIN-CD, OPER-COMPANY, SOURCE-DOC-A, SOURCE-DOC-N, SRC-LINE-NBRKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
ColineCOLINERequiredWhen PLS-ORIGIN-CD = "OE"PLS-COMPANYCOL-COMPANY, PLS-SOURCE-DOC-NCOL-ORDER-NBR, PLS-SRC-LINE-NBRCOL-LINE-NBR
CxprefitemCXPREFITEMRequiredWhen PLS-ORIGIN-CD = "CX"PLS-OPER-COMPANYCPI-COMPANY, PLS-SOURCE-DOC-NCPI-IF-REF-NBR
PolinePOLINERequiredPLS-COMPANYPLI-COMPANY, PLS-PO-NUMBERPLI-PO-NUMBER, PLS-PO-RELEASEPLI-PO-RELEASE, PLS-PO-CODEPLI-PO-CODE, PLS-LINE-NBRPLI-LINE-NBR
PurchorderPURCHORDERRequiredPLS-COMPANYPCR-COMPANY, PLS-PO-CODEPCR-PO-CODE, PLS-PO-NUMBERPCR-PO-NUMBER, PLS-PO-RELEASEPCR-PO-RELEASE
ReqlineREQLINERequiredWhen PLS-ORIGIN-CD = "RQ"PLS-OPER-COMPANYRLN-COMPANY, PLS-SOURCE-DOC-NRLN-REQ-NUMBER, PLS-SRC-LINE-NBRRLN-LINE-NBR

Programs

Updated by (221)

Referenced by (36)