COUNTRYPrompt Table: COUNTRY_TBL
Y/N Table Edit
Default Value: N
N=Non Taxable
S=Sales Tax
U=Use Tax
CNTRY_STAT_TBL(SQL Table) |
Index Back |
|---|---|
Cntry Codes for Stat Reporting |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 2 | STAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use for Statistics
Y/N Table Edit Default Value: N |
| 3 | STAT_CNTRY_3DIG | Character(3) | VARCHAR2(3) NOT NULL | 3-Dig Stat Country Code |
| 4 | CNTRY_DESCR7 | Character(7) | VARCHAR2(7) NOT NULL | 7-char Country Description |
| 5 | IST_CNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char Intrastat Country Cd |
| 6 | ESL_CNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-Char ESL Country Cd |
| 7 | VAT_CNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL | 2-character country code to be displayed along with the VAT Registration ID. |
| 8 | SALES_USE_TX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Code
N=Non Taxable S=Sales Tax U=Use Tax |