EXD_VN_BOESR_VW

(SQL View)
 Index Back

BOE Header search view

use by Supplier Excise Invoice processing

SELECT A.BUSINESS_UNIT , A.BOE_TYPE , A.BILL_OF_ENTRY , A.BILL_OF_LADING , A.BOE_DATE , A.BOE_STATUS , A.BOND_WHSE_LIC_NO , A.BOND_WHSE_VAL_DT , A.BOL_DATE , A.CHA_CODE , A.CUSTOMS_BOE_DT , A.CUSTOMS_BOE_ID , A.CUSTOMS_HOUSE_ID , A.INVOICE_ID , A.ORG_IE_CODE , A.PORT_CODE FROM PS_BOE_HDR A WHERE A.BOE_STATUS IN ('A', 'C') AND A.BOE_TYPE <> '2' AND EXISTS ( SELECT 'X' FROM PS_EXD_VN_BOELN_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_FROM AND A.BOE_TYPE = B.BOE_TYPE AND A.BILL_OF_ENTRY = B.BILL_OF_ENTRY)

# 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 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
5 BOE_DATE Date(10) DATE Bill of Entry Date

Default Value: %Date

6 BOE_STATUS Character(1) VARCHAR2(1) NOT NULL Bill of Entry Status
A=Assessed
C=Closed
H=Hold
O=Open
R=Ready
7 BOND_WHSE_LIC_NO Character(20) VARCHAR2(20) NOT NULL Bonded Warehouse License
8 BOND_WHSE_VAL_DT Date(10) DATE Bonded Warehouse Validity Date
9 BOL_DATE Date(10) DATE Bill of Lading Date
10 CHA_CODE Character(30) VARCHAR2(30) NOT NULL Customs House Agent Code
11 CUSTOMS_BOE_DT Date(10) DATE Customs BOE Date
12 CUSTOMS_BOE_ID Character(10) VARCHAR2(10) NOT NULL Customs BOE Reference ID
13 CUSTOMS_HOUSE_ID Character(10) VARCHAR2(10) NOT NULL Customs House Number
14 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
15 ORG_IE_CODE Character(20) VARCHAR2(20) NOT NULL Import Export Code for an Organization.This field will be used for Customs duty.
16 PORT_CODE Character(5) VARCHAR2(5) NOT NULL Port Code