BUSINESS_UNIT_INBUSINESS_UNITSOURCE_BUS_UNITEU=European Union
GB=United Kingdom
Prompt Table: NATURE_TXN2_USE
IST_RCNTRY2_TAO(SQL Table) |
Index Back |
|---|---|
Intrastat IN BU Countries |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 2 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | SOURCE_BUS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 7 | 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 |
| 8 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |