index back

EC Outbound Map Record - Work

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

  • PeopleSoft Field NameField TypeColumn TypeDescription
    ECMAPIDCharacter(10)VARCHAR2(10) NOT NULLEC Map ID
    ECFILEROWIDCharacter(3)VARCHAR2(3) NOT NULLElectronic 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

    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

    RECNAME_PARENTCharacter(15)VARCHAR2(15) NOT NULLParent 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_FILECharacter(15)VARCHAR2(15) NOT NULLModel File Layout

    Prompt Table: RECDEFN_VW

    ECHDRRECSWCharacter(1)VARCHAR2(1) NOT NULLHeader Record

    Y/N Table Edit

    Default: N

    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19