PTIASPCOMPREL

index back

Component Relation Definition

This table stores the relationships between products and other products, components and sub components

PeopleSoft Field Name Field Type Column Type Description
PTIASPPRDFMLY Character(5) VARCHAR2(5) NOT NULL Product Family
PTIASPARPPRDID Number(8,0) INTEGER NOT NULL Product ID
PTIASPPRDID Number(8,0) INTEGER NOT NULL Product ID
PTIASPPRDCMP Character(10) VARCHAR2(10) NOT NULL Product Component
PTIASPPRDCMPNM Character(30) VARCHAR2(30) NOT NULL Product Component Name
PTIASPPRDSUBCMP Character(14) VARCHAR2(14) NOT NULL Product Sub Component
PTIASPPRDSUBCMPNM Character(40) VARCHAR2(40) NOT NULL Product Sub Component
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19