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 |