PO_ACCT_IND_VW

(SQL View)
Index Back

PO Accounting Date IND View


SELECT %Substring(a.fieldvalue,1,1) , a.xlatlongname , a.xlatshortname FROM PSXLATITEM a WHERE a.fieldname = 'ACCOUNTING_DT_IND' AND %Substring(a.fieldvalue,1,1) IN ('C', 'S')

  • Related Language Record: PO_ACCTIND_VWLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACCOUNTING_DT_IND Character(1) VARCHAR2(1) NOT NULL Accounting Date Indicator
    C=Use Current Date
    D=Business Unit Default
    P=Use Payment Date
    S=Use Specific Date
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name