PSDOCLOFIELD

index back

Document layout Field table


PeopleSoft Field Name Field Type Column Type Description
IBDOCLAYOUTNAME Character(20) VARCHAR2(20) NOT NULL Layout Name (see PSDOCLODEFN).
IB_DOCPAGE_INDEX Number(3,0) SMALLINT NOT NULL Page Index
IB_DOCLAYOUT_ID Number(4,0) SMALLINT NOT NULL Document Layout ID
FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
IB_DISPLAY_FORMAT Number(3,0) SMALLINT NOT NULL Fixed Display Format
IB_CONT_THEME Character(3) VARCHAR2(3) NOT NULL Main Theme
A=a
B=b
C=c
D=d
E=e
IB_THEME Character(3) VARCHAR2(3) NOT NULL Content Theme
A=a
B=b
C=c
D=d
E=e
IB_THEME_DIVIDER Character(3) VARCHAR2(3) NOT NULL Theme Divider
IB_DOC_LBL_ID Character(35) VARCHAR2(35) NOT NULL Field Layout Type
IB_DOC_LBL_ALT_ID Character(35) VARCHAR2(35) NOT NULL Alt ID
IB_CONT_CLASSNAME Character(254) VARCHAR2(254) NOT NULL Container Class Name
IB_CLASSNAME Character(254) VARCHAR2(254) NOT NULL Content Class
IB_LBLTEXT Character(100) VARCHAR2(100) NOT NULL Label Text
IB_GRP_LBLTEXT Character(100) VARCHAR2(100) NOT NULL Group Label Text
IB_ACCESSTXT Character(100) VARCHAR2(100) NOT NULL Accessibility
FIELDUSE Number(10,0) DECIMAL(10) NOT NULL Panel Field Use
IB_CONT_STYLE Character(254) VARCHAR2(254) NOT NULL Main Style
IB_STYLE Character(254) VARCHAR2(254) NOT NULL Content Style
IB_LEVEL Character(35) VARCHAR2(35) NOT NULL Layout Level
IB_FIELD_SIZE Signed Number(6,0) DECIMAL(5) NOT NULL Document Field Size
IB_TEXTAREA_ROW Number(4,0) SMALLINT NOT NULL Text Area Row Size
IB_TEXTAREA_COL Number(4,0) SMALLINT NOT NULL Text Area Column Size
GRDCOLUMNCOUNT Number(3,0) SMALLINT NOT NULL Grid Column Count
IB_IMAGE_TYPE Number(3,0) SMALLINT NOT NULL Image Type
IB_SPACE Number(3,0) SMALLINT NOT NULL Space
IB_UPDATE_EVENT Number(1,0) SMALLINT NOT NULL Trigger Update
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19