GLRCN_TR_DEAL(SQL View) |
Index Back |
---|
SELECT A.BUSINESS_UNIT ,A.TREAS_HEADER_ID ,A.TRANSACTION_DT ,A.TR_APPV_STATUS ,C.BUSINESS_DATE ,C.SEQ_NBR ,C.AMOUNT ,C.CURRENCY_CD ,C.PYMNT_METHOD ,C.PYMNT_SELCT_STATUS ,C.APPROVAL_FLG_TR ,E.ACCTG_EVENT_TYPE ,E.TRA_PROCESS_STATUS FROM PS_TRX_HEADER_TR A , PS_CASH_FLOW_TR C , PS_TRA_EVENT_CAL E WHERE C.SOURCE_BUS_UNIT = E.BUSINESS_UNIT AND C.TR_SOURCE_CD = E.TR_SOURCE_CD AND C.TR_SOURCE_ID = E.EVENT_ID AND C.BUSINESS_DATE = E.EVENT_DT AND C.SEQ_NBR = E.SEQ_NBR AND A.BUSINESS_UNIT = C.SOURCE_BUS_UNIT AND A.TREAS_HEADER_ID = C.TR_SOURCE_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_TRD_NONVW |
2 | TREAS_HEADER_ID | Character(12) | VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Default Value: NEXT Prompt Table: TRX_HEADER_TR |
3 | TRANSACTION_DT | Date(10) | DATE NOT NULL | Transaction date (often used as trade date) |
4 | TR_APPV_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
An internal work field that indicates whether a given deal transaction has been approved by a reviewe
01=Authorized 02=Submitted 03=Pending Review 04=Deal Previewed 05=Deal Suspended 06=Deal Approved Default Value: 01 |
5 | BUSINESS_DATE | Date(10) | DATE | Represents a date upon which business is conducted within a given company in a given country. |
6 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
7 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
9 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer Prompt Table: STL_PYMT_MTHD_V |
10 | PYMNT_SELCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed D=Negative Voucher Sum E=Externally Paid F=Federal Sanctions Error I=In Process - EFT N=Not Selected for Payment O=Financial Sanctions Review P=Paid R=Requested for Payment S=Settlement Payment V=Convert Error X=Canceled Y=Prepaid Default Value: X |
11 | APPROVAL_FLG_TR | Character(1) | VARCHAR2(1) NOT NULL |
An internal work field that indicates that a given treasury transaction has been approved by
A=Approved D=Denied N=None Required P=Pending Approval Default Value: N |
12 | ACCTG_EVENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Accounting types for deal capture and hedging |
13 | TRA_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The processing status for a given accounting entry build.
A=Accruing D=Deactivated E=Error I=In Process N=Not Processed P=Processed T=Temporary Hold |