ECMAPIDECFILEROWIDSEQNOC=Convert
N=No Conversion
R=Record ID Value
T=Trading Partner Specific
Default Value: N
Prompt Table: ECTPCVT
E=EC Entity Code
N=None
P=Primary Event Code
Q=EC Queue Control Number
S=Secondary Event Code
Default Value: N
ECINMAPFLD_VW(SQL View) |
Index Back |
|---|---|
EC Inbound Map File Fields |
| select ecmapid, ecfilerowid, seqno, fieldname, fieldtype, ecstartpos, length, decimalpos, ecconvertcd, ectpcvtid, ecfldspecialcd, ecrowidvalue from PS_ECINMAPFLD |
| # | 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.) |
| 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 | 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 Value: N |
| 10 | ECTPCVTID | Character(10) | VARCHAR2(10) NOT NULL |
Conversion Type ID
Prompt Table: ECTPCVT |
| 11 | 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 Value: N |
| 12 | ECROWIDVALUE | Character(16) | VARCHAR2(16) NOT NULL | EC File Row ID Value |