SFA_CRC_GUAR_VW

(SQL View)
Index Back

Dest ID Guarantor View

List of Guarantors used in CRC processing

SELECT SFA_CR_OPEID , SFA_CR_BRANCH_ID , DESCR FROM PS_SFA_CRC_DEST_ID WHERE SFA_CR_OPEID_TYPE = 'G' AND SFA_CR_OPEID_STAT = 'Y'

  • Related Language Record: SFACRCGUARVWLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_GUAR_OPEID Character(8) VARCHAR2(8) NOT NULL Guarantor OPEID
    2 SFA_CR_GUAR_BRANCH Character(4) VARCHAR2(4) NOT NULL Guarantor Branch ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description