| Fee File (FEE) | 
|
|
|
|
|
|
 How to Access
|
The following is a list of fields found in the Fee file.
| Tabs3 Fee 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 |
| RATE | Rate | |
| HOURS | Hours to Bill | |
| CATEGORY | Category | 0-999 |
| WORKED_HOURS | Worked Hours | |
| MIRROR_SEQ_NO | * | |
| QBEditSeq | * | |
| QBTxnID | * | |
| ORIG_TRANS_SEQ_NO | * | |
| LOCATION | Geolocation | |
| 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.