TABLE DETAIL REFERENCE:		ReceivePaymentLine
(US VERSION)

FIELD NAME	TYPE	LENGTH	QRY	MOD	INS	REQ INS	VALIDATE	REL
TxnID	Varchar	36	True	False	False	N/A	String
TimeCreated	Timestamp	27	True	False	False	N/A	CCCC-MM-DDThh:mm:ssZ
TimeModified	Timestamp	27	True	False	False	N/A	CCCC-MM-DDThh:mm:ssZ
EditSequence	Varchar	16	True	False	False	N/A	String
TxnNumber	Integer	13	True	False	False	N/A	11.0
CustomerRefListID	Varchar	36	True	False	True	Yes	String
CustomerRefFullName	Varchar	209	True	True	True	Yes	String
ARAccountRefListID	Varchar	36	True	False	True	No	String
ARAccountRefFullName	Varchar	159	True	True	True	No	String
TxnDate	Date	10	True	True	True	No	CCCC-MM-DD
TxnDateMacro	Varchar	23	True	False	False	N/A	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	Varchar	20	True	True	True	No	String
TotalAmount	Decimal	11	True	True	True	No	8.2
PaymentMethodRefListID	Varchar	36	True	False	True	No	String
PaymentMethodRefFullName	Varchar	31	True	True	True	No	String
Memo	Varchar	4095	True	True	True	No	String
DepositToAccountRefListID	Varchar	36	True	False	True	No	String
DepositToAccountRefFullName	Varchar	159	True	True	True	No	String
CreditCardTxnInfoInputCreditCardNumber	Varchar	25	True	False	True	No	String
CreditCardTxnInfoInputExpirationMonth	Integer	13	True	False	True	No	11.0
CreditCardTxnInfoInputExpirationYear	Integer	13	True	False	True	No	11.0
CreditCardTxnInfoInputNameOnCard	Varchar	41	True	False	True	No	String
CreditCardTxnInfoInputCreditCardAddress	Varchar	41	True	False	True	No	String
CreditCardTxnInfoInputCreditCardPostalCode	Varchar	41	True	False	True	No	String
CreditCardTxnInfoInputCommercialCardCode	Varchar	50	True	False	True	No	String
CreditCardTxnInfoInputTransactionMode	Varchar	14	True	False	True	No	CardNotPresent CardPresent
CreditCardTxnInfoResultResultCode	Integer	13	True	False	True	No	11.0
CreditCardTxnInfoResultResultMessage	Varchar	500	True	False	True	No	String
CreditCardTxnInfoResultCreditCardTransID	Varchar	24	True	False	True	No	String
CreditCardTxnInfoResultMerchantAccountNumber	Varchar	32	True	False	True	No	String
CreditCardTxnInfoResultAuthorizationCode	Varchar	12	True	False	True	No	String
CreditCardTxnInfoResultAVSStreet	Varchar	12	True	False	True	No	Pass Fail NotAvailable
CreditCardTxnInfoResultAVSZip	Varchar	12	True	False	True	No	Pass Fail NotAvailable
CreditCardTxnInfoResultReconBatchID	Varchar	84	True	False	True	No	String
CreditCardTxnInfoResultPaymentGroupingCode	Integer	13	True	False	True	No	11.0
CreditCardTxnInfoResultPaymentStatus	Varchar	9	True	False	True	No	Unknown Completed
CreditCardTxnInfoResultTxnAuthorizationTime	Timestamp	27	True	False	True	No	CCCC-MM-DDThh:mm:ssZ
CreditCardTxnInfoResultTxnAuthorizationStamp	Integer	13	True	False	True	No	11.0
CreditCardTxnInfoResultClientTransID	Varchar	16	True	False	True	No	String
IsAutoApply	Bit	5	True	False	True	No	1 0 true false
UnusedPayment	Decimal	11	True	False	False	N/A	8.2
UnusedCredits	Decimal	11	True	False	False	N/A	8.2
AppliedToTxnTxnID	Varchar	36	True	False	True	Yes	String
AppliedToTxnPaymentAmount	Decimal	11	True	True	True	No	8.2
AppliedToTxnTxnType	Varchar	14	True	False	False	N/A	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
AppliedToTxnTxnDate	Date	10	True	False	False	N/A	CCCC-MM-DD
AppliedToTxnRefNumber	Varchar	20	True	False	False	N/A	String
AppliedToTxnBalanceRemaining	Decimal	11	True	False	False	N/A	8.2
AppliedToTxnAmount	Decimal	11	True	False	False	N/A	8.2
AppliedToTxnSetCreditCreditTxnID	Varchar	36	True	True	True	No	String
AppliedToTxnSetCreditAppliedAmount	Decimal	11	True	True	True	No	8.2
AppliedToTxnDiscountAmount	Decimal	11	True	True	True	No	8.2
AppliedToTxnDiscountAccountRefListID	Varchar	36	True	False	True	No	String
AppliedToTxnDiscountAccountRefFullName	Varchar	159	True	True	True	No	String
FQSaveToCache	Bit	5	True	False	True	No	FQSaveToCache
FQPrimaryKey	Varchar	73	True	False	False	N/A	FQPrimaryKey