C&P Data Dictionary: JE

Other files: ACCOUNTS AP AR AR_ITEMS BILLING_INFO CHANGE_ORDER CHECKS CHECK_ITEMS CLIENTS COSTS DEPTS GROUPS HISTORY HISTORY_CLIENT INT_ITEMS JE JOBS JOB_ORDER JOB_TASK JOB_TYPES MEDIA_EST MEDIA_EST_ITEMS MEDIA_ITEMS MEDIA_PLANS PAYMENTS PAYMENT_ITEMS PC PICTURES PO_ITEMS PO_TEMPLATE PRINT_SPECS PROGRAMS PROJECTS PURCHASE_ORDER RATES RECUR_AP RETAINERS STAFF STATIONS STATUS_CODES SUB_CLASSES TASK_TABLE VENDORS WEB_IP_LOG WEB_USERS WORKSHEETS

JE is the data file that stores the Journal Entries. Each JE record contains a single Journal Entry. It is a lookup file used primarly on Detailed G/L reports (e.g., Audit Trail and Income Statement). Each JE record has fields for the type of entry (i.e., JE_KIND, JE_REF, etc.), when and who added (i.e., JE_DATE, JE_POSTED, JE_PERIOD, ) and accounting / job data (i.e., JE_CREDIT, JE_DEBIT, JE_DESC) for each Journal Entry. These detail fields are updated when entries are posted. See related data files:      ACCOUNTS   AP   AR   CHECKS   PAYMENTS Field Name: Type: Length: Index: Description: JE_SEQ sequence x sequence # JE_DATE date   x entry date from invoice, check, etc. JE_REF char 15 x invoice, check, payment number JE_POSTED date   x date posted into G/L JE_DESC char 32000 description JE_DEBIT number 2dp   debit amount JE_CREDIT number 2dp credit amount JE_AC_NUM number 2dp x account number JE_PERIOD number 0dp x accounting period JE_JOB_NUM char 10 x job number JE_CLIENT_NUM char 10 x client number JE_RECONCILE number 2dp x key for bank reconciliation (100000=not cleared) JE_SOURCE integer x source (0=General/1=AP/2=AR/3=CK/4=PMT) JE_ADDED_BY char 4   who added this? JE_ADDED_WHEN date when was this JE added? JE_VENDOR_NUM char 10 x vendor number JE_AUTO_REV integer auto-reverse? JE_AUTO_ACC integer     auto-accrural JE? JE_TEMP_REC integer temporarily reconciled? JE_KIND integer     0=user/1=auto-rev/2=WIP/3=recurring 4=adjusting/5=clearing JE_PAY_BATCH char 10 Batch ID for client payments JE_GL_REC integer     G/L reconciliation - period JE_EXPORTED short date 1980..2079 date exported (for SQL only) 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.