ReceivablesInvoiceCommissions
Return a list of: ReceivablesInvoiceCommissions
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 | 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 | |
| GSTDiscountAmountCurrency | String | |
| GSTDiscountAmount | Decimal | |
| PaymentCashAmountCurrency | String | |
| PaymentCashAmount | Decimal | |
| PaymentCashBankAccountId | String | |
| PaymentCashDate | Datetime | |
| PaymentCashNumber | String | |
| PaymentCheckAmountCurrency | String | |
| PaymentCheckAmount | Decimal | |
| PaymentCheckBankAccountId | String | |
| PaymentCheckCheckNumber | String | |
| PaymentCheckDate | Datetime | |
| PaymentCheckNumber | String | |
| PaymentPaymentCardAmountCurrency | String | |
| PaymentPaymentCardAmount | Decimal | |
| PaymentPaymentCardDate | Datetime | |
| PaymentPaymentCardNumber | String | |
| PaymentPaymentCardReceiptNumber | String | |
| PaymentPaymentCardTypeId | String | |
| PaymentPaymentCardBankAccountId | String | |
| PaymentTermsId | String | |
| TermsDiscountItem | String | |
| TermsDiscountAvailableAmountCurrency | String | |
| TermsDiscountAvailableAmount | Decimal | |
| TermsDiscountDate | Datetime | |
| TermsDueDate | Datetime | |
| TermsDiscountAvailableTakenAmountCurrency | String | |
| TermsDiscountAvailableTakenAmount | Decimal | |
| TermsDiscountTakenAmountCurrency | String | |
| TermsDiscountTakenAmount | Decimal | |
| WriteoffAmountCurrency | String | |
| WriteoffAmount | Decimal | |
| CommissionAmountCurrency | String | |
| CommissionAmount | Decimal | |
| CommissionBasedOn | String | |
| CommissionsExtensionsExtensionAggregate | String | |
| CommissionsCommissionAmountCurrency | String | |
| CommissionsCommissionAmount | Decimal | |
| CommissionsCommissionPercent | Decimal | |
| CommissionsKeyReceivablesDocumentId [KEY] | String | |
| CommissionsKeySequenceNumber [KEY] | Int | |
| CommissionsNoncommissionedAmountCurrency | String | |
| CommissionsNoncommissionedAmount | Decimal | |
| CommissionsPercentOfSale | Decimal | |
| CommissionsSalesAmountCurrency | String | |
| CommissionsSalesAmount | Decimal | |
| CommissionsSalesTerritoryId | String | |
| CommissionsSalespersonId | 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 |