EXD_VN_BOELN_VW

(SQL View)
 Index Back

BOE view for Excise Inv


SELECT A.BUSINESS_UNIT , A.BOE_TYPE , A.BILL_OF_ENTRY , A.BOE_LINE_NBR , B.BILL_OF_LADING , 'N' , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.DESCR254_MIXED , A.INV_ITEM_ID , A.ITM_SETID , A.MERCH_AMT_BSE , A.MERCHANDISE_AMT , A.UNIT_PRICE , 0 , A.QTY_STD , A.QTY_PO , A.UOM_PO , A.UNIT_OF_MEASURE , A.BUSINESS_UNIT_PO , A.PO_ID , A.PO_LINE_NBR , A.PO_SCHED_NBR , A.RT_TYPE , C.SHIPTO_ID , H.VENDOR_SETID , H.VENDOR_ID , H.VNDR_LOC FROM PS_BOE_LN A , PS_BOE_HDR B , PS_PO_LINE_SHIP C , PS_PO_HDR H WHERE A.BOE_STATUS = 'C' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BOE_TYPE = B.BOE_TYPE AND A.BILL_OF_ENTRY = B.BILL_OF_ENTRY AND A.BUSINESS_UNIT_PO = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID AND A.PO_LINE_NBR = C.LINE_NBR AND A.PO_SCHED_NBR = C.SCHED_NBR AND A.BUSINESS_UNIT_PO = H.BUSINESS_UNIT AND A.PO_ID = H.PO_ID AND NOT EXISTS ( SELECT 'X' FROM PS_EXD_VND_INV_LN I WHERE A.BUSINESS_UNIT = I.BUSINESS_UNIT_FROM AND A.BOE_TYPE = I.BOE_TYPE AND A.BILL_OF_ENTRY = I.BILL_OF_ENTRY AND A.BOE_LINE_NBR = I.BOE_LINE_NBR )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From
2 BOE_TYPE Character(1) VARCHAR2(1) NOT NULL Bill Of Entry Type
1=Home Consumption
2=Warehousing
3=Ex-Bond
3 BILL_OF_ENTRY Character(10) VARCHAR2(10) NOT NULL Bill of Entry ID
4 BOE_LINE_NBR Number(5,0) INTEGER NOT NULL Bill of Entry Line Number
5 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
6 CB_SELECT_PO Character(1) VARCHAR2(1) NOT NULL Select PO Schedule Checkbox

Y/N Table Edit

Default Value: N

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
8 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
12 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
15 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base
16 QTY_SH_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Accepted Quantity
17 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
18 RECEIPT_UM Character(3) VARCHAR2(3) NOT NULL Receiving UOM
19 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
20 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
21 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
22 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
23 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
24 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
25 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
26 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
27 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
28 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location