ECINMAP_P1_VW (SQL View)	Index Back
EC Inbound Map Recfields

ECINMAP_P1_VW

(SQL View)

EC Inbound Map Recfields

select distinct ecmapid, ecfilerowid from PS_ECINMAPRECFLD

# 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.

#	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.