| Archive File (ARCHIVE) | 
|
|
|
|
|
|
 How to Access
|
The following is a list of fields found in the Archive file.
| Tabs3 Archive File | ||
|---|---|---|
| Field Name | Description | Notes |
| _SEQUENCE_NO | Internal Sequence Number | |
| CLIENT_ID | Client ID | |
| REC_TYPE | Record Type |
F=Fee C=Cost P=Payment U=Fund |
| REF_NUM | Reference Number | |
| TIMEKEEPER | Timekeeper Number | |
| DATE | Date of Transaction | |
| BILL_CODE | Bill Code | 0-4 |
| RATE_CODE | Rate Code | 0-9 |
| TCODE | Tcode | 0-999 |
| TCODE_TYPE | Tcode Type | 0-9 |
| AMOUNT | Amount | |
| HOLD | Status |
H=Hold P=Print U=Ready to be Updated S=Save |
| SALES_TAX | Sales Tax Code | 0-9 |
| SOURCE | Source of Transaction |
Fees, Costs, Payments B=Billing R=Remote D=Data Capture Device C or P=PracticeMaster or Tabs3 Connect A=Accounts Payable T=Trust Client Funds Transactions M=Manual Payment W=Client Funds Withdrawal |
| 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 |
| APPLYTO_STMT_NUM | Statement Number payment was applied to | |
| APPLYTO_STMT_ID | Sequence Number of statement payment was applied to | |
| UNITS | Units | |
| RATE | Rate | |
| ORIGINAL_AMT | Amount (used to determine write up and write down information) | |
| HOURS | Hours | |
| CATEGORY_COST_TYPE | Category or Cost Type | 0-999 for fees or 0-9 for cost |
| STATEMENT_NUMBER | Statement Number on which transaction was billed | |
| STATEMENT_ID | Sequence Number of Statement on which transaction was billed | |
| STATEMENT_DATE | Statement Date | |
| COURTESY_DISCOUNT | Courtesy Discount Amount | |
| WIP_SEQNO | * | |
| PYMT_LINK | * | |
| WORKED_HOURS | Worked Hours | |
| QBEditSeq | * | |
| QBTxnID | * | |
| QBVendor | QuickBooks Vendor | |
| QBAcct | QuickBooks Debit Account | |
| USER_ID | User ID | |
| CREATE_DATE | Date Entered | |
| CREATE_TIME | Time transaction was created | |
| GL_CHECK_NUM | Check Number | |
| GL_REF | * | |
| GL_RECEIPT_TYPE | Receipt Type | 0=Cash, 1=Check, 2=Credit Card, 3=Other Type, 4=Client Funds, 5=EFT |
| TR_SEQNO | Sequence Number of Trust transaction (if transaction originated in Trust) | |
| FP_LINK | Client Funds Payment Sequence Number | |
| ORIG_TRANS_SEQ_NO | * | |
| LP_TRANSACTION_ID | LawPay Transaction ID | |
| COMBINE_ID | * | |
| RESERVED_LONG_1 | * | |
| LOCATION | Geolocation | |
| RESERVED_ALPHA_1 | * | |
| DESCRIPTION | Description | Maximum 5000 characters |
| CC_TRANS_ID | PayFuse Transaction ID | |
| PP_PAYMENT_ID | LexCharge Payment ID | |
| RESERVED_MEMO_1 | * | |
| RESERVED_MEMO_2 | * | |
* Indicates the field is not applicable for ODBC applications. This field is used for internal processing only.
) are registered trademarks of Software Technology, LLC.