GPTH_RC_FLITFV

(SQL Table)
Index Back

Run ctrl File Layout ITF THA

Run 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