VENDOR10=NIF
20=Passport
60=NIE
90=CIF
Default Value: 90
Prompt Table: TRN_T_PHN_VN_VW
TRN_T_VENDR_ESP(SQL Table) |
Index Back |
|---|---|
FT Training Vendor DataTripartite Foundation. This record contains specific data related with FT. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR |
Character(6) | VARCHAR2(6) NOT NULL | Vendor ID |
| 2 | FISCAL_ID_TYPE_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Fiscal ID type. Tripartite fundation.
10=NIF 20=Passport 60=NIE 90=CIF Default Value: 90 |
| 3 | FISCAL_ID_CD | Character(10) | VARCHAR2(10) NOT NULL | Fiscal Identification Code |
| 4 | PHONE | Character(24) | VARCHAR2(24) NOT NULL |
Telephone
Prompt Table: TRN_T_PHN_VN_VW |