TD_CPY_PROM_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_FS_VW.SETID Prompt Table: SP_SETTD_NONVW
5	TO_PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	To Promotion Code Default Value: NEXT
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	TD_MULTIPLE	Character(1)	VARCHAR2(1) NOT NULL	Create Multiple Customer Promo Y/N Table Edit Default Value: Y
8	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.
9	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
10	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	LAST_ORDER_DATE	Date(10)	DATE	Last Order Date
13	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
14	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
15	FIRST_ORDER_DATE	Date(10)	DATE	First Order Date Default Value: PPRC_PROMO_TBL.FIRST_ORDER_DATE
16	FIRST_DELIVERY_DT	Date(10)	DATE	Physical date of position. Default Value: PPRC_PROMO_TBL.FIRST_DELIVERY_DT
17	FIRST_SHIP_DATE	Date(10)	DATE	First Scheduled Ship Date Default Value: PPRC_PROMO_TBL.FIRST_SHIP_DATE
18	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.