AR_UPDATE_AET

(SQL Table)

# 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 RP_ACTION Character(1) VARCHAR2(1) NOT NULL Receivables Update Action

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

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

7 PARTITION2 Number(2,0) SMALLINT NOT NULL Parallel processing partition

8 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge

9 GROUP_BU Character(5) VARCHAR2(5) NOT NULL Represents the high level grouping of multiple general ledger business units.

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

11 PARALLEL_PGG Number(2,0) SMALLINT NOT NULL Maximimum number of concurrent parallel processes.

12 PARALLEL_PST Number(2,0) SMALLINT NOT NULL Maximimum number of concurrent parallel processes.

13 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes

14 CYCLE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Cycle Count Instance

15 CYCLE_INST_PREV Number(10,0) DECIMAL(10) NOT NULL Cycle instance for parallel process on AR_Update

16 CONTROL_CNT Number(6,0) INTEGER NOT NULL Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly

#	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	RP_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Receivables Update Action
5	PGG_MODE	Character(1)	VARCHAR2(1) NOT NULL	PGG Mode of Operation
6	PARTITION1	Number(2,0)	SMALLINT NOT NULL	Parallel processing partition
7	PARTITION2	Number(2,0)	SMALLINT NOT NULL	Parallel processing partition
8	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge
9	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
10	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.
11	PARALLEL_PGG	Number(2,0)	SMALLINT NOT NULL	Maximimum number of concurrent parallel processes.
12	PARALLEL_PST	Number(2,0)	SMALLINT NOT NULL	Maximimum number of concurrent parallel processes.
13	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
14	CYCLE_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Cycle Count Instance
15	CYCLE_INST_PREV	Number(10,0)	DECIMAL(10) NOT NULL	Cycle instance for parallel process on AR_Update
16	CONTROL_CNT	Number(6,0)	INTEGER NOT NULL	Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly