PTAFAMT_REC_VW

index back

Record Definition View


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

PeopleSoft Field NameField TypeColumn TypeDescription
AMT_RECNAMECharacter(15)VARCHAR2(15) NOT NULLAmount Record
FIELDCOUNTNumber(4,0)SMALLINT NOT NULLField Count
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
AUDITRECNAMECharacter(15)VARCHAR2(15) NOT NULLAudit Record Name
RECUSENumber(5,0)INTEGER NOT NULLRecord Use. Audit Option bit values
RECTYPENumber(1,0)SMALLINT NOT NULLRecord Type
SETCNTRLFLDCharacter(18)VARCHAR2(18) NOT NULLTree Structure Node User Key Field Name
RELLANGRECNAMECharacter(15)VARCHAR2(15) NOT NULLRelated Language Record Name
RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
PARENTRECNAMECharacter(15)VARCHAR2(15) NOT NULLParent Record Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19