GPTH_TAX_ID_BRN

(SQL Table)
Index Back

Company Tax ID/Branch

Company Tax ID and Branch No

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 GPTH_TAX_ID Character(10) VARCHAR2(10) NOT NULL Tax identification number
5 GPTH_TAX_BRANCH Character(6) VARCHAR2(6) NOT NULL Tax branch number
6 GPTH_TAX_ID_L Character(13) VARCHAR2(13) NOT NULL Tax identification number 13
7 GPTH_SENDER_ID Character(4) VARCHAR2(4) NOT NULL Sender Id
8 GPTH_SENDER_NID Character(13) VARCHAR2(13) NOT NULL Sender Identification Id
9 GPTH_SENDER_BRANCH Character(6) VARCHAR2(6) NOT NULL Sender Branch No
10 GPTH_SENDER_ROLE Character(1) VARCHAR2(1) NOT NULL Sender Role
1=Withholding tax Payer
2=Representative
3=Agent
4=Flling Joinly
11 GPTH_LTO Character(1) VARCHAR2(1) NOT NULL Large Business Tax Administration Office
0=None LTO
1=LTO
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_USER_ID Character(20) VARCHAR2(20) NOT NULL User Id
14 GPTH_DEP_NAME Character(80) VARCHAR2(80) NOT NULL Department Name