ADB_ACT_LOG_TAO(SQL Table) |
Index Back |
---|---|
ADB Activity Log TAO |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
2 | ADB | Character(10) | VARCHAR2(10) NOT NULL |
Average Daily Balances
Prompt Table: %EDITTABLE |
3 | ADB_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ADB Balance Type
0=Management Balances 1=Regulatory Balances |
4 | ADB_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Period Type
D=Date to Date E=Year to Date M=Month to Date P=Regular Period Q=Quarter to Date R=Regular Date |
5 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
6 | 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. |
7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |