TD_FIN_DATA

#	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	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
5	PROMO_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Promotional Group
6	TD_FUND_CODE	Character(10)	VARCHAR2(10) NOT NULL	Promotions Management Fund Code
7	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type
8	TD_CHECK_COL_CUST	Character(2)	VARCHAR2(2) NOT NULL	Column Value
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL
11	TRANS_DATE	Date(10)	DATE	Transaction Date
12	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BUTDGL_NONVW
13	PROMO_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Promotion Type A=National Allowance P=Promotion Event
14	STATUS_TD	Character(2)	VARCHAR2(2) NOT NULL	Promotion Status CA=Customer Approved CE=Customer Cancelled CL=Closed CR=Customer Rejected MA=Management Approved MR=Management Rejected PA=Pending Approval PL=Planned RE=Recalled RL=Released
15	ALLOW_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Allowance Status 1=Planned 2=Released 3=Pending Approval 4=Approved 5=Rejected 6=Closed 7=Recalled
16	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
17	TD_UNITS	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Units
18	TD_LAST_REFRESH	DateTime(26)	TIMESTAMP	Last Refresh