ReturnMaterialAuthorizationLines
Return a list of: ReturnMaterialAuthorizationLines
Columns
| Name | Type | Description |
| ExtensionsExtensionAggregate | String | |
| BillToAddressId | String | |
| BillToCustomerId | String | |
| CurrencyKeyISOCode | String | |
| CustomerId | String | |
| CustomerName | String | |
| CustomerPONumber | String | |
| EntryDateTime | Datetime | |
| EstimatedArrivalDateTime | Datetime | |
| ExchangeDate | Datetime | |
| ExchangeRate | Decimal | |
| FrontOfficeIntegrationId | String | |
| Id | String | |
| Note | String | |
| OfficeId | String | |
| RateTypeId | String | |
| ShipToAddressId | String | |
| TransactionState | String | |
| UserDefined01 | String | |
| UserDefined02 | String | |
| UserDefined03 | String | |
| UserDefined04 | String | |
| UserDefined05 | String | |
| AuditsAggregate | String | |
| BillOfLading | String | |
| ClosedDateTime | Datetime | |
| CommitDateTime | Datetime | |
| CreatedBy | String | |
| IsFromServiceCall | Bool | |
| IsReceived | Bool | |
| LinesExtensionsExtensionAggregate | String | |
| LinesBillOfLading | String | |
| LinesClosedDateTime | Datetime | |
| LinesCommitDateTime | Datetime | |
| LinesCreatedBy | String | |
| LinesCustomerName | String | |
| LinesCustomerPONumber | String | |
| LinesDistributionsAggregate | String | |
| LinesEntryDateTime | Datetime | |
| LinesEquipmentLineSequenceNumber | Int | |
| LinesEstimatedArrivalDateTime | Datetime | |
| LinesFrontOfficeIntegrationId | String | |
| LinesIsClosed | Bool | |
| LinesIsCustomerOwned | Bool | |
| LinesIsFactorySealed | Bool | |
| LinesIsFromServiceCall | Bool | |
| LinesIsReadyToClose | Bool | |
| LinesIsReceived | Bool | |
| LinesIsTravelerPrinted | Bool | |
| LinesItemDescription | String | |
| LinesItemId | String | |
| LinesKeyLineSequenceNumber [KEY] | Int | |
| LinesKeyServiceDocumentId [KEY] | String | |
| LinesLotsAggregate | String | |
| LinesNote | String | |
| LinesOfficeId | String | |
| LinesOriginatingDocumentId | String | |
| LinesPromiseDateTime | Datetime | |
| LinesQuantity | Decimal | |
| LinesReasonCodeDescription | String | |
| LinesReasonCodeId | String | |
| LinesReference | String | |
| LinesRepairCostCurrency | String | |
| LinesRepairCost | Decimal | |
| LinesRepairDocumentId | String | |
| LinesRepairFlatRatePriceCurrency | String | |
| LinesRepairFlatRatePrice | Decimal | |
| LinesRepairInvoiceItemId | String | |
| LinesRepairNotToExceedPriceCurrency | String | |
| LinesRepairNotToExceedPrice | Decimal | |
| LinesRepairPriceCurrency | String | |
| LinesRepairPrice | Decimal | |
| LinesReplacementItemId | String | |
| LinesReplacementPriceLevelId | String | |
| LinesReplacementQuantity | Decimal | |
| LinesReplacementUnitCostCurrency | String | |
| LinesReplacementUnitCost | Decimal | |
| LinesReplacementUnitPriceCurrency | String | |
| LinesReplacementUnitPrice | Decimal | |
| LinesReplacementUofM | String | |
| LinesReplacementWarehouseId | String | |
| LinesReturnDateTime | Datetime | |
| LinesReturnStatus | String | |
| LinesReturnStatusCodeId | String | |
| LinesReturnToAddressExtensionsExtensionAggregate | String | |
| LinesReturnToAddressCity | String | |
| LinesReturnToAddressLine1 | String | |
| LinesReturnToAddressLine2 | String | |
| LinesReturnToAddressLine3 | String | |
| LinesReturnToAddressPostalCode | String | |
| LinesReturnToAddressState | String | |
| LinesReturnToAddressCountryRegion | String | |
| LinesReturnToAddressName | String | |
| LinesReturnTypeId | String | |
| LinesReturnWarehouseId | String | |
| LinesReturnedItemDescription | String | |
| LinesReturnedItemId | String | |
| LinesReturnedPriceLevelId | String | |
| LinesReturnedQuantity | Decimal | |
| LinesReturnedTotalAmountCurrency | String | |
| LinesReturnedTotalAmount | Decimal | |
| LinesReturnedTotalCostCurrency | String | |
| LinesReturnedTotalCost | Decimal | |
| LinesReturnedUnitCostCurrency | String | |
| LinesReturnedUnitCost | Decimal | |
| LinesReturnedUnitPriceCurrency | String | |
| LinesReturnedUnitPrice | Decimal | |
| LinesReturnedUofM | String | |
| LinesReturnedWarehouseId | String | |
| LinesSalesInvoiceComponentSequenceNumber | Int | |
| LinesSalesInvoiceLineKeyLineSequenceNumber | Int | |
| LinesSalesInvoiceLineKeySalesDocumentId | String | |
| LinesSalesOrderLineKeyLineSequenceNumber | Int | |
| LinesSalesOrderLineKeySalesDocumentId | String | |
| LinesSalesReturnLineKeyLineSequenceNumber | Int | |
| LinesSalesReturnLineKeySalesDocumentId | String | |
| LinesSerialsAggregate | String | |
| LinesServiceLineKeyLineSequenceNumber | Int | |
| LinesServiceLineKeyServiceDocumentId | String | |
| LinesShipToAddressExtensionsExtensionAggregate | String | |
| LinesShipToAddressCity | String | |
| LinesShipToAddressLine1 | String | |
| LinesShipToAddressLine2 | String | |
| LinesShipToAddressLine3 | String | |
| LinesShipToAddressPostalCode | String | |
| LinesShipToAddressState | String | |
| LinesShipToAddressCountryRegion | String | |
| LinesShipToAddressContactPerson | String | |
| LinesShipToAddressId | String | |
| LinesShippingMethodId | String | |
| LinesTotalAmountCurrency | String | |
| LinesTotalAmount | Decimal | |
| LinesTotalCostCurrency | String | |
| LinesTotalCost | Decimal | |
| LinesTransferDocumentLineKeyLineSequenceNumber | Int | |
| LinesTransferDocumentLineKeyServiceDocumentId | String | |
| LinesTransferStatus | String | |
| LinesUnitCostCurrency | String | |
| LinesUnitCost | Decimal | |
| LinesUnitPriceCurrency | String | |
| LinesUnitPrice | Decimal | |
| LinesUofM | String | |
| LinesUserDefined01 | String | |
| LinesUserDefined02 | String | |
| LinesUserDefined03 | String | |
| LinesUserDefined04 | String | |
| LinesUserDefined05 | String | |
| OriginatingDocumentId | String | |
| OriginatingDocumentType | String | |
| ReasonCodeDescription | String | |
| ReasonCodeId | String | |
| ReturnDateTime | Datetime | |
| ReturnStatus | String | |
| ReturnStatusCodeId | String | |
| ReturnToAddressExtensionsExtensionAggregate | String | |
| ReturnToAddressCity | String | |
| ReturnToAddressLine1 | String | |
| ReturnToAddressLine2 | String | |
| ReturnToAddressLine3 | String | |
| ReturnToAddressPostalCode | String | |
| ReturnToAddressState | String | |
| ReturnToAddressCountryRegion | String | |
| ReturnToAddressName | String | |
| ReturnTypeId | String | |
| ReturnWarehouseId | String | |
| ShipToAddressExtensionsExtensionAggregate | String | |
| ShipToAddressCity | String | |
| ShipToAddressLine1 | String | |
| ShipToAddressLine2 | String | |
| ShipToAddressLine3 | String | |
| ShipToAddressPostalCode | String | |
| ShipToAddressState | String | |
| ShipToAddressCountryRegion | String | |
| ShipToAddressContactPerson | String | |
| ShippingMethodId | String | |
| Type | 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 |