IST_SCNTRY_TAO

(SQL Table)
Index Back

Intrastat IN BU Countries

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
3 STATE Character(6) VARCHAR2(6) NOT NULL State
4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 NOTC1_DF_SP Character(1) VARCHAR2(1) NOT NULL Sale/Purchase Default
6 NOTC1_DF_RR Character(1) VARCHAR2(1) NOT NULL Returns/Replacements Default
7 NOTC2_DF_OSP Character(1) VARCHAR2(1) NOT NULL Sale/Purchase Default
8 NOTC2_DF_RTN Character(1) VARCHAR2(1) NOT NULL Returns Default
9 FRGM_DF_SHP Character(2) VARCHAR2(2) NOT NULL Normal EU Shipment Default
10 FRGM_DF_OSH Character(2) VARCHAR2(2) NOT NULL Other Shipments Default
11 SPROC_DF_SHP Character(6) VARCHAR2(6) NOT NULL Normal EU Shipment Default
12 SPROC_DF_OSH Character(6) VARCHAR2(6) NOT NULL Other Shipments Default
13 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