ReceivablesDocument
Return a list of: ReceivablesDocument
Columns
Name | Type | Description |
ExtensionsExtensionAggregate | String | |
AddressKeyCustomerId | String | |
AddressId | String | |
AuditTrailCode | String | |
BatchKeyCreatedDateTime | Datetime | |
BatchId | String | |
BatchKeySource | String | |
CorporateAccountId | String | |
CostAmountCurrency | String | |
CostAmount | Decimal | |
CurrencyKeyISOCode | String | |
CurrentDocumentAmountCurrency | String | |
CurrentDocumentAmount | Decimal | |
CustomerId | String | |
CustomerName | String | |
CustomerPONumber | String | |
Date | Datetime | |
Description | String | |
DistributionsAggregate | String | |
DocumentAmountCurrency | String | |
DocumentAmount | Decimal | |
ExchangeDate | Datetime | |
ExchangeRate | Decimal | |
FreightAmountCurrency | String | |
FreightAmount | Decimal | |
FreightTaxScheduleId | String | |
GeneralLedgerPostingDate | Datetime | |
InvoicePaidOffDate | Datetime | |
IsDeleted | Bool | |
IsDirectDebitDocument | Bool | |
IsElectronic | Bool | |
IsIntrastatDocument | Bool | |
IsVoided | Bool | |
Id [KEY] | String | |
MiscellaneousAmountCurrency | String | |
MiscellaneousAmount | Decimal | |
MiscellaneousTaxScheduleId | String | |
ModifiedBy | String | |
ModifiedDate | Datetime | |
PostedBy | String | |
PostedDate | Datetime | |
SalesAmountCurrency | String | |
SalesAmount | Decimal | |
SalesTaxScheduleId | String | |
SalesTerritoryId | String | |
SalespersonId | String | |
ShippingMethodId | String | |
TaxAmountCurrency | String | |
TaxAmount | Decimal | |
TaxScheduleId | String | |
TaxesAggregate | String | |
TradeDiscountAmountCurrency | String | |
TradeDiscountAmount | Decimal | |
TransactionState | String | |
Type | String | |
VoidDate | Datetime |
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 |