CDT_RMA_I_LN_VW (SQL View)	Index Back
CDT RMA Line View Date Initials Issue Description 03/07/01 dms SP2 (F-CJORGENS-3) CSR Desktop 06/26/01 JJM F-FSELK-11 Proj. Gemini chartfield changes

CDT_RMA_I_LN_VW

(SQL View)

CDT RMA Line View

Date Initials Issue Description 03/07/01 dms SP2 (F-CJORGENS-3) CSR Desktop 06/26/01 JJM F-FSELK-11 Proj. Gemini chartfield changes

SELECT r.business_unit , r.rma_id , r.rma_line_nbr , r.prod_id_entered , r.ref_bus_unit_om , r.ref_order_no , r.ref_line_nbr , r.prod_id_src , r.product_id , p.descr , r.prod_id_ordered , r.ref_bus_unit_in , r.ref_demd_line_nbr , r.ref_inv_item_id , r.ref_sched_nbr , r.account , r.altacct , r.deptid , r.project_id , %subrec(cf16_an_sbr,r) , r.address_seq_num , r.addr_ovrd_level , r.business_unit_om , r.cancel_date , r.cancel_reason , r.carrier_id , r.config_code , r.currency_cd , r.currency_cd_base , r.activity_id , r.resource_type , r.resource_category , r.resource_sub_cat , r.analysis_type , r.business_unit_pc , r.combo_valid_flg , r.credit_action , r.credit_flg , r.customer_po , r.distrib_type , r.est_return_dttm , r.freight_terms , r.inv_item_id , r.ist_txn_flg , r.net_unit_price , r.net_unit_price_bse , r.order_action , r.order_no , r.order_int_line_no , r.qty_returned , r.qty_returned_base , r.rate_date , r.rate_div , r.rate_mult , r.reason_cd , r.receipt_flag , r.ref_document_id , r.return_fr_cust_id , r.return_from_bu , r.return_from_loc , r.return_from_option , r.return_to_ibu , r.return_type_cd , r.rma_line_status , r.rma_print_method , r.rt_type , r.ship_type_id , r.speedtype_key , r.store_number , r.tax_cust_group , r.unit_of_measure , r.datetime_added , r.lastupddttm , r.last_maint_oprid FROM ps_rma_line r , ps_set_cntrl_rec sc , PS_MASTER_ITEM_TBL p WHERE sc.setcntrlvalue = r.business_unit AND sc.recname = 'MASTER_ITEM_TBL' AND sc.setid = p.setid AND r.inv_item_id = p.inv_item_id

Related Language Record: CDT_RMA_I_LNLVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_FS_NONVW

2 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
Prompt Table: RMA_HEADER

3 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
Default Value: 1

4 PROD_ID_ENTERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered
Prompt Table: %EDITTABLE10

5 REF_BUS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Reference Order Management Business Unit

6 REF_ORDER_NO Character(10) VARCHAR2(10) NOT NULL Referenced Order Nbr

7 REF_LINE_NBR Number(5,0) INTEGER NOT NULL Reference Line Number

8 PROD_ID_SRC Character(1) VARCHAR2(1) NOT NULL Product Source
C=Customer
P=UPC
S=System
U=Universal
Default Value: S

9 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description

11 PROD_ID_ORDERED Character(20) VARCHAR2(20) NOT NULL Product ID Entered

12 REF_BUS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Ref business unit IN

13 REF_DEMD_LINE_NBR Number(4,0) SMALLINT NOT NULL Ref Demand Line Nbr

14 REF_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Referenced Inv Item ID

15 REF_SCHED_NBR Number(6,0) INTEGER NOT NULL Referenced Schedule Number

16 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
Prompt Table: %EDIT_ACCOUNT

17 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
Prompt Table: %EDIT_ALTACCT

18 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPTID_BUGL_VW

19 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

20 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

21 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

22 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

23 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

24 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

25 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

26 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

27 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

28 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

29 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

30 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

31 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

32 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
Prompt Table: %EDITTABLE8

33 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule

34 BUSINESS_UNIT_OM Character(5) VARCHAR2(5) NOT NULL Order Management Business Unit

35 CANCEL_DATE Date(10) DATE Cancel Date

36 CANCEL_REASON Character(10) VARCHAR2(10) NOT NULL Cancel Reason
Prompt Table: RMA_CNCLRSN_VW

37 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
Prompt Table: CARRIER_ID

38 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
Prompt Table: RMA_CPCFG_VW

39 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

40 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

41 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PROJ_ACT_FS

42 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS

43 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT

44 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB

45 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Default Value: INSTALLATION_PC.AN_TYPE_IN
Prompt Table: PROJ_ANTYPE_FS

46 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: SP_BU_PC_NONVW

47 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo

48 CREDIT_ACTION Character(2) VARCHAR2(2) NOT NULL Credit Action
00=No Action
01=Unknown
02=Issue Credit Now
03=Issue Credit Upon Receipt

49 CREDIT_FLG Character(1) VARCHAR2(1) NOT NULL Credit Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

50 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO

51 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
Prompt Table: DISTR_IBU_VW
Set Control Field: BUSINESS_UNIT

52 EST_RETURN_DTTM DateTime(26) TIMESTAMP Estimated Return DateTime

53 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
Prompt Table: FREIGHT_TERMS

54 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: BU_ITM_INV_VW

55 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N

56 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price

57 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

58 ORDER_ACTION Character(2) VARCHAR2(2) NOT NULL Sales Order Action
00=No Action
01=Unknown
02=Replace Prior to Receipt
03=Replace After Receipt

59 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

60 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

61 QTY_RETURNED Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned

62 QTY_RETURNED_BASE Number(16,4) DECIMAL(15,4) NOT NULL Quantity Returned Base

63 RATE_DATE Date(10) DATE Exchange Rate Date

64 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

65 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

66 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: RMA_REASON_VW

67 RECEIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Received Complete
Y/N Table Edit
Default Value: N

68 REF_DOCUMENT_ID Character(10) VARCHAR2(10) NOT NULL Reference Document ID

69 RETURN_FR_CUST_ID Character(15) VARCHAR2(15) NOT NULL Return From Cust ID
Prompt Table: %EDITTABLE6

70 RETURN_FROM_BU Character(5) VARCHAR2(5) NOT NULL Return From Location
Prompt Table: RMA_LOCATION_VW

71 RETURN_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Return From Location
Prompt Table: RMA_LOCATION_VW

72 RETURN_FROM_OPTION Character(1) VARCHAR2(1) NOT NULL Return From Option
E=External Customer
I=Internal Location

73 RETURN_TO_IBU Character(5) VARCHAR2(5) NOT NULL Return To IBU
Prompt Table: SP_BUIN_NONVW

74 RETURN_TYPE_CD Character(10) VARCHAR2(10) NOT NULL Return Type Code
Prompt Table: RMA_RETURN_TYPE

75 RMA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
C=Closed
O=Open
P=Pending
X=Canceled

76 RMA_PRINT_METHOD Character(1) VARCHAR2(1) NOT NULL Print Method
1=Printer
2=File
3=Email
4=Fax
Default Value: 1

77 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.

78 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD

79 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key
Prompt Table: %EDITTABLE40
Set Control Field: BUSINESS_UNIT

80 STORE_NUMBER Character(17) VARCHAR2(17) NOT NULL Store Number

81 TAX_CUST_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Customer Group
Prompt Table: CUST_TAXGPSH_VW

82 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: %EDITTABLE11

83 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

84 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.

85 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_FS_NONVW
2	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number Prompt Table: RMA_HEADER
3	RMA_LINE_NBR	Number(5,0)	INTEGER NOT NULL	RMA Line Number Default Value: 1
4	PROD_ID_ENTERED	Character(20)	VARCHAR2(20) NOT NULL	Product ID Entered Prompt Table: %EDITTABLE10
5	REF_BUS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Reference Order Management Business Unit
6	REF_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Referenced Order Nbr
7	REF_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Reference Line Number
8	PROD_ID_SRC	Character(1)	VARCHAR2(1) NOT NULL	Product Source C=Customer P=UPC S=System U=Universal Default Value: S
9	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	PROD_ID_ORDERED	Character(20)	VARCHAR2(20) NOT NULL	Product ID Entered
12	REF_BUS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Ref business unit IN
13	REF_DEMD_LINE_NBR	Number(4,0)	SMALLINT NOT NULL	Ref Demand Line Nbr
14	REF_INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Referenced Inv Item ID
15	REF_SCHED_NBR	Number(6,0)	INTEGER NOT NULL	Referenced Schedule Number
16	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: %EDIT_ACCOUNT
17	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: %EDIT_ALTACCT
18	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
19	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
20	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
21	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
22	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
23	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
24	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
25	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
26	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
27	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
28	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
29	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
30	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
31	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
32	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number Prompt Table: %EDITTABLE8
33	ADDR_OVRD_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Address Override Level D=Demand Line H=Header L=Line S=Schedule
34	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
35	CANCEL_DATE	Date(10)	DATE	Cancel Date
36	CANCEL_REASON	Character(10)	VARCHAR2(10) NOT NULL	Cancel Reason Prompt Table: RMA_CNCLRSN_VW
37	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: CARRIER_ID
38	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator Prompt Table: RMA_CPCFG_VW
39	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
40	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
41	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_FS
42	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RESTYPE_FS
43	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDIT_RES_CAT
44	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDIT_RES_SUB
45	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Default Value: INSTALLATION_PC.AN_TYPE_IN Prompt Table: PROJ_ANTYPE_FS
46	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: SP_BU_PC_NONVW
47	COMBO_VALID_FLG	Character(1)	VARCHAR2(1) NOT NULL	ChartField Combinatn Valid Flg ?=Validation in Progress V=Valid ChartField Combination X=Invalid ChartField Combo
48	CREDIT_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Credit Action 00=No Action 01=Unknown 02=Issue Credit Now 03=Issue Credit Upon Receipt
49	CREDIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Credit Flag N=No Y=Yes Y/N Table Edit Default Value: N
50	CUSTOMER_PO	Character(25)	VARCHAR2(25) NOT NULL	Customer PO
51	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type Prompt Table: DISTR_IBU_VW Set Control Field: BUSINESS_UNIT
52	EST_RETURN_DTTM	DateTime(26)	TIMESTAMP	Estimated Return DateTime
53	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
54	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: BU_ITM_INV_VW
55	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes Y/N Table Edit Default Value: N
56	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
57	NET_UNIT_PRICE_BSE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
58	ORDER_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Sales Order Action 00=No Action 01=Unknown 02=Replace Prior to Receipt 03=Replace After Receipt
59	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
60	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
61	QTY_RETURNED	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Returned
62	QTY_RETURNED_BASE	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Returned Base
63	RATE_DATE	Date(10)	DATE	Exchange Rate Date
64	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
65	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
66	REASON_CD	Character(10)	VARCHAR2(10) NOT NULL	Reason Code Prompt Table: RMA_REASON_VW
67	RECEIPT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Received Complete Y/N Table Edit Default Value: N
68	REF_DOCUMENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Reference Document ID
69	RETURN_FR_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Return From Cust ID Prompt Table: %EDITTABLE6
70	RETURN_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Return From Location Prompt Table: RMA_LOCATION_VW
71	RETURN_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Return From Location Prompt Table: RMA_LOCATION_VW
72	RETURN_FROM_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Return From Option E=External Customer I=Internal Location
73	RETURN_TO_IBU	Character(5)	VARCHAR2(5) NOT NULL	Return To IBU Prompt Table: SP_BUIN_NONVW
74	RETURN_TYPE_CD	Character(10)	VARCHAR2(10) NOT NULL	Return Type Code Prompt Table: RMA_RETURN_TYPE
75	RMA_LINE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Line Status C=Closed O=Open P=Pending X=Canceled
76	RMA_PRINT_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Print Method 1=Printer 2=File 3=Email 4=Fax Default Value: 1
77	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.
78	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
79	SPEEDTYPE_KEY	Character(10)	VARCHAR2(10) NOT NULL	SpeedType Key Prompt Table: %EDITTABLE40 Set Control Field: BUSINESS_UNIT
80	STORE_NUMBER	Character(17)	VARCHAR2(17) NOT NULL	Store Number
81	TAX_CUST_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Tax Customer Group Prompt Table: CUST_TAXGPSH_VW
82	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: %EDITTABLE11
83	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
84	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.
85	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID