GPTH_RC_FLITFV(SQL Table) | 
Index Back | 
|---|---|
Run ctrl File Layout ITF THARun Control of File Layout of ITF View | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Company | |
| 3 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 4 | Character(5) | VARCHAR2(5) NOT NULL | GPTH_RECORD_TYPE | |
| 5 | Number(10,0) | DECIMAL(10) NOT NULL | GPTH_SEQ_NO | |
| 6 | GPTH_PIN | Character(13) | VARCHAR2(13) NOT NULL | ID No. of Tax payee | 
| 7 | GPTH_TIN | Character(10) | VARCHAR2(10) NOT NULL | Tax ID Number of the Tax-Payee | 
| 8 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix | 
| 9 | GPTH_PER_N1 | Character(40) | VARCHAR2(40) NOT NULL | Title of the tax payee | 
| 10 | GPTH_NAME1 | Character(80) | VARCHAR2(80) NOT NULL | Tax-Payee's First Name | 
| 11 | GPTH_SUR_N1 | Character(80) | VARCHAR2(80) NOT NULL | Tax-Payee's Last name | 
| 12 | GPTH_FL_DATE | Character(10) | VARCHAR2(10) NOT NULL | GPTH_FL_DATE | 
| 13 | GPTH_FL_PAYMENT | Number(16,2) | DECIMAL(15,2) NOT NULL | GPTH_FL_PAYMENT | 
| 14 | GPTH_FL_TAX | Number(16,2) | DECIMAL(15,2) NOT NULL | GPTH_FL_TAX | 
| 15 | GPTH_TAXCONDITION | Character(1) | VARCHAR2(1) NOT NULL | Tax Condition |