Lawson - Lawson Software Technical Library - Data File Text for POVAPARTLN

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 AP510 API1.1

API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5

CX220 CX30.1 CX300 CX506 CXCP.1 DR100

IC12.1 IC140 IC141 IC142 IC145 IC243

IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5

IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1

MA180 MA278 MA41.1 MA41.2 MA41.4 MA41.7

MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 MA53.1

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 PD570 PO04.1

PO04.2 PO10.1 PO10.2 PO100 PO101 PO115

PO120 PO122 PO13.3 PO131 PO132 PO136

PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190

PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2

PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4

PO220 PO222 PO224 PO225 PO229 PO23.1

PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6

PO25.7 PO251 PO26.2 PO26.3 PO26.4 PO26.5

PO26.6 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4

PO275 PO276 PO277 PO28.2 PO280 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 POII.1 POIJ.1 RQ01.1

RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1

RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500

RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.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 POIH.1

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

AP510 API1.1

API2.1 CX100

CX20.1 CX20.2

CX20.4 CX20.5

CX220 CX30.1

CX300 CX506

CXCP.1 DR100

IC12.1 IC140

IC141 IC142

IC145 IC243

IC330 IC64.1

IC64.2 IC64.3

IC64.4 IC64.5

IC64.6 IC64.7

IC64.8 IC64.9

IC66.1 IC83.1

MA180 MA278

MA41.1 MA41.2

MA41.4 MA41.7

MA42.2 MA43.2

MA43.7 MA44.1

MA44.2 MA53.1

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
Where	STATUS	=	1
And	HOLD-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
AP510	API1.1
API2.1	CX100
CX20.1	CX20.2
CX20.4	CX20.5
CX220	CX30.1
CX300	CX506
CXCP.1	DR100