AV_RECEIPT_NBRAV_INVLV_HP_VW(SQL View) |
Index Back |
|---|---|
Involvement Merchant View |
| SELECT AV_RECEIPT_NBR , AV_MERCHANT_ID_HP FROM PS_AV_INVLV_G_HDR A , PS_AV_BUS_UNIT_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AV_RECEIPT_NBR |
Character(12) | VARCHAR2(12) NOT NULL | Receipt Number |
| 2 | AV_MERCHANT_ID_HP | Character(12) | VARCHAR2(12) NOT NULL | CR Hosted Merchant ID |