Clients & Profits Worldwide :: Data Dictionary

Free help: USER GUIDE } WHAT'S NEW } SYSTEM MANAGER NEWS

Home > Support > Data Dictionary > AR

Search:

C&P X Data Dictionary: AR

Other files:

acc_periods
access_privs
accounts
addresses
ap
ar
ar_items
archived_jobs
asset_types
asset_files
asset_prefs
avail
billing_info
cal
calendar
change_items
change_order
checks
check_items
clients
contacts
costs
credit_card_prefs
date_count
depts
est_revs
f_preference
finance
global_vars
groups
history
history_client
history_vendor
home
int_items
je
jobs
job_order
job_task
job_types
media_briefs
media_est
media_est_items
media_items
media_plans
media_prefs
meetings
mlink
mlink_prefs
odbcusers
outbox
palm_cats
palm_jobs
palm_tasks
payments
payment_items
pc
pictures
po_items
po_template
prefs
print_specs
programs
projects
proposals
purchase_order
rates
recur_ap
retainers
sales_actions
sales_campaigns
sales_letters
schedule_chart
schedule_header
staff
statements
stations
status_codes
sub_classes
task_table
temp_tasks
thought
time_import
timecard
timeline
user_info
vendors
version
web_html
web_ip_log
web_log
web_prefs
web_users_log
working
worksheets
y1099

AR is the data file that stores data for client invoices. Each AR record contains a single invoice with total balance due from the client. Each AR record has fields for the client and invoce number(i.e., AR_CLIENT_NUM, AR_NUM), billing information including total amount that client has been charged, client has been paid, payment terms, etc. (i.e., AR_TOTAL, AR_AMT_PAID, AR_TERMS), and a record for the AR aging report (i.e. AR_PERIOD, Ar_30, AR_60, AR_90).

See related data files: AR_ITEMS CLIENTS PAYMENT_ITEMS JE

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)

LEGEND:

Type indicates whether a field contains characters (i.e., "char") which contains any combination of letters or numbers, numbers (which has a set number of decimal places), or integers (i.e., numbers that range from 0 to 255 only).

Length shows the size of a field. Character fields have lengths that are fixed, depending on their purpose. Description and note fields have a length of 32000, which make them variable-length; their actual size depends on how much data is entered into them.

Index indicates fields that are indexed in the database, which makes them key fields for finding and sorting data. For best performances on reporting and exporting, searches should made on index fields first.

Need help exporting? See the Exporting Data from Clients & Profits tech note.

For subscribers: VIDEOS } FAQs/TECH NOTES } COMMUNITY } LEARN } BUGS/WISH LIST } TIPS