POIVADIST

This is the intermediate vendor agreement line distribution table. It will contain all the fields in the existing POVADIST table, except the object ID fields for AC and GL commitments. This table will also contain some fields from the vendor agreement line and header for this distribution that are needed in the AC/GL budget edits.
UPDATED BY
POIK.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PVI-PROCURE-GROUP
Element: Procure Group
Alpha 4
PVI-VEN-AGRMT-REF
Element: Agreement Ref
Alpha 30
PVI-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number for the vendor agreement line.
PVI-LINE-SEQ
Element: Seq
Numeric 3
The vendor agreement line distribution sequence number.
PVI-ACCT-UNIT
Element: Acct Unit
Alpha 15
PVI-ACCOUNT
Element: Account
Numeric 6
PVI-SUB-ACCT
Element: Sub Acct
Numeric 4
PVI-DIST-COMPANY
Element: Company
Numeric 4
The vendor agreement line distribution company.
PVI-ACTIVITY
Element: Activity
Alpha 15
PVI-ACCT-CATEGORY
Element: Acct Category
Alpha 5
PVI-BILL-CATEGORY
Element: Bill Category
Alpha 32
The billing category.
PVI-DIST-PERCENT
Element: Total Percent
Signed 6.3
The percentage of the vendor agreement line cost this distribution represents.
PVI-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.
PVI-AGRMT-MAX-AMT
Element: Agrmt Max Amt
Numeric 13
This is the maximum amount on the contract line the distribution is associated with.
PVI-AGRMT-MAX-QTY
Element: Agrmt Max Qty
Numeric 10
This is the maximum quantity on the contract line the distribution is associated with.
PVI-BASE-COST
Element: Intl Cost
Signed 18.5
This is the base cost on the contract line the distribution is associated with.
PVI-AC-COMMIT-FLAG
Element: Ac Commit Flag
Numeric 1
The Flag to indicate whether the contract line associated with this distribution uses activity commitments.
PVI-GL-COMMIT-FLAG
Element: Gl Commit Flag
Numeric 1
The Flag to indicate whether the contract line associated with this distribution uses general ledger commitments.
PVI-SERVICE-CODE
Element: Service Code
Alpha 1
This is the service type code for a service item on an contract line the distribution is associated with.
PVI-CURRENCY-CODE
Element: Currency Code
Alpha 5
The currency code associated with the contract.
PVI-EFFECTIVE-DT
Element: Date
Numeric 8 (yyyymmdd)
This is the effective date for the contract.


POIVADIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PVISET1 PROCURE-GROUP
VEN-AGRMT-REF
LINE-NBR
LINE-SEQ
POIK.1


File created: Thu Jun 09 02:27:04 2016

Home
Contact Us



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