Field
Name: |
Type: |
Length: |
Index: |
Description: |
AX_SEQ |
sequence |
|
x |
sequence # |
AX_JOB_NUM |
char |
10 |
x |
job number |
AX_TASK |
char |
4 |
x |
job task |
AX_AR_NUM |
char |
10 |
x |
invoice number |
AX_AMT |
number |
2dp |
|
billing amount |
AX_SORT |
short num |
0dp |
|
sort (copied from job task) |
AX_GROUP |
short num |
0dp |
|
group (copied from job task) |
AX_TAXABLE1 |
boolean |
|
|
taxable 1 flag (yes/no) |
AX_TAXABLE2 |
boolean |
|
|
taxable 2 flag (yes/no) |
AX_DESC |
char |
2000 |
|
line item description |
AX_DATE |
short date |
1980..2079 |
x |
invoice date |
AX_CGL |
number |
2dp |
|
billing amount credit G/L#
(income) |
AX_POSTED |
short date |
1980..2079 |
x |
date posted into G/L |
AX_PERIOD |
short num |
0dp |
|
accounting period |
AX_NAME |
char |
50 |
|
task name/billing description |
AX_HOURS_BILLED |
number |
2dp |
|
hours billed this invoice |
AX_HIDE |
number |
0dp |
|
hide option |
AX_ROLL_UP |
char |
4 |
|
hide item, but roll up billing
amount into a task |
AX_SHOW_DESC |
short int |
(0 to 255) |
|
show line item notes |
AX_QTY |
number |
0dp |
|
quantity (or number of spots) |
AX_POX_KEY |
char |
15 |
|
for media/pre-billing: POX_PO_NUM+POX_LINE_NUMBER |
AX_PUB |
char |
20 |
|
for media billing: publication/station |
AX_ISSUE_DATE |
char |
15 |
|
media issue date |
AX_COST |
short num |
2dp |
|
for media billing - net cost
for WIP JE |
AX_EXPORTED |
short date |
1980..2079 |
|
date exported (SQL only) |