SFA_CRC_FIN_SUM

(SQL Table)
Index Back

CRC Financial Summary

Financial Summary Information.

  • Parent record: SFA_CRC_DOCUMNT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID
    2 SFA_CR_RECIP_ID Character(12) VARCHAR2(12) NOT NULL CRC Recipient ID
    3 SFA_CR_TOT_NET_DSB Character(12) VARCHAR2(12) NOT NULL Total Net Disbursement Amount
    4 SFA_CR_TOT_NET_EFT Character(12) VARCHAR2(12) NOT NULL Total Net EFT Disbursement Amt
    5 SFA_CR_TOT_NON_EFT Character(12) VARCHAR2(12) NOT NULL Total Net Non EFT Amount
    6 SFA_CR_TOT_REISSUE Character(12) VARCHAR2(12) NOT NULL Total Reissue Amount
    7 SFA_CR_TOT_CANCEL Character(12) VARCHAR2(12) NOT NULL Total Cancellation Amount
    8 SFA_CR_TOT_OUTCNCL Character(12) VARCHAR2(12) NOT NULL Total Outstanding Cancel Amt
    9 SFA_CR_TOT_NETCNCL Character(12) VARCHAR2(12) NOT NULL Total Netted Cancellation Amt
    10 SFA_CR_TOT_DEFICIT Character(12) VARCHAR2(12) NOT NULL Total Deficit Amount