TR_AF_STL_XREF

(SQL Table)
Index Back

Treasury AF Xref record.

Cross reference record for treasury Settlements.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
2 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
3 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
4 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
5 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Awaiting Further Approvals
T=Terminated
W=Canceled
X=Suspended/Pending Denial

Default Value: N

8 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
9 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
10 COMMENTS Long Character CLOB Comment
11 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
12 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
13 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
14 BUSINESS_DATE Date(10) DATE Represents a date upon which business is conducted within a given company in a given country.
15 CASH_FLOW_LINE Number(15,0) DECIMAL(15) NOT NULL A sequential number that indicates the time order sequence of a given deal transaction's cash flows.
16 CASH_FLOW_LEG Number(1,0) SMALLINT NOT NULL A sequential number that indicates the relationship between a cash flow and its corresponding deal transaction leg
17 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number