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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
PVISET1 |
PROCURE-GROUP VEN-AGRMT-REF LINE-NBR LINE-SEQ |
|
|
All trademarks and registered trademarks are the property of their
respective owners.