ECINMAPFLD_VW

index back

EC Inbound Map File Fields


select ecmapid, ecfilerowid, seqno, fieldname, fieldtype, ecstartpos, length, decimalpos, ecconvertcd, ectpcvtid, ecfldspecialcd, ecrowidvalue from ps_ecinmapfld

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
SEQNONumber(5,0)INTEGER NOT NULLSequence Number
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
ECSTARTPOSNumber(5,0)INTEGER NOT NULLField Start Position
LENGTHNumber(5,0)INTEGER NOT NULLLength
DECIMALPOSNumber(2,0)SMALLINT NOT NULLDecimal Positions
ECCONVERTCDCharacter(1)VARCHAR2(1) NOT NULLEC Field Conversion Type
C=Convert
N=No Conversion
R=Record ID Value
T=Trading Partner Specific

Default: N

ECTPCVTIDCharacter(10)VARCHAR2(10) NOT NULLConversion Type ID

Prompt Table: ECTPCVT

ECFLDSPECIALCDCharacter(1)VARCHAR2(1) NOT NULLSpecial EDI Field Processing
E=EC Entity Code
N=None
P=Primary Event Code
Q=EC Queue Control Number
S=Secondary Event Code

Default: N

ECROWIDVALUECharacter(16)VARCHAR2(16) NOT NULLEC File Row ID Value
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19