| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
Default Value: GP_PE_SBANK_DTL.PAY_ENTITY
|
| 2 |
ORG_LINK_OPTN |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
CO=Company
DE=Department
ET=Establishment
LO=Location
PG=Pay Group
Default Value: GP_PE_SBANK_DTL.ORG_LINK_OPTN
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: GP_PE_SBANK_DTL.EFFDT
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: GP_PE_SBANK_DTL.SETID
Prompt Table:
%GP_EDIT_FLD2
|
| 5 |
ORG_LINK_UNIT |
Character(12) |
VARCHAR2(12) NOT NULL |
Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID
Default Value: GP_PE_SBANK_DTL.ORG_LINK_UNIT
Prompt Table:
%GP_EDIT_FLD1
|
| 6 |
PAYMENT_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Method
A=Cash
C=Check
O=Pay Primary Account Only
P=Postal Order
T=Bank Transfer
U=Use Normal Distribution
W=Wire Transfer
|
| 7 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table:
SRC_BANK
|