ECINMAPFLD

index back

EC Inbound Map File Fields


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)

Prompt Table: EC_DATA_TBL_VW

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
DELIMIT_DATECharacter(1)VARCHAR2(1) NOT NULLDelimiter

Default: /

YEAR_STARTNumber(3,0)SMALLINT NOT NULLyear start

Default: 1

YEAR_LENNumber(3,0)SMALLINT NOT NULLyear length

Default: 4

MONTH_STARTNumber(3,0)SMALLINT NOT NULLmonth start

Default: 6

MONTH_LENNumber(3,0)SMALLINT NOT NULLmonth leng

Default: 2

DAY_STARTNumber(3,0)SMALLINT NOT NULLday start

Default: 9

DAY_LENNumber(3,0)SMALLINT NOT NULLday length

Default: 2

FLEX_DATECharacter(20)VARCHAR2(20) NOT NULLDate Fmt

Default: YYYYMMDD

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