AR_CRCARD_SCR

#	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.
2	PAYMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
3	CR_CARD_AUTH_STAT	Character(1)	VARCHAR2(1) NOT NULL	Credit Card Auth Status A=Authorized B=Billed C=Credited D=Denied E=Validation Errors F=Auth Reversal G=Validated H=Auth Reversal Denied J=Reauthorize K=No Action L=Credit Card Not In Group M=Manually Approved/Settled N=Change to Terms P=Authorized and Billed R=Processing T=Cancel Order U=Unprocessed/Retry V=Pending Approval W=Deleted after Settlement X=Deleted Y=Cancelled Z=Zero Payment for Maintenance
4	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.
5	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
6	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	CR_CARD_AUTH_DT	Date(10)	DATE	Credit Card Authorization Date
9	FROM_DATE	Date(10)	DATE	From Date
10	TO_DATE	Date(10)	DATE	To Date
11	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.
12	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance