GL_INCR_HIST

(SQL Table)
Index Back

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

Prompt Table: %EDITTABLE

10 ASOFDATE Date(10) DATE As of Date
11 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.
12 DETAIL_LEDGER Character(10) VARCHAR2(10) NOT NULL Detail Ledger ID
13 DETPER_FROM Number(3,0) SMALLINT NOT NULL Detail Period From
14 DETPER_TO Number(3,0) SMALLINT NOT NULL Detail Period To
15 ADJ_PER_FROM Number(3,0) SMALLINT NOT NULL Adjustment Period From
16 ADJ_PER_TO Number(3,0) SMALLINT NOT NULL Adjustment Period To
17 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.
18 IN_PROCESS Character(1) VARCHAR2(1) NOT NULL Process