ECTRANSIDECQUEUEINSTANCESFA_ASG_REC_VW2(SQL View) |
Index Back |
|---|---|
ACG/Smart Grant Recon |
| SELECT DISTINCT A.ECTRANSID , A.ECQUEUEINSTANCE , B.DESCR FROM PS_SFA_ASG_REC_EC A , PS_ECTRANS B WHERE A.ECTRANSINOUTSW = 'I' AND A.ECTRANSID = B.ECTRANSID |
| # | 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 | 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. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |