| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPSG_CPY_TAX_REF |
Character(11) |
VARCHAR2(11) NOT NULL |
Singapore Company Tax Reference Number
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
GPSG_REGISTERED_NM |
Character(70) |
VARCHAR2(70) NOT NULL |
Name of company registered with Singapore IRAS
|
| 5 |
GPSG_CPY_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Singapore Company Name/Description as used in IRAS reporting.
|
| 6 |
GPSG_8B_INCORP_DT |
Date(10) |
DATE |
This field is used to store the Date of Incorporation for ERIS (Start-Ups) only.
|
| 7 |
GPSG_TAX_CONT_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Singapore IRAS contact person's Employee Id
Prompt Table:
PERS_SRCH_GBL
|
| 8 |
GPSG_ROB_ROC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore IRAS ROB/ROC Number Type
7=UEN-Business (ROB)
8=UEN-Local Company (ROC)
A=Tax Ref. No. assigned by IRAS
C=ROC Number
G=Goods & Services Tax No.
G=Goods & Services Tax No.
I=Income Tax Ref. No.
M=Mgmt. Corp. Strata Titles No.
M=Mgmt. Corp. Strata Titles No.
N=Not Applicable
O=Other
R=ROB Number
U=UEN-Others
X=Central Registration Number
X=Central Registration Number
Default Value: N
|
| 9 |
GPSG_ROB_ROC_NO |
Character(12) |
VARCHAR2(12) NOT NULL |
Singapore IRAS ROB/ROC Number
|
| 10 |
GPSG_OHQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore OHQ (Overseas Headquarters) Status.
B=Not Applicable
N=No
Y=Yes
Default Value: B
|
| 11 |
GPSG_ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Singapore IRAS Reporting address
|
| 12 |
GPSG_ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Singapore IRAS Reporting address
|
| 13 |
GPSG_ADDRESS3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Singapore IRAS Reporting address
|
| 14 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 15 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 16 |
GPSG_CPY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Singapore Company Type
1=Ministry of Defence
4=Government Department
5=Statutory Board
6=Private Sector
7=ERIS(Start-Ups)
9=Others
|
| 17 |
GPSG_CPY_SIGNATORY |
Character(40) |
VARCHAR2(40) NOT NULL |
Name of comapny signatory
|
| 18 |
GPSG_FAX |
Character(24) |
VARCHAR2(24) NOT NULL |
Registered Fax Number
|