GM_PT_EFFT_AET(SQL Table) |
Index Back |
---|---|
Effort staging cache record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
3 | FILENAME_ERR | Character(1) | VARCHAR2(1) NOT NULL | Filename Error |
4 | RECORDNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record Name
01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC |
5 | RECORDNAME2 | Character(15) | VARCHAR2(15) NOT NULL | Record Name 2 |
6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
7 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
8 | FA_CS_FROM_VALUE | Character(10) | VARCHAR2(10) NOT NULL | Chartfield From Value |
9 | FA_CS_TO_VALUE | Character(10) | VARCHAR2(10) NOT NULL | Chartfield To Value |
10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
11 | FIELDNAME_ALIAS | Character(30) | VARCHAR2(30) NOT NULL | Field Name Alias |
12 | SETID_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
SetID Flag
N=Setid in Value X=No Setid Y=Setid in Field |
13 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
14 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
15 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
16 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |