PurchaseReceiptLines
Return a list of: PurchaseReceiptLines
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| ActualShipDate | Datetime | |
| AuditTrailCode | String | |
| BatchKeyCreatedDateTime | Datetime | |
| BatchId | String | |
| BatchKeySource | String | |
| CreatedBy | String | |
| CreatedDate | Datetime | |
| CurrencyKeyISOCode | String | |
| Date | Datetime | |
| DistributionsAggregate | String | |
| ExchangeDate | Datetime | |
| ExchangeRate | Decimal | |
| GeneralLedgerPostingDate | Datetime | |
| Id | String | |
| LinesExtensionsExtensionAggregate | String | |
| LinesActualShipDate | Datetime | |
| LinesBillOfLadingNumber | String | |
| LinesBinsAggregate | String | |
| LinesCostCategoryId | String | |
| LinesExtendedCostCurrency | String | |
| LinesExtendedCost | Decimal | |
| LinesInventoryGLAccountId | String | |
| LinesInventoryGLAccountKeyIsEncrypted | Bool | |
| LinesIsNonInventory | Bool | |
| LinesItemDescription | String | |
| LinesItemId | String | |
| LinesKeyLineSequenceNumber [KEY] | Int | |
| LinesKeyPurchaseTransactionId [KEY] | String | |
| LinesLandedCostGroupId | String | |
| LinesLotsAggregate | String | |
| LinesProjectId | String | |
| LinesPurchaseOrderId | String | |
| LinesPurchaseOrderLineKeyLineSequenceNumber | Int | |
| LinesPurchaseOrderLineKeyPurchaseTransactionId | String | |
| LinesQuantityRejected | Decimal | |
| LinesQuantityShipped | Decimal | |
| LinesSerialsAggregate | String | |
| LinesUnitCostCurrency | String | |
| LinesUnitCost | Decimal | |
| LinesUofM | String | |
| LinesVendorItemDescription | String | |
| LinesVendorItemNumber | String | |
| LinesWarehouseId | String | |
| ModifiedDate | Datetime | |
| PostedBy | String | |
| PostedDate | Datetime | |
| Reference | String | |
| RemitToAddressId | String | |
| SubtotalCurrency | String | |
| Subtotal | Decimal | |
| TotalLandedCostAmountCurrency | String | |
| TotalLandedCostAmount | Decimal | |
| TransactionState | String | |
| UserDefinedAggregate | String | |
| VendorDocumentNumber | String | |
| VendorId | String | |
| VendorName | String |
Pseudo-Columns
Pseudo-Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| PagingColumn | String |