TD_PAGECAL_WRK

(SQL Table)
Index Back

Pagelet Calendar Work Record

Pagelet Calendar Work Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

2 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code
3 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
4 HTMLAREA Long Character CLOB HTML Area
5 COLORNAME Character(30) VARCHAR2(30) NOT NULL Color Name
6 WS_HYPERLINK1 Character(1) VARCHAR2(1) NOT NULL eStore generic hyperlink
7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
8 FIRST_ORDER_DATE Date(10) DATE First Order Date
9 LAST_ORDER_DATE Date(10) DATE Last Order Date
10 FIRST_SHIP_DATE Date(10) DATE First Scheduled Ship Date
11 LAST_SHIP_DATE Date(10) DATE Last Scheduled Ship Date
12 FIRST_DELIVERY_DT Date(10) DATE Physical date of position.
13 LAST_DELIVERY_DT Date(10) DATE Last delivery date for a contract .