POLINEOUT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PLT
Primary key
COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION, CREATION-DATE, CREATION-TIME, LINE-NBR
Fields
81
Updated by
222 programs
Referenced by
0 programs

POLINEOUT is a Lawson Purchase Order table (prefix PLT); no description in the lawson data dictionary. It is indexed by COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION, CREATION-DATE, CREATION-TIME, LINE-NBR (PLTSET1); alternate indexes: PLTSET3. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 214 more. The table has 81 fields, 2 indexes and 0 documented relations.

About POLINEOUT

No description in the Lawson data dictionary.

Fields (81)

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

Field / columnTypeDescription & valuesUpdated by
PLT-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)
PLT-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)
PLT-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)
PLT-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)
PLT-PO-REVISION PK
PO_REVISION
Numeric 3The PO Revision number. Assigned sequentially by the system when the PO is revised.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-CREATION-DATE PK
CREATION_DATE
Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-CREATION-TIME PK
CREATION_TIME
Numeric 6 (hhmmss)The creation time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-RECORD-TYPE
RECORD_TYPE
Alpha 1This field identifies the type of record defined. Valid values are:
  • S Summary
  • D Detail
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-RECORD-STAT
RECORD_STAT
Numeric 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-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)
PLT-ITEM
ITEM
Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-ITEM-TYPE
ITEM_TYPE
Alpha 1This field identifies the line item type.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-SERVICE-CODE
SERVICE_CODE
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-PROCURE-GROUP
PROCURE_GROUP
Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-QUANTITY
QUANTITY
Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-VPRI-QUANTITY
VPRI_QUANTITY
Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-AGREEMENT-REF
AGREEMENT_REF
Alpha 30AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-AGRMT-REF-AMT
AGRMT_REF_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-SUBST-QTY
SUBST_QTY
Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-REJECT-QTY
REJECT_QTY
Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-ENT-UNIT-CST
ENT_UNIT_CST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-VBUY-UNIT-CST
VBUY_UNIT_CST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-TAXBL-UNT-CST
TAXBL_UNT_CST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-COST-CD
COST_CD
Alpha 1Unit cost origin codeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-ENT-BUY-UOM
ENT_BUY_UOM
Alpha 4This field contains the valid stock unit of measure for this item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-EBUY-UOM-MULT
EBUY_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)
PLT-VPRI-UOM
VPRI_UOM
Alpha 4This field contains the valid stock unit of measure for this item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-VPRI-UOM-MULT
VPRI_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)
PLT-LAND-UNIT-CST
LAND_UNIT_CST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-EARLY-DL-DATE
EARLY_DL_DATE
Numeric 8 (yyyymmdd)This field contains the early delivery date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-LATE-DL-DATE
LATE_DL_DATE
Numeric 8 (yyyymmdd)This field contains the late delivery date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-REC-ACT-DATE
REC_ACT_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)
PLT-CLOSE-DATE
CLOSE_DATE
Numeric 8 (yyyymmdd)Add on cost close date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-LOCATION
LOCATION
Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-BUYER-CODE
BUYER_CODE
Alpha 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-PURCH-FR-LOC
PURCH_FR_LOC
Alpha 4The vendor's purchase from location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-VEN-ITEM
VEN_ITEM
Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-DIST-CODE
DIST_CODE
Alpha 9A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-TAX-CODE
TAX_CODE
Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-WEIGHT
WEIGHT
Signed 9.3This field contains the unit weight of the item based on the stocking UOM.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-CUBIC-FEET
CUBIC_FEET
Signed 9.3This field contains the unit cubic feet of the item based on the stocking UOM.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-REC-PRT-FL
REC_PRT_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-COST-OPTION
COST_OPTION
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-CERT-REQ-FL
CERT_REQ_FL
Alpha 1This flag indicates whether a certification is required for this line when it is purchased. This field value is passed to the PO when the PO line is created. Valid values are: "N" = Certification not required. "Y" = Certification required.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-INSP-REQ-FL
INSP_REQ_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-REC-INSP-FL
REC_INSP_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-MSDS-FLAG
MSDS_FLAG
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-NO-LT-CALC-FL
NO_LT_CALC_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-TAXABLE-FLAG
TAXABLE_FLAG
Alpha 1Defines if Taxable.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-OSHIP-TOL-PCT
OSHIP_TOL_PCT
Percent 5.3 (Percent)Quantity overshipment tolerance percentage.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-USHIP-TOL-PCT
USHIP_TOL_PCT
Percent 6.3 (Percent)This is the quantity undership percentage for automatic back order cancellation. If a value of 10% is entered here, for instance, and a quantity of 91 is shipped against an ordered quantity of 100, that would be considered a 9% undershipment. Since this is less than the 10% limit, the backordered amount would be cancelled. This process takes place at receiving time. If a backorder is not cancelled manually, the system checks, in order, the PO line, the PO vendor purchase from record, the PO vendor record, and the company record. If an undershipment percentage of a zero percent flag set to Y is encountered at any level, that value is used. NOTE-The percentage can be set at 100%, which would cancel all backorders.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-USER-DATE-3
USER_DATE_3
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)
PLT-USER-DATE-4
USER_DATE_4
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)
PLT-PURCH-MAJCL
PURCH_MAJCL
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-PURCH-MINCL
PURCH_MINCL
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-MANUF-CODE
MANUF_CODE
Alpha 4This field contains a user defined code that indicates the manufacturer of an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-MANUF-DIVISION
MANUF_DIVISION
Alpha 4This is a user defined code that indicates which division of a manufacturer is tied to an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-MANUF-NBR
MANUF_NBR
Alpha 35This is the identifier that the manufacturer has assigned to an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-LAST-DST-SEQ
LAST_DST_SEQ
Numeric 3This field contains the record sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-RELEASED-FL
RELEASED_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-ISSUED-FLAG
ISSUED_FLAG
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-REVISED-FL
REVISED_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-CLOSED-FL
CLOSED_FL
Alpha 1The Closed Flag.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-ZERO-OSHIP-FL
ZERO_OSHIP_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-ZERO-USHIP-FL
ZERO_USHIP_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-EXCL-AOC-SPRD
EXCL_AOC_SPRD
Alpha 1Exclude this line item from the Add On Cost Spread Methods.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-PO-USER-FLD-2
PO_USER_FLD_2
Alpha 2Purchase order line user defined field.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-PO-USER-FLD-4
PO_USER_FLD_4
Alpha 30 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-PO-USER-FLD-6
PO_USER_FLD_6
Alpha 15 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-MATCH-CLASS
MATCH_CLASS
Alpha 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-MATCH-DTL-KEY
MATCH_DTL_KEY
Alpha 85AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-ARCHIVE-QTY
ARCHIVE_QTY
Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-MATCHED-NO-REC
MATCHED_NO_REC
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-CHARGEBACK-QTY
CHARGEBACK_QTY
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-WRITE-OFF-QTY
WRITE_OFF_QTY
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-RET-LINE-NBR
RET_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)
PLT-TAX-USAGE-CD
TAX_USAGE_CD
Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-EXTENDED-AMT
EXTENDED_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PLT-CXL-QTY
CXL_QTY
Signed 13.4This is the total quantity to date received for this ordered item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

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

IndexKeysFlagsConditionUsed in
PLTSET1COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION, CREATION-DATE, CREATION-TIME, LINE-NBRPrimaryPO522
PLTSET3COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE, PO-REVISION, LINE-NBRAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (222)