| ECOUTMAPREC(SQL Table) | Index Back | 
|---|---|
| EC Outbound Map Record | 
| # | 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. Default Value: 000 | |
| 3 | 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 |