ECOUTMAPWHER_VW(SQL View) |
Index Back |
|---|---|
EC Outbound Map Where Clause |
| select ecmapid, ecfilerowid, seqno, ecwhere from PS_ECOUTMAPWHERE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | EC Map ID | |
| 2 | Character(3) | VARCHAR2(3) NOT NULL | Electronic Commerce File Row ID. Used in EDI Manager. There must be one work record for every PeopleSoft Business Document file. The first field in the record is the Record_Id and the rest of the fields must match the corresponding business document, in the same order and length. | |
| 3 | Number(5,0) | INTEGER NOT NULL | Sequence Number | |
| 4 | ECWHERE | Character(50) | VARCHAR2(50) NOT NULL | Where Clause |