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

PO300 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.

TPL-CM-CONTRACT
Element: Cm Contract Numeric 15

TPL-LINE-NBR
Element: Line Nbr Numeric 6
This field contains the line number.

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.

TPL-LOCATION
Element: Location Alpha 5
This field contains a valid stocking location within the company inventory.

TPL-REQ-LOCATION
Element: Req Location Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.

TPL-MFG-CONTRACT
Element: Cm Contract Numeric 15
A contract used by the Contract Management programs in that Landmark application.

TPL-TIER
Element: Tier Alpha 4

TPL-TIER-CONTRACT
Element: Cm Contract Numeric 15
A contract used by Contract Management programs in that Landmark application.

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.

TPL-VEN-AGRMT-REF
Element: Agreement Ref Alpha 30

TPL-ITEM
Element: Item Alpha 32
This field contains the item identifier.

TPL-VEN-ITEM
Element: Item Alpha 32
The vendor's item identifier.

TPL-BASE-COST
Element: Intl Cost Signed 18.5
The base cost for this pricing tier line.

TPL-AGMT-TYPE
Element: Agmt Type Alpha 1

B = Blanket
C = Contract
S = Standing
T = Catalog/Quote
V = Service

TPL-STOCKLESS-FL
Element: All Flag Alpha 1
The flag indicating this is a stockless agreement line.
N = No
Y = Yes

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

TPL-CURR-NET-CST
Element: Intl Cost Signed 18.5
The current net cost with the mark/discounts applied.

TPL-MARKUP-DISC
Element: Markup Disc Alpha 1

D = Discount
M = Markup
F = Fixed

TPL-LNBRK-COST
Element: Intl Cost Signed 18.5
The cost for this tier price.

TPL-LNBRK-PERCENT
Element: Percent 3dec Percent 6.3 (Percent)
The markup/discount percentage for the tier price.

TPL-FREIGHT-COST
Element: Intl Cost Signed 18.5
The freight cost for this pricing tier.

TPL-FREIGHT-PCT
Element: Percent 3dec Percent 6.3 (Percent)
The freight markup/discount percentage.

TPL-PRIORITY
Element: Priority Numeric 1
Indicates order of precedence for contracts to determine costing defaults for items.

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.

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

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.)

TPL-FR-MARKUP-DISC
Element: Markup Disc Alpha 1
The freight markup/discount flag.
D = Discount
M = Markup

TPL-MODIFIED-FL
Element: All Flag Alpha 1
A flag used by the Contract Management Landmark application.

TPL-PRICE-FACTOR
Element: Intl Cost Signed 18.5
See the Contract Management Landmark application documentation.

TPL-FREIGHT-FACTOR
Element: Intl Cost Signed 18.5
See the Contract Management Landmark application documentation.

TPL-PRICING-ID
Element: Pricing Id Alpha 4
See the Contract Management Landmark application documentation.

TPL-DIST-MUMD
Element: Markup Disc Alpha 1
See the Contract Management Landmark application documentation.
M = Markup
D = Discount

TPL-DIST-COST
Element: Intl Cost Signed 18.5
See the Contract Management Landmark application documentation.

TPL-DIST-PERCENT
Element: Percent 3dec Percent 6.3 (Percent)
See the Contract Management Landmark application documentation.

TPL-DIST-FR-MUMD
Element: Markup Disc Alpha 1
See the Contract Management Landmark application documentation.
M = Markup
D = Discount

TPL-DIST-FR-COST
Element: Intl Cost Signed 18.5
See the Contract Management Landmark application documentation.

TPL-DIST-FR-PCT
Element: Percent 3dec Percent 6.3 (Percent)
See the Contract Management Landmark application documentation.

TPL-OVRIDE-NET-CST
Element: Intl Cost Signed 18.5

TPL-VENDOR
Element: Vendor Alpha 9 (Right Justified)
The vendor's identification code.

TPL-PVN-OBJ-ID
Element: Obj Id Numeric 12

TPL-PART-SEQ-NBR
Element: Seq Number Numeric 6