| # |
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 |
IST_VATREG_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Registration ID Required
Y/N Table Edit
Default Value: N
|
| 4 |
IST_VATREG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Registration Display
N=No Prefix
P=With Prefix
|
| 5 |
IST_VATREG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Vat Registration Country Type
2=2 Char
3=3 Char
N=3 Numeric
|
| 6 |
IST_VATREG_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Registration ID Source
L=Local Tax ID
V=VAT Registration ID
|
| 7 |
IST_DESCR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Goods Description Required
Y/N Table Edit
Default Value: N
|
| 8 |
IST_CNTRY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Country Dest/Cons Required
Default Value: N
|
| 9 |
IST_CNTRY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Country of Cons/Dest Type
2=2 Char
3=3 Char
N=3 Numeric
|
| 10 |
IST_REGION_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Region Requiredxxxxxxxxxxxxxxx
Y/N Table Edit
Default Value: N
|
| 11 |
IST_DLVYTRM1_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 1 Required
Y/N Table Edit
Default Value: N
|
| 12 |
IST_DLVYTRM2_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 2 Required
Y/N Table Edit
Default Value: N
|
| 13 |
IST_NOTC1_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
NOTC 1st Digit Required
Y/N Table Edit
Default Value: N
|
| 14 |
IST_NOTC2_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
NOTC 2nd Digit Required
Y/N Table Edit
Default Value: N
|
| 15 |
IST_TMODE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Mode Of Transport Required
Y/N Table Edit
Default Value: N
|
| 16 |
IST_PORT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Port/Airport Requiredxxxxxxxxx
Y/N Table Edit
Default Value: N
|
| 17 |
IST_COMMCODE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
EU Commodity Code Required
Y/N Table Edit
Default Value: N
|
| 18 |
IST_ORIGIN_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Country of Origin Required
Y/N Table Edit
Default Value: N
|
| 19 |
IST_ORIGIN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Country of Origin Type
2=2 Character
3=3 Character
N=3 Numeric
|
| 20 |
IST_STATPROC_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical Procedure Required
Y/N Table Edit
Default Value: N
|
| 21 |
IST_FISCREG_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Fiscal Regime Required flag
Y/N Table Edit
Default Value: N
|
| 22 |
IST_NETMASS_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Mass Required
Y/N Table Edit
Default Value: N
|
| 23 |
IST_NETMASS_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Mass Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
Default Value: N
|
| 24 |
IST_SUNIT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplementary Units Required
Y/N Table Edit
Default Value: N
|
| 25 |
IST_SUNIT_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppl Unit Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
Default Value: N
|
| 26 |
IST_INVAMT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Amount Required
Y/N Table Edit
Default Value: N
|
| 27 |
IST_INVAMT_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Amount Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
Default Value: N
|
| 28 |
IST_STATVAL_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical Value Required
Y/N Table Edit
Default Value: N
|
| 29 |
IST_STATVAL_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Stat Value Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
Default Value: N
|
| 30 |
IST_TPRTNR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partner Reg Required
Y/N Table Edit
Default Value: N
|
| 31 |
IST_TPRTNR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partner Display
N=No Prefix
P=With Prefix
|
| 32 |
IST_TPRTNR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partner Country Type
2=2 Char
3=3 Char
N=3 Numeric
|
| 33 |
IST_EXCPN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Exception Type
F=Fiscal Regime
N=Nature of Txn 2nd Digit
S=Statistical Procedure
|
| 34 |
NATURE_TXN2_USE |
Character(2) |
VARCHAR2(2) NOT NULL |
Nature of transaction secon ddigit use
EU=European Union
GB=United Kingdom
Prompt Table:
NATURE_TXN2_USE
|
| 35 |
IST_FINADJ_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Financial Adjustments
Y/N Table Edit
Default Value: N
|
| 36 |
IST_FINADJ_NOTC1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Financial Adjustment Notice
Y/N Table Edit
Default Value: N
|
| 37 |
IST_FINADJ_NOTC2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Financial Adjustment Notice
Y/N Table Edit
Default Value: N
|
| 38 |
IST_PORT_KEY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Port/Airport Key Required
Y/N Table Edit
Default Value: N
|
| 39 |
IST_DLVY1_KEY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 1 Key Required
Y/N Table Edit
Default Value: N
|
| 40 |
IST_TMODE_KEY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Mode Of Transport Key Required
Y/N Table Edit
Default Value: N
|