DST_ACCT_TYPELANGUAGE_CDCM_DST_TYPE_LVW(SQL View) |
Index Back |
|---|---|
Misc Charge Dst Type Prompt VW11/08/00 RT created rel lang vw for cm_dst_type_vw |
| SELECT B.fieldvalue , B.language_cd ,B.xlatlongname FROM PSXLATITEMLANG B WHERE B.FIELDNAME = 'DST_ACCT_TYPE' AND B.FIELDVALUE IN ('FRG','MISC','STX','UTX','VIN') |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |