CPTY_OBMAP_XREF(SQL Table) |
Index Back |
---|---|
Cpty EDI Outbound Map X-Ref |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
2 | COUNTERPARTY | Character(5) | VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table: BANK_TR_CPTY_VW |
3 | 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: ECTRANS_OUT_VW |