TD_PRM_COPY

(SQL Table)
 Index Back

Promotion Copy Work Record

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 TO_PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL To Promotion Code

Prompt Table: TD_PROMOTION_VW

4 TO_SETID Character(5) VARCHAR2(5) NOT NULL To Setid
5 FROM_SETID_ENTRY Character(5) VARCHAR2(5) NOT NULL From Setid Entry Type
6 TD_COPY_CUST Character(1) VARCHAR2(1) NOT NULL Copy Promotion Details
N=No
Y=Yes

Default Value: Y

7 TD_COPY_FUND Character(1) VARCHAR2(1) NOT NULL Copy Funds
N=No
Y=Yes

Default Value: Y

8 TD_COPY_MERCH Character(1) VARCHAR2(1) NOT NULL Copy Merchandising Activities
N=No
Y=Yes

Default Value: Y

9 TD_COPY_PRODS Character(1) VARCHAR2(1) NOT NULL Copy Products
N=No
Y=Yes

Default Value: Y

10 CUST_ID_TO Character(15) VARCHAR2(15) NOT NULL To Customer ID

Prompt Table: TD_CUST_OPRVW

11 CUST_ID_FRM Character(15) VARCHAR2(15) NOT NULL From Customer ID

Prompt Table: TD_PROM_CUST_VW

12 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

Prompt Table: TD_PROMOTION_VW