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 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
4 | GPTH_RECORD_TYPE | Character(5) | VARCHAR2(5) NOT NULL | GPTH_RECORD_TYPE |
5 | GPTH_SEQ_NO | 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 |