| # |
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 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 4 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 5 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
RECFIELD_VW
|
| 6 |
FIELDTYPE |
Number(2,0) |
SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
Prompt Table:
EC_DATA_TBL_VW
|
| 7 |
ECRECFLDVALUECD |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Field Value Code
C=EC Agent Calc'd
D=Default Value
F=File Field Value
Default Value: F
|
| 8 |
ECFILEFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
EC File Field Name
|
| 9 |
ECDEFAULTVALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
EC Default Value
|
| 10 |
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
|
| 11 |
ECRELATEDROWID |
Character(3) |
VARCHAR2(3) NOT NULL |
EC Related Row ID
Prompt Table:
ECINMAP_P1_VW
|
| 12 |
ECRELATEDRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
EC Related Record Name
Prompt Table:
ECINMAP_P2_VW
|
| 13 |
ECRELATEDFIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
EC Related Field Name
Prompt Table:
ECINMAP_P3_VW
|