| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ECMAPID |
Character(10) |
VARCHAR2(10) NOT NULL |
EC Map ID
|
| 2 |
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.
|
| 3 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 4 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 5 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
Prompt Table:
EC_DATA_TBL_VW
|
| 6 |
ECSTARTPOS |
Number(5,0) |
INTEGER NOT NULL |
Field Start Position
|
| 7 |
LENGTH |
Number(5,0) |
INTEGER NOT NULL |
Length
|
| 8 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 9 |
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 Value: R
|
| 10 |
ECTPCVTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Conversion Type ID
Prompt Table:
ECTPCVT
|
| 11 |
ECDEFAULTVALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
EC Default Value
|
| 12 |
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
|
| 13 |
DELIMIT_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Delimiter
Default Value: /
|
| 14 |
YEAR_START |
Number(3,0) |
SMALLINT NOT NULL |
year start
Default Value: 1
|
| 15 |
YEAR_LEN |
Number(3,0) |
SMALLINT NOT NULL |
year length
Default Value: 4
|
| 16 |
MONTH_START |
Number(3,0) |
SMALLINT NOT NULL |
month start
Default Value: 6
|
| 17 |
MONTH_LEN |
Number(3,0) |
SMALLINT NOT NULL |
month leng
Default Value: 2
|
| 18 |
DAY_START |
Number(3,0) |
SMALLINT NOT NULL |
day start
Default Value: 9
|
| 19 |
DAY_LEN |
Number(3,0) |
SMALLINT NOT NULL |
day length
Default Value: 2
|
| 20 |
FLEX_DATE |
Character(20) |
VARCHAR2(20) NOT NULL |
Date Fmt
Default Value: YYYYMMDD
|
| 21 |
ECPAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Pad Character
|
| 22 |
ECCAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Caps Field
Y/N Table Edit
Default Value: N
|
| 23 |
ECSTRIP_CHAR |
Character(10) |
VARCHAR2(10) NOT NULL |
Strip Characters
|
| 24 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|