ECINMAPFLD |
index back |
---|---|
EC Inbound Map File Fields |
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 |
ECCONVERTCD | Character(1) | VARCHAR2(1) NOT NULL |
EC Field Conversion Type
C=Convert N=No Conversion R=Record ID Value T=Trading Partner Specific Default: N |
ECTPCVTID | Character(10) | VARCHAR2(10) NOT NULL |
Conversion Type ID
Prompt Table: ECTPCVT |
ECFLDSPECIALCD | Character(1) | VARCHAR2(1) NOT NULL |
Special EDI Field Processing
E=EC Entity Code N=None P=Primary Event Code Q=EC Queue Control Number S=Secondary Event Code Default: N |
ECROWIDVALUE | Character(16) | VARCHAR2(16) NOT NULL | EC File Row ID Value |
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 |
DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |