PL_WB_TMPLATE_T

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PL_WB_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	PL_WB_TEMPLATE_ID
2	PL_WBENCH_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PL_WBENCH_TYPE 0001=Item Based 0002=Capacity Based 0003=Buyer Based
3	PL_NUMBER_PERIODS	Number(3,0)	SMALLINT NOT NULL	PL_NUMBER_PERIODS Default Value: 10
4	PL_PERIOD_DURATION	Character(2)	VARCHAR2(2) NOT NULL	Used on planning panels D=Day M=Month W=Week Default Value: W
5	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
6	PL_GRAPH_TYPE	Character(3)	VARCHAR2(3) NOT NULL	PL_GRAPH_TYPE 00=2D Bar 01=2D Stacked Bar 02=2D Percent Bar 03=2D Horizontal Stacked Bar 04=2D Line 05=Histogram 06=2D Pie 07=3D Bar 08=3D Stacked Bar 09=3D Pie 10=2D Horizontal Percent Chart 11=3D Percent Bar 12=2D Horizontal Bar
7	PL_START_DT_CALC	Character(4)	VARCHAR2(4) NOT NULL	Used to indicate whether the start date of the first bucket should be the Start Date Entered or the beginning of the Period in which the start date falls. 0001=Beginning of Period 0002=Start Date Entered Default Value: 0001
8	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Added Date/Time
9	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
10	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	Last Modified Date/Time
11	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By
12	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
13	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time