ECINMAPRECFLD

index back

EC Inbound Map Recfields


PeopleSoft Field NameField TypeColumn TypeDescription
ECMAPIDCharacter(10)VARCHAR2(10) NOT NULLEC Map ID
ECFILEROWIDCharacter(3)VARCHAR2(3) NOT NULLElectronic 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
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
SEQNONumber(5,0)INTEGER NOT NULLSequence Number
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

Prompt Table: RECFIELD_VW

FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)

Prompt Table: EC_DATA_TBL_VW

ECRECFLDVALUECDCharacter(1)VARCHAR2(1) NOT NULLRecord Field Value Code
C=EC Agent Calc'd
D=Default Value
F=File Field Value

Default: F

ECFILEFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLEC File Field Name
ECDEFAULTVALUECharacter(30)VARCHAR2(30) NOT NULLEC Default Value
ECINAGENTCALCCDCharacter(3)VARCHAR2(3) NOT NULLEC 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
ECRELATEDROWIDCharacter(3)VARCHAR2(3) NOT NULLEC Related Row ID

Prompt Table: ECINMAP_P1_VW

ECRELATEDRECNAMECharacter(15)VARCHAR2(15) NOT NULLEC Related Record Name

Prompt Table: ECINMAP_P2_VW

ECRELATEDFIELDNAMECharacter(18)VARCHAR2(18) NOT NULLEC Related Field Name

Prompt Table: ECINMAP_P3_VW

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