ECRUNCNTL

index back

Run Control EC


PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
ECFILELISTPATHCharacter(200)VARCHAR2(200) NOT NULLFile List Path
ECFILELISTNAMECharacter(100)VARCHAR2(100) NOT NULLFile List Name
ECONEFILEPATHCharacter(200)VARCHAR2(200) NOT NULLSingle File Path
ECONEFILENAMECharacter(100)VARCHAR2(100) NOT NULLSingle File Name
ECBUSDOCIDNumber(9,0)DECIMAL(9) NOT NULLEC Business Document ID

Prompt Table: ECBUSHDR_IN_VW

ECTRANSIDCharacter(15)VARCHAR2(15) NOT NULLElectronic 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

ECQUEUEINSTANCENumber(9,0)DECIMAL(9) NOT NULLElectronic 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

ECTRANSINOUTSWCharacter(1)VARCHAR2(1) NOT NULLElectronic 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
ECINDRIVEROPTCharacter(1)VARCHAR2(1) NOT NULLInbound EC Driver Run Option
F=Single File
I=Single Instance
L=File List Driven

Default: L

ECOUTOPT_ECTRANSIDCharacter(1)VARCHAR2(1) NOT NULLEC Trans ID

Y/N Table Edit

Default: N

ECOUTOPT_BUCharacter(1)VARCHAR2(1) NOT NULLBusiness Unit

Y/N Table Edit

Default: N

ECOUTOPT_ECAPPTPIDCharacter(1)VARCHAR2(1) NOT NULLVendor/Customer

Y/N Table Edit

Default: N

BUSINESS_UNITCharacter(5)VARCHAR2(5) NOT NULLBusiness Unit
ECCUSTVNDRVALCharacter(15)VARCHAR2(15) NOT NULLPS Customer/Vendor Number
ECTRANSID_WRKCharacter(15)VARCHAR2(15) NOT NULLEC Trans ID

Prompt Table: %EDITTABLE

ECSQCDIRCharacter(200)VARCHAR2(200) NOT NULLECOUTMAP.SQC Directory
ECFORCEFLGCharacter(1)VARCHAR2(1) NOT NULLEC Force Flag
8=Force with Map Information
9=Force with Partner Information
N=Do NOT Force Profile

Default: N

ECMAPIDCharacter(10)VARCHAR2(10) NOT NULLEC Map ID

Prompt Table: ECMAPDEFN

TP_PROFILE_IDCharacter(10)VARCHAR2(10) NOT NULLEC Profile ID

Prompt Table: ECTPPROFILE

CVT_PROFILE_IDCharacter(10)VARCHAR2(10) NOT NULLEC Convert Profile ID

Prompt Table: ECCVTPROFILE

ECENTITYCDCharacter(8)VARCHAR2(8) NOT NULLPeopleSoft Entity Code

Prompt Table: ECENTITYCDS

ECFORCETRANSCharacter(15)VARCHAR2(15) NOT NULLForced Trans Id

Prompt Table: ECTRANS_IN_VW

EC_EXT_TP_IDCharacter(16)VARCHAR2(16) NOT NULLElectronic 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

ECENTITYIAECCharacter(4)VARCHAR2(4) NOT NULLInternal Alias Entity Code
EC_ALIAS_TP_IDCharacter(16)VARCHAR2(16) NOT NULLElectronic Commerce Alias Trading Partner ID. An Alias can be used for the Internal Business Entities. Used in EDI Manager.
ECCSVDELCharacter(1)VARCHAR2(1) NOT NULLCSV Delimiter

Default: "

ECCSVFLGCharacter(1)VARCHAR2(1) NOT NULLComma Separated Format

Y/N Table Edit

Default: N

ECCSVDELNUMCharacter(1)VARCHAR2(1) NOT NULLNo Delimiter for Numeric ?

Y/N Table Edit

Default: N

ECCSVSEPCharacter(1)VARCHAR2(1) NOT NULLCSV Separator

Default: ,

ECSUPROWCharacter(1)VARCHAR2(1) NOT NULLSuppress Rowid

Y/N Table Edit

Default: N

ECMESSAGE_SWCharacter(1)VARCHAR2(1) NOT NULLMessage Switch

Y/N Table Edit

Default: N

ECSINGLEDOCCharacter(1)VARCHAR2(1) NOT NULLSingle Document File

Y/N Table Edit

Default: N

ECKEEPQSTATUSCharacter(1)VARCHAR2(1) NOT NULLKeep Queue Status

Y/N Table Edit

Default: N

ECSEPOUTCharacter(1)VARCHAR2(1) NOT NULLSeparate Output Flag

Y/N Table Edit

Default: N

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