MDW CJ Table Spec: fact_vendor_cost_cj_detail
fact_vendor_cost_cj_detail
Why is it important? Vendor reported data pulled from the cj api.
Term | Definition | Datatype |
actionstatus | actionStatus | String(1000) |
actiontrackerid | actionTrackerID | String(1000) |
actiontrackername | actionTrackerName | String(1000) |
actiontype | actionType | String(1000) |
advcommissionamountusd | advCommissionAmountUsd | Amount |
advertiserid | advertiserID | String(1000) |
advertisername | advertiserName | String(1000) |
cjfeeusd | cjFeeUsd | Amount |
clickdate | clickDate | Date |
eventdate | eventDate | Date |
newtofile | newToFile | String(1000) |
orderdiscountusd | orderDiscountUsd | Amount |
orderid | orderID | String(1000) |
postingdate | postingDate | Date |
original | original | String(1000) |
pubcommissionamountusd | pubCommissionAmountUsd | Amount |
publisherid | publisherID | String(1000) |
publishername | publisherName | String(1000) |
saleamountusd | saleAmountUsd | Amount |
source | Source | String(1000) |
websiteid | websiteID | String(1000) |
websitename | websiteName | String(1000) |
batch_id | Batch ID | String(1000) |
