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 |