| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
TR_SOURCE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
An internal work field that represents a unique identifier for records depicting a given treasury po
|
| 3 |
TR_SOURCE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Note: Changes to Translate Values must also be made to TRA_SOURCE_CD and SOURCE_TYPE. These 3 fields must be kept in sync.
Values that are inactive are for use in TR Accounting only
B=BSP
D=Deals
E=Deal Fees
F=Facility Fees
H=Hedges
I=Interest
M=Deal: Estimated Maturity Accr
N=Netted Deal
O=Other
P=Investment Pools
R=EFT Fees
S=Securities
T=LC Fees
W=EFT Requests
X=Bank Transfers
Default Value: W
|
| 4 |
STL_PARTY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Party Indicator for Settlement Parties
1=Receiver
2=Agent
3=Account
|
| 5 |
PMT_PARTY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Field for Identifying Various Party Types
CDTR=Creditor
CRAC=Creditor Account
CRAG=Creditor Agent
DBTR=Debtor
DRAC=Debtor Account
DRAG=Debtor Agent
INIT=Initiating Party
UCDT=Ultimate Creditor
UDBT=Ultimate Debtor
|
| 6 |
STD_ID_NUM_QUAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Standard ID Number
|
| 7 |
STD_ID_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
ID Number
|
| 8 |
STD_ID_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 9 |
CREDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Flag
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|