View - dbo.arch_AR_ReceiptPayment

Property	Value
Name	arch_AR_ReceiptPayment
Schema	dbo
Quoted Identifier Status	True
Ansi Nulls Status	True
Returns View Metadata	False
Create Date	10/17/2016 10:54 AM
Description

Column Name	Data Type	Allow Nulls	Fulltext Indexed	Identity	Description / Computed Formula
AuthorizationBatchNumber	varchar(8)	True	False	False
AuthorizationLineNumber	int(10, 0)	True	False	False
ChargeAutorizationNumber	varchar(6)	True	False	False
ChargeGuid	varchar(19)	True	False	False
ChargeTypeCode	varchar(2)	True	False	False
CheckingAccountNumber	varchar(19)	True	False	False
CheckNumber	varchar(16)	True	False	False
CreditCardExpirationDate	varchar(6)	True	False	False
CreditCardNumber	varchar(16)	True	False	False
CreditCardType	varchar(30)	False	False	False
PaymentAmount	numeric(17, 2)	False	False	False
PaymentName	varchar(40)	True	False	False
PaymentSequence	int(10, 0)	True	False	False
PaymentType	varchar(23)	False	False	False
PaymentTypeCode	varchar(2)	True	False	False
ReceiptKey	varchar(19)	True	False	False
ReceiptSeqNumber	int(10, 0)	True	False	False
ReferenceNumber	varchar(6)	True	False	False
RefundedAmount	numeric(17, 2)	False	False	False
StudentId	varchar(9)	True	False	False

Name

Insert

Update

Delete

Instead

Name

Clustered

Columns

Name	Type
AR_RECEIPT_PAYMENT_A	Table
UTL_CODE_TABLE	Table

Name	Type
AR_RECEIPT_PAYMENT_A	TABLE
UTL_CODE_TABLE	TABLE

Object

Property

Value

Object

Property

Value

/****** Object: View [dbo].[arch_AR_ReceiptPayment] Script Date: 03/09/2017 16:47:08 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE VIEW arch_AR_ReceiptPayment
AS
SELECT
       CASHIER_SESSION_KEY  AS ReceiptKey
      ,RECEIPT_SEQ AS ReceiptSeqNumber
      ,PAYMENT_SEQ AS PaymentSequence
      ,PAYMENT_TYPE AS PaymentTypeCode
      ,CASE
         WHEN PAYMENT_TYPE = 'DP' THEN 'Deposit from Receivable'
         WHEN PAYMENT_TYPE = 'CA' THEN 'Cash'
         WHEN PAYMENT_TYPE = 'CK' THEN 'Check'
         WHEN PAYMENT_TYPE = 'CI' THEN 'International Check'
         WHEN PAYMENT_TYPE = 'CO' THEN 'Out of Town Check'
         WHEN PAYMENT_TYPE = 'CR' THEN 'Credit Card'
         WHEN PAYMENT_TYPE = 'DB' THEN 'Debit Card'
         WHEN PAYMENT_TYPE = 'OC' THEN 'Bank or Overpayment'
         WHEN PAYMENT_TYPE = 'WT' THEN 'Wire Transfer'
         WHEN PAYMENT_TYPE = 'CC' THEN 'College Check'
         WHEN PAYMENT_TYPE = 'EC' THEN 'E-Check'
         WHEN PAYMENT_TYPE = 'CP' THEN 'Point of Purchase'
         ELSE 'Unknown'
       END AS PaymentType
      ,ISNULL(PAYMENT_AMOUNT,0) AS PaymentAmount
      ,PAYMENT_NAME AS PaymentName
      ,CHECK_ACCOUNT AS CheckingAccountNumber
      ,CHECK_NUM AS CheckNumber
      ,CHARGE_TYPE AS ChargeTypeCode
      ,ISNULL(CardType.DESCRIPTION,'N/A') AS CreditCardType
      ,CHARGE_NUM AS CreditCardNumber
      ,CHARGE_EXP AS CreditCardExpirationDate
      ,CHARGE_AUTH AS ChargeAutorizationNumber
      ,AUTHORIZATION_BATCH AS AuthorizationBatchNumber
      ,AUTHORIZATION_LINE_NO AS AuthorizationLineNumber
      ,STDNT_ID AS StudentId
      ,ISNULL(REFUNDED_AMT,0) AS RefundedAmount
      ,REF_NBR AS ReferenceNumber
      ,CHARGE_GUID AS ChargeGuid
  FROM AR_RECEIPT_PAYMENT_A RcptPaym
  LEFT OUTER JOIN UTL_CODE_TABLE CardType
  ON
  (
     CardType.TABLE_NAME = 'RCPT-CARDS' AND
     CardType.CODE = RcptPaym.CHARGE_TYPE AND
     CardType.STATUS = 'A'
  )