POVADIST

Vendor Agreement Distribution

POVADIST is a database file that will hold distributions for PO vendor agreement lines. When the PO vendor agreement line is added the account and activity information is put into POVADIST. There can be multiple POVADIST records added for one PO vendor agreement line.
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 PO980

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVD-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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number for the 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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-LINE-SEQ
Element: Seq
Numeric 3
The vendor agreement line distribution sequence number.
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-ACCT-UNIT
Element: 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
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-ACCOUNT
Element: 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
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-SUB-ACCT
Element: 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
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-DIST-COMPANY
Element: Company
Numeric 4
The vendor agreement line distribution company.
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-ACTIVITY
Element: 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
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-ACCT-CATEGORY
Element: Acct Category
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
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-BILL-CATEGORY
Element: Bill Category
Alpha 32
The billing category.
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-DIST-PERCENT
Element: Total Percent
Signed 6.3
The percentage of the vendor agreement line cost this distribution represents.
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 PO980
POCP.1 POI3.1
POII.1 POIJ.1
PVD-GLT-OBJ-ID
Element: Obj Id
Numeric 12
Object ID of the GL transaction created for a 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
PVD-ATN-OBJ-ID
Element: Obj Id
Numeric 12
Object ID of the AC transaction created for a 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
PVD-SPREAD-EDIT-FL
Element: Flag Num
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.
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
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
PVD-DISTRIB-AMOUNT
Element: Intl Amt
Signed 18.2
The total distribution amount, based on the vendor agreement line maximum amount and the percentage on the distribution 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 PO980
POCP.1 POI3.1
POII.1 POIJ.1


POVADIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVDSET1 PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
LINE-SEQ
...
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
PVDSET2 ATN-OBJ-ID
KeyChange, Subset
Where(ATN-OBJ-ID !=Zeroes)
PVDSET3 GLT-OBJ-ID
KeyChange, Subset
Where(GLT-OBJ-ID !=Zeroes)


POVADIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
PVD-ACCT-CATEGORY->AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Not Required
PVD-ACTIVITY->ACV-ACTIVITY
Accommitx ACCOMMITX Not Required
PVD-ATN-OBJ-ID->MIX-ATN-OBJ-ID
Glcommitix GLCOMMITX Not Required
PVD-GLT-OBJ-ID->GOX-GLT-OBJ-ID
Glmaster GLMASTER Required
PVD-DIST-COMPANY->GLM-COMPANY
PVD-ACCT-UNIT->GLM-ACCT-UNIT
PVD-ACCOUNT->GLM-ACCOUNT
PVD-SUB-ACCT->GLM-SUB-ACCOUNT
Glsystem GLSYSTEM Required
PVD-DIST-COMPANY->GLS-COMPANY
Povagrmthd POVAGRMTHD Required
PVD-PROCURE-GROUP->PVH-PROCURE-GROUP
PVD-VEN-AGRMT-REF->PVH-VEN-AGRMT-REF
Povagrmtln POVAGRMTLN Required
PVD-PROCURE-GROUP->PVN-PROCURE-GROUP
PVD-VEN-AGRMT-REF->PVN-VEN-AGRMT-REF
PVD-LINE-NBR->PVN-LINE-NBR
Procuregrp PROCUREGRP Required
PVD-PROCURE-GROUP->PCG-PROCURE-GROUP


POVADIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acpovacommit POVACOMMIT Delete Cascades
PVD-PROCURE-GROUP->PVC-PROCURE-GROUP
PVD-VEN-AGRMT-REF->PVC-VEN-AGRMT-REF
PVD-LINE-NBR->PVC-LINE-NBR
"AC"->PVC-SYSTEM
PVD-LINE-SEQ->PVC-LINE-SEQ
  PVC-COMMIT-DATE
Glpovacommit POVACOMMIT Delete Cascades
PVD-PROCURE-GROUP->PVC-PROCURE-GROUP
PVD-VEN-AGRMT-REF->PVC-VEN-AGRMT-REF
PVD-LINE-NBR->PVC-LINE-NBR
"GL"->PVC-SYSTEM
PVD-LINE-SEQ->PVC-LINE-SEQ
  PVC-COMMIT-DATE


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

Home
Contact Us



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