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
| 