POVAGRMTLN – Vendor Agreement Line

System
Purchase Order (PO)
Prefix
PVN
Primary key
PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR
Fields
147
Updated by
247 programs
Referenced by
21 programs

POVAGRMTLN is the Vendor Agreement Line table in Lawson Purchase Order (prefix PVN). It is indexed by PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR (PVNSET1); alternate indexes: PVNSET10, PVNSET11, PVNSET12, PVNSET13, PVNSET14, PVNSET2, PVNSET3, PVNSET4 and 5 more. It is related 1:1 to ITEMNDC, MAREASONCD, POCONTGRP, POVAGRMTHD and PROCUREGRP and 1:M to APDISTPAY, MAINVDTL, POAGMAUDIT, POAGMTPART, POAOCDTL, POVACOMMIT, POVADIST, POVAGLNERR and 1 more. It is updated by AP05.3, AP125, AP126, AP131, AP133, AP20.1, AP20.2, AP20.3 and 239 more and referenced by AP33.1, IC11.1, ICI9.1, ICIA.1, MA540, MAED.1, PO18.1, PO227 and 13 more. The table has 147 fields, 14 indexes and 14 documented relations.

About POVAGRMTLN

No description in the Lawson data dictionary.

Fields (147)

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

Field / columnTypeDescription & valuesUpdated by
PVN-PROCURE-GROUP PK
PROCURE_GROUP
Alpha 4Type or select a procurement group. A procurement group is 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)
PVN-VEN-AGRMT-REF PK
VEN_AGRMT_REF
Alpha 30AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LINE-NBR PK
LINE_NBR
Numeric 6This is the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AGMT-TYPE
AGMT_TYPE
Alpha 1
  • C Contract
  • B Blanket
  • S Standing
  • T Catalog/Quote
  • V Service
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-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)
PVN-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)
PVN-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)
PVN-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)
PVN-NDC-NBR
NDC_NBR
Alpha 15National Drug Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-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)
PVN-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)
PVN-DESCRIPTION2
DESCRIPTION2
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)
PVN-BASE-COST
BASE_COST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-COST-OPTION
COST_OPTION
Alpha 1
  • 1 Cost Required
  • 2 No Charge
  • 3 Vendor Determined
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-BASE-PERCENT
BASE_PERCENT
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CURRENT-PCT
CURRENT_PCT
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-BEG-NET-CST
BEG_NET_CST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CURR-NET-CST
CURR_NET_CST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-DEFBUY-UCOST
DEFBUY_UCOST
Numeric 18AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-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)
PVN-UOM
UOM
Alpha 4This is 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)
PVN-UOM-MULT
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)
PVN-MATCH-UOM-FL
MATCH_UOM_FL
Alpha 1
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-SERVICE-CODE
SERVICE_CODE
Alpha 1
  • Q Quantity
  • A Amount
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-MARKUP-DISC
MARKUP_DISC
Alpha 1
  • M Markup
  • D Discount
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-STOCKLESS-FL
STOCKLESS_FL
Alpha 1
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-PRIORITY
PRIORITY
Numeric 1Indicates order of precedence for contracts to determine costing defaults for items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-HOLD-FLAG
HOLD_FLAG
Alpha 1This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ACCOUNT
ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-SUB-ACCT
SUB_ACCT
Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ACTIVITY
ACTIVITY
Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-BILL-CATEGORY
BILL_CATEGORY
Alpha 32AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AGRMT-MAX-QTY
AGRMT_MAX_QTY
Numeric 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AGRMT-MAX-AMT
AGRMT_MAX_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ORDER-MIN-QTY
ORDER_MIN_QTY
Numeric 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ORDER-MIN-AMT
ORDER_MIN_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ORDER-MAX-QTY
ORDER_MAX_QTY
Numeric 10AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ORDER-MAX-AMT
ORDER_MAX_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-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)
PVN-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)
PVN-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)
PVN-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)
PVN-TAXABLE-FLAG
TAXABLE_FLAG
Alpha 1Select whether or not the line is Taxable.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-TAX-USAGE-CD
TAX_USAGE_CD
Alpha 10The tax usage code for the vendor. This field is required if the AP Company indicates that VAT reporting required.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-QAFLAG
LNBRK_QAFLAG
Alpha 1
  • Q Quantity
  • A Amount
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-QTYAMT1
LNBRK_QTYAMT1
Numeric 13AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-QTYAMT2
LNBRK_QTYAMT2
Numeric 13AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-QTYAMT3
LNBRK_QTYAMT3
Numeric 13AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-QTYAMT4
LNBRK_QTYAMT4
Numeric 13AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-QTYAMT5
LNBRK_QTYAMT5
Numeric 13AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-PERCENT1
LNBRK_PERCENT1
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-PERCENT2
LNBRK_PERCENT2
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-PERCENT3
LNBRK_PERCENT3
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-PERCENT4
LNBRK_PERCENT4
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-PERCENT5
LNBRK_PERCENT5
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-COST1
LNBRK_COST1
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-COST2
LNBRK_COST2
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-COST3
LNBRK_COST3
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-COST4
LNBRK_COST4
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LNBRK-COST5
LNBRK_COST5
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AMT-ORDERED
AMT_ORDERED
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-QTY-ORDERED
QTY_ORDERED
Signed 14.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LAW-ITEM-FLAG
LAW_ITEM_FLAG
Alpha 1The Lawson item flag is used to identify vendor items that should be available for purchase in the Lawson system. Entering Y in this field means the vendor item should be available for purchase and must be linked to a valid Lawson item number. Vendor Price Agreement Load (PO536) can be run to link the vendor item to an existing Lawson item number, or it can be run to link the vendor item to a new Lawson item number. How the new Lawson item is created is controlled by the item create flag on the agreement header. Only records with a value of Y in this field can be updated in PO25.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-INPUT-ITEM
INPUT_ITEM
Alpha 32The Lawson item number input manually by the user or included on the vendor catalog file. This item number may or may not be on the item master.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-GENERIC
GENERIC
Alpha 10A user-defined general name for an item, used for searching for an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-MANUF-AGR-REF
MANUF_AGR_REF
Alpha 30The agreement reference with the manufacturer.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LIC-CODE
LIC_CODE
Alpha 4The Labeler Identification Code (LIC) is assigned to any organization in the healthcare industry. The LIC is used with bar code technology to identify the company that put the label on the product.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-UPC
UPC
Alpha 15Universal Product Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-SKU
SKU
Alpha 15The Stock Keeping Unit identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-UPN-NBR
UPN_NBR
Alpha 20The HIBCC compliant Universal Product Number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-UPN2-NBR
UPN2_NBR
Alpha 25 (Right Justified)The UCC/EAN compliant Universal Product Number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ICSEGMENT
ICSEGMENT
Alpha 2Segment is the first level of the UNSPSC code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ICFAMILY
ICFAMILY
Alpha 2Family is the second level of the UNSPSC code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ICCLASS
ICCLASS
Alpha 2Class is the third level of the UNSPSC code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ICCOMMODITY
ICCOMMODITY
Alpha 2Commodity is the forth level of the UNSPSC code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-PURCH-MAJCL
PURCH_MAJCL
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-PURCH-MINCL
PURCH_MINCL
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-INVEN-MAJCL
INVEN_MAJCL
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-INVEN-MINCL
INVEN_MINCL
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD1
USER_FIELD1
Alpha 30This is the first user definable field. It can be used to capture any data that the user wants. The title of the field is setup in IC00.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD2
USER_FIELD2
Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD3
USER_FIELD3
Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD4
USER_FIELD4
Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD5
USER_FIELD5
Alpha 30This is the second user definable field. This field can be used to enter any data that the user wants to capture for this item. The title of the field is setup in IC00.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD-N1
USER_FIELD_N1
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD-N2
USER_FIELD_N2
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-USER-FIELD-N3
USER_FIELD_N3
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-EFFECTIVE-DT
EFFECTIVE_DT
Numeric 8 (yyyymmdd)The effective date is the date the record is first valid.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-EXPIRE-DT
EXPIRE_DT
Numeric 8 (yyyymmdd)The expire date is the last date the record is valid.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-PREV-COST
PREV_COST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-FUTURE-CST-DT
FUTURE_CST_DT
Numeric 8 (yyyymmdd)The future cost date is the date the future cost becomes effective.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-FUTURE-COST
FUTURE_COST
Signed 18.5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-COST-UPD-DT
COST_UPD_DT
Numeric 8 (yyyymmdd)The cost update date is the date the base cost field was updated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-REC-UPD-DT
REC_UPD_DT
Numeric 8 (yyyymmdd)The record update date is the date the record was last updated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-ERROR-FLAG
ERROR_FLAG
Alpha 1The error flag is set to Y to indicate the record has an error. All error messages for database POVAGRMTLN will be written to a separate error database called POVAGLNERR.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-MANUAL-FLAG
MANUAL_FLAG
Numeric 1The manual flag identifies records that require manual input. A value of 1 means Yes the record requires manual input, 0 means No it does not. An agreement record can be set to require manual input if a new vendor item is loaded and the agreement header has an item create flag of manual, or if there is an error encountered when assigning a Lawson item to the record. PO36.2 can be used to display and update records with the manual flag set to 1.
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-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)
PVN-REBATE
REBATE
Alpha 1
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-REBATE-PERCENT
REBATE_PERCENT
Signed 7.3The percentage determines how much retention is held. It can either be a percentage of each invoice, or it can be a percentage of a total.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-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)
PVN-SS-EVENT-NBR
SS_EVENT_NBR
Numeric 8AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-COMMODITY-CODE
COMMODITY_CODE
Alpha 35AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-SS-COMPANY
SS_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)
PVN-CONTRACT-GROUP
CONTRACT_GROUP
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CM-CONTRACT
CM_CONTRACT
Numeric 15AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-MRKP-DISC
CSN_MRKP_DISC
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-BRK-QAFLAG
CSN_BRK_QAFLAG
Alpha 1
  • Q Quantity
  • A Amount
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-BRK-QTYAMT
CSN_BRK_QTYAMT
Numeric 13 Occurs 5 Times ×5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-LNBRK-PCT
CSN_LNBRK_PCT
Percent 6.3 (Percent) Occurs 5 Times ×5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-BRK-COST
CSN_BRK_COST
Signed 18.5 Occurs 5 Times ×5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-QTY-ORDERD
CSN_QTY_ORDERD
Signed 14.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-AMT-ORDERD
CSN_AMT_ORDERD
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LN-BRK-LEV-FL
LN_BRK_LEV_FL
Alpha 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-STATUS
STATUS
Numeric 1
  • 0 Unreleased
  • 1 Released
  • 2 Revisions in Progress
  • 3 Closed
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-LAST-DIST-SEQ
LAST_DIST_SEQ
Numeric 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-MANUF-CODE
MANUF_CODE
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-MANUF-DIVISION
MANUF_DIVISION
Alpha 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RETAINAGE
RETAINAGE
Numeric 1
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RET-PCT-1
RET_PCT_1
Percent 5.2 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RET-PCT-2
RET_PCT_2
Percent 5.2 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RET-UP-TO-PCT
RET_UP_TO_PCT
Percent 5.2 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RET-PCT-COMP
RET_PCT_COMP
Percent 5.2 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RET-OVRD-PCT
RET_OVRD_PCT
Percent 5.2 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RET-INV-AMT
RET_INV_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-RET-INV-QTY
RET_INV_QTY
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CHARGEBACK-AMT
CHARGEBACK_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-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)
PVN-PVN-OBJ-ID
PVN_OBJ_ID
Numeric 12AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AMT-REQUESTED
AMT_REQUESTED
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CLOSE-COMMIT-F
CLOSE_COMMIT_F
Numeric 1
  • 0 Commitment not cleared
  • 1 Commitment has been cleared
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-CSN-CUR-NETCST
CSN_CUR_NETCST
Signed 18.5
PVN-REL-VEN-ITEM
REL_VEN_ITEM
Alpha 32AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-VEN-ITEM-DESC
VEN_ITEM_DESC
Alpha 30 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AC-COMMIT-FLAG
AC_COMMIT_FLAG
Numeric 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-GL-COMMIT-FLAG
GL_COMMIT_FLAG
Numeric 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-DIST-CODE-CO
DIST_CODE_CO
Numeric 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-MEMO-QTY
MEMO_QTY
Signed 13.4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-MEMO-AMT
MEMO_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-PROD-TAX-CAT
PROD_TAX_CAT
Alpha 15AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-REQ-COMPANY
REQ_COMPANY
Numeric 4A company to validate the requesting location on the agreement line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-GTIN
GTIN
Numeric 14AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-SPEC-ITEM-FLAG
SPEC_ITEM_FLAG
Numeric 1
  • 0 Item with Master File Record
  • 1 Special-type Item
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-REASON-CODE
REASON_CODE
Alpha 4This field contains the reason code, which indicates the cause for putting the agreement line on hold.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AGRMT-MAX-AOC
AGRMT_MAX_AOC
Signed 18.2Maximum Lifetime Add-On Charge amount for this agreement lineAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-AGRMT-MAX-TAX
AGRMT_MAX_TAX
Signed 18.2Maximum Lifetime Tax amount for this agreement lineAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVN-DESCRIPTION3
DESCRIPTION3
Alpha 350 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (14)

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

IndexKeysFlagsConditionUsed in
PVNSET1PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBRPrimaryAP05.3, AP125, AP126, AP131, AP133, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)
PVNSET10PROCURE-GROUP, VEN-ITEM, VENDOR, UOM, VEN-AGRMT-REF, LINE-NBRKeyChange, SubsetWhere VEN-ITEM != SpacesPO13.1, PO13.3, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO28.2 +2 more
PVNSET11PROCURE-GROUP, ITEM, CONTRACT-GROUP, CM-CONTRACT, VEN-ITEM, VEN-AGRMT-REF, LINE-NBRKeyChangeAP133, AP233, AP97.1, POIH.1, RQIC.1, RQIG.1
PVNSET12PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBRSubsetWhere (LAW-ITEM-FLAG = "Y")AP125, AP126, AP131, AP25.1, AP25.2, AP26.1, AP27.1, AP30.4 +22 more (list truncated in source)
PVNSET13PROCURE-GROUP, VEN-AGRMT-REF, VEN-ITEM, LINE-NBRKeyChange, SubsetWhere ITEM = SpacesPO36.1, PO536
PVNSET14PROCURE-GROUP, VEN-AGRMT-REF, VEN-ITEM, LINE-NBRKeyChange, SubsetWhere MANUAL-FLAG = 1PO36.2, PO536
PVNSET2PVN-OBJ-IDKeyChange, SubsetWhere PVN-OBJ-ID != ZeroesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVNSET3PROCURE-GROUP, AGMT-TYPE, ITEM, PRIORITY, DEFBUY-UCOST, VEN-AGRMT-REF, LINE-NBRKeyChange, SubsetWhere HOLD-FLAG = "N" And ((AGMT-TYPE = "C") Or (AGMT-TYPE = "B") Or (AGMT-TYPE = "T")) And STOCKLESS-FL = "N"AP125, AP126, AP131, AP25.1, AP25.2, AP26.1, AP27.1, AP30.4 +22 more (list truncated in source)
PVNSET4PROCURE-GROUP, VEN-AGRMT-REF, ITEM, DEFBUY-UCOST, LINE-NBRKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVNSET5PROCURE-GROUP, ITEM, VEN-AGRMT-REF, LINE-NBRKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVNSET6PROCURE-GROUP, ITEM, PRIORITY, DEFBUY-UCOST, VEN-AGRMT-REF, LINE-NBRKeyChange, SubsetWhere STOCKLESS-FL = "Y" And AGMT-TYPE = "C" And HOLD-FLAG = "N"AP125, AP126, AP131, AP25.1, AP25.2, AP26.1, AP27.1, AP30.4 +22 more (list truncated in source)
PVNSET7PROCURE-GROUP, VEN-AGRMT-REF, ITEM, VEN-ITEM, DEFBUY-UCOST, LINE-NBRKeyChange, SubsetWhere (LAW-ITEM-FLAG = "Y")AP125, AP126, AP131, AP25.1, AP25.2, AP26.1, AP27.1, AP30.4 +22 more (list truncated in source)
PVNSET8PROCURE-GROUP, VEN-ITEM, VEN-AGRMT-REF, LINE-NBRKeyChange, SubsetWhere VEN-ITEM != SpacesDR100, IC141, IC142, IC83.1, PO13.1, PO13.3, PO150, PO20.1 +22 more (list truncated in source)
PVNSET9PROCURE-GROUP, VEN-AGRMT-REF, ITEM, VEN-ITEM, UOM, 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
ItemndcITEMNDCNot RequiredPCG-ITEM-GROUPIDC-ITEM-GROUP, PVN-ITEMIDC-ITEM, PVN-NDC-NBRIDC-NDC-NBR
MareasoncdMAREASONCDRequiredPVN-REASON-CODEMAR-REASON-CODE
PocontgrpPOCONTGRPRequiredPVN-CONTRACT-GROUPCNG-CONTRACT-GROUP
PovagrmthdPOVAGRMTHDRequiredPVN-PROCURE-GROUPPVH-PROCURE-GROUP, PVN-VEN-AGRMT-REFPVH-VEN-AGRMT-REF
ProcuregrpPROCUREGRPRequiredPVN-PROCURE-GROUPPCG-PROCURE-GROUP

One to many (9) — child tables

RelationTableRulesConditionField map
ApdistpayAPDISTPAYPVN-VENDORDTY-VENDOR, PVN-VEN-AGRMT-REFDTY-VEN-AGRMT-REF, PVN-PVN-OBJ-IDDTY-PVN-OBJ-ID, DTY-COMPANY, DTY-PO-NUMBER, DTY-PO-RELEASE, DTY-PO-CODE, DTY-INVOICE, DTY-SUFFIX, DTY-PMT-SEQ-NBR, DTY-LINE-NBR, DTY-MAD-SEQ-NBR, DTY-DIST-SEQ-NBR
MainvdtlMAINVDTLPVN-PVN-OBJ-IDMAD-PVN-OBJ-ID, MAD-MATCH-OBJ-ID, MAD-COMPANY, MAD-VENDOR, MAD-INVOICE, MAD-SUFFIX, MAD-SEQ-NBR
PoagmauditPOAGMAUDITPVN-PROCURE-GROUPPVB-PROCURE-GROUP, PVN-VEN-AGRMT-REFPVB-VEN-AGRMT-REF, PVN-LINE-NBRPVB-LINE-NBR, PVB-AOC-CODE, PVB-SYSTEM, PVB-LINE-SEQ, PVB-COMMIT-DATE, PVB-UPDATE-DATE, PVB-UPDATE-TIME, PVB-FLD-NBR, PVB-AUDIT-TYPE
PoagmtpartPOAGMTPARTDelete CascadesPVN-PROCURE-GROUPPRK-PROCURE-GROUP, PVN-VEN-AGRMT-REFPRK-VEN-AGRMT-REF, PRK-COMPANY, PRK-LOCATION, PRK-REQ-LOCATION
PoaocdtlPOAOCDTLDelete CascadesPVN-PROCURE-GROUPPAO-PROCURE-GROUP, PVN-VEN-AGRMT-REFPAO-VEN-AGRMT-REF, PVN-LINE-NBRPAO-LINE-NBR, PAO-AOC-CODE
PopovacommitPOVACOMMITPVN-PROCURE-GROUPPVC-PROCURE-GROUP, PVN-VEN-AGRMT-REFPVC-VEN-AGRMT-REF, PVN-LINE-NBRPVC-LINE-NBR, "PO"PVC-SYSTEM, PVC-LINE-SEQ, PVC-COMMIT-DATE
PovadistPOVADISTDelete CascadesPVN-PROCURE-GROUPPVD-PROCURE-GROUP, PVN-VEN-AGRMT-REFPVD-VEN-AGRMT-REF, PVN-LINE-NBRPVD-LINE-NBR, PVD-LINE-SEQ
PovaglnerrPOVAGLNERRDelete CascadesPVN-PROCURE-GROUPPVE-PROCURE-GROUP, PVN-VEN-AGRMT-REFPVE-VEN-AGRMT-REF, PVN-LINE-NBRPVE-LINE-NBR, PVE-ERROR-SEQ
PovapartlnPOVAPARTLNDelete CascadesPVN-PROCURE-GROUPTPL-PROCURE-GROUP, PVN-VEN-AGRMT-REFTPL-VEN-AGRMT-REF, PVN-PVN-OBJ-IDTPL-PVN-OBJ-ID, TPL-PART-SEQ-NBR

Programs

Updated by (247)

Referenced by (21)