COMPANY_TBL_ITA(SQL Table) |
Index Back |
|---|---|
Company Table - ITACompany Codes For Italy |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | COMP_TYPE_CODE |
Character(3) | VARCHAR2(3) NOT NULL |
Company Code Type
CAT=Category representatives Inscr FAI=Insurance identification num. FAS=FASDAC Code FPD=Pension identification number IST=ISTAT Code PRE=Optional pension insurance TAX=TAX ID TRI=Tribunal Inscription Code VAT=Partita IVA |
| 4 | COMP_CODE_ITA |
Character(30) | VARCHAR2(30) NOT NULL | Company Codes ITA |
| 5 | COMP_MAIN_CODE_ITA | Character(1) | VARCHAR2(1) NOT NULL |
Company Main Code - ITA
Y/N Table Edit Default Value: N |