GPIT_770_RP_001(SQL Table) |
Index Back |
---|---|
Provider Data for 770Provider Data for 770 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | GPIT_TAX_CD_1 | Character(16) | VARCHAR2(16) NOT NULL |
Tax Code
Prompt Table: GPIT_PROV |
3 | GPIT_FILE_NBR4 | Number(4,0) | SMALLINT NOT NULL | File Number |
4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
5 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
6 | GPIT_TOT_FILE_NBR4 | Number(4,0) | SMALLINT NOT NULL | Total files sent |
7 | GPIT_PROVIDER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Provider Type
01=Company sending File directly 06=Government Administration 07=Post Administration 08=Partner Banks 10=Others Prompt Table: GPIT_PROV |