Field
Name: |
Type: |
Length: |
Index: |
Description: |
AP_SEQ |
sequence |
|
x |
sequence # |
AP_NUM |
char |
20 |
x |
invoice number |
AP_VENDOR_NUM |
char |
10 |
x |
vendor number |
AP_DATE |
short date |
1980..2079 |
x |
invoice date |
AP_KEY |
char |
30 |
x |
dupe key (vendor+invoice
number) |
AP_DESC |
char |
2000 |
|
invoice description |
AP_CGL |
number |
2dp |
|
credit G/L# |
AP_NET_AMT |
number |
2dp |
|
net cost amount (the
amount you'll pay) |
AP_COMM_NET |
number |
2dp |
|
commissionable net
amount |
AP_MARKUP_PC |
number |
2dp |
|
markup % |
AP_TAX_AMT |
number |
2dp |
|
sales tax amount |
AP_GROSS_AMT |
number |
2dp |
|
gross amount (including
markup) |
AP_POSTED |
short date |
1980..2079 |
x |
date posted |
AP_TOTAL_AMT |
number |
2dp |
|
invoice total (the
amount you'll pay) |
AP_DISC_DATE |
short date |
1980..2079 |
|
due date to get discount |
AP_JUMPSTART |
short int |
(0 to 255) |
|
added from Jump Start
(for compatibility) |
AP_ADDED_BY |
char |
4 |
|
who added this entry? |
AP_ADDED_WHEN |
short date |
1980..2079 |
|
date entry was added |
AP_VOUCHER |
char |
10 |
|
voucher number - for
media interface |
AP_TERMS1 |
number |
0dp |
|
payment terms - % discount |
AP_TERMS2 |
number |
0dp |
|
payment terms - days
for discount |
AP_TERMS3 |
number |
0dp |
|
payment terms - net
days |
AP_PAY_DATE |
date |
|
x |
date to pay (for cash
flow report) |
AP_PERIOD |
number |
0dp |
|
accounting period |
AP_CURRENT |
number |
2dp |
|
current balance due
(< 30 days) |
AP_30 |
number |
2dp |
|
30-day balance due |
AP_60 |
number |
2dp |
|
60-day balance due |
AP_90 |
number |
2dp |
|
90-day balance due |
AP_AUTO_PAY |
char |
10 |
x |
internal key for auto
checkwriting |
AP_GST_GL |
number |
2dp |
|
GST/VAT tax G/L# |
AP_GST1 |
short num |
2dp |
|
GST/VAT tax amount
1 |
AP_GST2 |
number |
2dp |
|
GST/VAT tax amount
2 |
AP_AMT_PAID |
number |
2dp |
|
amount paid from Checkbook |
AP_CLIENT_PAID |
short date |
1980..2079 |
|
date client paid this
invoice |
AP_CLOSE_PO |
short int |
(0 to 255) |
|
close this PO? flag |
AP_UNPAID |
short num |
0dp |
x |
yes=unpaid/no=paid |
AP_KIND |
short int |
(0 to 255) |
|
0=Job Cost/1=Overhead/2=Accrual/ |
AP_DISC_TAKEN |
short num |
2dp |
|
early pmt
discounts taken (checkbook) |
AP_EXPORTED |
short date |
1980..2079 |
|
date exported (SQL)
only |
