IST_RPT_INST2VW

(SQL View)
 Index Back

View for IDEP file


SELECT PS_IST_RPT_INST2.PROCESS_INSTANCE , PS_IST_RPT_INST2.IST_FLOW , PS_IST_RPT_INST2.COMMODITY_CD_EU , %Substring(PS_IST_RPT_INST2.COMMODITY_CD_EU, 9,1) , PS_IST_RPT_INST2.NATURE_OF_TXN1 , PS_IST_RPT_INST2.NATURE_OF_TXN2 , PS_IST_RPT_INST2.FISCAL_REGIME , PS_IST_RPT_INST2.IST_MEMBER_STATE , PS_IST_RPT_INST2.COUNTRY_IST_ORIGIN , PS_IST_RPT_INST2.IST_REGION , PS_IST_RPT_INST2.NET_MASS , PS_IST_RPT_INST2.SUPPLMNTRY_UNITS , %Substring(PS_IST_RPT_INST2.COUNTRY_VAT_TPRTNR, 1,2) %Concat %Substring(PS_IST_RPT_INST2.VAT_RGSTRN_TPRTNR, 1,18) , PS_IST_RPT_INST2.IST_TRANSPORT_MODE , PS_IST_RPT_INST2.IST_INV_AMT_RPTG , PS_IST_RPT_INST2.IST_STAT_VAL_RPTG , PS_IST_RPT_INST2.IST_DELIVERY_TRM1 , PS_IST_RPT_INST2.IST_DELIVERY_TRM2 FROM PS_IST_RPT_INST2 PS_IST_RPT_INST2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 IST_FLOW Character(1) VARCHAR2(1) NOT NULL Intrastat Report Flow
A=Arrivals
D=Dispatches
3 COMMODITY_CD_EU Character(10) VARCHAR2(10) NOT NULL EU Commodity Code
4 ADD_COMMODITY_CD Character(1) VARCHAR2(1) NOT NULL Additional Commodity Code
5 NATURE_OF_TXN1 Character(1) VARCHAR2(1) NOT NULL Nature of Transaction 1
6 NATURE_OF_TXN2 Character(1) VARCHAR2(1) NOT NULL Nature of Transaction 2
7 FISCAL_REGIME Character(6) VARCHAR2(6) NOT NULL Fiscal Regime
8 IST_MEMBER_STATE Character(3) VARCHAR2(3) NOT NULL Country of Cons/Dest
9 COUNTRY_IST_ORIGIN Character(3) VARCHAR2(3) NOT NULL Intrastat Country of Origin
10 IST_REGION Character(4) VARCHAR2(4) NOT NULL Region of Origin/Destination
11 NET_MASS Number(6,0) INTEGER NOT NULL Net Mass in KG
12 SUPPLMNTRY_UNITS Number(6,0) INTEGER NOT NULL Supplementary Units
13 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20
14 IST_TRANSPORT_MODE Character(1) VARCHAR2(1) NOT NULL Mode of Transport for Intrastat Reporting
1=Transport by Sea
2=Transport by Rail
3=Transport by Road
4=Transport by Air
5=Consignments by Post
7=Fixed Transport Installations
8=Transport by Inland Waterway
9=Own Propulsion
15 IST_INV_AMT_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount - Reporting
16 IST_STAT_VAL_RPTG Signed Number(28,3) DECIMAL(26,3) NOT NULL Statistical Value - Reporting
17 IST_DELIVERY_TRM1 Character(3) VARCHAR2(3) NOT NULL Delivery Terms 1
CFR=Cost and Freight
CIF=Cost, Insurance, Freight
CIP=Carriage and Insurance Paid To
CPT=Carriage Paid To
DAF=Delivered at Frontier
DDP=Delivered Duty Paid
DDU=Delivered Duty Unpaid
DEQ=Delivered Ex-Quay
DES=Delivered Ex-Ship
EXW=Ex-Works
FAS=Free Alongside Ship
FCA=Franco Carrier
FOB=Free on Board
XXX=Other Delivery Terms
18 IST_DELIVERY_TRM2 Character(1) VARCHAR2(1) NOT NULL Delivery Terms 2
1=Place in Reporting Country
2=Place in Other EU Country
3=Place in Other Non-EU Country