ECRUNCNTL

index back

Run Control EC


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

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19