MISC_RECEIPT (SQL Table)	Index Back
Receipt

MISC_RECEIPT

(SQL Table)

Receipt

Parent record: PAYMENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARED_NONVW

2 DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.

3 PAYMENT_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.

4 AR_RECEIPT_ID Character(10) VARCHAR2(10) NOT NULL Receipt ID

5 AR_RECEIPT_STATUS Character(3) VARCHAR2(3) NOT NULL Receipt Status
NEW=New
PRT=Printed

6 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.

7 PAYMENT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.

8 PAYMENT_METHOD Character(3) VARCHAR2(3) NOT NULL Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report

9 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

10 AR_RECEIPT_REF Character(60) VARCHAR2(60) NOT NULL Receipt Reference

11 AR_FIRST_NAME Character(50) VARCHAR2(50) NOT NULL First Name (MI)

12 AR_LAST_NAME Character(40) VARCHAR2(40) NOT NULL Last Name

13 AR_COMMENT Character(100) VARCHAR2(100) NOT NULL Comments

14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

15 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARED_NONVW
2	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
3	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
4	AR_RECEIPT_ID	Character(10)	VARCHAR2(10) NOT NULL	Receipt ID
5	AR_RECEIPT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Receipt Status NEW=New PRT=Printed
6	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
7	PAYMENT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
8	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
9	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
10	AR_RECEIPT_REF	Character(60)	VARCHAR2(60) NOT NULL	Receipt Reference
11	AR_FIRST_NAME	Character(50)	VARCHAR2(50) NOT NULL	First Name (MI)
12	AR_LAST_NAME	Character(40)	VARCHAR2(40) NOT NULL	Last Name
13	AR_COMMENT	Character(100)	VARCHAR2(100) NOT NULL	Comments
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.