RECV_VAL_ADJ_VW

(SQL View)
 Index Back

Recv view of PO val Adjustment


SELECT V.BUSINESS_UNIT , V.PO_ID , V.LINE_NBR , V.SCHED_NBR , V.MISC_CHARGE_CODE , V.CURRENCY_CD , V.LC_COMP_FLAG , V.LC_ACCRUAL_FLAG , V.LC_COMP_ON_PO , V.UNIT_PRICE_LC , V.LC_RTV_CREDIT FROM PS_PO_VAL_ADJ V WHERE V.MISC_CHARGE_CODE <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 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

8 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.
9 LC_COMP_ON_PO 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 included on the Purchase order to the merchandise supplier
10 UNIT_PRICE_LC Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price -Landed Cost
11 LC_RTV_CREDIT Character(1) VARCHAR2(1) NOT NULL Return to Vendor for Credit

Y/N Table Edit