COUNTRYDefault Value: MEX
EFFDTDefault Value: %date
COMPANYPrompt Table:
COMPANY_TBL
Set Control Field: COMPANY
GPMX_STATE_COUNTYCDJU=Ciudad Juarez
CHIH=Chihuahua
HGO=Hidalgo
GPMX_SPST_TAX_C(SQL Table) |
Index Back |
|---|---|
Special State Taxes ConceptsSpecial State Taxes Concepts for Mexico Country Extension. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: MEX |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 4 | GPMX_STATE_COUNTY |
Character(4) | VARCHAR2(4) NOT NULL |
Mexican States referenced with special taxes.
CDJU=Ciudad Juarez CHIH=Chihuahua HGO=Hidalgo |
| 5 | GPMX_SP_ST_TAX_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Special State Tax Percent. |