IST_STATVAL_TBL(SQL Table) |
Index Back |
|---|---|
Intrastat Statistical Value |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: EU_MEMBER_VW |
|
| 2 | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Report Flow
A=Arrivals D=Dispatches |
|
| 3 | Character(10) | VARCHAR2(10) NOT NULL |
EU Commodity Code
Prompt Table: COMMOD_CODE_EU |
|
| 4 | Character(3) | VARCHAR2(3) NOT NULL |
Country of Cons/Dest
Prompt Table: EU_MEMBER_VW |
|
| 5 | Character(4) | VARCHAR2(4) NOT NULL |
Port or Airport
Prompt Table: PORT_AIRPRT_VW2 |
|
| 6 | 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 | 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 |