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 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
    SEQNONumber(5,0)INTEGER NOT NULLSequence Number
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
    ECSTARTPOSNumber(5,0)INTEGER NOT NULLField Start Position
    DECIMALPOSNumber(2,0)SMALLINT NOT NULLDecimal Positions
    ECFIELDVALUECDCharacter(1)VARCHAR2(1) NOT NULLField Value Code
    I=Agent Value
    R=Source Field
    T=TP Conversion
    X=Not Applicable

    Default: R

    ECTPCVTIDCharacter(10)VARCHAR2(10) NOT NULLConversion Type ID

    Prompt Table: ECTPCVT

    ECDEFAULTVALUECharacter(30)VARCHAR2(30) NOT NULLEC Default Value
    ECDRIVERCALCCDCharacter(3)VARCHAR2(3) NOT NULLEC 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 2019, 8.54
    PTRef generated on 09-JUN-19