JDBC Driver for Oracle SCM

Build 22.0.8462

ReceivingTransactionsHistory

The Receiving Transaction History resource provides information about receiving transactions history.

Columns

Name Type Description
TransactionId [KEY] String TransactionId of ReceivingTransactionsHistory
TransactionTypeCode String TransactionTypeCode of ReceivingTransactionsHistory
TransactionType String TransactionType of ReceivingTransactionsHistory
TransactionDate Date TransactionDate of ReceivingTransactionsHistory
Quantity String Quantity of ReceivingTransactionsHistory
UOMCode String UOMCode of ReceivingTransactionsHistory
UnitOfMeasure String UnitOfMeasure of ReceivingTransactionsHistory
PrimaryQuantity String PrimaryQuantity of ReceivingTransactionsHistory
PrimaryUOMCode String PrimaryUOMCode of ReceivingTransactionsHistory
PrimaryUnitOfMeasure String PrimaryUnitOfMeasure of ReceivingTransactionsHistory
SecondaryQuantity String SecondaryQuantity of ReceivingTransactionsHistory
SecondaryUOMCode String SecondaryUOMCode of ReceivingTransactionsHistory
SecondaryUnitOfMeasure String SecondaryUnitOfMeasure of ReceivingTransactionsHistory
Amount String Amount of ReceivingTransactionsHistory
CurrencyCode String CurrencyCode of ReceivingTransactionsHistory
CurrencyName String CurrencyName of ReceivingTransactionsHistory
CurrencyConversionType String CurrencyConversionType of ReceivingTransactionsHistory
CurrencyConversionRate String CurrencyConversionRate of ReceivingTransactionsHistory
CurrencyConversionDate Date CurrencyConversionDate of ReceivingTransactionsHistory
ItemId String ItemId of ReceivingTransactionsHistory
ItemNumber String ItemNumber of ReceivingTransactionsHistory
ItemDescription String ItemDescription of ReceivingTransactionsHistory
ItemRevision String ItemRevision of ReceivingTransactionsHistory
SourceDocumentCode String SourceDocumentCode of ReceivingTransactionsHistory
SourceDocument String SourceDocument of ReceivingTransactionsHistory
DestinationTypeCode String DestinationTypeCode of ReceivingTransactionsHistory
DestinationType String DestinationType of ReceivingTransactionsHistory
ParentTransactionId String ParentTransactionId of ReceivingTransactionsHistory
ParentTransactionTypeCode String ParentTransactionTypeCode of ReceivingTransactionsHistory
ParentTransactionType String ParentTransactionType of ReceivingTransactionsHistory
OrganizationId String OrganizationId of ReceivingTransactionsHistory
OrganizationCode String OrganizationCode of ReceivingTransactionsHistory
OrganizationName String OrganizationName of ReceivingTransactionsHistory
GroupId String GroupId of ReceivingTransactionsHistory
ConsignedFlag Bool ConsignedFlag of ReceivingTransactionsHistory
Subinventory String Subinventory of ReceivingTransactionsHistory
LocatorId String LocatorId of ReceivingTransactionsHistory
Locator String Locator of ReceivingTransactionsHistory
FromSubinventory String FromSubinventory of ReceivingTransactionsHistory
FromLocatorId String FromLocatorId of ReceivingTransactionsHistory
FromLocator String FromLocator of ReceivingTransactionsHistory
DeliverToLocationId String DeliverToLocationId of ReceivingTransactionsHistory
DeliverToLocationName String DeliverToLocationName of ReceivingTransactionsHistory
DeliverToPersonId String DeliverToPersonId of ReceivingTransactionsHistory
DeliverToPersonName String DeliverToPersonName of ReceivingTransactionsHistory
ShipmentHeaderId String ShipmentHeaderId of ReceivingTransactionsHistory
ShipmentLineId String ShipmentLineId of ReceivingTransactionsHistory
ReceiptNumber String ReceiptNumber of ReceivingTransactionsHistory
LineNumber String LineNumber of ReceivingTransactionsHistory
ShipmentNumber String ShipmentNumber of ReceivingTransactionsHistory
POHeaderId String POHeaderId of ReceivingTransactionsHistory
POLineId String POLineId of ReceivingTransactionsHistory
POLineLocationId String POLineLocationId of ReceivingTransactionsHistory
PODistributionId String PODistributionId of ReceivingTransactionsHistory
PONumber String PONumber of ReceivingTransactionsHistory
POLineNumber String POLineNumber of ReceivingTransactionsHistory
POShipmentNumber String POShipmentNumber of ReceivingTransactionsHistory
PODistributionNumber String PODistributionNumber of ReceivingTransactionsHistory
TransferOrderHeaderId String TransferOrderHeaderId of ReceivingTransactionsHistory
TransferOrderLineId String TransferOrderLineId of ReceivingTransactionsHistory
TransferOrderDistributionId String TransferOrderDistributionId of ReceivingTransactionsHistory
TransferOrderNumber String TransferOrderNumber of ReceivingTransactionsHistory
TransferOrderLineNumber Int TransferOrderLineNumber of ReceivingTransactionsHistory
TransferOrderDistributionNumber String TransferOrderDistributionNumber of ReceivingTransactionsHistory
ReturnTransferOrderHeaderId String ReturnTransferOrderHeaderId of ReceivingTransactionsHistory
ReturnTransferOrderLineId String ReturnTransferOrderLineId of ReceivingTransactionsHistory
ReturnTransferOrderNumber String ReturnTransferOrderNumber of ReceivingTransactionsHistory
ReturnTransferOrderLineNumber Int ReturnTransferOrderLineNumber of ReceivingTransactionsHistory
ReceiptAdviceDocumentCode String ReceiptAdviceDocumentCode of ReceivingTransactionsHistory
ReceiptAdviceDocument String ReceiptAdviceDocument of ReceivingTransactionsHistory
ReceiptAdviceHeaderId String ReceiptAdviceHeaderId of ReceivingTransactionsHistory
ReceiptAdviceLineId String ReceiptAdviceLineId of ReceivingTransactionsHistory
ReceiptAdviceDocumentNumber String ReceiptAdviceDocumentNumber of ReceivingTransactionsHistory
ReceiptAdviceDocumentLineNumber String ReceiptAdviceDocumentLineNumber of ReceivingTransactionsHistory
RMAReference String RMAReference of ReceivingTransactionsHistory
VendorId String VendorId of ReceivingTransactionsHistory
VendorName String VendorName of ReceivingTransactionsHistory
VendorSiteId String VendorSiteId of ReceivingTransactionsHistory
VendorSiteCode String VendorSiteCode of ReceivingTransactionsHistory
CustomerId String CustomerId of ReceivingTransactionsHistory
CustomerName String CustomerName of ReceivingTransactionsHistory
EmployeeId String EmployeeId of ReceivingTransactionsHistory
EmployeeName String EmployeeName of ReceivingTransactionsHistory
FromOrganizationId String FromOrganizationId of ReceivingTransactionsHistory
FromOrganizationCode String FromOrganizationCode of ReceivingTransactionsHistory
FromOrganizationName String FromOrganizationName of ReceivingTransactionsHistory
ReceiptExceptionFlag Bool ReceiptExceptionFlag of ReceivingTransactionsHistory
InspectionStatusCode String InspectionStatusCode of ReceivingTransactionsHistory
InspectionStatus String InspectionStatus of ReceivingTransactionsHistory
AccrualStatusCode String AccrualStatusCode of ReceivingTransactionsHistory
Comments String Comments of ReceivingTransactionsHistory
ExternalSystemPackingUnit String ExternalSystemPackingUnit of ReceivingTransactionsHistory
CountryOfOriginCode String CountryOfOriginCode of ReceivingTransactionsHistory
ReceiptConfirmationStatusCode String ReceiptConfirmationStatusCode of ReceivingTransactionsHistory
ReceiptConfirmationMessageNumber String ReceiptConfirmationMessageNumber of ReceivingTransactionsHistory
InterfaceReturnsToShippingFlag Bool InterfaceReturnsToShippingFlag of ReceivingTransactionsHistory
ElectronicRecordId String ElectronicRecordId of ReceivingTransactionsHistory
BackToBackFlag Bool BackToBackFlag of ReceivingTransactionsHistory
BusinessEventPublishedFlag Bool BusinessEventPublishedFlag of ReceivingTransactionsHistory
FirstPartyTaxRegistrationId String FirstPartyTaxRegistrationId of ReceivingTransactionsHistory
ThirdPartyTaxRegistrationId String ThirdPartyTaxRegistrationId of ReceivingTransactionsHistory
DefaultTaxationCountryCode String DefaultTaxationCountryCode of ReceivingTransactionsHistory
DocumentFiscalClassification String DocumentFiscalClassification of ReceivingTransactionsHistory
TransactionBusinessCategoryCode String TransactionBusinessCategoryCode of ReceivingTransactionsHistory
TaxInvoiceNumber String TaxInvoiceNumber of ReceivingTransactionsHistory
TaxInvoiceDate Date TaxInvoiceDate of ReceivingTransactionsHistory
ShipFromLocationId String ShipFromLocationId of ReceivingTransactionsHistory
UserDefinedFiscalClassificationCode String UserDefinedFiscalClassificationCode of ReceivingTransactionsHistory
TaxClassificationCode String TaxClassificationCode of ReceivingTransactionsHistory
ProductFiscalClassificationId String ProductFiscalClassificationId of ReceivingTransactionsHistory
IntendedUseCode String IntendedUseCode of ReceivingTransactionsHistory
IntendedUseClassificationId String IntendedUseClassificationId of ReceivingTransactionsHistory
ProductTypeCode String ProductTypeCode of ReceivingTransactionsHistory
ProductCategoryCode String ProductCategoryCode of ReceivingTransactionsHistory
AssessableValue String AssessableValue of ReceivingTransactionsHistory
FinalDischargeLocationId String FinalDischargeLocationId of ReceivingTransactionsHistory
ExternalSystemTransactionReference String ExternalSystemTransactionReference of ReceivingTransactionsHistory
QuantityBilled String QuantityBilled of ReceivingTransactionsHistory
BillingUOMCode String BillingUOMCode of ReceivingTransactionsHistory
BillingUnitOfMeasure String BillingUnitOfMeasure of ReceivingTransactionsHistory
AmountBilled String AmountBilled of ReceivingTransactionsHistory

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462