PL_WB_TMPLATE_D

(SQL Table)
Index Back

WBench Template Detail

WBench Template Detail

# 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_ROWTYPE Number(4,0) SMALLINT NOT NULL PL_ROWTYPE

Prompt Table: PL_WB_ROWTYPEVW

4 SORT_ORDER_NUM Number(2,0) SMALLINT NOT NULL Sort Order Number
5 PL_INCLUDE_CHART Character(1) VARCHAR2(1) NOT NULL PL_INCLUDE_CHART

Y/N Table Edit

Default Value: N

6 ROW_ADDED_DTTM DateTime(26) TIMESTAMP Added Date/Time
7 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
8 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP Last Modified Date/Time
9 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
10 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.
11 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time