ECOUTMAPFLD

index back

EC Outbound Map File Field


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
ECFIELDVALUECD Character(1) VARCHAR2(1) NOT NULL Field Value Code
C=Child
D=Default
F=Current
I=Agent Value
P=Parent
R=Source Field
T=TP Conversion
V=Convert
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
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

ECPAD Character(1) VARCHAR2(1) NOT NULL Pad Character
ECCAP Character(1) VARCHAR2(1) NOT NULL Caps Field

Y/N Table Edit

Default: N

ECSTRIP_CHAR Character(10) VARCHAR2(10) NOT NULL Strip Characters
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