AR_EPYMNT_AET (SQL Table)	Index Back
AR ePay Process Cache Record

AR_EPYMNT_AET

(SQL Table)

AR ePay Process Cache Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

5 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

6 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

7 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

8 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

9 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

10 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

11 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.

12 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.

13 MAX_DEPOSIT_ID Number(15,0) DECIMAL(15) NOT NULL Maximum Deposit ID

14 HOLD_DEPOSIT_ID Number(15,0) DECIMAL(15) NOT NULL Deposit ID Holder

15 MIN_DEPOSIT_ID Number(15,0) DECIMAL(15) NOT NULL Minimum Deposit ID

16 DEPOSIT_CNT Number(4,0) SMALLINT NOT NULL Deposit Count

17 PAYMENT_CNT Number(5,0) INTEGER NOT NULL Payment count

18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

19 CONTROL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.

20 FORMAT_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.

21 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.

22 GROUP_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.

23 HOLD_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL HOLD_GROUP_ID

24 MIN_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL MIN_GROUP_ID

25 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.

26 CRCARD_REQ_CNT Number(3,0) SMALLINT NOT NULL REQUESTS

27 AE_EXISTS Character(1) VARCHAR2(1) NOT NULL Exists

28 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.

29 ENTRY_USE_ID Character(5) VARCHAR2(5) NOT NULL Specifies the System Function or type of processing associated with an entry type.

30 TOTAL_AMT_SEL Signed Number(28,3) DECIMAL(26,3) NOT NULL Total amount selected

31 NOTHING Character(1) VARCHAR2(1) NOT NULL Work Field

32 TUNING_MODE Character(1) VARCHAR2(1) NOT NULL Tuning Mode
D=On - Display Bind Setups
N=Delete Work Files
S=On - Stop at specified stmt
W=Retain Work Files
Y=On

33 ABORT_FLAG Character(1) VARCHAR2(1) NOT NULL Abort Process Flag

34 WORK_CNT Number(10,0) DECIMAL(10) NOT NULL Count of Anything

35 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1

36 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2

37 MAX_GRP_ID_NBR Number(15,0) DECIMAL(15) NOT NULL Maximum Group ID

38 REF_QUALIFIER_CODE Character(2) VARCHAR2(2) NOT NULL Reference Qualifier Code

39 CC_CALLER Character(1) VARCHAR2(1) NOT NULL Calling Application
C=Cash Control
O=Online
P=Payment Loader
R=Reconciliation

40 CASH_CNTL_METH Character(1) VARCHAR2(1) NOT NULL Debit To Cash Occurs At
E=Payment Entry
R=Bank Reconciliation

41 APPLICATION_SRC Character(1) VARCHAR2(1) NOT NULL Application Source
B=Batch Submission
C=CallApplicationEngine
P=Called from another program

42 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

43 EPAY_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL ePayment Profile

44 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

45 ERROR_FLG Character(1) VARCHAR2(1) NOT NULL Error Flag

46 FROM_DUE_DT Date(10) DATE From Due Date

47 TO_DUE_DT Date(10) DATE To Due Date

48 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

49 PGG_MODE Character(1) VARCHAR2(1) NOT NULL PGG Mode of Operation

50 PARTITION1 Number(2,0) SMALLINT NOT NULL Parallel processing partition

51 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

52 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

53 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

54 RP_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Exchange Rate

55 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

56 PARALLEL_SW Character(1) VARCHAR2(1) NOT NULL Process in Parallel
N=Synchronous Processing
Y=Parallel Processing

57 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.

58 HIST_SEQ Number(9,0) DECIMAL(9) NOT NULL History sequence number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
6	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
7	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
8	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
9	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
10	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
11	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.
12	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.
13	MAX_DEPOSIT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Maximum Deposit ID
14	HOLD_DEPOSIT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Deposit ID Holder
15	MIN_DEPOSIT_ID	Number(15,0)	DECIMAL(15) NOT NULL	Minimum Deposit ID
16	DEPOSIT_CNT	Number(4,0)	SMALLINT NOT NULL	Deposit Count
17	PAYMENT_CNT	Number(5,0)	INTEGER NOT NULL	Payment count
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	CONTROL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
20	FORMAT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.
21	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.
22	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
23	HOLD_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	HOLD_GROUP_ID
24	MIN_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	MIN_GROUP_ID
25	GROUP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.
26	CRCARD_REQ_CNT	Number(3,0)	SMALLINT NOT NULL	REQUESTS
27	AE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	Exists
28	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
29	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
30	TOTAL_AMT_SEL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total amount selected
31	NOTHING	Character(1)	VARCHAR2(1) NOT NULL	Work Field
32	TUNING_MODE	Character(1)	VARCHAR2(1) NOT NULL	Tuning Mode D=On - Display Bind Setups N=Delete Work Files S=On - Stop at specified stmt W=Retain Work Files Y=On
33	ABORT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Abort Process Flag
34	WORK_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Count of Anything
35	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
36	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
37	MAX_GRP_ID_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Maximum Group ID
38	REF_QUALIFIER_CODE	Character(2)	VARCHAR2(2) NOT NULL	Reference Qualifier Code
39	CC_CALLER	Character(1)	VARCHAR2(1) NOT NULL	Calling Application C=Cash Control O=Online P=Payment Loader R=Reconciliation
40	CASH_CNTL_METH	Character(1)	VARCHAR2(1) NOT NULL	Debit To Cash Occurs At E=Payment Entry R=Bank Reconciliation
41	APPLICATION_SRC	Character(1)	VARCHAR2(1) NOT NULL	Application Source B=Batch Submission C=CallApplicationEngine P=Called from another program
42	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
43	EPAY_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	ePayment Profile
44	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
45	ERROR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
46	FROM_DUE_DT	Date(10)	DATE	From Due Date
47	TO_DUE_DT	Date(10)	DATE	To Due Date
48	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
49	PGG_MODE	Character(1)	VARCHAR2(1) NOT NULL	PGG Mode of Operation
50	PARTITION1	Number(2,0)	SMALLINT NOT NULL	Parallel processing partition
51	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
52	TO_CUR	Character(3)	VARCHAR2(3) NOT NULL	To Currency Code
53	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
54	RP_EXCHNG_RT	Number(16,8)	DECIMAL(15,8) NOT NULL	Exchange Rate
55	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
56	PARALLEL_SW	Character(1)	VARCHAR2(1) NOT NULL	Process in Parallel N=Synchronous Processing Y=Parallel Processing
57	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
58	HIST_SEQ	Number(9,0)	DECIMAL(9) NOT NULL	History sequence number