DST_ACCT_TYPEEE_ACTLN_FS(SQL View) |
Index Back |
|---|---|
Description for Acctg Entries.Related Field Description for Voucher Accounting Entries. |
| SELECT B.FIELDVALUE , B.XLATLONGNAME FROM PSXLATITEM B WHERE B.FIELDNAME = 'DST_ACCT_TYPE' AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSXLATITEM D WHERE B.FIELDNAME = D.FIELDNAME AND B.FIELDVALUE = D.FIELDVALUE AND D.EFF_STATUS = 'A' AND D.EFFDT <= %CurrentDateIn) |
| # | 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 |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |