PayablesDocument
Return a list of: PayablesDocument
Columns
Name | Type | Description |
ExtensionsExtensionAggregate | String | |
AddressId | String | |
Amount1099Currency | String | |
Amount1099 | Decimal | |
AuditTrailCode | String | |
BatchKeyCreatedDateTime | Datetime | |
BatchId | String | |
BatchKeySource | String | |
ChargeAmountCurrency | String | |
ChargeAmount | Decimal | |
CurrencyKeyISOCode | String | |
Date | Datetime | |
Description | String | |
DistributionsAggregate | String | |
DocumentAmountCurrency | String | |
DocumentAmount | Decimal | |
ExchangeDate | Datetime | |
ExchangeRate | Decimal | |
FreightAmountCurrency | String | |
FreightAmount | Decimal | |
FreightTaxScheduleId | String | |
GeneralLedgerPostingDate | Datetime | |
HasIntercompanyDistributions | Bool | |
IsIntercompanyTransaction | Bool | |
IsVoided | Bool | |
Id [KEY] | String | |
MiscellaneousAmountCurrency | String | |
MiscellaneousAmount | Decimal | |
MiscellaneousTaxScheduleId | String | |
ModifiedBy | String | |
ModifiedDate | Datetime | |
PONumber | String | |
PostedBy | String | |
PostedDate | Datetime | |
PurchaseTaxScheduleId | String | |
PurchasesAmountCurrency | String | |
PurchasesAmount | Decimal | |
RemitToAddressId | String | |
ShippingMethodId | String | |
TaxAmountCurrency | String | |
TaxAmount | Decimal | |
TaxDate | Datetime | |
TaxScheduleId | String | |
TaxesAggregate | String | |
TradeDiscountAmountCurrency | String | |
TradeDiscountAmount | Decimal | |
TransactionState | String | |
Type | 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 |