index back

EC Outbound Map Record - Work

select ecmapid, ecfilerowid, recname, recname_parent, recname_file, echdrrecsw from PS_ECOUTMAPREC

  • PeopleSoft Field Name Field Type Column Type Description
    ECMAPID Character(10) VARCHAR2(10) NOT NULL EC Map ID
    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. translate values

    Default: 000

    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

    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

    RECNAME_FILE Character(15) VARCHAR2(15) NOT NULL Model File Layout

    Prompt Table: RECDEFN_VW

    ECHDRRECSW Character(1) VARCHAR2(1) NOT NULL Header Record

    Y/N Table Edit

    Default: N

    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20