CDT_RMA_HDR_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number
3	RETURN_FROM_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Return From Option E=External Customer I=Internal Location
4	SOLD_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Sold To Customer
5	RETURN_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Return From Location
6	RETURN_FR_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Return From Cust ID
7	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
8	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
10	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
11	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
12	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
13	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
14	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
15	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
16	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
17	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
18	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
19	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
20	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
21	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
22	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
23	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
24	ADDRESS_SEQ_SHIP	Number(5,0)	INTEGER NOT NULL	Primary Address - Ship To
25	ADDRESS_SEQ_SOLD	Number(5,0)	INTEGER NOT NULL	Primary Address - Sold To
26	ADDR_OVRD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Address Override Level D=Demand Line H=Header L=Line S=Schedule
27	ADDR_OVRDSD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Sold-to Override Level
28	ADJUSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Adjusted Flag H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments
29	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
30	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type
31	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category
32	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory
33	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type
34	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
35	COMBO_VALID_FLG	Character(1)	VARCHAR2(1) NOT NULL	ChartField Combinatn Valid Flg ?=Validation in Progress V=Valid ChartField Combination X=Invalid ChartField Combo
36	CNTCT_SEQ_BILL	Number(5,0)	INTEGER NOT NULL	Contact Sequence - Bill To
37	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
38	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
39	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
40	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
41	CANCEL_DATE	Date(10)	DATE	Cancel Date
42	CANCEL_REASON	Character(10)	VARCHAR2(10) NOT NULL	Cancel Reason
43	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
44	EST_RETURN_DTTM	DateTime(26)	TIMESTAMP	Estimated Return DateTime
45	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes Y/N Table Edit Default Value: N
46	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
47	PYMNT_TERMS_CD	Character(5)	VARCHAR2(5) NOT NULL	Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
48	RATE_DATE	Date(10)	DATE	Exchange Rate Date
49	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
50	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
51	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code
52	RESTOCK_FEE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Restocking Fee Y/N Table Edit
53	RETURN_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Return From Location
54	RETURN_TO_IBU	Character(5)	VARCHAR2(5) NOT NULL	Return To IBU
55	RETURN_TYPE_CD	Character(10)	VARCHAR2(10) NOT NULL	Return Type Code
56	RMA_APPROVED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approval Required Y/N Table Edit
57	RMA_DATE	Date(10)	DATE	RMA Date
58	RMA_STATUS	Character(2)	VARCHAR2(2) NOT NULL	RMA Status C=Closed O=Open P=Pending X=Canceled
59	RMA_PRINT_COUNT	Number(3,0)	SMALLINT NOT NULL	RMA Print Count
60	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.
61	RMA_TYPE	Character(1)	VARCHAR2(1) NOT NULL	RMA Type I=Inventory RMA O=Order Management RMA
62	SPEEDTYPE_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedType Key
63	LAST_RMA_PRINT_DT	Date(10)	DATE	Last RMA Print Date
64	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
65	LAST_DTTM_RMA_UPD	DateTime(26)	TIMESTAMP	Last dttm RMA update
66	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
67	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID