PurchaseOrderLinkedTransactions
Tracks relationships between purchase orders and linked transactions, such as bills or item receipts, allowing visibility into the purchasing and fulfillment lifecycle.
Columns
| Name | Type | ReadOnly | References | Filterable | Sortable | Description |
| LinkedTxnId [KEY] | String | True | False | False |
The unique identifier (Id) of the linked transaction line item that is associated with the purchase order. | |
| PurchaseOrderId [KEY] | String | False | True | True |
The unique Id of the purchase order that is associated with the linked transaction. | |
| SyncToken | String | True | False | False |
The version number of the object that is used to lock the object for use by one application at a time. As soon as an application modifies an object, its sync token is incremented. Attempts to modify an object specifying an older sync token fail. Only the latest version of the object is maintained by QuickBooks Online. | |
| MetaData_CreateTime | Datetime | True | True | True |
The date and time when the record was created. | |
| MetaData_LastUpdatedTime | Datetime | True | True | True |
The date and time when the record was last updated. | |
| DocNumber | String | False | True | True |
The reference number for the transaction that is associated with the linked purchase order. | |
| TxnDate | Date | False | True | True |
The date that is entered by the user when this transaction occurred. | |
| PrivateNote | String | False | False | False |
A private note for the transaction that does not appear on the transaction records. | |
| LinkedTxn_TxnId | String | False | False | False |
The unique Id of the linked transaction line item. | |
| LinkedTxn_TxnType | String | False | False | False |
The transaction type or category of the linked transaction line item. | |
| LinkedTxn_TxnLineId | String | False | False | False |
The Id of the specific line item within the linked transaction. | |
| LineAggregate | String | False | False | False |
An XML aggregate of all line items that are associated with the linked transaction for the purchase order. | |
| TotalAmt | Decimal | True | True | True |
The total monetary amount of the linked transaction that includes all charges, allowances, and taxes. | |
| VendorRef | String | False |
Vendors.Id | False | False |
The unique Id of the vendor that is associated with the linked transaction. |
| VendorRef_Name | String | True |
Vendors.DisplayName | False | False |
The name of the vendor that is associated with the linked transaction. |
| APAccountRef | String | False |
Accounts.Id | True | True |
The unique Id of the accounts-payable account to which the bill is credited. This account is implied when a company has a single accounts-payable account. When specified, the account must be a Liability account and the subtype must be of type Payables. |
| APAccountRef_Name | String | True |
Accounts.Name | False | False |
The name of the accounts-payable account to which the bill is credited. This account is implied when a company has a single accounts-payable account. When this column is specified, the account must be a Liability account and the subtype must be of type Payables. |