· Home    · License/Purchase    · Online help    · FAQ    · Contact    · Download    · PAD    · AliaWeb   
 Personal finance » On-line Shop » Advertise server » OnLine help

orders (Table)

Orders are customers, whitch order advertising.

Applies To

AdServer Database

Parameters

Parameter Name Description
order_id A Long unique order autonumber
ad_id A Long variable containing advertiser number
order_name A Text variable containing order name
order_desc A Text variable containing order description
order_paid A Boolean variable containing order paid status
order_active A Boolean variable containing order status
writer_id A Long variable containing writer
write_dt A Date variable containing date of write
change_dt A Date variable containing date of change


Remarks

Parameter ad_id specifies relationship to advertisers table.

Parameter order_paid is used to specify if orders entered for the advertiser are paid (for filtration and account purposes). Value -1 (True) means that order is paid; value 0 (False) means that order is not paid.

Parameter order_active is used to specify if campaigns entered for the advertiser is still active (valid). If it is not, campaign is not readed to server memory structures. Value -1 (True) means that order is valid; value 0 (False) means that order is invalid.

Example

Following example shows default order definition:

Parameter Name Default Value
order_id 0
ad_id 0
order_name "Default order"
order_desc "Default order"
order_paid 0 (False / No)
order_active -1 (True / Yes)
writer_id -2
write_dt Now()
change_dt Null


See Also

advertisers, campaigns

Copyright © 1998 - 2018 Aliaweb, s.r.o.
All Rights Reserved