| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| ECFILELISTPATH |
Character(200) |
VARCHAR2(200) NOT NULL |
File List Path
|
| ECFILELISTNAME |
Character(100) |
VARCHAR2(100) NOT NULL |
File List Name
|
| ECONEFILEPATH |
Character(200) |
VARCHAR2(200) NOT NULL |
Single File Path
|
| ECONEFILENAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Single File Name
|
| ECBUSDOCID |
Number(9,0) |
DECIMAL(9) NOT NULL |
EC Business Document ID
Prompt Table:
ECBUSHDR_IN_VW
|
| ECTRANSID |
Character(15) |
VARCHAR2(15) NOT NULL |
Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager
identifies a transaction type(like "PO" for Purchase Orders)
Prompt Table:
ECBUSDOCLN_VW
|
| ECQUEUEINSTANCE |
Number(9,0) |
DECIMAL(9) NOT NULL |
Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
Prompt Table:
ECBUSDOCLN1_VW
|
| ECTRANSINOUTSW |
Character(1) |
VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value
is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound
|
| ECINDRIVEROPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Inbound EC Driver Run Option
F=Single File
I=Single Instance
L=File List Driven
Default: L
|
| ECOUTOPT_ECTRANSID |
Character(1) |
VARCHAR2(1) NOT NULL |
EC Trans ID
Y/N Table Edit
Default: N
|
| ECOUTOPT_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit
Y/N Table Edit
Default: N
|
| ECOUTOPT_ECAPPTPID |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor/Customer
Y/N Table Edit
Default: N
|
| BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| ECCUSTVNDRVAL |
Character(15) |
VARCHAR2(15) NOT NULL |
PS Customer/Vendor Number
|
| ECTRANSID_WRK |
Character(15) |
VARCHAR2(15) NOT NULL |
EC Trans ID
Prompt Table:
%EDITTABLE
|
| ECSQCDIR |
Character(200) |
VARCHAR2(200) NOT NULL |
ECOUTMAP.SQC Directory
|
| ECFORCEFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
EC Force Flag
8=Force with Map Information
9=Force with Partner Information
N=Do NOT Force Profile
Default: N
|
| ECMAPID |
Character(10) |
VARCHAR2(10) NOT NULL |
EC Map ID
Prompt Table:
ECMAPDEFN
|
| TP_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
EC Profile ID
Prompt Table:
ECTPPROFILE
|
| CVT_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
EC Convert Profile ID
Prompt Table:
ECCVTPROFILE
|
| ECENTITYCD |
Character(8) |
VARCHAR2(8) NOT NULL |
PeopleSoft Entity Code
Prompt Table:
ECENTITYCDS
|
| ECFORCETRANS |
Character(15) |
VARCHAR2(15) NOT NULL |
Forced Trans Id
Prompt Table:
ECTRANS_IN_VW
|
| EC_EXT_TP_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Electronic Commerce External Trading Partner ID. Used in EDI Manager. The External Trading Partners are the customers, vendors, etc. that will do business with the PeopleSoft enterprise. External TPID
can be found out from the external businesses directly or from the VAN.
Prompt Table:
ECEXTPARTNER
|
| ECENTITYIAEC |
Character(4) |
VARCHAR2(4) NOT NULL |
Internal Alias Entity Code
|
| EC_ALIAS_TP_ID |
Character(16) |
VARCHAR2(16) NOT NULL |
Electronic Commerce Alias Trading Partner ID. An Alias can be used for the Internal Business Entities. Used in EDI Manager.
|
| ECCSVDEL |
Character(1) |
VARCHAR2(1) NOT NULL |
CSV Delimiter
Default: "
|
| ECCSVFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comma Separated Format
Y/N Table Edit
Default: N
|
| ECCSVDELNUM |
Character(1) |
VARCHAR2(1) NOT NULL |
No Delimiter for Numeric ?
Y/N Table Edit
Default: N
|
| ECCSVSEP |
Character(1) |
VARCHAR2(1) NOT NULL |
CSV Separator
Default: ,
|
| ECSUPROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress Rowid
Y/N Table Edit
Default: N
|
| ECMESSAGE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Switch
Y/N Table Edit
Default: N
|
| ECSINGLEDOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Document File
Y/N Table Edit
Default: N
|
| ECKEEPQSTATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Queue Status
Y/N Table Edit
Default: N
|
| ECSEPOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Output Flag
Y/N Table Edit
Default: N
|