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.
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.1 POIG.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVC-PROCURE-GROUP
Element: Procure Group		Alpha 4
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-VEN-AGRMT-REF
Element: Agreement Ref		Alpha 30
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-LINE-NBR
Element: Line Nbr		Numeric 6
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-SYSTEM
Element: System		Alpha 2
A 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-LINE-SEQ
Element: Seq		Numeric 3
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-COMMIT-DATE
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-SPREAD-AMOUNT
Element: Intl Amt		Signed 18.2
The 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-USED-AMOUNT
Element: Intl Amt		Signed 18.2
The 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-GLT-OBJ-ID
Element: Obj Id		Numeric 12
The object ID of the general ledger commitment.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-ATN-OBJ-ID
Element: Obj Id		Numeric 12
The object ID of the activity commitment for this agreement spread record.
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-ACCT-PERIOD
Element: Period		Numeric 2
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PO190 PO300
PO520 POCP.1
POI3.1 POII.1
POIJ.1
PVC-PVN-OBJ-ID
Element: Obj Id		Numeric 12
This is the object ID of the vendor agreement line that is associated with this spread commitment record.


POVACOMMIT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVCSET1 PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
SYSTEM
LINE-SEQ
COMMIT-DATE
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PVCSET2 ATN-OBJ-ID
PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
SYSTEM
LINE-SEQ
COMMIT-DATE
KeyChange, Subset
Where(ATN-OBJ-ID !=Zeroes)
PVCSET3 GLT-OBJ-ID
PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
SYSTEM
LINE-SEQ
COMMIT-DATE
KeyChange, Subset
Where(GLT-OBJ-ID !=Zeroes)
PVCSET4 PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
LINE-SEQ
SYSTEM
FISCAL-YEAR
ACCT-PERIOD
COMMIT-DATE*
KeyChange
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136
PVCSET5 PVN-OBJ-ID
PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
SYSTEM
LINE-SEQ
COMMIT-DATE


POVACOMMIT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accommitx ACCOMMITX Required
PVC-ATN-OBJ-ID->MIX-ATN-OBJ-ID (MIXSET2)
Glcommitx GLCOMMITX Required
PVC-GLT-OBJ-ID->GOX-GLT-OBJ-ID
Povadist POVADIST Required
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
Povagrmthd POVAGRMTHD Required
PVC-PROCURE-GROUP->PVH-PROCURE-GROUP
PVC-VEN-AGRMT-REF->PVH-VEN-AGRMT-REF
Povagrmtln POVAGRMTLN Required
PVC-PROCURE-GROUP->PVN-PROCURE-GROUP
PVC-VEN-AGRMT-REF->PVN-VEN-AGRMT-REF
PVC-LINE-NBR->PVN-LINE-NBR
Procuregrp PROCUREGRP Required
PVC-PROCURE-GROUP->PCG-PROCURE-GROUP


POVACOMMIT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Povacommix POVACOMMIX
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

File created: Wed Jun 08 20:50:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.