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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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 |