| 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
|
| SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101)
Prompt Table:
EC_DATA_TBL_VW
|
| ECSTARTPOS |
Number(5,0) |
INTEGER NOT NULL |
Field Start Position
|
| LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| ECFIELDVALUECD |
Character(1) |
VARCHAR2(1) NOT NULL |
Field 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
|
| ECTPCVTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Conversion Type ID
Prompt Table:
ECTPCVT
|
| ECDEFAULTVALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
EC Default Value
|
| ECDRIVERCALCCD |
Character(3) |
VARCHAR2(3) NOT NULL |
EC 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_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Delimiter
Default: /
|
| YEAR_START |
Number(3,0) |
SMALLINT NOT NULL |
year start
Default: 1
|
| YEAR_LEN |
Number(3,0) |
SMALLINT NOT NULL |
year length
Default: 4
|
| MONTH_START |
Number(3,0) |
SMALLINT NOT NULL |
month start
Default: 6
|
| MONTH_LEN |
Number(3,0) |
SMALLINT NOT NULL |
month leng
Default: 2
|
| DAY_START |
Number(3,0) |
SMALLINT NOT NULL |
day start
Default: 9
|
| DAY_LEN |
Number(3,0) |
SMALLINT NOT NULL |
day length
Default: 2
|
| FLEX_DATE |
Character(20) |
VARCHAR2(20) NOT NULL |
Date Fmt
Default: YYYYMMDD
|
| ECPAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Pad Character
|
| ECCAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Caps Field
Y/N Table Edit
Default: N
|
| ECSTRIP_CHAR |
Character(10) |
VARCHAR2(10) NOT NULL |
Strip Characters
|
| DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|