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 / column | Type | Description & values | Updated by |
|---|---|---|---|
PVH-PROCURE-GROUP PKPROCURE_GROUP | Alpha 4 | Type 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 PKVEN_AGRMT_REF | Alpha 30 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-VENDORVENDOR | 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-LOCPURCH_FR_LOC | Alpha 4 | The 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-DESCRIPTIONDESCRIPTION | 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-DESCRIPTION2DESCRIPTION2 | 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-DTEFFECTIVE_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-DTEXPIRE_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-DATEREVIEW_DATE | Numeric 8 (yyyymmdd) | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-BUYERBUYER | Alpha 3 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AGRMT-ADMINAGRMT_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-FLAGHOLD_FLAG | Alpha 1 | This field enables this entire lot to be put on hold, not allowing any issues or transfers to be made for this lot.
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-PRIORITYPRIORITY | Numeric 1 | Indicates 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-TERMSFREIGHT_TERMS | Alpha 1 | Freight 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-CODEFOB_CODE | Alpha 3 | The 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-CODETERM_CODE | Alpha 5 | A 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-CODECURRENCY_CODE | Alpha 5 | This 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-CODETAX_CODE | Alpha 10 | This 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-FLDFLT_TAXBL_FL | Alpha 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-DFLT-ACCOUNTDFLT_ACCOUNT | Numeric 6 | This 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-ACCTDFLT_SUB_ACCT | Numeric 4 | This 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-ACTIVITYDFLT_ACTIVITY | Alpha 15 | Activities 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-CATDFLT_ACCT_CAT | Alpha 5 | Account 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 thru | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-DFLT-BILL-CATDFLT_BILL_CAT | Alpha 32 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-GRP-PURCH-ORGGRP_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-CODEMANUF_CODE | Alpha 4 | This 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-DIVISIONMANUF_DIVISION | Alpha 4 | This 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-TYPEAGMT_TYPE | Alpha 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-PO-NUMBERPO_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-CODEPO_CODE | Alpha 4 | This 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-RELLAST_PO_REL | Numeric 4 | Used 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-1PO_USER_FLD_1 | Alpha 1 | Purchase 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-3PO_USER_FLD_3 | Alpha 10 | This 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-5PO_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-FLAGNOTIFY_FLAG | Alpha 1 | " "
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AGRMT-MAX-AMTAGRMT_MAX_AMT | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AGRMT-MAX-PCTAGRMT_MAX_PCT | Numeric 3 | If 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-AMTORDER_MIN_AMT | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-ORDER-MAX-AMTORDER_MAX_AMT | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-PCT-ORDEREDPCT_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-REMAININGPCT_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-FLSTOCKLESS_FL | Alpha 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AMT-ORDEREDAMT_ORDERED | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AMT-REMAININGAMT_REMAINING | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-LAST-LINE-NBRLAST_LINE_NBR | Numeric 6 | This 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-FLLN_BRK_LEV_FL | Alpha 1 | " "
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-SCH-FREQUENCYSCH_FREQUENCY | Alpha 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-SCH-NO-OF-RELSCH_NO_OF_REL | Numeric 4 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-ISSUE-FLAGISSUE_FLAG | Alpha 1 | " "
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-LAST-REL-DATELAST_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-FLMATCH_UOM_FL | Alpha 1 | " "
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-OVERID-UOM-FLOVERID_UOM_FL | Alpha 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-ALLW-UNDEF-ITMALLW_UNDEF_ITM | Alpha 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-DS-AGRMT-REFDS_AGRMT_REF | Alpha 30 | Dual 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-FLITEM_CREATE_FL | Alpha 1 | Item 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.
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-ITEM-ASGN-FLDITEM_ASGN_FLD | Alpha 1 | If the item create flag is set to assign, this indicates the field from which the new item number is assigned. " " = None
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AC-COMMIT-FLAGAC_COMMIT_FLAG | Numeric 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-GL-COMMIT-FLAGGL_COMMIT_FLAG | Numeric 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-RQ-COMMIT-AMTRQ_COMMIT_AMT | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-COM-COMPANYCOM_COMPANY | Numeric 4 | Identifies 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-UNITCOM_ACCT_UNIT | Alpha 15 | The 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-FCLOSE_COMMIT_F | Numeric 1 | 0
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-ATN-OBJ-IDATN_OBJ_ID | Numeric 12 | This 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-IDGLT_OBJ_ID | Numeric 12 | This 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-CODEDIST_CODE | Alpha 9 | A 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-REBATEREBATE | Alpha 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-REBATE-PERCENTREBATE_PERCENT | Signed 7.3 | The 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-LOCATIONREQ_LOCATION | Alpha 5 | The 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-STATUSSTATUS | Numeric 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-LIFETIME-EDITLIFETIME_EDIT | Numeric 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-DOC-ORIGIN-INDDOC_ORIGIN_IND | Numeric 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-RET-TRK-PCT-CPRET_TRK_PCT_CP | Numeric 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-RET-DUE-DAYSRET_DUE_DAYS | Numeric 4 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-RET-PCT-1RET_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-2RET_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-PCTRET_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-COMPRET_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-PCTRET_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-AMTRET_INV_AMT | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AMT-REQUESTEDAMT_REQUESTED | Signed 18.2 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-SPREAD-EDIT-FLSPREAD_EDIT_FL | Numeric 1 | —
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-DFLT-DIST-CODFLT_DIST_CO | Numeric 4 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-DFLT-ACCT-UNITDFLT_ACCT_UNIT | Alpha 15 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-COM-ACCOUNTCOM_ACCOUNT | Numeric 6 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-COM-SUB-ACCTCOM_SUB_ACCT | Numeric 4 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-COM-ACTIVITYCOM_ACTIVITY | Alpha 15 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-COM-ACCT-CATCOM_ACCT_CAT | Alpha 5 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-DIST-CODE-CODIST_CODE_CO | Numeric 4 | — | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-REQ-COMPANYREQ_COMPANY | Numeric 4 | A 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-DTCLOSED_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-DTLST_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-CODEREASON_CODE | Alpha 4 | This 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-CTINCL_AOC_CT | Numeric 1 | Include Catalog Add-On Charge in the Lifetime Maximum AOC amount calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-AOC-BLINCL_AOC_BL | Numeric 1 | Include Blanket Add-On-Charge amount in the Lifetime Maximum Amount calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-AOC-CNINCL_AOC_CN | Numeric 1 | Include Contract Add-On-Charge amount in the Lifetime Maximum AOC calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-AOC-SVINCL_AOC_SV | Numeric 1 | Include Service Add-On Charge amount in the Lifetime Maximum AOC calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-AOC-STINCL_AOC_ST | Numeric 1 | Include Standing Order Add-On Charge amount in Lifetime Maximum AOC calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-TAX-CTINCL_TAX_CT | Numeric 1 | Include Catalog Tax amount in the Lifetime Maximum Tax calculation
| — |
PVH-INCL-TAX-BLINCL_TAX_BL | Numeric 1 | Include Blanket Tax amount in Lifetime Maximum Tax calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-TAX-CNINCL_TAX_CN | Numeric 1 | Include Contract Tax amount in Lifetime Maximum Tax calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-TAX-SVINCL_TAX_SV | Numeric 1 | Include Service Tax amount in Lifetime Maximum Tax calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-INCL-TAX-STINCL_TAX_ST | Numeric 1 | Include Standing Order Tax amount in Lifetime Maximum Tax calculation
| AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AGRMT-MAX-AOCAGRMT_MAX_AOC | Signed 18.2 | Lifetime maximum Add-On Charge amount for the agreement header | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-AGRMT-MAX-TAXAGRMT_MAX_TAX | Signed 18.2 | Lifetime maximum AOC amount for the agreement header | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source) |
PVH-FRST-INVC-DTFRST_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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PVHSET1 | PROCURE-GROUP, VEN-AGRMT-REF | Primary | AP125, AP126, AP131, AP133, AP20.1, AP20.2, AP20.3, AP20.4 +22 more (list truncated in source) | |
PVHSET10 | GLT-OBJ-ID, PROCURE-GROUP, VEN-AGRMT-REF | KeyChange, Subset | Where GLT-OBJ-ID != Zeroes | — |
PVHSET2 | PROCURE-GROUP, PO-NUMBER* | KeyChange, Subset | Where PO-NUMBER != Spaces | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) |
PVHSET3 | PROCURE-GROUP, VENDOR, PURCH-FR-LOC, VEN-AGRMT-REF | KeyChange | AC160, AM115, AM117, AM15.1, AM15.2, AM15.3, AM15.4, AM19.1 +22 more (list truncated in source) | |
PVHSET4 | PROCURE-GROUP, AGRMT-ADMIN, VEN-AGRMT-REF | KeyChange | — | |
PVHSET5 | PROCURE-GROUP, AGMT-TYPE, VEN-AGRMT-REF | PO229 | ||
PVHSET6 | PROCURE-GROUP, VEN-AGRMT-REF | Subset | Where AGMT-TYPE = "S" | PO101 |
PVHSET7 | PROCURE-GROUP, VENDOR, PO-NUMBER | KeyChange, Subset | Where AGMT-TYPE = "V" | AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source) |
PVHSET8 | PROCURE-GROUP, VEN-AGRMT-REF | Subset | Where AGMT-TYPE != "V" | PO36.1 |
PVHSET9 | ATN-OBJ-ID, PROCURE-GROUP, VEN-AGRMT-REF | KeyChange, Subset | Where ATN-OBJ-ID != Zeroes | — |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Mareasoncd | MAREASONCD | Required | PVH-REASON-CODE → MAR-REASON-CODE (MARSET1) | |
| Pocontacts | POCONTACTS | Not Required | PVH-PROCURE-GROUP → POC-PROCURE-GROUP, PVH-AGRMT-ADMIN → POC-AGRMT-ADMIN | |
| Povagrmthd | POVAGRMTHD | Required | PVH-PROCURE-GROUP → PVH-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PVH-VEN-AGRMT-REF | |
| Pvhbod | PVHBOD | Not Required, Delete Cascades | PVH-PROCURE-GROUP → PBH-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PBH-VEN-AGRMT-REF |
One to many (8) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acpovacommit | POVACOMMIT | Delete Cascades | Valid When (PVH-AC-COMMIT-FLAG = 1) | PVH-PROCURE-GROUP → PVC-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PVC-VEN-AGRMT-REF, Zeroes → PVC-LINE-NBR, "AC" → PVC-SYSTEM, Zeroes → PVC-LINE-SEQ, → PVC-COMMIT-DATE |
| Apdistpay | APDISTPAY | PVH-VENDOR → DTY-VENDOR, PVH-VEN-AGRMT-REF → DTY-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 | ||
| Glpovacommit | POVACOMMIT | Delete Cascades | Valid When (PVH-GL-COMMIT-FLAG = 1) | PVH-PROCURE-GROUP → PVC-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PVC-VEN-AGRMT-REF, Zeroes → PVC-LINE-NBR, "GL" → PVC-SYSTEM, Zeroes → PVC-LINE-SEQ, → PVC-COMMIT-DATE |
| Poagmaudit | POAGMAUDIT | PVH-PROCURE-GROUP → PVB-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PVB-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 | ||
| Poagmtpart | POAGMTPART | Delete Cascades | PVH-PROCURE-GROUP → PRK-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PRK-VEN-AGRMT-REF, → PRK-COMPANY, → PRK-LOCATION, → PRK-REQ-LOCATION | |
| Poagmtpric | POAGMTPRIC | Delete Cascades | PVH-PROCURE-GROUP → PRI-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PRI-VEN-AGRMT-REF, → PRI-EFFECTIVE-DT | |
| Poline | POLINE | PVH-PROCURE-GROUP → PLI-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PLI-AGREEMENT-REF, → PLI-COMPANY, → PLI-PO-NUMBER, → PLI-PO-RELEASE, → PLI-PO-CODE, → PLI-LINE-NBR | ||
| Povagrmtln | POVAGRMTLN | Delete Cascades | PVH-PROCURE-GROUP → PVN-PROCURE-GROUP, PVH-VEN-AGRMT-REF → PVN-VEN-AGRMT-REF, → PVN-LINE-NBR |
Programs
Updated by (230)
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- API1.1 Add Invoice
- API2.1 Add Invoice
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO07.1 PO Contacts
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO18.1 Workflow Approval Maintenance
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.2 Vendor Agreement Line Distributions
- PO26.3 Vendor Agreement Commitments Spread
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO26.6 Vendor Agreement Line Maximums
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.1 Create PO Release From Blanket
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- PO55.5 Agreement Header Retainage
- PO55.6 Agreement Line Retainage
- POCP.1 POC Comments Copy
- POD0.1 Po Orphan Record Check
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program
Referenced by (90)
- AC160 Asset Management Interface
- AM115 Mass Additions
- AM117 Mass Distribution Split
- AM15.1 Single Invoice Interface
- AM15.2 Combine Invoice Interface
- AM15.3 Single Activity Interface
- AM15.4 Combine Activity Interface
- AM19.1 PO Line Asset Detail
- AM19.2 Create Detail
- AM20.1 Quick Addition
- AM20.3 Items
- AM21.1 Leased Asset Quick Addition
- AM21.3 Items
- AM22.1 Items
- AM500 Asset Management Interface
- AM51.1 Item Update Adjust Interface Maint
- AM551 Item Update Adjustment Interface
- AM97.1 Item Interface Adjustment
- AP03.3 Query List Members
- AP10.2 Vendor Location
- AP110 Mass Vendor Update
- AP115 Vendor Merge
- AP133 Mass Retainage Payment Adjust
- AP150 Cash Requirements
- AP210 Vendor Listing
- AP220 Invoice Edit Report
- AP233 Retainage Invoice Listing
- AP271 Vendor Spend Report
- AP300 Invoice and Vendor History Purge
- AP305 Accounts Payable Company Purge
- AP90.1 Invoice Search by Vendor, Invoice
- AP90.4 Invoice Search by Purchase Order
- AP91.1 Vendor Activity
- AP97.1 Retainage Invoice Inquiry By Vendor Agreement
- AP97.5 Retainage Totals
- API3.1 Vendor Location Invoke
- API4.1 Vendor Master Invoke
- IC11.1 Item Master
- IC840 Cart Par Location Conversion
- MA126 Auto Matching
- MA279 Invoice AOC Detail Report
- MA540 Invoice Interface
- MA63.1 Invoice Line Match
- MA65.1 Invoice Line Adjustment
- MA69.1 AOC Level Detail Match
- MAED.1 Vendor
- MX123 List Member Build
- MX500 Attribute Value Population
- PD235 P-Card Merchant Report
- PO13.1 Vendor Item
- PO13.3 Vendor Items
- PO192 PO Vendor Item Audit Report
- PO195 PO Vendor Agreement Audit Report
- PO215 Procurement Template Listing
- PO223 Buyer Expediting Report
- PO226 Vendor Agreement Renewal Report
- PO227 Contract Agreement Compliance Report
- PO233 PO Received Quantity Exceptions
- PO253 Item Receipt Volume Report
- PO254 PO Inquiry Report
- PO278 RNI Aging Report
- PO525 Vendor Agreement Header, Line
- PO529 PO Receiving File Create
- PO65.1 Vendor Agreement Header Audit Inquiry
- PO65.2 Vendor Agreement Line Audit Inquiry
- POA3.1 Data Load for Vendor Analysis
- POBD.1 Po Bod Maintenance
- POBD.2 PO BOD Inquiry
- POI1.1 POC Comments Copy
- POI2.1 POC Comments Copy
- POI4.1 PODOCREF Invoked Oject
- POI6.1 Assign Doc Number Oject
- POI7.1 POI7 Print Object
- POIB.1 Create Agreement Tier Line
- POIG.1 MMDIST Budget Check
- POIH.1 Invokeable Unit Cost Default
- POIK.1 Edit AC and GL Budgets
- POIM.1 GL Budget Ck for PO and RQ
- PR05.1 Deduction
- PR05.3 Additional Vendors
- PR226 United States Employee Garnishment Listing
- PR247 Canada Employee Garnishment Listing
- PR26.1 United States Employee Garnishment
- PR47.1 Canada Employee Garnishment
- PR514 Employee Deduction Master Load
- RQ260 Requisitioned Items Report
- RQIC.1 Get Item List Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- RQIH.1 Invoke Determine Express Data