BUSINESS_UNITSHIPTO_IDIST_FLOWA=Arrivals
D=Dispatches
EU=European Union
GB=United Kingdom
Prompt Table: NATURE_TXN2_USE
IST_SHIPTO_TAO(SQL Table) |
Index Back |
|---|---|
Intrastat Shipto Countries |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SHIPTO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 3 | IST_FLOW |
Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Report Flow
A=Arrivals D=Dispatches |
| 4 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 5 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 6 | 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 |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |