| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
ECFILELISTPATH |
Character(200) |
VARCHAR2(200) NOT NULL |
File List Path
|
| 4 |
ECFILELISTNAME |
Character(100) |
VARCHAR2(100) NOT NULL |
File List Name
|
| 5 |
ECONEFILEPATH |
Character(200) |
VARCHAR2(200) NOT NULL |
Single File Path
|
| 6 |
ECONEFILENAME |
Character(100) |
VARCHAR2(100) NOT NULL |
Single File Name
|
| 7 |
ECBUSDOCID |
Number(9,0) |
DECIMAL(9) NOT NULL |
EC Business Document ID
Prompt Table:
ECBUSHDR_IN_VW
|
| 8 |
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
|
| 9 |
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
|
| 10 |
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
|
| 11 |
ECINDRIVEROPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Inbound EC Driver Run Option
F=Single File
I=Single Instance
L=File List Driven
Default Value: L
|
| 12 |
ECOUTOPT_ECTRANSID |
Character(1) |
VARCHAR2(1) NOT NULL |
EC Trans ID
Y/N Table Edit
Default Value: N
|
| 13 |
ECOUTOPT_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit
Y/N Table Edit
Default Value: N
|
| 14 |
ECOUTOPT_ECAPPTPID |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor/Customer
Y/N Table Edit
Default Value: N
|
| 15 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 16 |
ECCUSTVNDRVAL |
Character(15) |
VARCHAR2(15) NOT NULL |
PS Customer/Vendor Number
|
| 17 |
ECTRANSID_WRK |
Character(15) |
VARCHAR2(15) NOT NULL |
EC Trans ID
Prompt Table:
%EDITTABLE
|
| 18 |
ECSQCDIR |
Character(200) |
VARCHAR2(200) NOT NULL |
ECOUTMAP.SQC Directory
|
| 19 |
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 Value: N
|
| 20 |
ECMAPID |
Character(10) |
VARCHAR2(10) NOT NULL |
EC Map ID
Prompt Table:
ECMAPDEFN
|
| 21 |
TP_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
EC Profile ID
Prompt Table:
ECTPPROFILE
|
| 22 |
CVT_PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
EC Convert Profile ID
Prompt Table:
ECCVTPROFILE
|
| 23 |
ECENTITYCD |
Character(8) |
VARCHAR2(8) NOT NULL |
PeopleSoft Entity Code
Prompt Table:
ECENTITYCDS
|
| 24 |
ECFORCETRANS |
Character(15) |
VARCHAR2(15) NOT NULL |
Forced Trans Id
Prompt Table:
ECTRANS_IN_VW
|
| 25 |
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
|
| 26 |
ECENTITYIAEC |
Character(4) |
VARCHAR2(4) NOT NULL |
Internal Alias Entity Code
|
| 27 |
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.
|
| 28 |
ECCSVDEL |
Character(1) |
VARCHAR2(1) NOT NULL |
CSV Delimiter
Default Value: "
|
| 29 |
ECCSVFLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Comma Separated Format
Y/N Table Edit
Default Value: N
|
| 30 |
ECCSVDELNUM |
Character(1) |
VARCHAR2(1) NOT NULL |
No Delimiter for Numeric ?
Y/N Table Edit
Default Value: N
|
| 31 |
ECCSVSEP |
Character(1) |
VARCHAR2(1) NOT NULL |
CSV Separator
Default Value: ,
|
| 32 |
ECSUPROW |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppress Rowid
Y/N Table Edit
Default Value: N
|
| 33 |
ECMESSAGE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Message Switch
Y/N Table Edit
Default Value: N
|
| 34 |
ECSINGLEDOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Single Document File
Y/N Table Edit
Default Value: N
|
| 35 |
ECKEEPQSTATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Keep Queue Status
Y/N Table Edit
Default Value: N
|
| 36 |
ECSEPOUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Output Flag
Y/N Table Edit
Default Value: N
|