Clients & Profits Worldwide :: Data Dictionary

Free help: USER GUIDE } BLOG } SYSTEM MANAGER NEWS

Home > Support > Data Dictionary > CHECKS

C&P X Data Dictionary: CHECKS

Other files:

ACC_PERIODS
ACCOUNTS
AP
AR
AR_ITEMS
BILLING_INFO
CHANGE_ITEMS
CHANGE_ORDER
CHECKS
CHECK_ITEMS
CLIENTS
COSTS
DATE_COUNT
EST_REVS
FINANCE
GROUPS
INT_ITEMS
JE
JOBS
JOB_ORDER
JOB_TASK
JOB_TYPES
MEDIA_BRIEFS
MEDIA_EST
MEDIA_EST_ITEMS
MEDIA_ITEMS
MEDIA_PLANS
PAYMENTS
PAYMENT_ITEMS
PC
PO_ITEMS
PO_TEMPLATE
PRINT_SPECS
PROGRAMS
PROJECTS
PROPOSALS
PURCHASE_ORDER
RATES
RECUR_AP
RETAINERS
SCHEDULE_CHART
SCHEDULE_HEADER
STATEMENTS
STATIONS
STATUS_CODES
SUB_CLASSES
TASK_TABLE
TEMP_TASKS
TIMECARD
TIMELINE
VENDORS
WORKING
WORKSHEETS
Y1099

CHECKS is the header file that stores checks. Each CHECKS record contains a single check. It is a data file used for printing checks. Each record has fields for payee name and address (i.e.,CK_PAYEE and CK_ADDRESS1-3), amounts to pay (i.e., CK_AMOUNT, CK_NET_AMT, and CK_GROSS [net & gross amounts are for job cost checks]) for each check. These amount fields are updated when entries are posted. Financial statements are also created from these amount fields.

See related data files: VENDORS CHECK_ITEMS

Field Name:	Type:	Length:	Index:	Description:
CK_SEQ	sequence		x	sequence #
CK_NUM	short num	0dp	x	check number
CK_VENDOR_NUM	char	10	x	vendor number (-- for direct disbursements)
CK_PAYEE	char	40	x	payee name
CK_ADDRESS1	char	40		payee address 1
CK_ADDRESS2	char	40		payee address 2
CK_ADDRESS3	char	40		payee address 3
CK_DATE	short date	1980..2079	x	check date
CK_POSTED	short date	1980..2079	x	date posted into G/L
CK_MEMO	char	2000		check memo
CK_NET_AMT	number	2dp		check net amount
CK_CGL	number	2dp		check's credit G/L# (usually cash)
CK_PAY	short int	(0 to 255)		check type (1=vendor payment/0 =disbursement)
CK_ADDED_BY	char	4		added by who?
CK_ADDED_WHEN	date			date added
CK_CLEARED	short int	(0 to 255)		cleared the bank? flag
CK_DONT_PRINT	short int	(0 to 255)		handwritten check/don't print it flag
CK_AMOUNT	char	80		written amount of check
CK_TYPE	char	10	x	check type (usually "Check")
CK_GROSS	number	2dp		check amount + markup
CK_DISC_AMT	number	2dp		discount amount
CK_DISC_GL	number	2dp		discount G/L
CK_OK	short int	(0 to 255)	x	check in balance? flag
CK_PERIOD	short num	0dp		accounting period
CK_1099	long int			include on year-end 1099 report? flag
CK_TAX_ID	char	15		vendor tax ID - for 1099s
CK_EMP_ADV_EXP	short num	2dp		employee's expense advances - posted so far
CK_EMPL_ADV_CK	short num	0dp		empl's exp adv - their check number

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