RPT_FMT_TMPL2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	REPORT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report Identifier
3	RPT_TEMPLATE_ID2	Character(20)	VARCHAR2(20) NOT NULL	Report Print Options Template ID
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	FIELD_ORDER	Number(3,0)	SMALLINT NOT NULL	Field Order
6	REQUIRED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Required Flag
7	AMOUNT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Total Amount
8	ALLOW_OVERRIDE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Override of Lead Days
9	INCLUDE_IN_REPORT	Character(1)	VARCHAR2(1) NOT NULL	Include in Report Y/N Table Edit
10	DISPLAY_LENGTH	Number(2,0)	SMALLINT NOT NULL	Use to determine the ChartField Length to be display.
11	LABEL_OVERRIDE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Override label heading, Yes or Not Y/N Table Edit
12	LABEL_OVERRIDE_30	Character(30)	VARCHAR2(30) NOT NULL	Label Override Value
13	SUBTOTAL_SW	Character(1)	VARCHAR2(1) NOT NULL	Print subtotals Y/N Table Edit