ECBUSDOCLINK |
index back |
---|---|
EC Business Document Links |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
EC_PACKAGE_CNTL_NB | Character(10) | VARCHAR2(10) NOT NULL | EC Package Control ID |
EC_PACKAGE_VER | Character(6) | VARCHAR2(6) NOT NULL | EC Package Version |
EC_TRANS_GROUP_NBR | Character(18) | VARCHAR2(18) NOT NULL | EC Transaction Group Cntl Nbr |
EC_TRANS_GROUP_VER | Character(6) | VARCHAR2(6) NOT NULL | EC Transaction Group Version |
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. |
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) |
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 |
ECBUSDOCID | Number(9,0) | DECIMAL(9) NOT NULL | EC Business Document ID |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |