PROD_LD_ERR_TAO(SQL Table) |
Index Back |
---|---|
Products Load Error TempDate Initials Issue Description 032601 dms SP2 (DI-EDWONG-14) Modify key fields |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(10) | VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync |
|
3 | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field | |
4 | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). | |
5 | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). | |
6 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 01 | |
7 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 02 | |
8 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 03 | |
9 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 04 | |
10 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 05 | |
11 | Character(25) | VARCHAR2(25) NOT NULL | Key Char(25) 06 | |
12 | Date(10) | DATE | Key Date 01 | |
13 | Number(5,0) | INTEGER NOT NULL | Key Number 01 | |
14 | Date(10) | DATE | Key Date 02 | |
15 | Number(5,0) | INTEGER NOT NULL | Key Number 02 | |
16 | KEY_NUM_03 | Number(5,0) | INTEGER NOT NULL | Key Number 03 |
17 | KEY_DATE_03 | Date(10) | DATE | Key Date 03 |
18 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
19 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
20 | EDITVALUE | Character(20) | VARCHAR2(20) NOT NULL | Edit Value |
21 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
22 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
23 | LASTUPDDTTM | 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. |