ECINMAPFLD_VW

index back

EC Inbound Map File Fields


select ecmapid, ecfilerowid, seqno, fieldname, fieldtype, ecstartpos, length, decimalpos, ecconvertcd, ectpcvtid, ecfldspecialcd, ecrowidvalue from ps_ecinmapfld

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
ECCONVERTCD Character(1) VARCHAR2(1) NOT NULL EC Field Conversion Type
C=Convert
N=No Conversion
R=Record ID Value
T=Trading Partner Specific

Default: N

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

Prompt Table: ECTPCVT

ECFLDSPECIALCD Character(1) VARCHAR2(1) NOT NULL Special EDI Field Processing
E=EC Entity Code
N=None
P=Primary Event Code
Q=EC Queue Control Number
S=Secondary Event Code

Default: N

ECROWIDVALUE Character(16) VARCHAR2(16) NOT NULL EC File Row ID Value
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19