GL_HP_BUD_AET(SQL Table) |
Index Back |
|---|
| # | 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 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | KK_SOURCE_TRAN | Character(10) | VARCHAR2(10) NOT NULL | Source Transaction Type |
| 6 | RECNAME_SIBL | Character(15) | VARCHAR2(15) NOT NULL | KK Source Header Record |
| 7 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |
| 8 | BATCH_CLEANUP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Batch Cleanup Flag
C=Clear Fields D=Delete Rows Published U=Update Rows Published |
| 9 | SRC_HDR_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Header Record |
| 10 | SRC_LINE_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Line Record |
| 11 | TGT_HDR_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Header Record |
| 12 | TGT_LINE_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Line Record |
| 13 | LINE_FIELD_NAME | Character(18) | VARCHAR2(18) NOT NULL | Line Field Name |
| 14 | BATCH_ID | Character(18) | VARCHAR2(18) NOT NULL | Batch ID |
| 15 | STG_RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Header Record |
| 16 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |