ECOUTMAPREC(SQL Table) |
Index Back |
---|---|
EC Outbound Map Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ECMAPID | Character(10) | VARCHAR2(10) NOT NULL | EC Map ID |
2 | ECFILEROWID | 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.
Default Value: 000 |
3 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
4 | RECNAME_PARENT | Character(15) | VARCHAR2(15) NOT NULL |
Parent Record. If this comes from a sub-record, this column has the name of the sub-record, otherwise it has the same value as RECNAME.
Prompt Table: RECDEFN_VW |
5 | RECNAME_FILE | Character(15) | VARCHAR2(15) NOT NULL |
Model File Layout
Prompt Table: RECDEFN_VW |
6 | ECHDRRECSW | Character(1) | VARCHAR2(1) NOT NULL |
Header Record
Y/N Table Edit Default Value: N |