| Payment File (PAYMENT) |
|
|
The following is a list of fields found in the Payment file.
| Tabs3 Payment 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 |
| SOURCE | Source of Transaction |
B=Billing R=Remote D=Data Capture Device A=Accounts Payable T=Trust Accounting |
| USER_ID | User ID | |
| CREATE_DATE | Date Entered | |
| CREATE_TIME | Time transaction was created | |
| EXPENSE_ADVANCE | Expense/Advance Indicator (if TCODE_TYPE = 2) |
E=Expense A=Advance |
| APPLYTO_STMT_NUM | Statement Number for Payment Application | |
| APPLYTO_STMT_ID | Sequence Number of Statement Number for Payment Application | |
| PAYMENT_LEFT | Payment Amount Unapplied | |
| GL_CHECK_NUM | Check Number | |
| GL_REF | GL Reference | Defaults to Client ID |
| GL_RECEIPT_TYPE | Receipt Type | 0=Cash, 1=Check, 2=Credit Card, 3=Other Type, 4=Client Funds, 5=EFT |
| TR_SEQNO | Sequence # of transaction in Trust if payment originated in Trust | |
| CF_SEQNO | Sequence # of linked client funds transaction | |
| LP_TRANSACTION_ID | LawPay Transaction ID | |
| DESCRIPTION | Description | maximum 5000 characters |
| CC_TRANS_ID | PayFuse Transaction ID | |
| PP_PAYMENT_ID | LexCharge Payment ID | |