| 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
|
| RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFIELD_VW
|
| FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101)
Prompt Table:
EC_DATA_TBL_VW
|
| ECRECFLDVALUECD |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Field Value Code
C=EC Agent Calc'd
D=Default Value
F=File Field Value
Default: F
|
| ECFILEFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
EC File Field Name
|
| FLDDEFNNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Definition Name (see PSFLDDEFN).
|
| FLDSEGNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Segment Name
|
| FLDFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name
|
| ECDEFAULTVALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
EC Default Value
|
| ECINAGENTCALCCD |
Character(3) |
VARCHAR2(3) NOT NULL |
EC Inbound Agent Calc Code
ACT=Action Code Conversion
APV=Apportion Parent Value
ASV=Average Summary Value
BEX=Business Doc Level External TP
BIN=Business Doc Level Internal TP
CNT=Cumulative Counter Variable
DAT=Current Date
DTM=Current Date and Time
ECQ=EC Queue Instance
ECT=EC Transaction ID
FID=File Name/File ID
IPV=Inherit Parent Value
NSV=Minimum Summary Value
OID=Operator ID
PID=Process Instance
RID=Run Control ID
SEQ=Incremented Key Sequence Nbr
TIM=Current Time
TPC=Trading Partner Conversion
TSV=Total/Accumulate Summary Value
XSV=Maximum Summary Value
|
| ECRELATEDROWID |
Character(3) |
VARCHAR2(3) NOT NULL |
EC Related Row ID
Prompt Table:
ECINMAP_P1_VW
|
| ECRELATEDRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
EC Related Record Name
Prompt Table:
ECINMAP_P2_VW
|
| ECRELATEDFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
EC Related Field Name
Prompt Table:
ECINMAP_P3_VW
|