InventoryStagedTransactions
InventoryStagedTransactions
Columns
| Name | Type | Description |
| OrganizationId | Long | Value that uniquely identifies the organization. |
| OrganizationName | String | Name of the organization. |
| InventoryItemId | Long | Value that uniquely identifies the inventory item. |
| ItemNumber | String | Inventory item number. |
| ItemDescription | String | ItemDescription of InventoryStagedTransactions |
| Revision | String | Revision of the inventory item. |
| SubinventoryCode | String | Abbreviation that identifies the subinventory. |
| LocatorId | Long | Value that uniquely identifies the stock locator. |
| LocatorName | String | Description of the stock locators. |
| TransactionQuantity | Double | Transacted quantity of the item. |
| TransactionUOM | String | Abbreviation that identifies the unit of measure for the transaction. |
| TransactionUnitOfMeasure | String | Unit of measure for the transaction. |
| TransferOrganization | Long | Value that uniquely identifies the destination organization for transfer transactions. |
| TransferOrganizationName | String | Name of the transfer organization. |
| TransferSubinventory | String | Name of the destination subinventory for a transfer transaction. |
| TransferLocator | Long | Destination locator for a transfer transaction. |
| TransferLocatorName | String | Name of the destination locator for a transfer transaction. |
| TransactionHeaderId | Long | Value that uniquely identifies the transaction header. |
| TransactionInterfaceId [KEY] | Long | Value that uniquely identifies the transaction. |
| TrxSourceLineId | Long | Value that uniquely identifies the transaction source line. |
| TrxSourceDeliveryId | Long | Value that uniquely identifies the transaction source shipment. |
| TransactionDate | Datetime | Date when the transaction occurred. |
| SourceCode | String | Abbreviation that identifies the source. |
| SourceHeaderId | Long | Value that uniquely identifies the source header. |
| SourceLineId | Long | Value that uniquely identifies the source line. |
| TransactionSourceName | String | Name of the transaction source. |
| DemandSourceHeaderId | Long | Value that uniquely identifies the demand source header. |
| DemandSourceLine | String | Value that identifies the line in the demand document. |
| DemandSourceDelivery | String | Value that identifies the shipment in the demand document. |
| TransactionTypeName | String | Name of the transaction type. |
| TransactionTypeId | Long | Value that uniquely identifies the transaction type. |
| TransactionSourceTypeName | String | Name of the transaction source type. |
| TransactionSourceTypeId | Long | Value that uniquely identifies the transaction source type name. |
| TransactionActionName | String | Name of the transaction action. |
| TransactionActionId | String | Value that uniquely identifies the transaction action. |
| TransactionMode | String | Indicates the transaction mode. |
| LockStatus | String | Current status of the lock. |
| ProcessStatus | String | Current status of the process. |
| TransactionReference | String | Reference to the transaction. |
| ReasonId | Long | Value that uniquely identifies the inventory staged transaction reason. |
| ReasonName | String | Name of the inventory staged transaction reason. |
| ErrorCode | String | Abbreviation that identifies the error. |
| ErrorExplanation | String | Explanation of why the error occurred. |
| ShipmentNumber | String | Number that identifies the shipment. |
| FreightCarrierId | Long | Value that uniquely identifies the carrier. |
| Carrier | String | Name of the carrier. |
| ExternalSystemPackingUnit | String | Name of the packing unit in the external application. |
| WaybillAirbill | String | Number that identifies the waybill or airbill. |
| Containers | Double | Value that identifies the container to use when packing the unit. |
| TransferCost | Double | Cost incurred for the transfer. |
| TransportationCost | Double | Cost incurred for the transportation. |
| ExpectedArrivalDate | Date | Date when the item is expected to arrive. |
| OwningOrganizationId | Long | Value that uniquely identifies the owning organization. |
| OwningOrganizationName | String | Name of the owning organization. |
| OwningTpType | String | Type of owning trading partner. |
| TransferOwningOrganizationId | Long | Value that uniquely identifies the organization that owns the transfer. |
| TransferOwningOrganizationName | String | Name of the organization that owns the transfer. |
| TransferOwningTpType | String | Type of trading party owning the transfer. |
| ProcurementBusinessUnitName | String | Name of the business unit that procured the item. |
| VendorName | String | Name of the vendor. |
| VendorNumber | String | Number that identifies the vendor. |
| ConsignmentAgreementNumber | String | Number that identifies the consignment agreement. |
| DistributionAccountId | Long | Value that uniquely identifies the distribution account. |
| UseCurrentCostFlag | Bool | Contains one of the following values: true or false. If true, then use the current item cost. If false, then do not use the current item cost. This attribute does not have a default value. This attribute is mandatory. |
| PrimaryQuantity | Double | Transaction quantity in the primary unit of measure that the item uses. |
| TransactionBatchId | Long | Value that uniquely identifies the transaction batch. |
| TransactionBatchSequence | Long | Sequence number that identifies the transaction batch. |
| TransactionCost | Double | Cost incurred for the transaction. |
| TransactionGroupId | Long | Value that uniquely identifies the transaction group. |
| TransactionGroupSequence | Double | Sequence number that identifies the transaction group. |
| DefaultTaxationCountry | String | Abbreviation that identifies the default country for taxation. |
| DocumentSubType | String | Abbreviation that identifies the classification of the fiscal document. |
| TrxBusinessCategory | String | Name of the transaction business category. |
| UserDefinedFiscClass | String | Name of the fiscal classification. |
| TaxInvoiceNumber | String | Number of the tax invoice document. |
| TaxInvoiceDate | Date | Date and time of generation of the tax invoice document. |
| ProductCategory | String | Name of the product category of the transaction. |
| ProductType | String | Type of the product of the transaction. |
| AssessableValue | Double | Price that the tax authority uses to calculate tax for the item. |
| TaxClassificationCode | String | Abbreviation that identifies the tax classification. |
| ExemptCertificateNumber | String | Number that identifies the exempt certificate. |
| ExemptReasonCode | String | Abbreviation that identifies the reason for exemption. |
| IntendedUse | String | Value that identifies the classification for the intended use. |
| FirstPtyNumber | String | Number that identifies the first party of the transaction. |
| ThirdPtyNumber | String | Number that identifies the third party of the transaction. |
| FinalDischargeLocCode | String | Abbreviation that identifies the final discharge location. |
| CategoryName | String | Name of the category. |
| TransactionCostIdentifier | String | Value that uniquely identifies the transaction cost. |
| TransactionSourceId | Long | Value that uniquely identifies the transaction source. |
| ChartOfAccountsId | Long | Value that uniquely identifies the chart of accounts. |
| StructureInstanceNumber | Long | StructureInstanceNumber of InventoryStagedTransactions |
| SecondaryInventoryName | String | SecondaryInventoryName of InventoryStagedTransactions |
| SubinventoryId | Long | SubinventoryId of InventoryStagedTransactions |
| TransferSubInventoryId | Long | TransferSubInventoryId of InventoryStagedTransactions |
| TransferLocatorsSIN | Long | TransferLocatorsSIN of InventoryStagedTransactions |
| AccountCombination | String | Combination of the inventory transactions for a specified account combination. |
| AccountAliasCombination | String | Combination of the inventory transactions for an account alias. |
| TransferProjectId | Long | Value that uniquely identifies the destination project for the project transfer transactions. This attribute is associated with a feature that requires opt in. |
| TransferTaskId | Long | Value that uniquely identifies the destination task for the project transfer transactions. This attribute is associated with a feature that requires opt in. |
| TransferInvProject | String | Number that identifies the destination project for the project transfer transactions. This attribute is associated with a feature that requires opt in. |
| TransferInvTask | String | Number that identifies the destination task for the project transfer transactions. This attribute is associated with a feature that requires opt in. |
| LotTransactionGroupName | String | Name of the group of lot split, merge, and translate transactions data. This value is defined by the user. |
| SourceLotFlag | Bool | Contains one of the following values: true or false. If true, then the data belongs to the source lot of lot split, merge, and translate transaction types. If false, then the data belongs to the resultant lot of split, merge, and translate transaction types. This attribute does not have a default value. |
| RequesterId | String | Value that uniquely identifies the person who requested the material issued or received. |
| RequesterName | String | Name of the person who requested the material issued or received. |
| RequesterNumber | String | Number that uniquely identifies the person who requested the material issued or received. This value is defined by the user. |
| ExternalSystemTransactionReference | String | Value that refers to the corresponding transaction in external applications. |
| RepresentativeLotFlag | Bool | Contains one of the following values: true or false. If true, then the data belongs to the representative source lot for a lot merge transaction type. The lot attributes from the representative source lot will be copied to the resultant lot. If false, then the lot is not the representative source lot. This attribute does not have a default value. |
| SecondaryUOMCode | String | Abbreviation that identifies the secondary unit of measure that does not have a fixed conversion from the primary unit of measure. Also, this is part of the dual unit of measure record keeping that enables industries to maintain and use inventory in both quantity and weight units of measure, or volume and length units of measure. |
| SecondaryUnitOfMeasure | String | Secondary unit of measure in which an item can be transacted. |
| SecondaryTransactionQuantity | Double | Transaction quantity of an item in its secondary unit of measure. |
| LoadRequestId | Long | LoadRequestId of InventoryStagedTransactions |
| CreationDate | Datetime | CreationDate of InventoryStagedTransactions |
| CreatedBy | String | CreatedBy of InventoryStagedTransactions |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |