ECINMAPRECFD_VW

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
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: RECFIELD_VW
FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101)
ECRECFLDVALUECD	Character(1)	VARCHAR2(1) NOT NULL	Record Field Value Code C=EC Agent Calc'd D=Default Value F=File Field Value Default: F
ECFILEFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	EC File Field Name
ECDEFAULTVALUE	Character(30)	VARCHAR2(30) NOT NULL	EC Default Value
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
ECRELATEDROWID	Character(3)	VARCHAR2(3) NOT NULL	EC Related Row ID
ECRELATEDRECNAME	Character(15)	VARCHAR2(15) NOT NULL	EC Related Record Name
ECRELATEDFIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	EC Related Field Name

index back

(c)David Kurtz 2020, www.go-faster.co.uk

PeopleTools 8.58 PTRef generated on 21-DEC-20