PTAFAMT_REC_VW

index back

Record Definition View


SELECT recname ,fieldcount ,version ,auditrecname ,recuse ,rectype ,setcntrlfld ,rellangrecname ,recdescr ,parentrecname FROM psrecdefn

PeopleSoft Field Name Field Type Column Type Description
AMT_RECNAME Character(15) VARCHAR2(15) NOT NULL Amount Record
FIELDCOUNT Number(4,0) SMALLINT NOT NULL Field Count
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
AUDITRECNAME Character(15) VARCHAR2(15) NOT NULL Audit Record Name
RECUSE Number(5,0) INTEGER NOT NULL Record Use. Audit Option bit values
RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name
RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name
RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19