| Cost File (COST) | 
|
|
|
|
|
|
 How to Access
|
The following is a list of fields found in the Cost file.
| Tabs3 Cost File | ||
|---|---|---|
| Field Name | Description | Notes |
| _SEQUENCE_NO | Internal Sequence Number | |
| CLIENT_ID | Client ID | |
| REF_NUM | Ref # | |
| DATE | Date of Transaction | |
| TCODE | Tcode | 1-999 |
| TCODE_TYPE | Tcode Type | 0-9 |
| AMOUNT | Amount | |
| HOLD | Status |
H=Hold P=Print U=Ready to be Updated S=Save s=Final billed save |
| SOURCE | Source of Transaction |
B=Billing b=Split Billing R=Remote D=Data Capture Device P or C=PracticeMaster or Tabs3 Connect A=Accounts Payable |
| USER_ID | User ID | |
| CREATE_DATE | Date Entered | |
| CREATE_TIME | Time transaction was created | |
| TIMEKEEPER | Timekeeper Number | |
| BILL_CODE | Bill Code | 0-4 |
| RATE_CODE | Rate Code | 0-9 |
| SALES_TAX | Sales Tax Code | 0-9 |
| PHASE_TASK | Phase/Task Code for Task Code Billing | AA001 through ZZ999 |
| ACTIVITY | Activity or Expense Code | A001-A999, E001-E999, X001-X999 |
| EXPENSE_ADVANCE | Expense/Advance Indicator |
E=Expense A=Advance |
| ORIGINAL_AMT | Amount field stored to calculate write-up or write-down figures | |
| COST_TYPE | Cost Type | 0-9 for cost |
| UNITS | Units | |
| RATE | Rate | |
| MIRROR_SEQ_NO | * | |
| QBEditSeq | * | |
| QBTxnID | * | |
| QBVendor | QuickBooks Vendor | |
| QBAcct | QuickBooks Debit Account | |
| ORIG_TRANS_SEQ_NO | * | |
| DESCRIPTION | Description | maximum 5000 characters |
* Indicates the field is not applicable for ODBC applications. This field is used for internal processing only.
) are registered trademarks of Software Technology, LLC.