EDIOUTMAPFLD

index back

EC Outbound Map File Field


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
ECFIELDVALUECDCharacter(1)VARCHAR2(1) NOT NULLField Value Code
C=Child
D=Default
F=Current
I=Agent Value
P=Parent
R=Source Field
T=TP Conversion
V=Convert
X=Not Applicable

Default: R

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

Prompt Table: ECTPCVT

ECDEFAULTVALUECharacter(30)VARCHAR2(30) NOT NULLEC Default Value
ECDRIVERCALCCDCharacter(3)VARCHAR2(3) NOT NULLEC Driver Calc Code
ACT=Action Code/Primary Event Code
DAT=Current Date
DTM=Current Datetime
ECD=EC Entity Code Flag
ECQ=EC Queue Instance
ECT=EC Trans ID
SEC=Secondary Event Code
SEQ=Incremented Sequence Nbr
TIM=Current Time
TPC=Trading Partner Conversion
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

ECPADCharacter(1)VARCHAR2(1) NOT NULLPad Character
ECCAPCharacter(1)VARCHAR2(1) NOT NULLCaps Field

Y/N Table Edit

Default: N

ECSTRIP_CHARCharacter(10)VARCHAR2(10) NOT NULLStrip Characters
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