EDIINMAPRECFLD

index back

EC Inbound Map Recfields


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)

Prompt Table: EC_DATA_TBL_VW

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
FLDDEFNNAME Character(30) VARCHAR2(30) NOT NULL Definition Name (see PSFLDDEFN).
FLDSEGNAME Character(15) VARCHAR2(15) NOT NULL Segment Name
FLDFIELDNAME Character(18) VARCHAR2(18) NOT NULL 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

Prompt Table: ECINMAP_P1_VW

ECRELATEDRECNAME Character(15) VARCHAR2(15) NOT NULL EC Related Record Name

Prompt Table: ECINMAP_P2_VW

ECRELATEDFIELDNAME Character(18) VARCHAR2(18) NOT NULL EC Related Field Name

Prompt Table: ECINMAP_P3_VW

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19