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 |