PMT_IDPMT_EXP_CC_VW(SQL View) |
Index Back |
|---|---|
Expense cc infoExpense cc info is decrypted by AP paycyle. FG uses this view to re trieve the cc info |
| SELECT B.PMT_ID , A.PAY_DOC_ID , A.INVOICE_ID , A.INVOICE_ID1 FROM PS_PMNT_ADV_TMP A , PS_PMT_INVOICE_TBL B , PS_PMT_DETAIL_TBL C WHERE C.PMT_ID = B.PMT_ID AND C.PMT_SOURCE = 'EX' AND A.PAY_DOC_ID = B.PAY_DOC_ID AND A.PAY_DOC_SEQ = B.PAY_DOC_SEQ AND A.PAY_CYCLE = C.PAY_CYCLE AND A.PAY_CYCLE_SEQ_NUM = C.PAY_CYCLE_SEQ_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PMT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Payment id |
| 2 | PAY_DOC_ID | Character(20) | VARCHAR2(20) NOT NULL | Advice ID |
| 3 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 4 | INVOICE_ID1 | Character(44) | VARCHAR2(44) NOT NULL | Invoice Number |