POIVADIST – No description in the Lawson data dictionary
- System
- Purchase Order (PO)
- Prefix
PVI- Primary key
PROCURE-GROUP,VEN-AGRMT-REF,LINE-NBR,LINE-SEQ- Fields
- 21
- Updated by
- 1 program
- Referenced by
- 0 programs
POIVADIST is a Lawson Purchase Order table (prefix PVI); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, LINE-SEQ (PVISET1). It is updated by POIK.1. The table has 21 fields, 1 index and 0 documented relations.
About POIVADIST
No description in the Lawson data dictionary.
Fields (21)
Column = COBOL field name without the PVI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PVI-PROCURE-GROUP PKPROCURE_GROUP | Alpha 4 | — | — |
PVI-VEN-AGRMT-REF PKVEN_AGRMT_REF | Alpha 30 | — | — |
PVI-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number for the vendor agreement line. | — |
PVI-LINE-SEQ PKLINE_SEQ | Numeric 3 | The vendor agreement line distribution sequence number. | — |
PVI-ACCT-UNITACCT_UNIT | Alpha 15 | — | — |
PVI-ACCOUNTACCOUNT | Numeric 6 | — | — |
PVI-SUB-ACCTSUB_ACCT | Numeric 4 | — | — |
PVI-DIST-COMPANYDIST_COMPANY | Numeric 4 | The vendor agreement line distribution company. | — |
PVI-ACTIVITYACTIVITY | Alpha 15 | — | — |
PVI-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | — | — |
PVI-BILL-CATEGORYBILL_CATEGORY | Alpha 32 | The billing category. | — |
PVI-DIST-PERCENTDIST_PERCENT | Signed 6.3 | The percentage of the vendor agreement line cost this distribution represents. | — |
PVI-SPREAD-EDIT-FLSPREAD_EDIT_FL | Numeric 1 | An indicator of whether spread commitment records (POVACOMMIT) exist for this distribution. Further, it is an indicator if period maximum edits will be enforced, if yearly maximum edits will be enforced for the spread amounts, or if no maximum edits will be enforced for the spread amounts. | — |
PVI-AGRMT-MAX-AMTAGRMT_MAX_AMT | Numeric 13 | This is the maximum amount on the contract line the distribution is associated with. | — |
PVI-AGRMT-MAX-QTYAGRMT_MAX_QTY | Numeric 10 | This is the maximum quantity on the contract line the distribution is associated with. | — |
PVI-BASE-COSTBASE_COST | Signed 18.5 | This is the base cost on the contract line the distribution is associated with. | — |
PVI-AC-COMMIT-FLAGAC_COMMIT_FLAG | Numeric 1 | The Flag to indicate whether the contract line associated with this distribution uses activity commitments. | — |
PVI-GL-COMMIT-FLAGGL_COMMIT_FLAG | Numeric 1 | The Flag to indicate whether the contract line associated with this distribution uses general ledger commitments. | — |
PVI-SERVICE-CODESERVICE_CODE | Alpha 1 | This is the service type code for a service item on an contract line the distribution is associated with. | — |
PVI-CURRENCY-CODECURRENCY_CODE | Alpha 5 | The currency code associated with the contract. | — |
PVI-EFFECTIVE-DTEFFECTIVE_DT | Numeric 8 (yyyymmdd) | This is the effective date for the contract. | — |
Indexes (1)
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 |
|---|---|---|---|---|
PVISET1 | PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, LINE-SEQ | Primary | POIK.1 |
Programs
Updated by (1)
- POIK.1 Edit AC and GL Budgets