DST_ACCT_TYPEKK_ALOG_PO4_VW4(SQL View) |
Index Back |
|---|---|
ProCard-Acct Entry Type Prompt |
| SELECT DISTINCT A.DST_ACCT_TYPE FROM PS_KK_SOURCE_HDR A , PS_KK_ACTIVITY_LOG B WHERE A.KK_TRAN_ID = B.KK_TRAN_ID AND A.KK_TRAN_DT = B.KK_TRAN_DT AND A.KK_SOURCE_TRAN IN ('PO_RAENC' ,'PO_RAEXP' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |