ChargeLinkedTxn 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	TxnID	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
CustomerRef_ListID	12	VARCHAR	36	True	False	False	True	%s	ListID	2.0	US, CA, UK
CustomerRef_FullName	12	VARCHAR	209	True	False	False	True	%s	FullName	2.0	US, CA, UK
TxnDate	91	DATE	10	True	False	False	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
RefNumber	12	VARCHAR	11	True	False	False	False	%s		2.0	US, CA, UK
ItemRef_ListID	12	VARCHAR	36	True	False	False	True	%s	ListID	2.0	US, CA, UK
ItemRef_FullName	12	VARCHAR	159	True	False	False	True	%s	FullName	2.0	US, CA, UK
InventorySiteRef_ListID	12	VARCHAR	36	True	False	False	True	%s	ListID	10.0	US, CA, UK
InventorySiteRef_FullName	12	VARCHAR	31	True	False	False	True	%s	Name	10.0	US, CA, UK
Quantity	3	DECIMAL	18	True	False	False	False	%10.5f		2.0	US, CA, UK
UnitOfMeasure	12	VARCHAR	31	True	False	False	False	%s		7.0	US, CA, UK
Rate	3	DECIMAL	18	True	False	False	False	%10.5f		2.0	US, CA, UK
OptionForPriceRuleConflict	12	VARCHAR	36					%s		2.0	US, CA, UK
Amount	3	DECIMAL	15	True	False	False	False	%10.2f		2.0	US, CA, UK
BalanceRemaining	3	DECIMAL	15	True	False	False	False	%10.2f		2.0	US, CA, UK
Description	12	VARCHAR	4095	True	False	False	False	%s		2.0	US, CA, UK
ARAccountRef_ListID	12	VARCHAR	36	True	False	False	False	%s		2.0	US, CA, UK
ARAccountRef_FullName	12	VARCHAR	159	True	False	False	False	%s		2.0	US, CA, UK
ClassRef_ListID	12	VARCHAR	36	True	False	False	False	%s		2.0	US, CA, UK
ClassRef_FullName	12	VARCHAR	159	True	False	False	False	%s		2.0	US, CA, UK
BilledDate	91	DATE	6	True	False	False	False	CCCC-MM-DD		2.0	US, CA, UK
DueDate	10	DATE	6	True	False	False	False	CCCC-MM-DD		2.0	US, CA, UK
OverrideItemAccountRef_ListID	12	VARCHAR	36	True	False	False	False	%s	ListID	2.0	US, CA, UK
OverrideItemAccountRef_FullName	12	VARCHAR	159	True	False	False	False	%s	FullName	2.0	US, CA, UK
OverrideUOMSetRef_ListID	12	VARCHAR	36						ListID	7.0	US, CA, UK
OverrideUOMSetRef_FullName	12	VARCHAR	31						Name	7.0	US, CA, UK
ExternalGUID	12	VARCHAR	40							9.0	US, CA, UK
LinkedTxn_TxnID	12	VARCHAR	36	True	False	False	False	%s		3.0	US, CA, UK
LinkedTxn_TxnType	12	VARCHAR	21	True	False	False	False	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		3.0	US, CA, UK
LinkedTxn_TxnDate	91	DATE	10	True	False	False	False	CCCC-MM-DD		3.0	US, CA, UK
LinkedTxn_RefNumber	12	VARCHAR	20	True	False	False	False	%s		3.0	US, CA, UK
LinkedTxn_LinkType	12	VARCHAR	8	True	False	False	False	AMTTYPE QUANTYPE		3.0	US, CA, UK
LinkedTxn_Amount	2	NUMERIC	15	True	False	False	False	%10.2f		3.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.

• 
• 
•