ECINMAPFILE_VW

(SQL View)
Index Back

EC Inbound Map File Defn


select ecmapid, ecfilerowid, recname from PS_ECINMAPFILE

# 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.
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RECDEFN_VW