DepositLine Table

Back to list of tables.

Column	Data type	Data type name	Length	Can be queried?	Can be updated?	Can be inserted?	Mandatory when inserting?	Format	Refers To	Version introduced in	Edition available in
ID	12	VARCHAR	75
TxnID	12	VARCHAR	36	True	False	False	False	%s		2.0	US, CA, UK
TimeCreated	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		2.0	US, CA, UK
TimeModified	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		2.0	US, CA, UK
EditSequence	12	VARCHAR	16	True	False	False	False	%s		2.0	US, CA, UK
TxnNumber	4	INTEGER	9	True	False	False	False	%12.0f		2.0	US, CA, UK
TxnDate	9	DATE	91	True	False	True	False	CCCC-MM-DD		2.0	US, CA, UK
TxnDateMacro	12	VARCHAR	25	True	False	False	False	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		2.0	US, CA, UK
DepositToAccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	2.0	US, CA, UK
DepositToAccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	2.0	US, CA, UK
Memo	12	VARCHAR	4095	True	True	True	False	%s		2.0	US, CA, UK
DepositTotal	2	NUMERIC	15	True	False	False	False	%10.2f		2.0	US, CA, UK
CurrencyRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	8.0	US, CA, UK
CurrencyRef_FullName	12	VARCHAR	64	True	True	True	True	%s	FullName	8.0	US, CA, UK
ExchangeRate	2	NUMERIC	18	True	False	False	False	%6.6f		8.0	US, CA, UK
DepositTotalInHomeCurrency	2	NUMERIC	15	True	False	False	False	%10.2f		8.0	US, CA, UK
CashBackInfo_TxnLineID	12	VARCHAR	36	True	False	False	False	%s		2.0	US, CA, UK
CashBackInfo_AccountRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	2.0	US, CA, UK
CashBackInfo_AccountRef_FullName	12	VARCHAR	159	True	True	True	False	%s	FullName	2.0	US, CA, UK
CashBackInfo_Memo	12	VARCHAR	4095	True	True	True	False	%s		2.0	US, CA, UK
CashBackInfo_Amount	2	NUMERIC	15	True	False	True	False	%10.2f		2.0	US, CA, UK
ExternalGUID	12	VARCHAR	40							9.0	US, CA, UK
DepositLine_TxnType	12	VARCHAR	22	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate Invoice InventoryAdjustment JournalEntry LiabilityAdjustment PurchaseOrder ReceivePayment SalesReceipt SalesTaxPaymentCheck TimeTracking Transfer VendorCredit		2.0	US, CA, UK
DepositLine_TxnID	12	VARCHAR	36	True	False	False	False	%s		2.0	US, CA, UK
DepositLine_TxnLineID	12	VARCHAR	36	True	True	False	False	%s		2.0	US, CA, UK
DepositLine_PaymentTxnID	12	VARCHAR	36	True	True	True	False	%s		2.0	US, CA, UK
DepositLine_PaymentTxnLineID	12	VARCHAR	36	True	True	True	False	%s		7.0	US, CA, UK
DepositLine_OverrideMemo	12	VARCHAR	255							2.0	US, CA, UK
DepositLine_OverrideMemo	12	VARCHAR	255							2.0	US, CA, UK
DepositLine_OverrideMemo	12	VARCHAR	255							2.0	US, CA, UK
DepositLine_OverrideMemo	12	VARCHAR	255							2.0	US, CA, UK
DepositLine_EntityRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	2.0	US, CA, UK
DepositLine_EntityRef_FullName	12	VARCHAR	255	True	True	True	False	%s	FullName	2.0	US, CA, UK
DepositLine_AccountRef_ListID	12	VARCHAR	36	True	True	True	True	%s	ListID	2.0	US, CA, UK
DepositLine_AccountRef_FullName	12	VARCHAR	159	True	True	True	True	%s	FullName	2.0	US, CA, UK
DepositLine_Memo	12	VARCHAR	4095	True	True	True	False	%s		2.0	US, CA, UK
DepositLine_CheckNumber	12	VARCHAR	11	True	True	True	False	%s		2.0	US, CA, UK
DepositLine_PaymentMethodRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	2.0	US, CA, UK
DepositLine_PaymentMethodRef_FullName	12	VARCHAR	31	True	True	True	False	%s	Name	2.0	US, CA, UK
DepositLine_ClassRef_ListID	12	VARCHAR	36	True	True	True	False	%s	ListID	2.0	US, CA, UK
DepositLine_ClassRef_FullName	12	VARCHAR	159	True	True	True	False	%s	FullName	2.0	US, CA, UK
DepositLine_Amount	3	NUMERIC	15	True	True	True	False	%10.2f		2.0	US, CA, UK
RQUseCachedID	-7	BIT	2							2.0	US, CA, UK

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•