PurchaseInvoice
Return a list of: PurchaseInvoice
Columns
Name | Type | ReadOnly | Description |
ExtensionsExtensionAggregate | String | False | |
Amount1099Currency | String | False | |
Amount1099 | Decimal | False | |
AuditTrailCode | String | False | |
BatchKeyCreatedDateTime | Datetime | False | |
BatchId | String | False | |
BatchKeySource | String | False | |
CreatedBy | String | False | |
CreatedDate | Datetime | False | |
CurrencyKeyISOCode | String | False | |
Date | Datetime | False | |
DistributionsAggregate | String | False | |
ExchangeDate | Datetime | False | |
ExchangeRate | Decimal | False | |
FreightAmountCurrency | String | False | |
FreightAmount | Decimal | False | |
FreightTaxAmountCurrency | String | False | |
FreightTaxAmount | Decimal | False | |
FreightTaxBasis | String | False | |
FreightTaxScheduleId | String | False | |
FreightTaxesAggregate | String | False | |
GeneralLedgerPostingDate | Datetime | False | |
Id [KEY] | String | False | |
LinesAggregate | String | False | |
MiscellaneousAmountCurrency | String | False | |
MiscellaneousAmount | Decimal | False | |
MiscellaneousTaxAmountCurrency | String | False | |
MiscellaneousTaxAmount | Decimal | False | |
MiscellaneousTaxBasis | String | False | |
MiscellaneousTaxScheduleId | String | False | |
MiscellaneousTaxesAggregate | String | False | |
ModifiedDate | Datetime | False | |
PaymentTermsId | String | False | |
PostedBy | String | False | |
PostedDate | Datetime | False | |
Reference | String | False | |
RemitToAddressId | String | False | |
SubtotalCurrency | String | False | |
Subtotal | Decimal | False | |
TaxAmountCurrency | String | False | |
TaxAmount | Decimal | False | |
TaxScheduleId | String | False | |
TaxesAggregate | String | False | |
TermsDiscountItem | String | False | |
TermsDiscountAvailableAmountCurrency | String | False | |
TermsDiscountAvailableAmount | Decimal | False | |
TermsDiscountDate | Datetime | False | |
TermsDueDate | Datetime | False | |
TradeDiscountAmountCurrency | String | False | |
TradeDiscountAmount | Decimal | False | |
TransactionState | String | False | |
VendorDocumentNumber | String | False | |
VendorId | String | False | |
VendorName | String | False | |
VoucherNumber | String | False |
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 |