PMT_DTL_REF_VW2(SQL View) |
Index Back |
|---|---|
View of dtl stg, ref stgView of PMT_DETAIL_STG, PMT_REF_STG |
| SELECT DISTINCT A.PMT_MSG_ID , A.PMT_SEQ_NUM , A.PMT_STATUS , A.PMT_SOURCE , %subrec(PMT_REFKEYS_SBR , B) , A.BUSINESS_UNIT , A.AMOUNT , A.AMOUNT_CURRENCY_CD , A.BANK_SETID , A.BANK_CD , A.BANK_ACCT_KEY , A.FORMAT_ID , A.PYMNT_METHOD , A.PROCESS_INSTANCE , A.CREATED_BY_USER FROM PS_PMT_DETAIL_STG A , PS_PMT_REF_STG B WHERE A.PMT_MSG_ID = B.PMT_MSG_ID AND A.PMT_SEQ_NUM = B.PMT_SEQ_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PMT_MSG_ID | Character(15) | VARCHAR2(15) NOT NULL | Payment Message ID |
| 2 | PMT_SEQ_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | PMT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Payment status
C=Canceled CM=Cancelled with Message E=Error H=Flagged for Hold L=Awaiting Dispatch N=Not Processed P=Paid PC=Pending Cancellation PR=Pending Reversal R=Received by Bank RM=Reversed with Message S=Dispatched to Bank SC=In Process |
| 4 | PMT_SOURCE | Character(10) | VARCHAR2(10) NOT NULL | Source System Name |
| 5 | KEY_CHAR_40_01 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/01 |
| 6 | KEY_CHAR_40_02 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/02 |
| 7 | KEY_CHAR_40_03 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/03 |
| 8 | KEY_CHAR_40_04 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/04 |
| 9 | KEY_CHAR_40_05 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/05 |
| 10 | KEY_CHAR_40_06 | Character(40) | VARCHAR2(40) NOT NULL | Key_Char 40/06 |
| 11 | KEY_CHAR_40_07 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/07 |
| 12 | KEY_CHAR_40_08 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/08 |
| 13 | KEY_CHAR_40_09 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/09 |
| 14 | KEY_CHAR_40_10 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/10 |
| 15 | KEY_CHAR_40_11 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/11 |
| 16 | KEY_CHAR_40_12 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/12 |
| 17 | KEY_CHAR_40_13 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/13 |
| 18 | KEY_CHAR_40_14 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/14 |
| 19 | KEY_CHAR_40_15 | Character(40) | VARCHAR2(40) NOT NULL | Key Char 40/15 |
| 20 | KEY_DATE_01 | Date(10) | DATE | Key Date 01 |
| 21 | KEY_DATE_02 | Date(10) | DATE | Key Date 02 |
| 22 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
| 23 | KEY_DATE_04 | Date(10) | DATE | Key Date 04 |
| 24 | KEY_DATE_05 | Date(10) | DATE | Key Date 05 |
| 25 | KEY_DTTM_01 | DateTime(26) | TIMESTAMP | Key Date Time 01 |
| 26 | KEY_DTTM_02 | DateTime(26) | TIMESTAMP | Key Date Time 02 |
| 27 | KEY_DTTM_03 | DateTime(26) | TIMESTAMP | Key Date Time 03 |
| 28 | KEY_DTTM_04 | DateTime(26) | TIMESTAMP | Key Date Time 04 |
| 29 | KEY_DTTM_05 | DateTime(26) | TIMESTAMP | Key Date Time 05 |
| 30 | KEY_SIGN_01 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 01 |
| 31 | KEY_SIGN_02 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 02 |
| 32 | KEY_SIGN_03 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 03 |
| 33 | KEY_SIGN_04 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 04 |
| 34 | KEY_SIGN_05 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Key Signed Number 05 |
| 35 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 36 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 37 | AMOUNT_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 38 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 39 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 40 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 41 | FORMAT_ID | Character(10) | VARCHAR2(10) NOT NULL | Format ID |
| 42 | 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 |
| 43 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 44 | CREATED_BY_USER | Character(30) | VARCHAR2(30) NOT NULL | Created By |