POVAGRMTHD – Vendor Agreement

System
Purchase Order (PO)
Prefix
PVH
Primary key
PROCURE-GROUP, VEN-AGRMT-REF
Fields
105
Updated by
230 programs
Referenced by
90 programs

POVAGRMTHD is the Vendor Agreement table in Lawson Purchase Order (prefix PVH). It is indexed by PROCURE-GROUP, VEN-AGRMT-REF (PVHSET1); alternate indexes: PVHSET10, PVHSET2, PVHSET3, PVHSET4, PVHSET5, PVHSET6, PVHSET7, PVHSET8 and 1 more. It is related 1:1 to MAREASONCD, POCONTACTS, POVAGRMTHD and PVHBOD and 1:M to POVACOMMIT, APDISTPAY, POAGMAUDIT, POAGMTPART, POAGMTPRIC, POLINE and POVAGRMTLN. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 222 more and referenced by AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 and 82 more. The table has 105 fields, 10 indexes and 12 documented relations.

About POVAGRMTHD

No description in the Lawson data dictionary.

Fields (105)

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

Field / columnTypeDescription & valuesUpdated by
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-REVIEW-DATE
REVIEW_DATE
Numeric 8 (yyyymmdd)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-BUYER
BUYER
Alpha 3AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-AGRMT-ADMIN
AGRMT_ADMIN
Alpha 10 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-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)
PVH-FREIGHT-TERMS
FREIGHT_TERMS
Alpha 1Freight terms are used to define who pays for freight costs incurred when goods are shipped. Prepaid, for instance, would normally mean that the vendor would pay for freight. Collect would mean the customer would pay for freight. A freight terms code can be entered on a purchase order, or defaulted by vendor or company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-FOB-CODE
FOB_CODE
Alpha 3The user defined Free On Board Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-TERM-CODE
TERM_CODE
Alpha 5A user-defined code representing a method of determining invoice due and discount dates.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-CURRENCY-CODE
CURRENCY_CODE
Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-DFLT-TAXBL-FL
DFLT_TAXBL_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)
PVH-DFLT-ACCOUNT
DFLT_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)
PVH-DFLT-SUB-ACCT
DFLT_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)
PVH-DFLT-ACTIVITY
DFLT_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)
PVH-DFLT-ACCT-CAT
DFLT_ACCT_CAT
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)
PVH-DFLT-BILL-CAT
DFLT_BILL_CAT
Alpha 32AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-GRP-PURCH-ORG
GRP_PURCH_ORG
Alpha 9 (Right Justified)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-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)
PVH-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)
PVH-PO-NUMBER
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)
PVH-PO-CODE
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)
PVH-LAST-PO-REL
LAST_PO_REL
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)
PVH-PO-USER-FLD-1
PO_USER_FLD_1
Alpha 1Purchase Order header user field one.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-PO-USER-FLD-3
PO_USER_FLD_3
Alpha 10This 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)
PVH-PO-USER-FLD-5
PO_USER_FLD_5
Alpha 30 (Lower Case)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-NOTIFY-FLAG
NOTIFY_FLAG
Alpha 1" "
  • Y Admin Notified
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-AGRMT-MAX-PCT
AGRMT_MAX_PCT
Numeric 3If a value is entered here, a value must have been entered in the agreement maximum amount field. A valid login must also have been entered for the agreement administrator. Then, when the amount ordered on the agreement divided by the agreement max amount equals or exceeds the percent entered in this field, a message will be sent to the agreement administrator.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-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)
PVH-PCT-ORDERED
PCT_ORDERED
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-PCT-REMAINING
PCT_REMAINING
Percent 6.3 (Percent)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-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)
PVH-AMT-REMAINING
AMT_REMAINING
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-LAST-LINE-NBR
LAST_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)
PVH-LN-BRK-LEV-FL
LN_BRK_LEV_FL
Alpha 1" "
  • A Agreement
  • O Order
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-SCH-FREQUENCY
SCH_FREQUENCY
Alpha 1
  • W Weekly
  • B Bi Weekly
  • M Monthly
  • Q Quarterly
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-SCH-NO-OF-REL
SCH_NO_OF_REL
Numeric 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-ISSUE-FLAG
ISSUE_FLAG
Alpha 1" "
  • 1 Do Not Issue
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-LAST-REL-DATE
LAST_REL_DATE
Numeric 8 (yyyymmdd)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-OVERID-UOM-FL
OVERID_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)
PVH-ALLW-UNDEF-ITM
ALLW_UNDEF_ITM
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)
PVH-DS-AGRMT-REF
DS_AGRMT_REF
Alpha 30Dual Source Agreement Reference.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-ITEM-CREATE-FL
ITEM_CREATE_FL
Alpha 1Item create flag is needed for the creation source of new item numbers. When adding a line to the agreement where the item number cannot be found, this flag determines how to create the item number. Valid values are, 1 to create the next sequential item number, 2 to assign the item number from another field, and 3 to manually input the new item number. The field will default to the value of the default item create flag on the Item Group database.
  • 1 Sequential
  • 2 Assign
  • 3 Manual Input
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-ITEM-ASGN-FLD
ITEM_ASGN_FLD
Alpha 1If the item create flag is set to assign, this indicates the field from which the new item number is assigned. " " = None
  • 1 VENDOR-ITEM
  • 2 MFG-ITEM
  • 3 UPC
  • 4 SKU
  • 5 HIBCC-UPN
  • 6 UCCEAN-UPN
  • 7 NDC
  • 8 GTIN
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-AC-COMMIT-FLAG
AC_COMMIT_FLAG
Numeric 1
  • 0 No
  • 1 Header
  • 2 Line
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-GL-COMMIT-FLAG
GL_COMMIT_FLAG
Numeric 1
  • 0 No
  • 1 Header
  • 2 Line
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-RQ-COMMIT-AMT
RQ_COMMIT_AMT
Signed 18.2AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-COM-COMPANY
COM_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)
PVH-COM-ACCT-UNIT
COM_ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-CLOSE-COMMIT-F
CLOSE_COMMIT_F
Numeric 10
  • 1 Commitment has been cleared
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-ATN-OBJ-ID
ATN_OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-GLT-OBJ-ID
GLT_OBJ_ID
Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-LIFETIME-EDIT
LIFETIME_EDIT
Numeric 1
  • 0 Purchase Orders
  • 1 Purchase Orders & Requisitions
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-DOC-ORIGIN-IND
DOC_ORIGIN_IND
Numeric 1
  • 0 Entered
  • 1 Contract Management
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-RET-TRK-PCT-CP
RET_TRK_PCT_CP
Numeric 1
  • 0 No Retainage
  • 1 Vendor Agreement Level
  • 2 Line Level
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-RET-DUE-DAYS
RET_DUE_DAYS
Numeric 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-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)
PVH-SPREAD-EDIT-FL
SPREAD_EDIT_FL
Numeric 1
  • 0 No spreading exists
  • 1 Spreading with period max edit
  • 2 Spreading with annual max edit
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-DFLT-DIST-CO
DFLT_DIST_CO
Numeric 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-DFLT-ACCT-UNIT
DFLT_ACCT_UNIT
Alpha 15AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-COM-ACCOUNT
COM_ACCOUNT
Numeric 6AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-COM-SUB-ACCT
COM_SUB_ACCT
Numeric 4AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-COM-ACTIVITY
COM_ACTIVITY
Alpha 15AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-COM-ACCT-CAT
COM_ACCT_CAT
Alpha 5AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-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)
PVH-REQ-COMPANY
REQ_COMPANY
Numeric 4A company used to validate the requesting location that is on the agreement header.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-CLOSED-DT
CLOSED_DT
Numeric 8 (yyyymmdd)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-LST-INV-ALW-DT
LST_INV_ALW_DT
Numeric 8 (yyyymmdd)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-REASON-CODE
REASON_CODE
Alpha 4This field contains the reason code, which indicates the cause for putting the agreement on hold.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-AOC-CT
INCL_AOC_CT
Numeric 1Include Catalog Add-On Charge in the Lifetime Maximum AOC amount calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-AOC-BL
INCL_AOC_BL
Numeric 1Include Blanket Add-On-Charge amount in the Lifetime Maximum Amount calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-AOC-CN
INCL_AOC_CN
Numeric 1Include Contract Add-On-Charge amount in the Lifetime Maximum AOC calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-AOC-SV
INCL_AOC_SV
Numeric 1Include Service Add-On Charge amount in the Lifetime Maximum AOC calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-AOC-ST
INCL_AOC_ST
Numeric 1Include Standing Order Add-On Charge amount in Lifetime Maximum AOC calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-TAX-CT
INCL_TAX_CT
Numeric 1Include Catalog Tax amount in the Lifetime Maximum Tax calculation
  • 0 No
  • 1 Yes
PVH-INCL-TAX-BL
INCL_TAX_BL
Numeric 1Include Blanket Tax amount in Lifetime Maximum Tax calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-TAX-CN
INCL_TAX_CN
Numeric 1Include Contract Tax amount in Lifetime Maximum Tax calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-TAX-SV
INCL_TAX_SV
Numeric 1Include Service Tax amount in Lifetime Maximum Tax calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-INCL-TAX-ST
INCL_TAX_ST
Numeric 1Include Standing Order Tax amount in Lifetime Maximum Tax calculation
  • 0 No
  • 1 Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-AGRMT-MAX-AOC
AGRMT_MAX_AOC
Signed 18.2Lifetime maximum Add-On Charge amount for the agreement headerAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-AGRMT-MAX-TAX
AGRMT_MAX_TAX
Signed 18.2Lifetime maximum AOC amount for the agreement headerAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PVH-FRST-INVC-DT
FRST_INVC_DT
Numeric 8 (yyyymmdd)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (10)

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

IndexKeysFlagsConditionUsed in
PVHSET1PROCURE-GROUP, VEN-AGRMT-REFPrimaryAP125, AP126, AP131, AP133, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source)
PVHSET10GLT-OBJ-ID, PROCURE-GROUP, VEN-AGRMT-REFKeyChange, SubsetWhere GLT-OBJ-ID != Zeroes
PVHSET2PROCURE-GROUP, PO-NUMBER*KeyChange, SubsetWhere PO-NUMBER != SpacesAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVHSET3PROCURE-GROUP, VENDOR, PURCH-FR-LOC, VEN-AGRMT-REFKeyChangeAC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source)
PVHSET4PROCURE-GROUP, AGRMT-ADMIN, VEN-AGRMT-REFKeyChange
PVHSET5PROCURE-GROUP, AGMT-TYPE, VEN-AGRMT-REFPO229
PVHSET6PROCURE-GROUP, VEN-AGRMT-REFSubsetWhere AGMT-TYPE = "S"PO101
PVHSET7PROCURE-GROUP, VENDOR, PO-NUMBERKeyChange, SubsetWhere AGMT-TYPE = "V"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVHSET8PROCURE-GROUP, VEN-AGRMT-REFSubsetWhere AGMT-TYPE != "V"PO36.1
PVHSET9ATN-OBJ-ID, PROCURE-GROUP, VEN-AGRMT-REFKeyChange, SubsetWhere ATN-OBJ-ID != Zeroes

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
MareasoncdMAREASONCDRequiredPVH-REASON-CODEMAR-REASON-CODE (MARSET1)
PocontactsPOCONTACTSNot RequiredPVH-PROCURE-GROUPPOC-PROCURE-GROUP, PVH-AGRMT-ADMINPOC-AGRMT-ADMIN
PovagrmthdPOVAGRMTHDRequiredPVH-PROCURE-GROUPPVH-PROCURE-GROUP, PVH-VEN-AGRMT-REFPVH-VEN-AGRMT-REF
PvhbodPVHBODNot Required, Delete CascadesPVH-PROCURE-GROUPPBH-PROCURE-GROUP, PVH-VEN-AGRMT-REFPBH-VEN-AGRMT-REF

One to many (8) — child tables

RelationTableRulesConditionField map
AcpovacommitPOVACOMMITDelete CascadesValid When (PVH-AC-COMMIT-FLAG = 1)PVH-PROCURE-GROUPPVC-PROCURE-GROUP, PVH-VEN-AGRMT-REFPVC-VEN-AGRMT-REF, ZeroesPVC-LINE-NBR, "AC"PVC-SYSTEM, ZeroesPVC-LINE-SEQ, PVC-COMMIT-DATE
ApdistpayAPDISTPAYPVH-VENDORDTY-VENDOR, PVH-VEN-AGRMT-REFDTY-VEN-AGRMT-REF, DTY-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
GlpovacommitPOVACOMMITDelete CascadesValid When (PVH-GL-COMMIT-FLAG = 1)PVH-PROCURE-GROUPPVC-PROCURE-GROUP, PVH-VEN-AGRMT-REFPVC-VEN-AGRMT-REF, ZeroesPVC-LINE-NBR, "GL"PVC-SYSTEM, ZeroesPVC-LINE-SEQ, PVC-COMMIT-DATE
PoagmauditPOAGMAUDITPVH-PROCURE-GROUPPVB-PROCURE-GROUP, PVH-VEN-AGRMT-REFPVB-VEN-AGRMT-REF, PVB-EFFECTIVE-DT, PVB-COMPANY, PVB-LOCATION, PVB-REQ-LOCATION, PVB-SYSTEM, PVB-COMMIT-DATE, PVB-UPDATE-DATE, PVB-UPDATE-TIME, PVB-FLD-NBR, PVB-AUDIT-TYPE
PoagmtpartPOAGMTPARTDelete CascadesPVH-PROCURE-GROUPPRK-PROCURE-GROUP, PVH-VEN-AGRMT-REFPRK-VEN-AGRMT-REF, PRK-COMPANY, PRK-LOCATION, PRK-REQ-LOCATION
PoagmtpricPOAGMTPRICDelete CascadesPVH-PROCURE-GROUPPRI-PROCURE-GROUP, PVH-VEN-AGRMT-REFPRI-VEN-AGRMT-REF, PRI-EFFECTIVE-DT
PolinePOLINEPVH-PROCURE-GROUPPLI-PROCURE-GROUP, PVH-VEN-AGRMT-REFPLI-AGREEMENT-REF, PLI-COMPANY, PLI-PO-NUMBER, PLI-PO-RELEASE, PLI-PO-CODE, PLI-LINE-NBR
PovagrmtlnPOVAGRMTLNDelete CascadesPVH-PROCURE-GROUPPVN-PROCURE-GROUP, PVH-VEN-AGRMT-REFPVN-VEN-AGRMT-REF, PVN-LINE-NBR

Programs

Updated by (230)

Referenced by (90)