ECTRANS_OUT_VW(SQL View) |
Index Back |
---|---|
EC Transaction List View |
select distinct ectransid, descr from PS_ECTRANS where ectransinoutsw = 'O' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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) |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |