ECINMAPFLD

index back

EC Inbound Map File Fields


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)

Prompt Table: EC_DATA_TBL_VW

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
DELIMIT_DATE Character(1) VARCHAR2(1) NOT NULL Delimiter

Default: /

YEAR_START Number(3,0) SMALLINT NOT NULL year start

Default: 1

YEAR_LEN Number(3,0) SMALLINT NOT NULL year length

Default: 4

MONTH_START Number(3,0) SMALLINT NOT NULL month start

Default: 6

MONTH_LEN Number(3,0) SMALLINT NOT NULL month leng

Default: 2

DAY_START Number(3,0) SMALLINT NOT NULL day start

Default: 9

DAY_LEN Number(3,0) SMALLINT NOT NULL day length

Default: 2

FLEX_DATE Character(20) VARCHAR2(20) NOT NULL Date Fmt

Default: YYYYMMDD

DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19