PTIASPCOMPREL

index back

Component Relation Definition

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

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPPRDFMLYCharacter(5)VARCHAR2(5) NOT NULLProduct Family
PTIASPARPPRDIDNumber(8,0)INTEGER NOT NULLProduct ID
PTIASPPRDIDNumber(8,0)INTEGER NOT NULLProduct ID
PTIASPPRDCMPCharacter(10)VARCHAR2(10) NOT NULLProduct Component
PTIASPPRDCMPNMCharacter(30)VARCHAR2(30) NOT NULLProduct Component Name
PTIASPPRDSUBCMPCharacter(14)VARCHAR2(14) NOT NULLProduct Sub Component
PTIASPPRDSUBCMPNMCharacter(40)VARCHAR2(40) NOT NULLProduct Sub Component
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19