IST_STATVAL_TBL

(SQL Table)
Index Back

Intrastat Statistical Value

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: EU_MEMBER_VW

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

Prompt Table: COMMOD_CODE_EU

4 IST_MEMBER_STATE Character(3) VARCHAR2(3) NOT NULL Country of Cons/Dest

Prompt Table: EU_MEMBER_VW

5 PORT_AIRPORT Character(4) VARCHAR2(4) NOT NULL Port or Airport

Prompt Table: PORT_AIRPRT_VW2

6 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
7 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
8 IST_STATVAL_ENTER Signed Number(17,8) DECIMAL(15,8) NOT NULL Statistical Value Factor
9 MULT_DIV_FLG Character(1) VARCHAR2(1) NOT NULL Multiply or Divide
D=Divide
M=Multiply
10 IST_STATVAL_FACTOR Signed Number(17,8) DECIMAL(15,8) NOT NULL Statistical Value Factor