ECTRANSIDPrompt Table: SFA_ASG_HDR_VW
ECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
PG_BATCH_ID_00Prompt Table: SFA_ASG_BTID_VW
SFA_ASG_MRR_SRC(SQL View) |
Index Back |
|---|---|
ACG/SMART MRR Search ViewACG/SMART MRR Search View |
| SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , PG_BATCH_ID_00 , OPRID , PELL_TRANS_DTTM FROM PS_SFA_ASG_HDR_EC WHERE ECTRANSID LIKE 'AGMR%' OR ECTRANSID LIKE 'SGMR%' |
| # | 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)
Prompt Table: SFA_ASG_HDR_VW |
| 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 | 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 Default Value: I |
| 4 | PG_BATCH_ID_00 |
Character(26) | VARCHAR2(26) NOT NULL |
Batch ID
Prompt Table: SFA_ASG_BTID_VW |
| 5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 6 | PELL_TRANS_DTTM | DateTime(26) | TIMESTAMP | Pell Trans Date/Time |