Field
Name: |
Type: |
Length: |
Index: |
Description: |
AR_SEQ |
sequence |
|
x |
sequence # |
AR_NUM |
char |
10 |
x |
invoice number |
AR_JOB_NUM |
char |
10 |
x |
job number (-- for multi-job
or non-job billings) |
AR_CLIENT_NUM |
char |
10 |
x |
client number |
AR_DATE |
short date |
1980..2079 |
x |
invoice date |
AR_POSTED |
short date |
1980..2079 |
x |
date posted to G/L |
AR_AE |
char |
10 |
|
AE (from job; initials) |
AR_TERMS |
char |
20 |
|
payment terms |
AR_PERIOD |
short num |
0dp |
|
accounting period |
AR_PO |
char |
15 |
x |
client's PO number |
AR_DESC |
char |
2000 |
|
invoice description |
AR_DUE_DATE |
short
date |
|
x |
date payment expected to be
made (for cash flow reports) |
AR_COUNT |
short num |
0dp |
|
number of payments made so far |
AR_DISC_DUE |
short date |
1980..2079 |
|
date to get a early-pay discount |
AR_DISC_AMT |
number |
2dp |
|
early-pay discount amount |
AR_AMT_PAID |
number |
2dp |
|
amount paid by client |
AR_TOTAL |
number |
2dp |
|
amount charged to client, including
tax |
AR_DAYS |
number |
0dp |
|
days taken to pay invoice completely |
AR_TAX_AMT1 |
number |
2dp |
|
sales tax amount billed 1 |
AR_TAX_AMT2 |
number |
2dp |
|
sales tax amount billed 2 |
AR_TAXABLE1 |
number |
2dp |
|
taxable sales 1 |
AR_TAXABLE2 |
number |
2dp |
|
taxable sales 2 |
AR_TAX_RATE1 |
number |
4dp |
|
sales tax rate 1 |
AR_TAX_RATE2 |
number |
4dp |
|
sales tax rate 2 |
AR_TAX_CGL1 |
number |
2dp |
|
tax cGL 1 |
AR_TAX_CGL2 |
number |
2dp |
|
tax cGL 2 |
AR_STATUS |
char |
20 |
|
agency contact title, called
AR_AE_TITLE in DML version |
AR_OPEN |
short int |
(0 to 255) |
|
open item (1) balance forward
(0) |
AR_JUMP |
short int |
(0 to 255) |
|
added with jump start? (for
compatibility) |
AR_DGL |
number |
2dp |
|
invoice's debit G/L# |
AR_CURR |
number |
2dp |
|
current balance due (< 30
days) |
AR_30 |
number |
2dp |
|
30-day balance due |
AR_60 |
number |
2dp |
|
60-day balance due |
AR_90 |
number |
2dp |
|
90-day balance due |
AR_120 |
number |
2dp |
|
120-day balance due (unused) |
AR_ADDED_BY |
char |
4 |
|
who added this? |
AR_ADDED_WHEN |
short date |
1980..2079 |
|
added when? |
AR_CLIENT_CONTACT |
char |
40 |
|
client contact (copied form
job) |
AR_AGENCY_CONTACT |
char |
40 |
|
agency contact (copied from
job) |
AR_SHOW_SPECS |
short int |
(0 to 255) |
|
show job specs? flag |
AR_RETAINR_NOTE |
char |
80 |
|
retainer description |
AR_RETAINER_AMT |
number |
2dp |
|
retainer amount applied to invoice |
AR_RETAINER_GL |
number |
2dp |
|
retainer cGL |
AR_BILLING_TYPE |
short num |
0dp |
|
invoice style (determines which
invoice to use) 1=Job 2=Advance 3=Progress 4=Estimate 5=Retainer
6=Multi 7=Misc 8=Finance 9=Media 10=Pre-billing 11=WIP Billing |
AR_COMM_AMT |
number |
2dp |
|
commission amount |
AR_COMM_GL |
number |
2dp |
|
commission cGL |
AR_COMM_DESC |
char |
32000 |
|
commission description |
AR_MISC_AMT1 |
number |
2dp |
|
misc amount |
AR_MISC_GL1 |
number |
2dp |
|
misc cGL |
AR_MISC_DESC1 |
char |
32000 |
|
misc description |
AR_MISC_AMT2 |
Number |
2 dp |
|
misc amount |
AR_MISC_GL2 |
Number |
2 dp |
|
misc cGL |
AR_MISC_DESC2 |
char |
2000 |
|
misc description |
AR_ADDRESS1 |
char |
50 |
|
optional address line |
AR_ADDRESS2 |
char |
50 |
|
optional address line |
AR_ADDRESS3 |
char |
50 |
|
optional address line |
AR_ADDRESS4 |
char |
50 |
|
optional address line |
AR_ADDRESS5 |
char |
50 |
|
optional address line |
AR_TO1 |
char |
10 |
|
print copy 1 |
AR_TO2 |
char |
10 |
|
print copy 2 |
AR_TO3 |
char |
10 |
|
print copy 3 |
AR_TO4 |
char |
10 |
|
print copy 4 |
AR_TO5 |
char |
10 |
|
print copy 5 |
AR_ADDRESS6 |
char |
50 |
|
optional address line |
AR_ZERO_AS |
char |
10 |
|
text that will appear for zero amounts on the printed invoice |
AR_FINANCE_CHG |
Number |
2 dp |
|
finance charge % |
AR_FINANCE_AMT |
Number |
2 dp |
|
finance change amount (calc'd during aging) |
AR_FINANCE_CGL |
Number |
2 dp |
|
finance charge income G/L# |
AR_ROLL_UP |
Number |
0 dp |
|
option - roll up amounts into selected tasks |
AR_SHOW_TOTALS |
Number |
0 dp |
|
option - show totals only |
AR_ADV_PMT |
Number |
2 dp |
|
advance payment amount applied to an invoice |
AR_ADV_PMT_GL |
Number |
2 dp |
|
advance paymen applied GL# |
AR_CHARGE_NUM |
char |
20 |
|
custom invoice form |
AR_PRINT_EST |
Short int |
(0 to 255) |
|
print estimate with invoice? |
AR_SHOW_HOURS |
Boolean |
|
|
hours billed on invoice? flag |
AR_UNPAID |
Short num |
0 dp |
x |
yes=unpaid/no=paid |
AR_KIND |
Short int |
(0 to 255) |
|
special invoice kind (1=broadcast) |
AR_KEY |
char |
20 |
x |
con(AR_CLIENT_NUM, AR_NUM) |
AR_SHIP_ADDRESS1 |
char |
50 |
|
ship to address 1 |
AR_SHIP_ADDRESS2 |
char |
50 |
|
ship to address 2 |
AR_SHIP_ADDRESS3 |
char |
50 |
|
ship to address 3 |
AR_SHIP_ADDRESS4 |
char |
50 |
|
ship to address 4 |
AR_SHIP_ADDRESS5 |
char |
50 |
|
ship to address 5 |
AR_SHIP_ADDRESS6 |
char |
50 |
|
ship to address 6 |
AR_PC |
char |
10 |
x |
invoice's profit center |
AR_APPROVED |
Short int |
(0 to 255) |
|
invoice approved checkbox |
AR_APPROVED_BY |
char |
4 |
|
approver's initials |
AR_APPROVED_DATE |
Short date |
2000..2099 |
|
approved date |
AR_APPROVAL1 |
char |
40 |
|
billing preview - approval name 1 |
AR_APPROVAL2 |
char |
40 |
|
billing preview - approval name 2 |
AR_APPROVAL3 |
char |
40 |
|
billing preview - approval name 3 |
AR_RETURN_DATE |
Short date |
2000..2099 |
|
billing preview - due to be returned ok'd |
AR_BILL_INSTRUCTION S |
char |
2000 |
|
billing preview - billing instructions |
AR_EXPORTED |
Short date |
1980..2079 |
|
date exported (for SQL only) |
AR_PMT_STATUS |
Short int |
(0 to 255) |
|
payment status number |
AR_PMT_STATUS_NO TE |
char |
32000 |
|
payment status note |
AR_PMT_NEXT_DATE |
Date and time |
(#FDT) |
|
date of next collection manager action |
AR_PMT_NEXT_ACTIO N |
Short int |
(0 to 255) |
|
next collection action (uses same codes as AR_PMT_STATUS) |
AR_PMT_NEXT_WHO |
char |
4 |
|
initials of the person who has to do the next collection action |
AR_PMT_NEXT_NOTE |
char |
32000 |
|
description of what to do with the next collection action |
AR_PMT_NEXT_NUM |
Short num |
0 dp |
|
letter number to send at the next collection action (future) |