index back

EC Outbound Map File Field

select ecmapid, ecfilerowid, seqno, fieldname, fieldtype, ecstartpos, length, decimalpos, ecfieldvaluecd, ectpcvtid, ecdefaultvalue, ecdrivercalccd from PS_ECOUTMAPFLD

  • Parent record: ECOUTMAPREC_VW
  • 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
    SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
    ECSTARTPOS Number(5,0) INTEGER NOT NULL Field Start Position
    LENGTH Number(5,0) INTEGER NOT NULL Length
    DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    ECFIELDVALUECD Character(1) VARCHAR2(1) NOT NULL Field Value Code
    I=Agent Value
    R=Source Field
    T=TP Conversion
    X=Not Applicable

    Default: R

    ECTPCVTID Character(10) VARCHAR2(10) NOT NULL Conversion Type ID

    Prompt Table: ECTPCVT

    ECDEFAULTVALUE Character(30) VARCHAR2(30) NOT NULL EC Default Value
    ECDRIVERCALCCD Character(3) VARCHAR2(3) NOT NULL EC Driver Calc Code
    ACT=Action Code/Primary Event Code
    DAT=Current Date
    DTM=Current Datetime
    ECD=EC Entity Code Flag
    ECQ=EC Queue Instance
    ECT=EC Trans ID
    SEC=Secondary Event Code
    SEQ=Incremented Sequence Nbr
    TIM=Current Time
    TPC=Trading Partner Conversion
    index back (c)David Kurtz 2020, PeopleTools 8.58
    PTRef generated on 21-DEC-20