RTV_ITM_FEE_VW

(SQL View)
 Index Back

RTV Default Item Fees View


SELECT A.SETID , A.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.MISC_CHARGE_CODE , A.RETURN_REASON , A.FEE_ACTION , A.FEE_PERCENT , B.COST_ELEMENT , B.DST_ACCT_TYPE , B.LC_ACCRUAL_FLAG , B.LC_COMP_FLAG FROM PS_ITM_VND_RTV_FEE A , PS_CM_LC_COMPONENT B WHERE A.SETID = B.SETID AND A.MISC_CHARGE_CODE = B.MISC_CHARGE_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
7 RETURN_REASON Character(10) VARCHAR2(10) NOT NULL Reason Code
8 FEE_ACTION Character(2) VARCHAR2(2) NOT NULL Fee Action
CR=Credit
DB=Debit
9 FEE_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Fee Percent
10 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
11 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
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.

Y/N Table Edit

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

Y/N Table Edit