BOE_WHSE_CLS_VW

(SQL View)
Index Back

Bill of Entry Line


SELECT A.BUSINESS_UNIT ,a.boe_type , A.BILL_OF_ENTRY , A.BOE_LINE_NBR , A.ASSESS_VALUE , A.ASSESS_VALUE_BSE , A.ASSESS_VALUE_RPT , A.BENEFIT_ID , A.BOE_STATUS , A.BSE_RATE_DATE , A.BSE_RATE_DIV , A.BSE_RATE_MULT , A.BSE_RT_TYPE , A.BUSINESS_UNIT_PO , A.CENVAT_POST_FLG , A.CATEGORY_ID , A.CIF_AMOUNT , A.CIF_AMOUNT_BSE , A.CIF_AMOUNT_RPT , A.CONVERSION_RATE , A.CSD_ITM_CATG_CD , A.CSD_NRCVRY_AMT , A.CSD_NRCVRY_AMT_BSE , A.CSD_NRCVRY_AMT_RPT , A.CSD_RCVRY_AMT , A.CSD_RCVRY_AMT_BSE , A.CSD_RCVRY_AMT_RPT , A.CSD_TAX_AMT , A.CSD_TAX_AMT_BSE , A.CSD_TAX_AMT_RPT , A.CSD_TPRTNR_CATG_CD , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.CURRENCY_CD_RPT , A.DESCR254_MIXED , A.EXEMPTION_ID , A.FREIGHT_AMT , A.FREIGHT_AMT_BSE , A.FREIGHT_AMT_RPT , A.INSURANCE_CHARGE , A.INS_CHARGE_BSE , A.INS_CHARGE_RPT , A.INV_ITEM_ID , A.ITM_SETID , A.LANDING_CHARGES , A.LANDING_CHARGE_BSE , A.LANDING_CHARGE_RPT , A.MERCH_AMT_BSE , A.MERCH_AMT_RPT , A.MERCHANDISE_AMT , A.OTHER_COST , A.OTHER_COST_BSE , A.OTHER_COST_RPT , A.PO_ID , A.PO_LINE_NBR , A.PO_SCHED_NBR , A.QTY_BOE , A.QTY_PO , A.QTY_STD , A.RT_RATE , A.RT_TYPE , A.SHIPTO_SETID , A.SHIPTO_ID , A.UNIT_MEASURE_STD , A.UNIT_OF_MEASURE , A.UNIT_PRICE , A.UOM_PO , A.VENDOR_ID , A.VENDOR_SETID , A.VNDR_LOC , A.BUSINESS_UNIT_EXS , A.COUNTRY_SHIP_FROM , A.COUNTRY_SHIP_TO , A.CSD_TAX_CATG_CD , A.CSD_TAX_RATE_CD , A.EXS_TAX_TXN_TYPE , A.ORG_BU_TYPE , A.STATE_SHIP_FROM , A.STATE_SHIP_TO FROM PS_BOE_LN A , PS_BOE_HDR B WHERE A.BOE_TYPE IN ('2', '3') AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BILL_OF_ENTRY = B.BILL_OF_ENTRY AND B.BOE_STATUS = 'C' AND (A.QTY_BOE > ( SELECT SUM(C.QTY_BOE) FROM PS_BOE_LN C WHERE A.BUSINESS_UNIT_PO = C.BUSINESS_UNIT_PO AND A.PO_ID= C.PO_ID AND A.PO_LINE_NBR = C.PO_LINE_NBR AND A.PO_SCHED_NBR = C.PO_SCHED_NBR AND C.BOE_TYPE = '3') OR NOT EXISTS ( SELECT 'X'FROM PS_BOE_LN D WHERE A.BUSINESS_UNIT_PO = D.BUSINESS_UNIT_PO AND A.PO_ID= D.PO_ID AND A.PO_LINE_NBR = D.PO_LINE_NBR AND A.PO_SCHED_NBR = D.PO_SCHED_NBR AND D.BOE_TYPE = '3'))

# 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 BOE_REF_ID Character(10) VARCHAR2(10) NOT NULL Bill of Entry Reference ID
4 BOE_REF_LINE Number(5,0) INTEGER NOT NULL Bill of Entry Reference Line
5 ASSESS_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Assessable Value
6 ASSESS_VALUE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Assess Value in Base Currency
7 ASSESS_VALUE_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Assess Value Report Currency
8 BENEFIT_ID Character(10) VARCHAR2(10) NOT NULL Benefit Identification
9 BOE_STATUS Character(1) VARCHAR2(1) NOT NULL Bill of Entry Status
A=Assessed
C=Closed
H=Hold
O=Open
R=Ready

Default Value: O

10 BSE_RATE_DATE Date(10) DATE Exchange Rate Date
11 BSE_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Base Rate Divisor for Exchange Rates
12 BSE_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Base Rate Multiplier for Exchange Rates
13 BSE_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.
14 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
15 CENVAT_POST_FLG Character(1) VARCHAR2(1) NOT NULL CENVAT Posting

Y/N Table Edit

Default Value: N

16 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
17 CIF_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL CIF Amount
18 CIF_AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL CIF Amount in Base Currency
19 CIF_AMOUNT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL CIF Amount in Report Currency
20 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
21 CSD_ITM_CATG_CD Character(10) VARCHAR2(10) NOT NULL Customs Duty Item Category Code
22 CSD_NRCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
23 CSD_NRCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
24 CSD_NRCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty NonRecovery Amount
25 CSD_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
26 CSD_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
27 CSD_RCVRY_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Recovery Amount
28 CSD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Tax Amount
29 CSD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Amount Base
30 CSD_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Custom Duty Amount Reporting
31 CSD_TPRTNR_CATG_CD Character(10) VARCHAR2(10) NOT NULL Customs Duty Tax Category
32 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
33 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
34 CURRENCY_CD_RPT Character(3) VARCHAR2(3) NOT NULL Currency Code - Reporting
35 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
36 EXEMPTION_ID Character(10) VARCHAR2(10) NOT NULL Exemption Notification ID
37 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
38 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
39 FREIGHT_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount in Report Cur
40 INSURANCE_CHARGE Signed Number(20,2) DECIMAL(18,2) NOT NULL Insurance Charge
41 INS_CHARGE_BSE Signed Number(20,2) DECIMAL(18,2) NOT NULL Insurance charge in base cur
42 INS_CHARGE_RPT Signed Number(20,2) DECIMAL(18,2) NOT NULL Insurance charge in Report Cur
43 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
44 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
45 LANDING_CHARGES Signed Number(28,3) DECIMAL(26,3) NOT NULL Landing Charges
46 LANDING_CHARGE_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Landing Charges in Base
47 LANDING_CHARGE_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Landing Charges in Report Cur
48 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
49 MERCH_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Report Merchandise Amount
50 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
51 OTHER_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Cost
52 OTHER_COST_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Cost in Base Currency
53 OTHER_COST_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Other Cost in Report Currency
54 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
55 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
56 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
57 QTY_BOE Number(16,4) DECIMAL(15,4) NOT NULL Bill of Entry Quantity
58 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
59 QTY_STD Number(16,4) DECIMAL(15,4) NOT NULL Standard Quantity
60 RT_RATE Number(16,8) DECIMAL(15,8) NOT NULL Market Rate
61 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.
62 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
63 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
64 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
65 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

66 UNIT_PRICE Signed Number(17,5) DECIMAL(15,5) NOT NULL Unit Price
67 UOM_PO Character(3) VARCHAR2(3) NOT NULL Unit Of Measure PO
68 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
69 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
70 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
71 BUSINESS_UNIT_EXS Character(5) VARCHAR2(5) NOT NULL Excise Business Unit
72 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).

Prompt Table: COUNTRY_TBL

73 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

Prompt Table: COUNTRY_TBL

74 CSD_TAX_CATG_CD Character(10) VARCHAR2(10) NOT NULL Custom Tax Category

Prompt Table: EXS_TAX_CAT_VW2

75 CSD_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Customs Tax Rate Code
76 EXS_TAX_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import

Prompt Table: PO_TAX_EXS_TXNV

77 ORG_BU_TYPE Character(2) VARCHAR2(2) NOT NULL Business Unit Type. This field will have six translate values representing the various BUs
AP=Payables
AR=Receivables
BI=Billing
IN=Inventory
OM=Order Management
PO=Purchasing
78 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State
79 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State