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 |