| # |
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 |
TREAS_HEADER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
|
| 4 |
JPM_AGGREGATE_ID |
Number(5,0) |
INTEGER NOT NULL |
The manner in which aggregate instruments are identified for purposes of analytics processing in t
|
| 5 |
JPM_COMPOSITE_ID |
Number(5,0) |
INTEGER NOT NULL |
The manner in which composite instruments are identified for purposes of analytics processing in t
|
| 6 |
JPM_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
"A given deal transaction's associated instrument type
|