InventoryAdjustmentLineItems

Contains detailed line-item data for vendor bills, including products or services purchased, amounts, tax details, and associated accounts for expense tracking and reporting.

Table Specific Information

Inventory Adjustments may be inserted, updated, or queried via the InventoryAdjustments or InventoryAdjustmentLineItems tables. Inventory Adjustments may be deleted by using the InventoryAdjustments table.

Select

All filterable columns support the following operators:

The driver processes other filters client-side within the driver.

Select

For example, the following queries are processed server-side:

    select * from InventoryAdjustmentLineItems where MetaData_CreateTime = '2024-10-15 15:44:40.0'
    select * from InventoryAdjustmentLineItems where MetaData_CreateTime >= '2024-10-15 15:44:40.0'
    select * from InventoryAdjustmentLineItems where MetaData_CreateTime <= '2024-10-15 15:44:40.0'
    select * from InventoryAdjustmentLineItems where MetaData_CreateTime < '2024-10-15 15:44:40.0'
    select * from InventoryAdjustmentLineItems where MetaData_CreateTime > '2024-10-15 15:44:40.0'

Insert

To add an Inventory Adjustment, specify the Line_DetailType, Line_ItemAdjustmentLineDetail_QtyDiff, Line_ItemAdjustmentLineDetail_ItemRef, and InventoryAdjustmentId columns. For example, the following will insert a new Inventory Adjustment with two Line Items:

INSERT INTO InventoryAdjustmentLineItems (InventoryAdjustmentId, Line_DetailType, Line_ItemAdjustmentLineDetail_QtyDiff, Line_ItemAdjustmentLineDetail_ItemRef) VALUES ('148', 'ItemAdjustmentLineDetail', -100, '17')

INSERT INTO InventoryAdjustmentLineItems#TEMP (Line_DetailType, Line_ItemAdjustmentLineDetail_QtyDiff, Line_ItemAdjustmentLineDetail_ItemRef) VALUES ('ItemAdjustmentLineDetail', -5, '11')
      INSERT INTO InventoryAdjustments (TxnDate, DocNumber, PrivateNote, AdjustAccountRef, LineAggregate) VALUES ('2024-12-03', 'ADJ-001', 'Inventory adjustment for damaged goods', '34', InventoryAdjustmentLineItems#TEMP)

Update

	UPDATE InventoryAdjustmentLineItems SET Line_ItemAdjustmentLineDetail_QtyDiff = -250 WHERE InventoryAdjustmentId = '148' AND LineId = 5

Delete

	DELETE FROM InventoryAdjustmentLineItems WHERE LineId=1 and InventoryAdjustmentId = '148'

GetDeleted

	GETDELETED FROM InventoryAdjustmentLineItems

Columns


Name	Type	ReadOnly	References	Filterable	Sortable	Description
LineId [KEY]	String	True		False	False	The unique identifier (Id) that is assigned to the individual line item within the inventory adjustment. This links each line item to its parent adjustment and allows tracking of specific item adjustments.
InventoryAdjustmentId [KEY]	String	False	InventoryAdjustments.Id	True	False	The unique Id of the inventory adjustment to which the line item belongs. This connects the line detail to its parent adjustment transaction.
SyncToken	String	True		False	False	The version number that is assigned to the bill object. QuickBooks Online increments this token each time the object is modified to prevent conflicting updates. You must supply the current SyncToken when you update or delete a bill to ensure data integrity.
Line_Id	String	False		False	False	The unique Id that is assigned to the line item itself, enabling differentiation of multiple lines within the same inventory adjustment.
Line_DetailType	String	False		False	False	Specifies the type of line detail for this inventory adjustment line item. For inventory adjustments, this is always 'ItemAdjustmentLineDetail'. 使用できる値は次のとおりです。ItemAdjustmentLineDetail
Line_ItemAdjustmentLineDetail_QtyDiff	String	False		False	False	The quantity difference for this inventory adjustment line. This value can be positive (for inventory found or added) or negative (for inventory shrinkage or removed). This is the core adjustment value for the line item.
Line_ItemAdjustmentLineDetail_ItemRef	String	False	Items.Id	False	False	The Id of the inventory item that is being adjusted in this line. This Id links the adjustment to a specific inventory item in the company file.
Line_ItemAdjustmentLineDetail_ItemRef_Name	String	True	Items.Name	False	False	The name of the inventory item that is being adjusted in this line. This is the human-readable counterpart to the ItemRef Id and helps identify the item being adjusted.
MetaData_CreateTime	Datetime	True		True	True	The date and time when the inventory adjustment record was originally created in QuickBooks Online. The CreateTime value provides a reference point for auditing and synchronization.
MetaData_LastModifiedByRef	Long	True		False	False	The identifier of the user who last modified the inventory adjustment record. This reference tracks who made the most recent changes to the record for auditing purposes.
MetaData_LastUpdatedTime	Datetime	True		True	True	The date and time when the inventory adjustment record was last updated in QuickBooks Online. The LastUpdatedTime value helps track changes and identify the most recent version of the record.
DocNumber	String	False		False	False	The document reference number that is associated with the transaction. This document number allows users to match QuickBooks transactions to external documents such as inventory adjustment forms.
TxnDate	Date	False		False	False	The date that is entered by the user for when this transaction occurred. This date is used as the posting date in financial statements.
PrivateNote	String	False		False	False	A private, internal note about the transaction. The private note does not appear on printed or shared transaction records by default.
AdjustAccountRef	String	False	Accounts.Id	False	False	The Id of the account that is used for this inventory adjustment. This Id connects the adjustment to the correct account in the chart of accounts for recording inventory changes.
AdjustAccountRef_Name	String	False	Accounts.Name	False	False	The name of the account that is used for this inventory adjustment. This name is the human-readable counterpart to the AdjustAccountRef Id.

Tableau Connector for QuickBooks Online

InventoryAdjustmentLineItems

Table Specific Information

Select

Select

Insert

Update

Delete

GetDeleted

Columns