POVACOMMIT – Commitments for Vendor Agrmt

System
Purchase Order (PO)
Prefix
PVC
Primary key
PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, SYSTEM, LINE-SEQ, COMMIT-DATE
Fields
13
Updated by
225 programs
Referenced by
4 programs

POVACOMMIT is the Commitments for Vendor Agrmt table in Lawson Purchase Order (prefix PVC). It is indexed by PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, SYSTEM, LINE-SEQ, COMMIT-DATE (PVCSET1); alternate indexes: PVCSET2, PVCSET3, PVCSET4 and PVCSET5. It is related 1:1 to ACCOMMITX, GLCOMMITX, POVADIST, POVAGRMTHD, POVAGRMTLN and PROCUREGRP and 1:M to POAGMAUDIT and POVACOMMIX. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 217 more and referenced by PO13.1, PO13.3, PO18.1 and POIG.1. The table has 13 fields, 5 indexes and 9 documented relations.

About POVACOMMIT

This table will hold information to allow spreading GL/AC commitments for a vendor agreement header or distribution line. It will also hold the spread amount maximums that apply if certain edit flags are set on the distribution or the agreement header.

Fields (13)

Column = COBOL field name without the PVC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PVC-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-VEN-AGRMT-REF PK
VEN_AGRMT_REF		Alpha 30—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number. It has a zero value for agreement header spread commitments.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. For our purposes the two valid systems are AC (Activity Management) and GL (General Ledger).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-LINE-SEQ PK
LINE_SEQ		Numeric 3This is the sequence number of the agreement line distribution, or it has a zero value for agreement header spread commitments.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-COMMIT-DATE PK
COMMIT_DATE		Numeric 8 (yyyymmdd)The date for the spread commitment amount. It will fall into a particular year and period. For non-commitment spread amounts this is the period beginning date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-SPREAD-AMOUNT
SPREAD_AMOUNT		Signed 18.2The amount of the commitment that is spread or applied to the commitment date for this amount. It can represent a maximum amount if the Spread Edit Flag is set to period or yearly maximum edits.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-USED-AMOUNT
USED_AMOUNT		Signed 18.2The amount of the commitment that has been associated or used by a purchase order or requisition that references this vendor agreement line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-GLT-OBJ-ID SET3
GLT_OBJ_ID		Numeric 12The object ID of the general ledger commitment.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-ATN-OBJ-ID SET2
ATN_OBJ_ID		Numeric 12The object ID of the activity commitment for this agreement spread record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-FISCAL-YEAR SET4
FISCAL_YEAR		Numeric 4This is the current fiscal year. This field is updated by Period Closing (GL199).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-ACCT-PERIOD SET4
ACCT_PERIOD		Numeric 2This is the current accounting period. This field is updated by Period Closing (GL199).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVC-PVN-OBJ-ID SET5
PVN_OBJ_ID		Numeric 12This is the object ID of the vendor agreement line that is associated with this spread commitment record.—

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PVCSET1
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. LINE-NBR
  4. SYSTEM
  5. LINE-SEQ
  6. COMMIT-DATE
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVCSET2
  1. ATN-OBJ-ID
  2. PROCURE-GROUP
  3. VEN-AGRMT-REF
  4. LINE-NBR
  5. SYSTEM
  6. LINE-SEQ
  7. COMMIT-DATE
KeyChange, SubsetWhere (ATN-OBJ-ID != Zeroes)—
PVCSET3
  1. GLT-OBJ-ID
  2. PROCURE-GROUP
  3. VEN-AGRMT-REF
  4. LINE-NBR
  5. SYSTEM
  6. LINE-SEQ
  7. COMMIT-DATE
KeyChange, SubsetWhere (GLT-OBJ-ID != Zeroes)—
PVCSET4
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. LINE-NBR
  4. LINE-SEQ
  5. SYSTEM
  6. FISCAL-YEAR
  7. ACCT-PERIOD
  8. COMMIT-DATE ↓
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PVCSET5
  1. PVN-OBJ-ID
  2. PROCURE-GROUP
  3. VEN-AGRMT-REF
  4. LINE-NBR
  5. SYSTEM
  6. LINE-SEQ
  7. COMMIT-DATE
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACCOMMITXGLCOMMITXPOVADISTPOVAGRMTHDPOVAGRMTLNPROCUREGRPPOAGMAUDITPOVACOMMIXPOVACOMMIT

One to one (6) — lookups and parents

RelationTableRulesConditionField map
AccommitxACCOMMITXRequired
PVC-ATN-OBJ-ID→MIX-ATN-OBJ-ID (MIXSET2)
GlcommitxGLCOMMITXRequired
PVC-GLT-OBJ-ID→GOX-GLT-OBJ-ID
PovadistPOVADISTRequired
PVC-PROCURE-GROUP→PVD-PROCURE-GROUP
PVC-VEN-AGRMT-REF→PVD-VEN-AGRMT-REF
PVC-LINE-NBR→PVD-LINE-NBR
PVC-LINE-SEQ→PVD-LINE-SEQ
PovagrmthdPOVAGRMTHDRequired
PVC-PROCURE-GROUP→PVH-PROCURE-GROUP
PVC-VEN-AGRMT-REF→PVH-VEN-AGRMT-REF
PovagrmtlnPOVAGRMTLNRequired
PVC-PROCURE-GROUP→PVN-PROCURE-GROUP
PVC-VEN-AGRMT-REF→PVN-VEN-AGRMT-REF
PVC-LINE-NBR→PVN-LINE-NBR
ProcuregrpPROCUREGRPRequired
PVC-PROCURE-GROUP→PCG-PROCURE-GROUP

One to many (3) — child tables

RelationTableRulesConditionField map
PoagmaudithdrPOAGMAUDITValid When PVC-LINE-NBR = Zeroes
PVC-PROCURE-GROUP→PVB-PROCURE-GROUP
PVC-VEN-AGRMT-REF→PVB-VEN-AGRMT-REF
Zeroes→PVB-EFFECTIVE-DT
Zeroes→PVB-COMPANY
Spaces→PVB-LOCATION
Spaces→PVB-REQ-LOCATION
PVC-SYSTEM→PVB-SYSTEM
PVC-COMMIT-DATE→PVB-COMMIT-DATE
—→PVB-UPDATE-DATE
—→PVB-UPDATE-TIME
—→PVB-FLD-NBR
—→PVB-AUDIT-TYPE
PoagmauditlinePOAGMAUDITValid When PVC-LINE-NBR != Zeroes
PVC-PROCURE-GROUP→PVB-PROCURE-GROUP
PVC-VEN-AGRMT-REF→PVB-VEN-AGRMT-REF
PVC-LINE-NBR→PVB-LINE-NBR
Spaces→PVB-AOC-CODE
PVC-SYSTEM→PVB-SYSTEM
PVC-LINE-SEQ→PVB-LINE-SEQ
PVC-COMMIT-DATE→PVB-COMMIT-DATE
—→PVB-UPDATE-DATE
—→PVB-UPDATE-TIME
—→PVB-FLD-NBR
—→PVB-AUDIT-TYPE
PovacommixPOVACOMMIX
PVC-PROCURE-GROUP→PVX-PROCURE-GROUP
PVC-VEN-AGRMT-REF→PVX-VEN-AGRMT-REF
PVC-LINE-NBR→PVX-LINE-NBR
PVC-SYSTEM→PVX-SYSTEM
PVC-LINE-SEQ→PVX-LINE-SEQ
PVC-COMMIT-DATE→PVX-SPREAD-DATE
—→PVX-SPT-OBJ-ID

Programs

Updated by (225)

Referenced by (4)