SETIDPrompt Table: SETID_TBL
EOCM_ACCESS_IDPrompt Table: EOCM_TRDPARTNER
EOCM_DATA_SRC_IDSEQNUMERROR_COUNTEOCM_DS_ERROR(SQL Table) |
Index Back |
|---|---|
Data Source Error LogThis record stores all the log information with the uploading of Data Source Files |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | EOCM_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Field for storing the Partner ID
Prompt Table: EOCM_TRDPARTNER |
| 3 | EOCM_DATA_SRC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Source ID |
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | ERROR_COUNT |
Number(9,0) | DECIMAL(9) NOT NULL | Error Count |
| 6 | EOCM_LINE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Line Number |
| 7 | EOCM_FIELD_NAME | Character(32) | VARCHAR2(32) NOT NULL | store the last field for new prods |
| 8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 9 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 10 | EOCM_ERROR_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Current Value |
| 11 | EOCM_ORIG_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Current Value |