AR_REMIT_LVW1

(SQL View)
Index Back

Select item remit status

select item remit status

SELECT DISTINCT A.AR_REMIT_STATUS , B.EFFDT , B.LANGUAGE_CD , B.XLATLONGNAME , B.XLATSHORTNAME FROM PS_AR_REMIT_VW A , PSXLATITEMLANG B , PSXLATITEM I WHERE A.AR_REMIT_STATUS = B.FIELDVALUE AND B.FIELDNAME = 'AR_REMIT_STATUS' AND B.FIELDNAME = I.FIELDNAME AND B.FIELDVALUE = I.FIELDVALUE AND B.EFFDT = I.EFFDT AND I.EFF_STATUS = 'A'

  • Related Language Record for AR_REMIT_VW1
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 AR_REMIT_STATUS Character(1) VARCHAR2(1) NOT NULL Remittance process status
    B=Duplicate Pay and Remit
    D=Duplicate Match
    N=Not Processed
    P=Duplicate Payments
    R=Duplicate Remittances
    U=Unmatched
    2 EFFDT Date(10) DATE Effective Date
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name