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

2000

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

short date

1980..2079

Indexed

invoice date/check date/time work date

COST_BILL_RATE

short num

2dp

billing rate (for time only)

COST_COST_RATE

short num

2dp

cost rate (for time only)

COST_PO_NUM

char

15

Indexed

purchase order number (for A/P only)

COST_BILLABLE

short int

(0 to 255)

billable? (yes/no)

COST_VENDOR

char

10

Indexed

vendor number/staff initials (for time only)

COST_PERIOD

short int

(0 to 255)

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

short date

1980..2079

Indexed

date posted into the G/L

COST_KEY

char

15

A/P key (vendor number + invoice number)

COST_FINISHED

short int

(0 to 255)

task finished? flag

COST_MARKUP

short num

2dp

markup %

COST_BILL_AMT

number

2dp

amount to be billed when posted

COST_AR_DATE

short date

1980..2079

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

short date

1980..2079

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

short num

2dp

actual billed hours

COST_OT

short num

0dp

overtime? flag (yes/no)

COST_POX_LINE

short int

(0 to 255)

PO line number

COST_GL

char

20

charge number (copied from job)

COST_J_PROD_STATUS

short num

0dp

job's production status

COST_J_BILL_STATUS

short num

0dp

job's billing status

COST_PC

char

10

profit center

COST_QTY

short num

2dp

quantity used

COST_DAYS

short num

2dp

days used

COST_COST_EA

short num

2dp

unit cost

COST_SIZE

char

6

item size

COST_ADDED_BY

char

4

who added this?

COST_GROSS_EA

short num

2dp

COST_ADV_CK

short num

0dp

employee expense adv check number