InventoryCompletedTransactions
InventoryCompletedTransactions
Columns
Name | Type | Description |
TransactionId [KEY] | Long | TransactionId of InventoryCompletedTransactions |
Item | String | Item of InventoryCompletedTransactions |
ItemDescription | String | ItemDescription of InventoryCompletedTransactions |
InventoryItemId | Long | InventoryItemId of InventoryCompletedTransactions |
Revision | String | Revision of InventoryCompletedTransactions |
SubinventoryCode | String | SubinventoryCode of InventoryCompletedTransactions |
SubinventoryId | Long | SubinventoryId of InventoryCompletedTransactions |
LocatorId | Long | LocatorId of InventoryCompletedTransactions |
Locator | String | Locator of InventoryCompletedTransactions |
TransactionQuantity | Double | TransactionQuantity of InventoryCompletedTransactions |
TransactionUOMCode | String | TransactionUOMCode of InventoryCompletedTransactions |
TransactionUOM | String | TransactionUOM of InventoryCompletedTransactions |
TransactionDate | Datetime | TransactionDate of InventoryCompletedTransactions |
TransactionTypeId | Long | TransactionTypeId of InventoryCompletedTransactions |
TransactionType | String | TransactionType of InventoryCompletedTransactions |
TransactionSourceTypeId | Long | TransactionSourceTypeId of InventoryCompletedTransactions |
TransactionSourceType | String | TransactionSourceType of InventoryCompletedTransactions |
SourceReference | String | SourceReference of InventoryCompletedTransactions |
Account | String | Account of InventoryCompletedTransactions |
Reason | String | Reason of InventoryCompletedTransactions |
Reference | String | Reference of InventoryCompletedTransactions |
ErrorExplanation | String | ErrorExplanation of InventoryCompletedTransactions |
TransferOrganization | String | TransferOrganization of InventoryCompletedTransactions |
TransferOrganizationCode | String | TransferOrganizationCode of InventoryCompletedTransactions |
TransferOrganizationId | Long | TransferOrganizationId of InventoryCompletedTransactions |
TransferOrgLocation | String | TransferOrgLocation of InventoryCompletedTransactions |
TransferOrgLocationId | Double | TransferOrgLocationId of InventoryCompletedTransactions |
TransferSubinventory | String | TransferSubinventory of InventoryCompletedTransactions |
TransferSubinventoryCode | String | TransferSubinventoryCode of InventoryCompletedTransactions |
TransferLocator | String | TransferLocator of InventoryCompletedTransactions |
TransferLocatorId | Long | TransferLocatorId of InventoryCompletedTransactions |
TransferBusinessUnit | String | TransferBusinessUnit of InventoryCompletedTransactions |
Quantity | Double | Quantity of InventoryCompletedTransactions |
UOMName | String | UOMName of InventoryCompletedTransactions |
PrimaryUOMCode | String | PrimaryUOMCode of InventoryCompletedTransactions |
SecondaryQuantity | Double | SecondaryQuantity of InventoryCompletedTransactions |
SecondaryUOM | String | SecondaryUOM of InventoryCompletedTransactions |
SecondaryUOMCode | String | SecondaryUOMCode of InventoryCompletedTransactions |
Source | String | Source of InventoryCompletedTransactions |
SourceLine | Long | SourceLine of InventoryCompletedTransactions |
TransactionAction | String | TransactionAction of InventoryCompletedTransactions |
TransactionActionId | Long | TransactionActionId of InventoryCompletedTransactions |
TransactionSet | Long | TransactionSet of InventoryCompletedTransactions |
TransferTransaction | Long | TransferTransaction of InventoryCompletedTransactions |
ReceivingTransaction | Long | ReceivingTransaction of InventoryCompletedTransactions |
Costed | String | Costed of InventoryCompletedTransactions |
AssetTrackingStatus | String | AssetTrackingStatus of InventoryCompletedTransactions |
AlmInterfaceStatus | String | AlmInterfaceStatus of InventoryCompletedTransactions |
PickSlip | Long | PickSlip of InventoryCompletedTransactions |
PackingUnit | String | PackingUnit of InventoryCompletedTransactions |
ReceiptRequiredAtExpenseDestination | String | ReceiptRequiredAtExpenseDestination of InventoryCompletedTransactions |
ManualReceiptExpense | String | ManualReceiptExpense of InventoryCompletedTransactions |
Location | String | Location of InventoryCompletedTransactions |
ShipToLocationId | Long | ShipToLocationId of InventoryCompletedTransactions |
LocationType | String | LocationType of InventoryCompletedTransactions |
Shipment | String | Shipment of InventoryCompletedTransactions |
Waybill | String | Waybill of InventoryCompletedTransactions |
Carrier | String | Carrier of InventoryCompletedTransactions |
FreightCode | String | FreightCode of InventoryCompletedTransactions |
NumberOfContainers | Long | NumberOfContainers of InventoryCompletedTransactions |
OwningPartyType | String | OwningPartyType of InventoryCompletedTransactions |
OwningTpType | Long | OwningTpType of InventoryCompletedTransactions |
TransferOwningTpType | Long | TransferOwningTpType of InventoryCompletedTransactions |
OwningParty | String | OwningParty of InventoryCompletedTransactions |
OwningPartySite | String | OwningPartySite of InventoryCompletedTransactions |
TransferOwningPartyType | String | TransferOwningPartyType of InventoryCompletedTransactions |
TransferOwningParty | String | TransferOwningParty of InventoryCompletedTransactions |
TransferOwningPartySite | String | TransferOwningPartySite of InventoryCompletedTransactions |
ConsumptionAdvice | String | ConsumptionAdvice of InventoryCompletedTransactions |
ConsumptionAdviceLine | String | ConsumptionAdviceLine of InventoryCompletedTransactions |
ConsumptionLineId | Long | ConsumptionLineId of InventoryCompletedTransactions |
PurchaseOrder | String | PurchaseOrder of InventoryCompletedTransactions |
PurchaseOrderHeaderId | String | PurchaseOrderHeaderId of InventoryCompletedTransactions |
PurchaseOrderLineId | String | PurchaseOrderLineId of InventoryCompletedTransactions |
PurchaseOrderLine | String | PurchaseOrderLine of InventoryCompletedTransactions |
ParentTransaction | Long | ParentTransaction of InventoryCompletedTransactions |
Receipt | String | Receipt of InventoryCompletedTransactions |
RcvShipmentHeaderId | Long | RcvShipmentHeaderId of InventoryCompletedTransactions |
ReceiptLine | String | ReceiptLine of InventoryCompletedTransactions |
RcvShipmentLineId | String | RcvShipmentLineId of InventoryCompletedTransactions |
ConsumptionAdviceError | String | ConsumptionAdviceError of InventoryCompletedTransactions |
ConsumptionAdviceErrorAction | String | ConsumptionAdviceErrorAction of InventoryCompletedTransactions |
AssociatedOwnershipChangeTransaction | Long | AssociatedOwnershipChangeTransaction of InventoryCompletedTransactions |
TaxationCountry | String | TaxationCountry of InventoryCompletedTransactions |
DefaultTaxationCountry | String | DefaultTaxationCountry of InventoryCompletedTransactions |
TransactionBusinessCategory | String | TransactionBusinessCategory of InventoryCompletedTransactions |
TrxBusinessCategory | String | TrxBusinessCategory of InventoryCompletedTransactions |
DocumentFiscalClassification | String | DocumentFiscalClassification of InventoryCompletedTransactions |
DocumentSubType | String | DocumentSubType of InventoryCompletedTransactions |
UserDefinedFiscalClassification | String | UserDefinedFiscalClassification of InventoryCompletedTransactions |
UserDefinedFiscClass | String | UserDefinedFiscClass of InventoryCompletedTransactions |
ProductFiscalClassification | String | ProductFiscalClassification of InventoryCompletedTransactions |
CategoryId | Long | CategoryId of InventoryCompletedTransactions |
IntendedUse | String | IntendedUse of InventoryCompletedTransactions |
IntendedUseClassifId | Long | IntendedUseClassifId of InventoryCompletedTransactions |
LocationOfFinalDischarge | String | LocationOfFinalDischarge of InventoryCompletedTransactions |
ProductCategory | String | ProductCategory of InventoryCompletedTransactions |
ProductCategoryCode | String | ProductCategoryCode of InventoryCompletedTransactions |
TaxClassificationCode | String | TaxClassificationCode of InventoryCompletedTransactions |
TaxClassification | String | TaxClassification of InventoryCompletedTransactions |
ProductType | String | ProductType of InventoryCompletedTransactions |
ProductTypeCode | String | ProductTypeCode of InventoryCompletedTransactions |
FirstPartyTaxRegistrationNumber | String | FirstPartyTaxRegistrationNumber of InventoryCompletedTransactions |
FirstPtyRegId | Long | FirstPtyRegId of InventoryCompletedTransactions |
ThirdPartyTaxRegistrationNumber | String | ThirdPartyTaxRegistrationNumber of InventoryCompletedTransactions |
ThirdPtyRegId | Long | ThirdPtyRegId of InventoryCompletedTransactions |
ShipFromSite | String | ShipFromSite of InventoryCompletedTransactions |
ShipFromLocationId | Long | ShipFromLocationId of InventoryCompletedTransactions |
TaxInvoiceNumber | String | TaxInvoiceNumber of InventoryCompletedTransactions |
TaxInvoiceDate | Date | TaxInvoiceDate of InventoryCompletedTransactions |
AssessableValue | Double | AssessableValue of InventoryCompletedTransactions |
Currency | String | Currency of InventoryCompletedTransactions |
TaxExemptionCertificateNumber | String | TaxExemptionCertificateNumber of InventoryCompletedTransactions |
TaxExemptReasonCode | String | TaxExemptReasonCode of InventoryCompletedTransactions |
ExemptReasonCode | String | ExemptReasonCode of InventoryCompletedTransactions |
OperationNumber | String | OperationNumber of InventoryCompletedTransactions |
OperationSequenceNumber | Long | OperationSequenceNumber of InventoryCompletedTransactions |
OperationSequenceNumberId | Long | OperationSequenceNumberId of InventoryCompletedTransactions |
OperationTransaction | Long | OperationTransaction of InventoryCompletedTransactions |
WIPSupplyType | String | WIPSupplyType of InventoryCompletedTransactions |
WIPSupplyTypeCode | Double | WIPSupplyTypeCode of InventoryCompletedTransactions |
WorkCenter | String | WorkCenter of InventoryCompletedTransactions |
DepartmentCode | String | DepartmentCode of InventoryCompletedTransactions |
DepartmentId | Long | DepartmentId of InventoryCompletedTransactions |
AssemblySerialNumber | String | AssemblySerialNumber of InventoryCompletedTransactions |
ElectronicSignature | Long | ElectronicSignature of InventoryCompletedTransactions |
Organization | String | Organization of InventoryCompletedTransactions |
OrganizationName | String | OrganizationName of InventoryCompletedTransactions |
OrganizationId | Long | OrganizationId of InventoryCompletedTransactions |
OwningPartyOrgName | String | OwningPartyOrgName of InventoryCompletedTransactions |
OwningPartyLocation | String | OwningPartyLocation of InventoryCompletedTransactions |
OwningPartyLocationId | Long | OwningPartyLocationId of InventoryCompletedTransactions |
LotTransactionGroupName | String | LotTransactionGroupName of InventoryCompletedTransactions |
SourceLotFlag | Bool | SourceLotFlag of InventoryCompletedTransactions |
TransactionSourceName | String | TransactionSourceName of InventoryCompletedTransactions |
TransactionSourceId | Long | TransactionSourceId of InventoryCompletedTransactions |
ReasonId | Long | ReasonId of InventoryCompletedTransactions |
ConsErrorTypeCode | String | ConsErrorTypeCode of InventoryCompletedTransactions |
ConsErrorActionCode | String | ConsErrorActionCode of InventoryCompletedTransactions |
OwningOrganizationId | Long | OwningOrganizationId of InventoryCompletedTransactions |
XfrOwningOrganizationId | Long | XfrOwningOrganizationId of InventoryCompletedTransactions |
StructureInstanceNumber | Long | StructureInstanceNumber of InventoryCompletedTransactions |
CreationDate | Datetime | CreationDate of InventoryCompletedTransactions |
CreatedBy | String | CreatedBy of InventoryCompletedTransactions |
Category | String | Category of InventoryCompletedTransactions |
Lot | String | Lot of InventoryCompletedTransactions |
SerialNumber | String | SerialNumber of InventoryCompletedTransactions |
SupplierLot | String | SupplierLot of InventoryCompletedTransactions |
ExternalSystemPackingUnit | String | ExternalSystemPackingUnit of InventoryCompletedTransactions |
DistributionAccountId | Long | DistributionAccountId of InventoryCompletedTransactions |
FinalDischargeLocationId | Long | FinalDischargeLocationId of InventoryCompletedTransactions |
ProjectId | Double | ProjectId of InventoryCompletedTransactions |
TaskId | Double | TaskId of InventoryCompletedTransactions |
CountryOfOriginCode | String | CountryOfOriginCode of InventoryCompletedTransactions |
ProjectNumber | String | ProjectNumber of InventoryCompletedTransactions |
TaskNumber | String | TaskNumber of InventoryCompletedTransactions |
CountryOfOrigin | String | CountryOfOrigin of InventoryCompletedTransactions |
TransferProjectId | Long | TransferProjectId of InventoryCompletedTransactions |
TransferTaskId | Long | TransferTaskId of InventoryCompletedTransactions |
TransferProjectNumber | String | TransferProjectNumber of InventoryCompletedTransactions |
TransferTaskNumber | String | TransferTaskNumber of InventoryCompletedTransactions |
RequesterId | Long | RequesterId of InventoryCompletedTransactions |
RequesterName | String | RequesterName of InventoryCompletedTransactions |
ExternalSystemTransactionReference | String | ExternalSystemTransactionReference of InventoryCompletedTransactions |
MovementRequestLineId | Long | MovementRequestLineId of InventoryCompletedTransactions |
LoadRequestId | Long | LoadRequestId of InventoryCompletedTransactions |
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 |
BindInventoryItemId | Long | bindInventoryItemId |
BindItem | String | bindItem |
BindOrganization | String | bindOrganization |
BindOrganizationId | Long | bindOrganizationId |
BindPJCProjectId | String | bindPJCProjectId |
BindPJCProjectNumber | String | bindPJCProjectNumber |
BindPJCTaskId | String | bindPJCTaskId |
BindPJCTaskNumber | String | bindPJCTaskNumber |
BindTransactionDate | Datetime | bindTransactionDate |
BindTransactionId | Long | bindTransactionId |
Finder | String | finder |