Document toolboxDocument toolbox

Blueshift Automatic Delivery

The Automatic Delivery data object, formerly known as Book Club or BCL, was created to allow Blueshift users to target customers based on specific automatic delivery attributes.


Attribute

Advantage Field

Blueshift Field

Logic/Rules

Attribute

Advantage Field

Blueshift Field

Logic/Rules

Ship to Customer Number

shp_ctm

customer_id



Member ID

ctc_id

member_id



Club Code

club_cde

club_code



Product Class

prd_cls

product_class



Product Series Code

prs_cde

series_code



Product Series Branch Code

prs_bch

series_branch_code



Product Series Step

prs_stp

series_step



Set Date

set_dte

setup_date



Quantity Ordered

qty_ord

quantity_ordered



Shipping Frequency

shp_frq

shipping_frequency



Start Date

str_dte

series_start_date



Series Member Status

smb_sta

series_status

If smb_sta = A Then Active
If smb_sta = C Then Completed
If smb_sta = M Then Moved/Terminated
If smb_sta = S Then Suspended
If smb_sta = T Then Terminated
If smb_sta = Z Then Cancelled
Else UNKNOWN

Amount Ordered

amt_ord

amount_ordered



BCL Next Price

bcl_nprc

next_price



Item Number 1

itm_num_1

item_1



Item Number 2

itm_num_2

item_2



Item Number 3

itm_num_3

item_3



Item Number 4

itm_num_4

item_4



Order Released

ord_rel

order_released



Total Sales Amount

tot_sls

total_sales_amount



Last Ship Date

lsh_dte

last_ship_date



Owning Org



owning_org



com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.