| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 5 |
GPES_FILE_PATH |
Character(250) |
VARCHAR2(250) NOT NULL |
Output / Input file path
|
| 6 |
GPES_FILE_NAME |
Character(250) |
VARCHAR2(250) NOT NULL |
Name of a file, according to the process scheduler server.
|
| 7 |
GPES_TAX_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
|
| 8 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 9 |
GPES_MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 10 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 11 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Name
|
| 12 |
CONTACT_PHONE |
Character(12) |
VARCHAR2(12) NOT NULL |
Contact Phone
|
| 13 |
GPES_CONTACT_CELL |
Character(9) |
VARCHAR2(9) NOT NULL |
Contact cellular number
|
| 14 |
GPES_CONTACT_EMAIL |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact e-mail address
|
| 15 |
GPES_TAXMODEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax report model. Indicates if the report model is quarterly (Model 110) or monthly (Model 111)
110=Quarterly
111=Monthly
|
| 16 |
GPES_QUARTER_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Quarter code
1T=First Quarter
2T=Second Quarter
3T=Third Quarter
4T=Fourth Quarter
|
| 17 |
GPES_COMMENTS_350 |
Long Character(350) |
VARCHAR2(350) |
Comments text 350 characters long
|
| 18 |
SIGNATURE_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Signature City
|
| 19 |
SIGNATURE_DT |
Date(10) |
DATE |
Signature Date
|
| 20 |
GPES_TAX_PAY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay type for 110 report
D=Direct Debit
I=Cash
O=Debit
|
| 21 |
GPES_TAX_DECL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration Type for 110 report
G=Transfer to Tax Agency Account
I=Payment in Cash
N=Negative Declaration
U=Bank Account
|
| 22 |
GPES_110_DECL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration Type for 110 report
G=Tax Agency Account
I=Pay In
N=Negative
U=Direct Debit
|
| 23 |
GPES_111_DECL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration Type for 111 report
G=Tax Agency Account
I=Pay In
N=Negative
U=Direct Debit
|
| 24 |
GPES_216_DECL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration Type for 216 report
I=Pay In
N=Negative
U=Direct Debit
|
| 25 |
GPES_EXP_PERIOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Period
MON=Monthly
QUA=Quarterly
|
| 26 |
GPES_AEAT216_ID_RE |
Character(16) |
VARCHAR2(16) NOT NULL |
Related Id for delarations sent electronically (not printed on the official form). Actually 13 characters long.
|
| 27 |
GPES_AEAT216_ID_EL |
Character(16) |
VARCHAR2(16) NOT NULL |
Related ID for declarations sent printed on the official form (not electronically)
|
| 28 |
GPES_AEAT216_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of statement
0=Ordinary
1=Complementary
|
| 29 |
GPES_COMPL_DED_AMT |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
Complementary deduction amount
|
| 30 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
|