PowerExchange Adapters for PowerCenter
- PowerExchange Adapters for PowerCenter 10.5.4
- All Products
id
| Customer Name
| Invoices
| Service Level
| Contacts
| Ratings
|
---|---|---|---|---|---|
1111
| John
| [{invoice_id=123,item=toaster, price=456,discount=0.2},
{invoice_id=124,item=oven, price=12345, discount=0.3}]
| Silver
| [{type=primary,name="John Johnson"},
{type=invoicing,name="Jane Johnson"}]
| [7,8]
|
2222
| Jane
| [{invoice_id=125,item=blender, price=7456,discount=0.5},
| Gold
| [{type=primary,name="Jane Johnson"}
| [5,6]
|
id
| Customer Name
| Number of Invoices
| Service Level
| Number of Contacts
| Number of Ratings
|
---|---|---|---|---|---|
1111
| John
| 2
| Silver
| 2
| 2
|
2222
| Jane
| 1
| Gold
| 1
| 2
|
CustomerTable.id
| Invoices_index
| invoice_id
| item
| price
| discount
|
---|---|---|---|---|---|
1111
| 1
| 123
| toaster
| 456
| 0.2
|
1111
| 2
| 124
| oven
| 12345
| 0.3
|
2222
| 1
| 125
| blender
| 7456
| 0.5
|
CustomerTable.id
| Contacts_index
| type
| name
|
---|---|---|---|
1111
| 1
| primary
| John Johnson
|
1111
| 2
| invoicing
| Jane Johnson
|
2222
| 1
| primary
| Jane Johnson
|
CustomerTable.id
| Ratings_index
| Ratings_value
|
---|---|---|
1111
| 1
| 7
|
1111
| 2
| 8
|
2222
| 1
| 5
|
2222
| 2
| 6
|