RTV_LN_FEE_FS

(SQL View)

SELECT A.BUSINESS_UNIT , A.RTV_ID , A.RTV_LN_NBR , A.MISC_CHARGE_CODE , A.AP_DISTRIB_STATUS , A.COST_ELEMENT , A.CURRENCY_CD , A.DST_ACCT_TYPE , A.FEE_ACTION , A.FEE_AMOUNT , A.FEE_PERCENT , A.LC_ACCRUAL_FLAG , A.LC_COMP_FLAG , A.PROCESS_FLAG , A.PROCESS_INSTANCE , A.RETURN_REASON , A.UNIT_PRICE_LC FROM PS_RTV_LN_FEE A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

3 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

4 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
Prompt Table: CM_LC_COMPONENT

5 AP_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AP Distribution Status

6 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

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

8 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

9 FEE_ACTION Character(2) VARCHAR2(2) NOT NULL Fee Action
CR=Credit
DB=Debit

10 FEE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The transaction fee amount.

11 FEE_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Fee Percent

12 LC_ACCRUAL_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. Indicates whether this landed cost component is typically accrued upon receipt (i.e., included in inventory value) or whether it is expensed.

13 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

14 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N

15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
Default Value: 0

16 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: RETURN_REASONS

17 UNIT_PRICE_LC Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price -Landed Cost

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
3	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
4	MISC_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Prompt Table: CM_LC_COMPONENT
5	AP_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AP Distribution Status
6	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
9	FEE_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Fee Action CR=Credit DB=Debit
10	FEE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The transaction fee amount.
11	FEE_PERCENT	Number(6,2)	DECIMAL(5,2) NOT NULL	Fee Percent
12	LC_ACCRUAL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement. Indicates whether this landed cost component is typically accrued upon receipt (i.e., included in inventory value) or whether it is expensed.
13	LC_COMP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
14	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least Default Value: N
15	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance Default Value: 0
16	RETURN_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reason Code Prompt Table: RETURN_REASONS
17	UNIT_PRICE_LC	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Unit Price -Landed Cost