GPTH_HD_FLITF

(SQL Table)
Index Back

ITF File Layout Record

Header of ITF File Layout Record

# 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 GPTH_HEADER Character(1) VARCHAR2(1) NOT NULL Header
4 GPTH_SENDER_ID Character(4) VARCHAR2(4) NOT NULL Sender Id
5 GPTH_SENDER_NID Character(13) VARCHAR2(13) NOT NULL Sender Identification Id
6 GPTH_SENDER_ROLE Character(1) VARCHAR2(1) NOT NULL Sender Role
1=Withholding tax Payer
2=Representative
3=Agent
4=Flling Joinly
7 GPTH_TAX_TYPE Character(8) VARCHAR2(8) NOT NULL Tax Report Name
8 GPTH_COMPIN Character(13) VARCHAR2(13) NOT NULL ID No. Of Tax Payer
9 GPTH_LTO Character(1) VARCHAR2(1) NOT NULL Large Business Tax Administration Office
0=None LTO
1=LTO
10 GPTH_TAXMONTH Character(2) VARCHAR2(2) NOT NULL Tax Month
11 GPTH_TAXYEAR Character(4) VARCHAR2(4) NOT NULL Tax Year
12 GPTH_BRANCH_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Branch Type
B=VAT&SBT
S=Special Business Tax Branch
V=Value Added Tax Branch
13 GPTH_FORMTYPE Character(2) VARCHAR2(2) NOT NULL Type of Submission
14 GPTH_TOT_NUM Number(7,0) INTEGER NOT NULL Total No of person
15 GPTH_TOT_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Total Income Amount
16 GPTH_TOT_TAX Signed Number(19,2) DECIMAL(17,2) NOT NULL Total Withholding Tax Amount
17 GPTH_SUR_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Additional Tax Payment
18 GPTH_GTOT_TAX Signed Number(19,2) DECIMAL(17,2) NOT NULL Total Withholding tax and additional tax
19 GPTH_TRANS_AMT Signed Number(19,2) DECIMAL(17,2) NOT NULL Transfer bank Amount
20 GPTH_USER_ID Character(20) VARCHAR2(20) NOT NULL User Id
21 GPTH_FORM_FLAG Character(1) VARCHAR2(1) NOT NULL Filing Channel
22 GPTH_DEP_NAME Character(80) VARCHAR2(80) NOT NULL Department Name
23 GPTH_SENDER_BR Character(9) VARCHAR2(9) NOT NULL Sender Branch and Branch Type
24 GPTH_BR_L Character(9) VARCHAR2(9) NOT NULL Taxpayer Branch No and Branch Type