| # |
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_EXCPN_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Intrastat Exception Code
Prompt Table:
%EDITTABLE
|
| 4 |
IST_EXCPN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Exception Type
F=Fiscal Regime
N=Nature of Txn 2nd Digit
S=Statistical Procedure
|
| 5 |
IST_CNTRY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Country Dest/Cons Required
Y/N Table Edit
Default Value: N
|
| 6 |
IST_REGION_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Region Requiredxxxxxxxxxxxxxxx
Y/N Table Edit
Default Value: N
|
| 7 |
IST_DLVYTRM1_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 1 Required
Y/N Table Edit
Default Value: N
|
| 8 |
IST_DLVYTRM2_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 2 Required
Y/N Table Edit
Default Value: N
|
| 9 |
IST_NOTC1_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
NOTC 1st Digit Required
Y/N Table Edit
Default Value: N
|
| 10 |
IST_NOTC2_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
NOTC 2nd Digit Required
Y/N Table Edit
Default Value: N
|
| 11 |
IST_TMODE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Mode Of Transport Required
Y/N Table Edit
Default Value: N
|
| 12 |
IST_PORT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Port/Airport Requiredxxxxxxxxx
Y/N Table Edit
|
| 13 |
IST_COMMCODE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
EU Commodity Code Required
Y/N Table Edit
Default Value: N
|
| 14 |
IST_ORIGIN_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Country of Origin Required
Y/N Table Edit
Default Value: N
|
| 15 |
IST_NETMASS_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Mass Required
Y/N Table Edit
Default Value: N
|
| 16 |
IST_SUNIT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplementary Units Required
Y/N Table Edit
Default Value: N
|
| 17 |
IST_INVAMT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Amount Required
Y/N Table Edit
Default Value: N
|
| 18 |
IST_STATVAL_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical Value Required
Y/N Table Edit
Default Value: N
|
| 19 |
IST_TPRTNR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partner Reg Required
Y/N Table Edit
Default Value: N
|