POVAPARTLN

Contract Participant Line

This table contains the vendor agreement line contract participants and their pricing information.
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
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC66.1 IC83.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA67.2 MA67.3 MA68.2 MA68.3 MA68.5
MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO13.3 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO28.1 PO28.2 PO28.3 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POI3.1
POIB.1 POID.1 POIH.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPL-CONTRACT-GROUP
Element: Enterprise Grp		Alpha 4
This field contains the identifier for a group of contracts that can be shared by one or more companies.
POIB.1
TPL-CM-CONTRACT
Element: Cm Contract		Numeric 15
POIB.1
TPL-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
POIB.1
TPL-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
POIB.1
TPL-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
POIB.1
TPL-REQ-LOCATION
Element: Req Location		Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.
POIB.1
TPL-MFG-CONTRACT
Element: Cm Contract		Numeric 15
A contract used by the Contract Management programs in that Landmark application.
POIB.1
TPL-TIER
Element: Tier		Alpha 4
POIB.1
TPL-TIER-CONTRACT
Element: Cm Contract		Numeric 15
A contract used by Contract Management programs in that Landmark application.
POIB.1
TPL-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.
POIB.1
TPL-VEN-AGRMT-REF
Element: Agreement Ref		Alpha 30
POIB.1
TPL-ITEM
Element: Item		Alpha 32
This field contains the item identifier.
POIB.1
TPL-VEN-ITEM
Element: Item		Alpha 32
The vendor's item identifier.
PO13.3 POIB.1
TPL-BASE-COST
Element: Intl Cost		Signed 18.5
The base cost for this pricing tier line.
POIB.1
TPL-AGMT-TYPE
Element: Agmt Type		Alpha 1

B = Blanket
C = Contract
S = Standing
T = Catalog/Quote
V = Service
POIB.1
TPL-STOCKLESS-FL
Element: All Flag		Alpha 1
The flag indicating this is a stockless agreement line.
N = No
Y = Yes
PO150 PO25.1
PO25.6 PO25.7
PO536 POIB.1
TPL-HOLD-FLAG
Element: Hold Flag		Alpha 1
This field enables this particpant tier line to be put on hold, not allowing it to be using in cost defaulting.
N = No
Y = Yes
PO150 PO25.1
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 POIB.1
TPL-CURR-NET-CST
Element: Intl Cost		Signed 18.5
The current net cost with the mark/discounts applied.
POIB.1
TPL-MARKUP-DISC
Element: Markup Disc		Alpha 1

D = Discount
M = Markup
F = Fixed
POIB.1
TPL-LNBRK-COST
Element: Intl Cost		Signed 18.5
The cost for this tier price.
POIB.1
TPL-LNBRK-PERCENT
Element: Percent 3dec		Percent 6.3 (Percent)
The markup/discount percentage for the tier price.
POIB.1
TPL-FREIGHT-COST
Element: Intl Cost		Signed 18.5
The freight cost for this pricing tier.
POIB.1
TPL-FREIGHT-PCT
Element: Percent 3dec		Percent 6.3 (Percent)
The freight markup/discount percentage.
POIB.1
TPL-PRIORITY
Element: Priority		Numeric 1
Indicates order of precedence for contracts to determine costing defaults for items.
POIB.1
TPL-DEFBUY-UCOST
Element: Defbuy Ucost		Numeric 18
The whole number value of the unit cost for this participant tier line, used in the cost cost defualting to find the lowest cost.
POIB.1
TPL-STATUS
Element: Status		Numeric 1
This field displays the status of the vendor agreement participant line.
0 = Unreleased
1 = Released
2 = Revisions in Progress
3 = Closed		 ...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140
IC66.1 IC83.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA43.7
MA44.1 MA44.2
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
TPL-LAST-SEQ-NBR
Element: Seq Number		Numeric 6
Identifies the last sequence number used for the participant line tiers. Ensures the record is unique. (This is used only in the CM system.)
POIB.1
TPL-FR-MARKUP-DISC
Element: Markup Disc		Alpha 1
The freight markup/discount flag.
D = Discount
M = Markup
POIB.1
TPL-MODIFIED-FL
Element: All Flag		Alpha 1
A flag used by the Contract Management Landmark application.
POIB.1
TPL-PRICE-FACTOR
Element: Intl Cost		Signed 18.5
See the Contract Management Landmark application documentation.
POIB.1
TPL-FREIGHT-FACTOR
Element: Intl Cost		Signed 18.5
See the Contract Management Landmark application documentation.
POIB.1
TPL-PRICING-ID
Element: Pricing Id		Alpha 4
See the Contract Management Landmark application documentation.
POIB.1
TPL-DIST-MUMD
Element: Markup Disc		Alpha 1
See the Contract Management Landmark application documentation.
M = Markup
D = Discount
POIB.1
TPL-DIST-COST
Element: Intl Cost		Signed 18.5
See the Contract Management Landmark application documentation.
POIB.1
TPL-DIST-PERCENT
Element: Percent 3dec		Percent 6.3 (Percent)
See the Contract Management Landmark application documentation.
POIB.1
TPL-DIST-FR-MUMD
Element: Markup Disc		Alpha 1
See the Contract Management Landmark application documentation.
M = Markup
D = Discount
POIB.1
TPL-DIST-FR-COST
Element: Intl Cost		Signed 18.5
See the Contract Management Landmark application documentation.
POIB.1
TPL-DIST-FR-PCT
Element: Percent 3dec		Percent 6.3 (Percent)
See the Contract Management Landmark application documentation.
POIB.1
TPL-OVRIDE-NET-CST
Element: Intl Cost		Signed 18.5
POIB.1
TPL-VENDOR
Element: Vendor		Alpha 9 (Right Justified)
The vendor's identification code.
POIB.1
TPL-PVN-OBJ-ID
Element: Obj Id		Numeric 12
POIB.1
TPL-PART-SEQ-NBR
Element: Seq Number		Numeric 6
POIB.1


POVAPARTLN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPLSET1 CONTRACT-GROUP
CM-CONTRACT
LINE-NBR
COMPANY
LOCATION
REQ-LOCATION
MFG-CONTRACT
POIB.1
TPLSET2 PROCURE-GROUP
AGMT-TYPE
ITEM
VEN-ITEM
PRIORITY
DEFBUY-UCOST
COMPANY
LOCATION
REQ-LOCATION
CONTRACT-GROUP
CM-CONTRACT
LINE-NBR
MFG-CONTRACT
Subset
WhereSTATUS =1
AndHOLD-FLAG ="N"
POIH.1
TPLSET3 PROCURE-GROUP
VEN-AGRMT-REF
PVN-OBJ-ID
PART-SEQ-NBR
...
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
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140


POVAPARTLN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Iclocation ICLOCATION Required
TPL-COMPANY->ICL-COMPANY
TPL-LOCATION->ICL-LOCATION
Itemmast ITEMMAST Required
PCG-ITEM-GROUP->ITE-ITEM-GROUP
TPL-ITEM->ITE-ITEM
Pocompany POCOMPANY Required
TPL-COMPANY->PCY-COMPANY
Pocontgrp POCONTGRP Required
TPL-CONTRACT-GROUP->CNG-CONTRACT-GROUP
Pocontract POCONTRACT Required
TPL-CONTRACT-GROUP->CMH-CONTRACT-GROUP
TPL-CM-CONTRACT->CMH-CM-CONTRACT
Procuregrp PROCUREGRP Required
TPL-PROCURE-GROUP->PCG-PROCURE-GROUP
Rqloc RQLOC Required
TPL-COMPANY->RQL-COMPANY
TPL-REQ-LOCATION->RQL-REQ-LOCATION

File created: Thu Jun 09 11:25:16 2016

Home
Contact Us



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