Clients & Profits | Data Dictionary

Free help: USER GUIDE

Home > Support > Data Dictionary > CHECK_ITEMS

C&P X Data Dictionary: CHECK_ITEMS

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

CHECK_ITEMS is the data file that stores the Check line items. Each CHECK_ITEMS record contains a single check line item. Each CHECK_ITEMS record has fields for the check line item's debit G/L (A/P invoice or job cost) held in the CX_DGL field, vendor & invoice numbers for payment (CX_AP_NUM and CX_VENDOR_NUM), and job or task number for expenses (CX_JOB_NUM and CX_TASK). These fields are updated when checks are saved.

See related data files: CHECKS AP

Field Name:	Type:	Length:	Index:	Description:
CX_SEQ	sequence		x	sequence
CX_CK_DATE	short date	1980..2079	x	check date
CX_NET_AMT	number	2dp		net cost amount
CX_DGL	number	2dp		check line item's debit G/L# (usually A/P or job cost)
CX_AP_NUM	char	20	x	invoice number (for payment)
CX_VENDOR_NUM	char	10	x	vendor number (for payment)
CX_JOB_NUM	char	10		job number (for expense)
CX_TASK	char	4		task (for expense)
CX_POSTED	short date	1980.2079	x	date posted
CX_GROSS_AMT	number	2dp		gross amount, including markup
CX_CK_NUM	number	0dp	x	check number
CX_COMM_AMT	number	2dp		commission amount
CX_MARKUP_PC	number	2dp		markup %
CX_DISC_AMT	short num	2dp		discount amount
CX_PERIOD	short int	(0 to 255)	x	accounting period
CX_COST_SEQ	short num	0dp		seq # of COSTS record
CX_DISC_DGL	number	2dp		discount taken dGL
CX_BILLABLE	short int	(0 to 255)		billable?
CX_NOTE	char	2000		optional note to describe each purchase or payment

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 } LEARN

Sign up for Clients & Profits news:
© Clients & Profits, Inc. w e l o v e a d v e r t i s i n g