ECOUTMAPFLD_VW(SQL View) |
Index Back |
|---|---|
EC Outbound Map File Field |
| select ecmapid, ecfilerowid, seqno, fieldname, fieldtype, ecstartpos, length, decimalpos, ecfieldvaluecd, ectpcvtid, ecdefaultvalue, ecdrivercalccd from PS_ECOUTMAPFLD |
| # | 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 | 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 |