Field
Name: |
Type: |
Length: |
Index: |
Description: |
POX_SEQ |
sequence |
|
x |
sequence |
POX_LINE_NUMBER |
short int |
(0 to 255) |
|
line number; used for sorting |
POX_JOB_NUM |
char |
10 |
x |
job number |
POX_TASK |
char |
4 |
|
job task |
POX_DESC |
char |
2000 |
|
a complete description |
POX_PROGRAM |
char |
30 |
|
|
POX_QTY |
number |
0dp |
|
quantity / {number of spots} |
POX_COST_EACH |
number |
4dp |
|
unit cost |
POX_COST |
number |
2dp |
|
quantity * unit cost |
POX_MARKUP |
number |
2dp |
|
markup % |
POX_GROSS |
number |
2dp |
|
cost + markup |
POX_COST_PAID |
number |
2dp |
|
amount billed from A/P, net |
POX_GROSS_PAID |
number |
2dp |
|
amount billed from A/P, gross |
POX_PO_NUM |
char |
12 |
x |
PO number (for reference) |
POX_BILLABLE |
short int |
(0 to 255) |
|
billable -yes or no? |
POX_UNIT |
char |
6 |
|
unit of measure |
POX_NAME |
char |
40 |
|
item name (appears on window) |
POX_KEY |
char |
15 |
x |
POX_PO_NUM +POX_LINE_NUMBER |
POX_BUYDETID |
short num |
0dp |
|
media interface (or MI_SEQ) |
POX_DUE_DATE |
short date |
1980..2079 |
x |
due date (or materials due date) |
POX_DUE_DATE2 |
short date |
1980..2079 |
x |
due date 2 (space close date) |
POX_ISSUE_DATE |
char |
12 |
|
issue date (from media estimates) / {day} |
POX_REVISION |
char |
10 |
|
revision (from media estimates) |
POX_AP_OK |
char |
10 |
|
invoice ok (from media estimates) |
POX_AD_SIZE |
char |
25 |
|
ad size / {dates} |
POX_AD_NAME |
char |
25 |
|
ad#/caption / {time} |
POX_AR_NUM |
char |
12 |
x |
A/R number from pre-billing |
POX_PUB |
char |
25 |
|
media publication name |
POX_CLIENT_NUM |
char |
10 |
x |
|
POX_BILL_NET |
short int |
(0 to 255) |
|
Insertion orders - bill net, not gross option |
POX_TYPE |
short num |
0dp |
x |
/0=Purchase Order/1=Insertion Order/2=Work Order/3=Change
Order/4=Broadcast Order |
POX_RATING |
short num |
2dp |
|
broadcast - rating |
POX_CPP |
short num |
2dp |
|
broadcast - cost per rating point |
POX_CPM |
short num |
2dp |
|
broadcast - cost per 1000 |
POX_MAKEGOOD |
short int |
(0 to 255) |
|
makegood? |
POX_AR_AMOUNT |
short num |
2dp |
|
amount billed from A/R |
POX_COST_NUM |
char |
20 |
|
A/P invoice which billed this invoice amount |
POX_BILL_DATE |
short date |
1920..2079 |
x |
due invoice was billed |
POX_SALES_TAX |
short int |
(0 to 255) |
|
|
POX_ISSUE_DATE2 |
short date |
1980..2079 |
x |
|
POX_TRADE |
short int |
(0 to 255) |
|
cash or trade? (0=cash/1=trade) |
POX_RUN_DATE |
short date |
1980..2079 |
x |
actual date the ad appears or airs |