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 |