SSF_REVGL_AET

(SQL Table)
Index Back

State record for Reverse GL

State Record used for Reverse Direct to GL Entries AE Process

# 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 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
5 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
6 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 SF_GL_RUN_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 SSF_TOTGL_HIST Number(10,0) DECIMAL(10) NOT NULL Field definition to hold Total Number of SF GL History records updated. This field is used in SSF_REVGL_AET record

Default Value: 0

11 SSF_TOTGL_TRANSREC Number(10,0) DECIMAL(10) NOT NULL Field definition to hold Total Number of Direct to GL Transaction records updated. This field is used in SSF_REVGL_AET record

Default Value: 0

12 SSF_TOT_ACCTGLN Number(10,0) DECIMAL(10) NOT NULL Field definition to hold total number of SF Accounting line records deleted. This field is used in SSF_REVGL_AET record

Default Value: 0

13 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
14 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now