GL_INCR_STATUS

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_ID Character(12) VARCHAR2(12) NOT NULL Process Name
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
5 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
6 FISCAL_YEAR_TO Number(4,0) SMALLINT NOT NULL Range To Fiscal Year
7 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
8 CURR_STEP Character(10) VARCHAR2(10) NOT NULL Process Step

Prompt Table: %EDITTABLE

9 ASOFDATE Date(10) DATE As of Date
10 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
11 DETAIL_LEDGER Character(10) VARCHAR2(10) NOT NULL Detail Ledger ID
12 DETPER_FROM Number(3,0) SMALLINT NOT NULL Detail Period From
13 DETPER_TO Number(3,0) SMALLINT NOT NULL Detail Period To
14 ADJ_PER_FROM Number(3,0) SMALLINT NOT NULL Adjustment Period From
15 ADJ_PER_TO Number(3,0) SMALLINT NOT NULL Adjustment Period To
16 PERIOD_OPTN Character(1) VARCHAR2(1) NOT NULL Period type
0=Regular and Adjustment Periods
1=Regular Periods
2=Adjustment Periods

Default Value: 1

17 CLOSE_BOOKCD Character(1) VARCHAR2(1) NOT NULL Close by Book Code Option

Default Value: N

18 BOOK_CODE Character(4) VARCHAR2(4) NOT NULL Book Code
19 DTTM_STAMP_SEC 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.
20 IN_PROCESS Character(1) VARCHAR2(1) NOT NULL Process