RCV_LN_SH_LC_VW

(SQL View)
Index Back

Rcpt Landed Cost Dtl View

02/28/99 ebn CN#CM800-2.0: Added for Landed Cost Enhancement 03/22/01 R-DWEAVE-WC593 Display only Accrued Charges.

SELECT BUSINESS_UNIT ,RECEIVER_ID ,RECV_LN_NBR ,RECV_SHIP_SEQ_NBR ,MISC_CHARGE_CODE ,BUSINESS_UNIT_PO ,PO_ID ,LINE_NBR ,SCHED_NBR ,COST_ELEMENT ,LC_ACCRUAL_FLAG ,LC_COMP_FLAG ,LC_COMP_ON_PO ,LC_RTV_CREDIT ,CURRENCY_CD , MISC_CHG_AMT ,UNIT_PRICE_LC ,MATCH_STATUS_LC ,PPV_POST_FLG ,PROCESS_FLAG ,PROCESS_INSTANCE FROM PS_RECV_LN_SHIP_LC WHERE LC_ACCRUAL_FLAG = 'Y'

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

12 LC_COMP_FLAG Character(1) VARCHAR2(1) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
13 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
14 LC_RTV_CREDIT Character(1) VARCHAR2(1) NOT NULL Return to Vendor for Credit
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 MISC_CHG_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL 11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement
17 UNIT_PRICE_LC Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price -Landed Cost
18 MATCH_STATUS_LC Number(1,0) SMALLINT NOT NULL 03/14/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

Default Value: 2

19 PPV_POST_FLG Character(1) VARCHAR2(1) NOT NULL PPV Post Flag

Default Value: N

20 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

Default Value: N

21 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance