PROCESS_INSTANCEN=No
Y=Yes
UPG_GL_ADB_AET(SQL Table) |
Index Back |
|---|---|
Upgrade GL ADBUpgrade GL ADB Ledger Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 3 | SQLROWS_TAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 4 | SQLROWS_STAO | Number(12,0) | DECIMAL(12) NOT NULL | Total Rows |
| 5 | SQLROWS_3 | Number(12,0) | DECIMAL(12) NOT NULL | Used in AE |
| 6 | DELETE_LIMIT | Number(12,0) | DECIMAL(12) NOT NULL | Used in GL AE batch processes to perform deletes rather than truncate. |
| 7 | SQL_WHERE_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 8 | DATE_CODE | Character(1) | VARCHAR2(1) NOT NULL | This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements. |
| 9 | DATE_CODE2 | Character(1) | VARCHAR2(1) NOT NULL | This field defines codes for Date field used in Journal lines record. The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements. |
| 10 | RECNAME_ADB_LED | Character(15) | VARCHAR2(15) NOT NULL | ADB Ledger |
| 11 | PERIOD_SEQUENCE | Number(1,0) | SMALLINT NOT NULL | Period Sequence |
| 12 | TAO_TBL_NAME | Character(15) | VARCHAR2(15) NOT NULL | Base TAO Table Name |
| 13 | SQLROWS_NEW | Number(10,0) | DECIMAL(10) NOT NULL | Total Rows |
| 14 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 15 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |