PurchaseInvoiceLines
Return a list of: PurchaseInvoiceLines
Columns
Name | Type | Description |
ExtensionsExtensionAggregate | String | |
Amount1099Currency | String | |
Amount1099 | Decimal | |
AuditTrailCode | String | |
BatchKeyCreatedDateTime | Datetime | |
BatchId | String | |
BatchKeySource | String | |
CreatedBy | String | |
CreatedDate | Datetime | |
CurrencyKeyISOCode | String | |
Date | Datetime | |
DistributionsAggregate | String | |
ExchangeDate | Datetime | |
ExchangeRate | Decimal | |
FreightAmountCurrency | String | |
FreightAmount | Decimal | |
FreightTaxAmountCurrency | String | |
FreightTaxAmount | Decimal | |
FreightTaxBasis | String | |
FreightTaxScheduleId | String | |
FreightTaxesAggregate | String | |
GeneralLedgerPostingDate | Datetime | |
Id | String | |
LinesExtensionsExtensionAggregate | String | |
LinesBackoutTaxAmountCurrency | String | |
LinesBackoutTaxAmount | Decimal | |
LinesCostCategoryId | String | |
LinesExtendedCostCurrency | String | |
LinesExtendedCost | Decimal | |
LinesIsLandedCost | Bool | |
LinesIsNonInventory | Bool | |
LinesItemId | String | |
LinesItemTaxScheduleId | String | |
LinesKeyLineSequenceNumber [KEY] | Int | |
LinesKeyPurchaseTransactionId [KEY] | String | |
LinesProjectId | String | |
LinesPurchaseOrderId | String | |
LinesPurchaseOrderLineKeyLineSequenceNumber | Int | |
LinesPurchaseOrderLineKeyPurchaseTransactionId | String | |
LinesQuantityInvoiced | Decimal | |
LinesReceiptsAggregate | String | |
LinesTaxAmountCurrency | String | |
LinesTaxAmount | Decimal | |
LinesTaxBasis | String | |
LinesTaxesAggregate | String | |
LinesUnitCostCurrency | String | |
LinesUnitCost | Decimal | |
LinesUofM | String | |
LinesVarianceGLAccountId | String | |
LinesVarianceGLAccountKeyIsEncrypted | Bool | |
LinesVendorItemDescription | String | |
LinesVendorItemNumber | String | |
LinesWarehouseTaxScheduleId | String | |
MiscellaneousAmountCurrency | String | |
MiscellaneousAmount | Decimal | |
MiscellaneousTaxAmountCurrency | String | |
MiscellaneousTaxAmount | Decimal | |
MiscellaneousTaxBasis | String | |
MiscellaneousTaxScheduleId | String | |
MiscellaneousTaxesAggregate | String | |
ModifiedDate | Datetime | |
PaymentTermsId | String | |
PostedBy | String | |
PostedDate | Datetime | |
Reference | String | |
RemitToAddressId | String | |
SubtotalCurrency | String | |
Subtotal | Decimal | |
TaxAmountCurrency | String | |
TaxAmount | Decimal | |
TaxScheduleId | String | |
TaxesAggregate | String | |
TermsDiscountItem | String | |
TermsDiscountAvailableAmountCurrency | String | |
TermsDiscountAvailableAmount | Decimal | |
TermsDiscountDate | Datetime | |
TermsDueDate | Datetime | |
TradeDiscountAmountCurrency | String | |
TradeDiscountAmount | Decimal | |
TransactionState | String | |
VendorDocumentNumber | String | |
VendorId | String | |
VendorName | String | |
VoucherNumber | 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 |