TABLE DETAIL REFERENCE: ItemReceiptLinkedTxn
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorRefFullName12 VARCHAR 41TrueTrueTrueFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
LiabilityAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
LiabilityAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
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
TotalAmount3 DECIMAL 18TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 20TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
LinkToTxnID112 VARCHAR 36TrueFalseTrueFalse%s
LinkedTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
LinkedTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
LinkedTxnTxnType12 VARCHAR 21TrueFalseFalseFalse
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
LinkedTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
LinkedTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
LinkedTxnLinkType12 VARCHAR 8TrueFalseFalseFalse
AMTTYPE
QUANTYPE
LinkedTxnAmount3 DECIMAL 18TrueFalseFalseFalse%10.2f
Tax1Total3 DECIMAL 17TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 17TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 17TrueTrueTrueFalse%6.8f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey
CustomFieldLinkedTxnALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnPulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnPulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnStyle12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupPulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupPulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupStyle12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineALU12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineALU212 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineApproved12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineColor12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineCompletedby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineCustomer12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineInspectedBy12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineOrdered12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLinePulled12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLinePulledby12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineQtyPriceBreak12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineRequiredDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineStartDate12 VARCHAR 30TrueTrueFalseFalse%s
CustomFieldLinkedTxnGroupLineStyle12 VARCHAR 30TrueTrueFalseFalse%s