ECTRANSIDPG_BATCH_ID_00PG_BATID_IN_VW(SQL View) |
Index Back |
|---|---|
99-00 PELL Inbound Prompt VwPELL Inbound Prompt record for 99-00 |
| SELECT ECTRANSID, PG_BATCH_ID_00, PELL_TRANS_DTTM FROM PS_PG_HDR_00_EC WHERE ECTRANSINOUTSW = 'I' |
| # | 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 | PG_BATCH_ID_00 |
Character(26) | VARCHAR2(26) NOT NULL | Pell Batch ID |
| 3 | PELL_TRANS_DTTM | DateTime(26) | TIMESTAMP | Pell Trans Date/Time |