CM_DST_TYPE_VW

(SQL View)
 Index Back

Misc Charge Dst Type Prompt VW

02/16/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement 11/08/00 RT created rel lang vw cm_dst_type_lvw 12/10/01 dbe Redefined SQL text.

SELECT A.fieldvalue , A.xlatlongname FROM PSXLATITEM A WHERE A.FIELDNAME = 'DST_ACCT_TYPE' AND A.FIELDVALUE IN ('FRG','MISC','STX','UTX','VIN')

  • Related Language Record: CM_DST_TYPE_LVW

    • # 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 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name