ECINMAPRECFD_VW

#	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	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: RECFIELD_VW
6	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
7	ECRECFLDVALUECD	Character(1)	VARCHAR2(1) NOT NULL	Record Field Value Code C=EC Agent Calc'd D=Default Value F=File Field Value Default Value: F
8	ECFILEFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	EC File Field Name
9	ECDEFAULTVALUE	Character(30)	VARCHAR2(30) NOT NULL	EC Default Value
10	ECINAGENTCALCCD	Character(3)	VARCHAR2(3) NOT NULL	EC Inbound Agent Calc Code ACT=Action Code Conversion APV=Apportion Parent Value ASV=Average Summary Value BEX=Business Doc Level External TP BIN=Business Doc Level Internal TP CNT=Cumulative Counter Variable DAT=Current Date DTM=Current Date and Time ECQ=EC Queue Instance ECT=EC Transaction ID FID=File Name/File ID IPV=Inherit Parent Value NSV=Minimum Summary Value OID=Operator ID PID=Process Instance RID=Run Control ID SEQ=Incremented Key Sequence Nbr TIM=Current Time TPC=Trading Partner Conversion TSV=Total/Accumulate Summary Value XSV=Maximum Summary Value
11	ECRELATEDROWID	Character(3)	VARCHAR2(3) NOT NULL	EC Related Row ID
12	ECRELATEDRECNAME	Character(15)	VARCHAR2(15) NOT NULL	EC Related Record Name
13	ECRELATEDFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	EC Related Field Name