ECINMAPFLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECMAPID	Character(10)	VARCHAR2(10) NOT NULL	EC Map ID
2	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.
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.) Prompt Table: EC_DATA_TBL_VW
6	ECSTARTPOS	Number(5,0)	INTEGER NOT NULL	Field Start Position
7	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
8	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
9	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 Value: N
10	ECTPCVTID	Character(10)	VARCHAR2(10) NOT NULL	Conversion Type ID Prompt Table: ECTPCVT
11	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 Value: N
12	ECROWIDVALUE	Character(16)	VARCHAR2(16) NOT NULL	EC File Row ID Value
13	DELIMIT_DATE	Character(1)	VARCHAR2(1) NOT NULL	Delimiter Default Value: /
14	YEAR_START	Number(3,0)	SMALLINT NOT NULL	year start Default Value: 1
15	YEAR_LEN	Number(3,0)	SMALLINT NOT NULL	year length Default Value: 4
16	MONTH_START	Number(3,0)	SMALLINT NOT NULL	month start Default Value: 6
17	MONTH_LEN	Number(3,0)	SMALLINT NOT NULL	month leng Default Value: 2
18	DAY_START	Number(3,0)	SMALLINT NOT NULL	day start Default Value: 9
19	DAY_LEN	Number(3,0)	SMALLINT NOT NULL	day length Default Value: 2
20	FLEX_DATE	Character(20)	VARCHAR2(20) NOT NULL	Date Fmt Default Value: YYYYMMDD
21	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description