C&P Data Dictionary: COSTS

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

COSTS is the data file that holds data for all cost detail. The data contained in this file is used primarly on cost detail ased reports (e.g., job cost report in snapshots, unbilled WIP cost report). Each COSTS record has cost detail for a single cost (i.e. Time, Job Cost Check, Expenses, Job Cost A/P, Job Cost Transfer). These amount fields are updated when job cost entries are saved. See related data files:   PO_ITEMS   AP   PAYMENTS Field Name: Type: Length: Index: Description: COST_SEQ sequence Indexed sequence # COST_NUM char 20 Indexed invoice number/check number/time ID # COST_JOB_NUM char 10 Indexed job number COST_TASK char 4 Indexed job task COST_NOTE char 32000 cost notes COST_NET_AMT number 2dp   cost's net amount COST_GROSS_AMT number 2dp cost's gross amount (including markups) COST_HOURS number 2dp   hours (for time sheets only) COST_KIND integer Indexed 0=A/P,checks/1=Time/2=Expenses /3=Transfer/4=Misc/5=Internal Charges/ COST_DATE date   Indexed invoice date/check date/time work date COST_BILL_RATE number 2dp billing rate (for time only) COST_COST_RATE number 2dp   cost rate (for time only) COST_PO_NUM char 15 Indexed purchase order number (for A/P only) COST_BILLABLE integer     billable? (yes/no) COST_VENDOR char 10 Indexed vendor number/staff initials (for time only) COST_PERIOD integer Indexed accounting period COST_CLIENT_NUM char 10 Indexed cost's client number COST_DGL number 2dp   cost's debit G/L# (for A/P, checks only) COST_POSTED date Indexed date posted into the G/L COST_KEY char 15   A/P key (vendor number + invoice number) COST_FINISHED integer task finished? flag COST_MARKUP number 2dp   markup % COST_BILL_AMT number 2dp amount to be billed when posted COST_AR_DATE date   Indexed date on which this cost was last billed COST_AR_NUM char 12 Indexed A/R number on which this cost was billed COST_BILLED_AMT number 2dp amount billed to client on A/R invoice COST_STATUS char 10 Indexed cost status (Billable/Unbilled/Unbillable/On Hold/Cancelled/Write-off) COST_AR_PAID date     date on which this cost's A/R invoice was paid COST_CK_NUM char 10 check number on which this cost's A/R invoice was paid COST_REF char 16 Indexed time key (combines initials + work date) COST_HOURS_BILLED number 2dp actual billed hours COST_OT number 0dp   overtime? flag (yes/no) COST_POX_LINE integer PO line number COST_GL char 20   charge number (copied from job) COST_J_PROD_STATUS number 0dp job's production status COST_J_BILL_STATUS number 0dp   job's billing status COST_PC char 10 profit center COST_QTY number 2dp   quantity used COST_DAYS number 2dp days used COST_COST_EA number 2dp   unit cost COST_SIZE char 6 item size COST_ADDED_BY char 4   who added this? COST_GROSS_EA number 2dp COST_ADV_CK number 0dp   employee expense adv check number COST_EXPORTED short date 1980..2079   date exported (for SQL only) COST_WIP_EXPORTED short date 1980..2079   date WIP exported (for SQL only) COST_WIP_REV_EXPORTED short date 1980..2079   date WIP reversal was 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.