RMA_PRICE_SCHED

(SQL Table)
Index Back

RMA Pricing Schedule

RMA Pricing Schedule

# 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

Prompt Table: RMA_HEADER

3 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number

Default Value: 1

4 PRC_SCHED_NBR Number(6,0) INTEGER NOT NULL Pricing Schedule Number
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
7 QTY_RETURNED Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned
8 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
9 NET_UNIT_PRICE_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)
10 PRICING_QTY Number(16,4) DECIMAL(15,4) NOT NULL Pricing quantity.
11 PRC_NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
12 PRC_NET_UNIT_BSE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)