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