Get all transactions
get
/fscmRestApi/resources/11.13.18.05/inventoryStagedTransactions
Request
Query Parameters
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables- PrimaryKey Finds inventory staged transaction according to the primary key.
Finder Variables- TransactionInterfaceId; integer; Value that uniquely identifies the transaction.
- PrimaryKey Finds inventory staged transaction according to the primary key.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- AccountAliasCombination; string; Combination of the inventory transactions for an account alias.
- AccountCombination; string; Combination of the inventory transactions for a specified account combination.
- AssessableValue; number; Price that the tax authority uses to calculate tax for the item.
- Carrier; string; Name of the carrier.
- CategoryId; integer; Value that uniquely identifies the details of the category.
- CategoryName; string; Name of the category.
- ChartOfAccountsId; integer; Value that uniquely identifies the chart of accounts.
- ConsignmentAgreementNumber; string; Number that identifies the consignment agreement.
- Containers; number; Value that identifies the container to use when packing the unit.
- ContentLPNId; integer; Value that uniquely identifies the content LPN.
- ContentLicensePlateNumber; string; Name of the content LPN is populated if the entire LPN is transacted.
- CreatedBy; string; User who created the transaction.
- CreationDate; string; Date when the user created the transaction.
- CurrencyCode; string; Abbreviation that identifies the currency code for the transaction.
- DefaultTaxationCountry; string; Abbreviation that identifies the default country for taxation.
- DefaultingControl; string; Default control for the dual unit of measure Item.
- DemandSourceDelivery; string; Value that identifies the shipment in the demand document.
- DemandSourceHeaderId; integer; Value that uniquely identifies the demand source header.
- DemandSourceLine; string; Value that identifies the line in the demand document.
- DistributionAccountId; integer; Value that uniquely identifies the distribution account.
- DocumentSubType; string; Abbreviation that identifies the classification of the fiscal document.
- ERecordId; integer; Value that uniquely identifies the electronic signature.
- ErrorCode; string; Abbreviation that identifies the error.
- ErrorExplanation; string; Explanation of why the error occurred.
- ExemptCertificateNumber; string; Number that identifies the exempt certificate.
- ExemptReasonCode; string; Abbreviation that identifies the reason for exemption.
- ExpectedArrivalDate; string; Date when the item is expected to arrive.
- ExternalSystemPackingUnit; string; Name of the packing unit in the external application.
- ExternalSystemTransactionReference; string; Value that refers to the corresponding transaction in external applications.
- FinalDischargeLocCode; string; Abbreviation that identifies the final discharge location.
- FirstPtyNumber; string; Number that identifies the first party of the transaction.
- FreightCarrierId; integer; Value that uniquely identifies the carrier.
- IntendedUse; string; Value that identifies the classification for the intended use.
- InventoryItemId; integer; Value that uniquely identifies the inventory item.
- ItemDescription; string; Description of the item.
- ItemNumber; string; Inventory item number.
- LPNId; integer; Value that uniquely identifies the LPN.
- LastUpdateDate; string; Date and time when the user most recently updated the row.
- LastUpdateLogin; string; Login that the user used when updating the row.
- LastUpdatedBy; string; User who most recently updated the row.
- LicensePlateNumber; string; Name of the LPN.
- LoadRequestId; integer; Value that uniquely identifies the Load Interface File for Import scheduled process that uploaded the transaction.
- LocationType; string; Location type identifier that qualifies the ship-to location.
- LocatorId; integer; Value that uniquely identifies the stock locator.
- LocatorName; string; Description of the stock locators.
- LockStatus; string; Current status of the lock.
- LotControlCode; number; Code that's associated with the lot-controlled item.
- LotTransactionGroupName; string; Name of the group of lot split, merge, and translate transactions data. This value is defined by the user.
- OrganizationId; integer; Value that uniquely identifies the organization.
- OrganizationName; string; Name of the organization.
- OwningOrganizationId; integer; Value that uniquely identifies the owning organization.
- OwningOrganizationName; string; Name of the owning organization.
- OwningTpType; string; Type of owning trading partner.
- ParentId; integer; Transaction Interface ID of the parent interface line in the case of LPN Repack transactions.
- PrimaryQuantity; number; Transaction quantity in the primary unit of measure that the item uses.
- PrimaryUOMCode; string; Abbreviation that identifies the primary unit of measure for the transaction.
- ProcessId; integer; Value that indicates the process ID of the job that created or last updated the row.
- ProcessStatus; string; Current status of the process.
- ProcurementBusinessUnitName; string; Name of the business unit that procured the item.
- ProductCategory; string; Name of the product category of the transaction.
- ProductType; string; Type of the product of the transaction.
- ReasonId; integer; Value that uniquely identifies the reason.
- ReasonName; string; Name of the inventory transaction reason.
- ReceivingTransactionId; integer; Value that uniquely identifies the details of the receiving transaction.
- RepresentativeLotFlag; boolean; 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 isn't the representative source lot. This attribute doesn't 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.
- Revision; string; Revision of the inventory item.
- RevisionControlCode; number; Code that's associated with the revision-controlled item.
- RfidEventActionId; integer; Value that identifies the RFID event action that created the inventory transaction.
- SecondaryInventoryName; string; Name of the secondary inventory.
- SecondaryTransactionQuantity; number; Transaction quantity of an item in its secondary unit of measure.
- SecondaryUOMCode; string; Abbreviation that identifies the secondary unit of measure that doesn't 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.
- SerialNumberControlCode; number; Code that's associated with the serial-controlled item.
- ShipFromLocationId; integer; Value that uniquely identifies the details of the location from which an item is shipped.
- ShipToLocationId; integer; Value that uniquely identifies the details of the location to which an item is shipped.
- ShipmentNumber; string; Number that identifies the shipment.
- SourceCode; string; Abbreviation that identifies the source.
- SourceHeaderId; integer; Value that uniquely identifies the source header.
- SourceLineId; integer; Value that uniquely identifies the source line.
- SourceLotFlag; boolean; 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 doesn't have a default value.
- StructureInstanceNumber; integer; Number that identifies the structure instance.
- SubinventoryCode; string; Abbreviation that identifies the subinventory.
- SubinventoryId; integer; Value that uniquely identifies the subinventory.
- TagCode; string; Value that identifies the RFID tag linked to the inventory transaction.
- TaxClassificationCode; string; Abbreviation that identifies the tax classification.
- TaxInvoiceDate; string; Date and time of generation of the tax invoice document.
- TaxInvoiceNumber; string; Number of the tax invoice document.
- ThirdPtyNumber; string; Number that identifies the third party of the transaction.
- TrackingUnitOfMeasure; string; Name of the unit of measure used for tracking the item in inventory.
- TransactionActionId; string; Value that uniquely identifies the transaction action.
- TransactionActionName; string; Name of the transaction action.
- TransactionBatchId; integer; Value that uniquely identifies the transaction batch.
- TransactionBatchSequence; integer; Sequence number that identifies the transaction batch.
- TransactionCost; number; Cost incurred for the transaction.
- TransactionCostIdentifier; string; Value that uniquely identifies the transaction cost.
- TransactionDate; string; Date when the transaction occurred.
- TransactionGroupId; integer; Value that uniquely identifies the transaction group.
- TransactionGroupSequence; number; Sequence number that identifies the transaction group.
- TransactionHeaderId; integer; Value that uniquely identifies the transaction header.
- TransactionInterfaceId; integer; Value that uniquely identifies the transaction. This attribute is associated with a feature that requires opt in.
- TransactionMode; string; Indicates the transaction mode.
- TransactionQuantity; number; Transaction quantity of the item.
- TransactionReference; string; Reference to the transaction.
- TransactionSourceId; integer; Value that uniquely identifies the transaction source.
- TransactionSourceName; string; Name of the transaction source.
- TransactionSourceTypeId; integer; Value that uniquely identifies the transaction source type name.
- TransactionSourceTypeName; string; User who created the transaction source type.
- TransactionTypeId; integer; Value that uniquely identifies the transaction type.
- TransactionTypeName; string; Name of the transaction type.
- TransactionUOM; string; Abbreviation that identifies the unit of measure for the transaction.
- TransactionUnitOfMeasure; string; Unit of measure for the transaction.
- TransferCost; number; Cost incurred for the transfer.
- 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.
- TransferLPNId; integer; Value that uniquely identifies the transfer LPN.
- TransferLicensePlateNumber; string; Name of the transfer LPN.
- TransferLocator; integer; Destination locator for a transfer transaction.
- TransferLocatorName; string; Name of the destination locator for a transfer transaction.
- TransferLocatorsSIN; integer; Structure instance number of the transfer locators.
- TransferOrganization; integer; Value that uniquely identifies the destination organization for transfer transactions.
- TransferOrganizationName; string; Name of the transfer organization.
- TransferOwningOrganizationId; integer; 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.
- TransferProjectId; integer; Value that uniquely identifies the destination project for the project transfer transactions. This attribute is associated with a feature that requires opt in.
- TransferSubInventoryId; integer; Value that uniquely identifies the transfer subinventory.
- TransferSubinventory; string; Name of the destination subinventory for a transfer transaction.
- TransferTaskId; integer; Value that uniquely identifies the destination task for the project transfer transactions. This attribute is associated with a feature that requires opt in.
- TransportationCost; number; Cost incurred for the transportation.
- TrxBusinessCategory; string; Name of the transaction business category.
- TrxSourceDeliveryId; integer; Value that uniquely identifies the transaction source shipment.
- TrxSourceLineId; integer; Value that uniquely identifies the transaction source line.
- UseCurrentCostFlag; boolean; Contains one of the following values: true or false. If true, then use the current item cost. If false, then don't use the current item cost. This attribute doesn't have a default value. This attribute is mandatory.
- UserDefinedFiscClass; string; Name of the fiscal classification.
- VendorName; string; Name of the supplier for the lot.
- VendorNumber; string; Number that identifies the supplier.
- WaybillAirbill; string; Number that identifies the waybill or airbill.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : inventoryStagedTransactions
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-item-response
Type:
Show Source
object-
AccountAliasCombination: string
Combination of the inventory transactions for an account alias.
-
AccountCombination: string
Combination of the inventory transactions for a specified account combination.
-
AssessableValue: number
Price that the tax authority uses to calculate tax for the item.
-
attachments: array
Attachments
Title:
AttachmentsThe attachments resource is used to view, create, and update attachments. -
Carrier: string
Maximum Length:
255Name of the carrier. -
CategoryId: integer
(int64)
Value that uniquely identifies the details of the category.
-
CategoryName: string
Maximum Length:
250Name of the category. -
ChartOfAccountsId: integer
(int64)
Value that uniquely identifies the chart of accounts.
-
ConsignmentAgreementNumber: string
Maximum Length:
30Number that identifies the consignment agreement. -
Containers: number
Value that identifies the container to use when packing the unit.
-
ContentLicensePlateNumber: string
Maximum Length:
255Name of the content LPN is populated if the entire LPN is transacted. -
ContentLPNId: integer
(int64)
Value that uniquely identifies the content LPN.
-
costs: array
Costs
Title:
CostsThe smallest logical units of expenditure that you can charge against inventory staged transactions. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the transaction. -
CreationDate: string
(date-time)
Read Only:
trueDate when the user created the transaction. -
CurrencyCode: string
Maximum Length:
30Abbreviation that identifies the currency code for the transaction. -
DefaultingControl: string
Title:
Defaulting ControlRead Only:trueMaximum Length:30Default control for the dual unit of measure Item. -
DefaultTaxationCountry: string
Maximum Length:
2Abbreviation that identifies the default country for taxation. -
DemandSourceDelivery: string
Maximum Length:
30Value that identifies the shipment in the demand document. -
DemandSourceHeaderId: integer
(int64)
Value that uniquely identifies the demand source header.
-
DemandSourceLine: string
Maximum Length:
30Value that identifies the line in the demand document. -
dFFs: array
dFFs
-
DistributionAccountId: integer
(int64)
Value that uniquely identifies the distribution account.
-
DocumentSubType: string
Maximum Length:
240Abbreviation that identifies the classification of the fiscal document. -
ERecordId: integer
(int64)
Read Only:
trueValue that uniquely identifies the electronic signature. -
ErrorCode: string
Maximum Length:
240Abbreviation that identifies the error. -
ErrorExplanation: string
Maximum Length:
240Explanation of why the error occurred. -
ExemptCertificateNumber: string
Maximum Length:
80Number that identifies the exempt certificate. -
ExemptReasonCode: string
Maximum Length:
30Abbreviation that identifies the reason for exemption. -
ExpectedArrivalDate: string
(date)
Date when the item is expected to arrive.
-
ExternalSystemPackingUnit: string
Maximum Length:
2000Name of the packing unit in the external application. -
ExternalSystemTransactionReference: string
Maximum Length:
300Value that refers to the corresponding transaction in external applications. -
FinalDischargeLocCode: string
Maximum Length:
60Abbreviation that identifies the final discharge location. -
FirstPtyNumber: string
Maximum Length:
30Number that identifies the first party of the transaction. -
FreightCarrierId: integer
(int64)
Value that uniquely identifies the carrier.
-
IntendedUse: string
Maximum Length:
240Value that identifies the classification for the intended use. -
InventoryItemId: integer
(int64)
Value that uniquely identifies the inventory item.
-
ItemDescription: string
Title:
Item DescriptionRead Only:trueMaximum Length:240Description of the item. -
ItemNumber: string
Maximum Length:
255Inventory item number. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the user most recently updated the row. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the row. -
LastUpdateLogin: string
Read Only:
trueMaximum Length:32Login that the user used when updating the row. -
LicensePlateNumber: string
Maximum Length:
255Name of the LPN. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LoadRequestId: integer
(int64)
Read Only:
trueValue that uniquely identifies the Load Interface File for Import scheduled process that uploaded the transaction. -
LocationType: string
Maximum Length:
30Location type identifier that qualifies the ship-to location. -
LocatorId: integer
(int64)
Value that uniquely identifies the stock locator.
-
LocatorName: string
Maximum Length:
255Description of the stock locators. -
LockStatus: string
Maximum Length:
30Current status of the lock. -
LotControlCode: number
Title:
Lot ControlRead Only:trueCode that's associated with the lot-controlled item. -
lots: array
Lots
Title:
LotsThe lots in staged inventory transactions resource gets lot details for inventory transactions when the item is under lot control. The details include lot, parent lot, quantity, grade, expiration action, maturity date, and so on. -
LotSummaries: array
Lot Summaries
Title:
Lot SummariesThe item quantities for organization, subinventory, subinventory and locator, project, and project and task, and the inbound quantities for an organization for items that are enabled for lot control. -
LotTransactionGroupName: string
Maximum Length:
30Name of the group of lot split, merge, and translate transactions data. This value is defined by the user. -
LPNId: integer
(int64)
Value that uniquely identifies the LPN.
-
OrganizationId: integer
(int64)
Value that uniquely identifies the organization.
-
OrganizationName: string
Maximum Length:
255Name of the organization. -
OwningOrganizationId: integer
(int64)
Value that uniquely identifies the owning organization.
-
OwningOrganizationName: string
Maximum Length:
240Name of the owning organization. -
OwningTpType: string
Maximum Length:
30Type of owning trading partner. -
ParentId: integer
(int64)
Read Only:
trueTransaction Interface ID of the parent interface line in the case of LPN Repack transactions. -
PrimaryQuantity: number
Transaction quantity in the primary unit of measure that the item uses.
-
PrimaryUOMCode: string
Title:
Primary UOMRead Only:trueMaximum Length:3Abbreviation that identifies the primary unit of measure for the transaction. -
ProcessId: integer
(int64)
Value that indicates the process ID of the job that created or last updated the row.
-
ProcessStatus: string
Maximum Length:
30Default Value:1Current status of the process. -
ProcurementBusinessUnitName: string
Maximum Length:
240Name of the business unit that procured the item. -
ProductCategory: string
Maximum Length:
240Name of the product category of the transaction. -
ProductType: string
Maximum Length:
240Type of the product of the transaction. -
projectCostingDFFs: array
projectCostingDFFs
-
ReasonId: integer
(int64)
Value that uniquely identifies the reason.
-
ReasonName: string
Maximum Length:
255Name of the inventory transaction reason. -
ReceivingTransactionId: integer
(int64)
Value that uniquely identifies the details of the receiving transaction.
-
RepresentativeLotFlag: boolean
Maximum Length:
80Contains 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 isn't the representative source lot. This attribute doesn't have a default value. -
RequesterId: string
Maximum Length:
80Value that uniquely identifies the person who requested the material issued or received. -
RequesterName: string
Maximum Length:
240Name of the person who requested the material issued or received. -
RequesterNumber: string
Maximum Length:
30Number that uniquely identifies the person who requested the material issued or received. This value is defined by the user. -
Revision: string
Maximum Length:
18Revision of the inventory item. -
RevisionControlCode: number
Title:
Revision ControlRead Only:trueCode that's associated with the revision-controlled item. -
RfidEventActionId: integer
Read Only:
trueValue that identifies the RFID event action that created the inventory transaction. -
SecondaryInventoryName: string
Read Only:
trueMaximum Length:10Name of the secondary inventory. -
SecondaryTransactionQuantity: number
Transaction quantity of an item in its secondary unit of measure.
-
SecondaryUnitOfMeasure: string
Maximum Length:
25Secondary unit of measure in which an item can be transacted. -
SecondaryUOMCode: string
Maximum Length:
3Abbreviation that identifies the secondary unit of measure that doesn't 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. -
SerialNumberControlCode: number
Title:
Serial Number ControlRead Only:trueCode that's associated with the serial-controlled item. -
serials: array
Lot Serials
Title:
Lot SerialsThe lot serials in staged inventory transactions resource gets lot and serial details for inventory transactions when the item is under both lot and serial control. The details include lot number, serial number, and so on. -
SerialSummaries: array
Serial Summaries
Title:
Serial SummariesThe item quantities for organization, subinventory, subinventory and locator, project, and project and task, and the inbound quantities for an organization for items that are enabled for serial control. -
ShipFromLocationId: integer
(int64)
Value that uniquely identifies the details of the location from which an item is shipped.
-
ShipmentNumber: string
Maximum Length:
30Number that identifies the shipment. -
ShipToLocationId: integer
(int64)
Value that uniquely identifies the details of the location to which an item is shipped.
-
SourceCode: string
Maximum Length:
30Abbreviation that identifies the source. -
SourceHeaderId: integer
(int64)
Value that uniquely identifies the source header.
-
SourceLineId: integer
(int64)
Value that uniquely identifies the source line.
-
SourceLotFlag: boolean
Maximum Length:
3Contains 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 doesn't have a default value. -
StructureInstanceNumber: integer
(int64)
Title:
Locator StructureRead Only:trueNumber that identifies the structure instance. -
SubinventoryCode: string
Maximum Length:
10Abbreviation that identifies the subinventory. -
SubinventoryId: integer
(int64)
Read Only:
trueValue that uniquely identifies the subinventory. -
SubinventoryName: string
Read Only:
trueMaximum Length:30Name of the subinventory. -
TagCode: string
Read Only:
trueMaximum Length:255Value that identifies the RFID tag linked to the inventory transaction. -
TaxClassificationCode: string
Maximum Length:
50Abbreviation that identifies the tax classification. -
TaxInvoiceDate: string
(date)
Date and time of generation of the tax invoice document.
-
TaxInvoiceNumber: string
Maximum Length:
150Number of the tax invoice document. -
ThirdPtyNumber: string
Maximum Length:
30Number that identifies the third party of the transaction. -
trackingAttributesDFF: array
trackingAttributesDFF
-
TrackingUnitOfMeasure: string
Title:
Tracking Unit of MeasureRead Only:trueMaximum Length:30Name of the unit of measure used for tracking the item in inventory. -
TransactionActionId: string
Maximum Length:
30Value that uniquely identifies the transaction action. -
TransactionActionName: string
Maximum Length:
255Name of the transaction action. -
TransactionBatchId: integer
(int64)
Value that uniquely identifies the transaction batch.
-
TransactionBatchSequence: integer
(int64)
Sequence number that identifies the transaction batch.
-
TransactionCost: number
Cost incurred for the transaction.
-
TransactionCostIdentifier: string
Maximum Length:
30Value that uniquely identifies the transaction cost. -
TransactionDate: string
(date-time)
Date when the transaction occurred.
-
TransactionGroupId: integer
(int64)
Value that uniquely identifies the transaction group.
-
TransactionGroupSequence: number
Sequence number that identifies the transaction group.
-
TransactionHeaderId: integer
(int64)
Value that uniquely identifies the transaction header.
-
TransactionInterfaceId: integer
(int64)
Value that uniquely identifies the transaction. This attribute is associated with a feature that requires opt in.
-
TransactionMode: string
Maximum Length:
30Indicates the transaction mode. -
TransactionQuantity: number
Transaction quantity of the item.
-
TransactionReference: string
Maximum Length:
240Reference to the transaction. -
TransactionSourceId: integer
(int64)
Value that uniquely identifies the transaction source.
-
TransactionSourceName: string
Name of the transaction source.
-
TransactionSourceTypeId: integer
(int64)
Value that uniquely identifies the transaction source type name.
-
TransactionSourceTypeName: string
Maximum Length:
255User who created the transaction source type. -
TransactionTypeId: integer
(int64)
Value that uniquely identifies the transaction type.
-
TransactionTypeName: string
Maximum Length:
255Name of the transaction type. -
TransactionUnitOfMeasure: string
Maximum Length:
25Unit of measure for the transaction. -
TransactionUOM: string
Maximum Length:
3Abbreviation that identifies the unit of measure for the transaction. -
TransferCost: number
Cost incurred for the transfer.
-
TransferInvProject: string
Maximum Length:
255Number that identifies the destination project for the project transfer transactions. This attribute is associated with a feature that requires opt in. -
TransferInvTask: string
Maximum Length:
255Number that identifies the destination task for the project transfer transactions. This attribute is associated with a feature that requires opt in. -
TransferLicensePlateNumber: string
Maximum Length:
255Name of the transfer LPN. -
TransferLocator: integer
(int64)
Destination locator for a transfer transaction.
-
TransferLocatorName: string
Maximum Length:
255Name of the destination locator for a transfer transaction. -
TransferLocatorsSIN: integer
(int64)
Title:
Locator StructureRead Only:trueStructure instance number of the transfer locators. -
TransferLPNId: integer
(int64)
Value that uniquely identifies the transfer LPN.
-
TransferOrganization: integer
(int64)
Value that uniquely identifies the destination organization for transfer transactions.
-
TransferOrganizationName: string
Maximum Length:
240Name of the transfer organization. -
TransferOwningOrganizationId: integer
(int64)
Value that uniquely identifies the organization that owns the transfer.
-
TransferOwningOrganizationName: string
Maximum Length:
240Name of the organization that owns the transfer. -
TransferOwningTpType: string
Maximum Length:
30Type of trading party owning the transfer. -
TransferProjectId: integer
(int64)
Value that uniquely identifies the destination project for the project transfer transactions. This attribute is associated with a feature that requires opt in.
-
TransferSubinventory: string
Maximum Length:
10Name of the destination subinventory for a transfer transaction. -
TransferSubInventoryId: integer
(int64)
Read Only:
trueValue that uniquely identifies the transfer subinventory. -
TransferSubinventoryName: string
Read Only:
trueMaximum Length:30Name of the transfer subinventory. -
TransferTaskId: integer
(int64)
Value that uniquely identifies the destination task for the project transfer transactions. This attribute is associated with a feature that requires opt in.
-
TransportationCost: number
Cost incurred for the transportation.
-
TrxBusinessCategory: string
Maximum Length:
240Name of the transaction business category. -
TrxSourceDeliveryId: integer
(int64)
Value that uniquely identifies the transaction source shipment.
-
TrxSourceLineId: integer
(int64)
Value that uniquely identifies the transaction source line.
-
UseCurrentCostFlag: boolean
Maximum Length:
1Contains one of the following values: true or false. If true, then use the current item cost. If false, then don't use the current item cost. This attribute doesn't have a default value. This attribute is mandatory. -
UserDefinedFiscClass: string
Maximum Length:
30Name of the fiscal classification. -
VendorName: string
Maximum Length:
240Name of the supplier for the lot. -
VendorNumber: string
Maximum Length:
30Number that identifies the supplier. -
WaybillAirbill: string
Maximum Length:
20Number that identifies the waybill or airbill.
Nested Schema : Attachments
Type:
arrayTitle:
AttachmentsThe attachments resource is used to view, create, and update attachments.
Show Source
Nested Schema : Costs
Type:
arrayTitle:
CostsThe smallest logical units of expenditure that you can charge against inventory staged transactions.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Lots
Type:
arrayTitle:
LotsThe lots in staged inventory transactions resource gets lot details for inventory transactions when the item is under lot control. The details include lot, parent lot, quantity, grade, expiration action, maturity date, and so on.
Show Source
Nested Schema : Lot Summaries
Type:
arrayTitle:
Lot SummariesThe item quantities for organization, subinventory, subinventory and locator, project, and project and task, and the inbound quantities for an organization for items that are enabled for lot control.
Show Source
Nested Schema : projectCostingDFFs
Type:
Show Source
array-
Array of:
object Discriminator: __FLEX_Context
Discriminator:
{ "propertyName":"__FLEX_Context", "mapping":{ "AP_Distribution_Sets":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FDistribution__5FSetsVO-item-response", "AP_Invoice_Distribution":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FInvoice__5FDistributionVO-item-response", "AP_Invoice_Line":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FInvoice__5FLineVO-item-response", "EXM_Expense_Report":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFEXM__5FExpense__5FReportVO-item-response", "EXM_Expense_Report_Line":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response", "INV_Misc_Transactions":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFINV__5FMisc__5FTransactionsVO-item-response", "OM_Sales_Order":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFOM__5FSales__5FOrderVO-item-response", "PJC_All":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPJC__5FAllVO-item-response", "PJC_Expenditure_Batch":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPJC__5FExpenditure__5FBatchVO-item-response", "POR_Requisition":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPOR__5FRequisitionVO-item-response", "POR_User_Preferences":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPOR__5FUser__5FPreferencesVO-item-response", "PO_Purchase_Order":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrderVO-item-response", "PO_Purchase_Order_Line":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response", "PO_Purchase_Order_Schedule":"#/components/schemas/oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response" } }
Nested Schema : Lot Serials
Type:
arrayTitle:
Lot SerialsThe lot serials in staged inventory transactions resource gets lot and serial details for inventory transactions when the item is under both lot and serial control. The details include lot number, serial number, and so on.
Show Source
Nested Schema : Serial Summaries
Type:
arrayTitle:
Serial SummariesThe item quantities for organization, subinventory, subinventory and locator, project, and project and task, and the inbound quantities for an organization for items that are enabled for serial control.
Show Source
Nested Schema : inventoryStagedTransactions-attachments-item-response
Type:
Show Source
object-
AsyncTrackerId: string
Title:
Asynchronous Upload Tracker IdAttribute provided for the exclusive use by the Attachment UI components to assist in uploading files. -
AttachedDocumentId: integer
(int64)
Title:
Attached Document IdThe unique identifier of the attached document. -
CategoryName: string
Title:
CategoryMaximum Length:30The category of the attachment. - ContentRepositoryFileShared: boolean
-
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:255The user who created the record. -
CreatedByUserName: string
Title:
Created By User NameRead Only:trueThe user name who created the record. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the record was created. -
DatatypeCode: string
Title:
TypeMaximum Length:30Default Value:FILEA value that indicates the data type. -
Description: string
Title:
DescriptionMaximum Length:255The description of the attachment. -
DmDocumentId: string
Maximum Length:
255The document ID from which the attachment is created. -
DmFolderPath: string
Title:
Dm Folder PathMaximum Length:1000The folder path from which the attachment is created. -
DmVersionNumber: string
Maximum Length:
255The document version number from which the attachment is created. -
DownloadInfo: string
Title:
DownloadInfoJSON object represented as a string containing information used to programmatically retrieve a file attachment. -
ErrorStatusCode: string
Title:
Error Status CodeThe error code, if any, for the attachment. -
ErrorStatusMessage: string
Title:
Error Status MessageThe error message, if any, for the attachment. -
ExpirationDate: string
(date-time)
Title:
Expiration DateThe expiration date of the contents in the attachment. -
FileContents: string
(byte)
Title:
File ContentsThe contents of the attachment. -
FileName: string
Title:
File NameMaximum Length:2048The file name of the attachment. -
FileUrl: string
Title:
File UrlThe URI of the file. -
FileWebImage: string
(byte)
Title:
File Web ImageRead Only:trueThe base64 encoded image of the file displayed in .png format if the source is a convertible image. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date when the record was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:255The user who last updated the record. -
LastUpdatedByUserName: string
Title:
Last Updated By UserRead Only:trueThe user name who last updated the record. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PostProcessingAction: string
Title:
PostProcessingActionThe name of the action that can be performed after an attachment is uploaded. -
Title: string
Title:
TitleThe title of the attachment. -
UploadedFileContentType: string
Title:
Uploaded File Content TypeThe content type of the attachment. -
UploadedFileLength: integer
Title:
File SizeThe size of the attachment file. -
UploadedFileName: string
Title:
Uploaded File NameThe name to assign to a new attachment file. -
UploadedText: string
Title:
Uploaded TextThe text content for a new text attachment. -
Uri: string
Title:
UriMaximum Length:4000The URI of a Topology Manager type attachment. -
Url: string
Title:
UrlMaximum Length:4000The URL of a web page type attachment. -
UserName: string
Title:
User NameRead Only:trueMaximum Length:255The login credentials of the user who created the attachment.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : inventoryStagedTransactions-costs-item-response
Type:
Show Source
object-
Cost: number
Cost of the item.
-
CostComponentCode: string
Maximum Length:
30Abbreviation that identifies the cost component. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-dFFs-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
ContextMaximum Length:30Context -
__FLEX_Context_DisplayValue: string
Title:
ContextContext -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-lots-item-response
Type:
Show Source
object-
ErrorCode: string
Maximum Length:
240Abbreviation that identifies the error. -
ExpirationActionCode: string
Maximum Length:
32Abbreviation that identifies the expiration action. -
ExpirationActionDate: string
(date-time)
Date when the expiration action was performed.
-
ExpirationActionName: string
Maximum Length:
80Name of the expiration action. -
GradeCode: string
Maximum Length:
150Abbreviation that identifies the grade. -
HoldDate: string
(date)
Date when the warehouse applied a hold on the lot.
-
LengthUOMName: string
Maximum Length:
25Unit of measure for the lot length. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
lotAttributeDFFs: array
lotAttributeDFFs
-
LotExpirationDate: string
(date)
Date and time when the lot expires.
-
LotLength: number
Length of the lot.
-
LotNumber: string
Maximum Length:
80Lot number for the item. -
lotSerials: array
Lot Serials
Title:
Lot SerialsThe lot serials in staged inventory transactions resource gets lot and serial details for inventory transactions when the item is under both lot and serial control. The details include lot number, serial number, and so on. -
LotSerialSummaries: array
Serial Summaries
Title:
Serial SummariesThe item quantities for organization, subinventory, subinventory and locator, project, and project and task, and the inbound quantities for an organization for items that are enabled for serial control. -
lotStandardDFFs: array
lotStandardDFFs
-
LotThickness: number
Thickness of the lot.
-
LotVolume: number
Volume of the lot.
-
LotWidth: number
Width of the lot.
-
MaturityDate: string
(date)
Date when the lot matures.
-
OriginationDate: string
(date-time)
Date when this lot serial originated.
-
OriginationType: string
Maximum Length:
30Type of origination for the lot. -
ParentLotNumber: string
Maximum Length:
80Number that identifies the parent lot of a lot. -
PrimaryQuantity: number
Transaction quantity in the primary unit of measure that the item uses.
-
ProductCode: string
Maximum Length:
5Abbreviation that identifies the product. -
ProductTransactionId: integer
(int64)
Value that uniquely identifies the product transaction.
-
ReasonCode: string
Maximum Length:
4Abbreviation that identifies the inventory transaction reason. -
ReasonId: integer
(int64)
Value that uniquely identifies the reason.
-
ReasonName: string
Maximum Length:
30Name of the inventory transaction reason. -
RetestDate: string
(date)
Date when the lot is retested.
-
SecondaryTransactionQuantity: number
Transaction quantity of an item in its secondary unit of measure.
-
SerialTransactionTempId: integer
(int64)
Value that uniquely identifies the serial transaction.
-
SourceCode: string
Maximum Length:
30Abbreviation that identifies the source. -
SourceLineId: integer
(int64)
Value that uniquely identifies the source line.
-
StatusCode: string
Maximum Length:
80Abbreviation that identifies the status. -
StatusId: integer
(int64)
Value that uniquely identifies the status.
-
SupplierLotNumber: string
Maximum Length:
150Number that identifies the supplier lot. -
TerritoryShortName: string
Maximum Length:
80Short name of the territory. -
TransactionInterfaceId: integer
(int64)
Value that uniquely identifies the transaction. This attribute is associated with a feature that requires opt in.
-
TransactionQuantity: number
Transaction quantity of the item.
-
VendorName: string
Maximum Length:
240Name of the supplier for the lot. -
VolumeUOMName: string
Maximum Length:
25Unit of measure for the lot volume. -
WidthUOMName: string
Maximum Length:
25Unit of measure for the lot width.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Lot Serials
Type:
arrayTitle:
Lot SerialsThe lot serials in staged inventory transactions resource gets lot and serial details for inventory transactions when the item is under both lot and serial control. The details include lot number, serial number, and so on.
Show Source
Nested Schema : Serial Summaries
Type:
arrayTitle:
Serial SummariesThe item quantities for organization, subinventory, subinventory and locator, project, and project and task, and the inbound quantities for an organization for items that are enabled for serial control.
Show Source
Nested Schema : inventoryStagedTransactions-lots-lotAttributeDFFs-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:30Context Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LotNumber: string
Maximum Length:
80 -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-lots-lotSerials-item-response
Type:
Show Source
object-
ErrorCode: string
Maximum Length:
240Abbreviation that identifies the error. -
FmSerialNumber: string
Maximum Length:
80Starting serial number in a range of serial numbers. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OriginationDate: string
(date)
Date when this lot serial originated.
-
serialAttributeDFFs: array
serialAttributeDFFs
-
SerialQuantity: number
Read Only:
trueValue that indicates the serial quantity for a given interface record. -
serialStandardDFFs: array
serialStandardDFFs
-
SourceCode: string
Maximum Length:
30Abbreviation that identifies the source. -
SourceLineId: integer
(int64)
Value that uniquely identifies the source line.
-
StatusCode: string
Maximum Length:
80Abbreviation that identifies the status. -
StatusId: integer
(int64)
Value that uniquely identifies the status.
-
StatusName: string
Maximum Length:
30Description of the status. -
ToSerialNumber: string
Maximum Length:
80Ending serial number in a range of serial numbers. -
TransactionInterfaceId: integer
(int64)
Value that uniquely identifies the transaction.
-
VendorSerialNumber: string
Maximum Length:
80Supplier serial number corresponding to a serial number for an item.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-lots-lotSerials-serialAttributeDFFs-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:30Context Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
FromSerialNumber: string
Maximum Length:
80 -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-lots-lotSerials-serialStandardDFFs-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:30Context Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
FromSerialNumber: string
Maximum Length:
80 -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-lots-LotSerialSummaries-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Serialscount: number
Read Only:
trueCount of serial controlled item entries for the transaction. -
Serialsquantitysum: number
Read Only:
trueTotal quantity of serial controlled items for the transaction.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-lots-lotStandardDFFs-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:30Context Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LotNumber: string
Maximum Length:
80 -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-LotSummaries-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Lotscount: number
Read Only:
trueCount of lot controlled item entries for the transaction. -
Lotsquantitysum: number
Read Only:
trueTotal quantity of lot controlled items for the transaction.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
objectDiscriminator: __FLEX_Context
Discriminator Values
- AP_Distribution_Sets
- AP_Invoice_Distribution
- AP_Invoice_Line
- EXM_Expense_Report
- EXM_Expense_Report_Line
- INV_Misc_Transactions
- OM_Sales_Order
- PJC_All
- PJC_Expenditure_Batch
- POR_Requisition
- POR_User_Preferences
- PO_Purchase_Order
- PO_Purchase_Order_Line
- PO_Purchase_Order_Schedule
Match One Schema
Show Source
-
AP_Distribution_Sets -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FDistribution__5FSetsVO-item-response
-
AP_Invoice_Distribution -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FInvoice__5FDistributionVO-item-response
-
AP_Invoice_Line -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FInvoice__5FLineVO-item-response
-
EXM_Expense_Report -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFEXM__5FExpense__5FReportVO-item-response
-
EXM_Expense_Report_Line -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response
-
INV_Misc_Transactions -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFINV__5FMisc__5FTransactionsVO-item-response
-
OM_Sales_Order -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFOM__5FSales__5FOrderVO-item-response
-
PJC_All -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPJC__5FAllVO-item-response
-
PJC_Expenditure_Batch -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPJC__5FExpenditure__5FBatchVO-item-response
-
POR_Requisition -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPOR__5FRequisitionVO-item-response
-
POR_User_Preferences -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPOR__5FUser__5FPreferencesVO-item-response
-
PO_Purchase_Order -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrderVO-item-response
-
PO_Purchase_Order_Line -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response
-
PO_Purchase_Order_Schedule -
object
oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FDistribution__5FSetsVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:AP_Distribution_SetsContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FInvoice__5FDistributionVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:AP_Invoice_DistributionContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFAP__5FInvoice__5FLineVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:AP_Invoice_LineContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFEXM__5FExpense__5FReportVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:EXM_Expense_ReportContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:EXM_Expense_Report_LineContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFINV__5FMisc__5FTransactionsVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:INV_Misc_TransactionsContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFOM__5FSales__5FOrderVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:OM_Sales_OrderContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
billableFlag: string
Title:
BillableMaximum Length:1Billable -
billableFlag_Display: string
Title:
BillableBillable -
capitalizableFlag: string
Title:
CapitalizableMaximum Length:1Capitalizable -
capitalizableFlag_Display: string
Title:
CapitalizableCapitalizable -
contractId: integer
(int64)
Title:
Contract NumberContract Number -
contractId_Display: string
Title:
Contract NumberContract Number -
expenditureItemDate: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
expenditureTypeId: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
expenditureTypeId_Display: string
Title:
Expenditure TypeExpenditure Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
organizationId: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
organizationId_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
projectId: integer
(int64)
Title:
Project NumberProject Number -
projectId_Display: string
Title:
Project NumberProject Number -
reservedAttribute1: string
Title:
Funding SourceMaximum Length:150Funding Source -
reservedAttribute1_Display: string
Title:
Funding SourceFunding Source -
taskId: integer
(int64)
Title:
Task NumberTask Number -
taskId_Display: string
Title:
Task NumberTask Number -
TransactionInterfaceId: integer
(int64)
-
workTypeId: integer
(int64)
Title:
Work TypeWork Type -
workTypeId_Display: string
Title:
Work TypeWork Type
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPJC__5FAllVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PJC_AllContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_DisplayValue: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_DisplayValue: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPJC__5FExpenditure__5FBatchVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PJC_Expenditure_BatchContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPOR__5FRequisitionVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:POR_RequisitionContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPOR__5FUser__5FPreferencesVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:POR_User_PreferencesContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrderVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PO_Purchase_OrderContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PO_Purchase_Order_LineContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : oracle_apps_flex_scm_inventory_materialTransactions_pendingTransactions_restModel_stagedInvTxnPJCDFF_view_StagedInvTxnPJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:40Default Value:PO_Purchase_Order_ScheduleContext Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1Billable -
_BILLABLE_FLAG_Display: string
Title:
BillableBillable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum Length:1Capitalizable -
_CAPITALIZABLE_FLAG_Display: string
Title:
CapitalizableCapitalizable -
_CONTRACT_ID: integer
(int64)
Title:
Contract NumberContract Number -
_CONTRACT_ID_Display: string
Title:
Contract NumberContract Number -
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item DateExpenditure Item Date -
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure TypeExpenditure Type -
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure TypeExpenditure Type -
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure OrganizationExpenditure Organization -
_ORGANIZATION_ID_Display: string
Title:
Expenditure OrganizationExpenditure Organization -
_PROJECT_ID: integer
(int64)
Title:
Project NumberProject Number -
_PROJECT_ID_Display: string
Title:
Project NumberProject Number -
_RESERVED_ATTRIBUTE1: string
Title:
Funding SourceMaximum Length:150Funding Source -
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding SourceFunding Source -
_TASK_ID: integer
(int64)
Title:
Task NumberTask Number -
_TASK_ID_Display: string
Title:
Task NumberTask Number -
_WORK_TYPE_ID: integer
(int64)
Title:
Work TypeWork Type -
_WORK_TYPE_ID_Display: string
Title:
Work TypeWork Type -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-serials-item-response
Type:
Show Source
object-
ErrorCode: string
Maximum Length:
240Abbreviation that identifies the error. -
FmSerialNumber: string
Maximum Length:
80Starting serial number in a range of serial numbers. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
OriginationDate: string
(date)
Date when this lot serial originated.
-
serialAttributeDFFs: array
serialAttributeDFFs
-
SerialQuantity: number
Read Only:
trueValue that indicates the serial quantity for a given interface record. -
serialStandardDFFs: array
serialStandardDFFs
-
SourceCode: string
Maximum Length:
30Abbreviation that identifies the source. -
SourceLineId: integer
(int64)
Value that uniquely identifies the source line.
-
StatusCode: string
Maximum Length:
80Abbreviation that identifies the status. -
StatusId: integer
(int64)
Value that uniquely identifies the status.
-
StatusName: string
Maximum Length:
30Description of the status. -
ToSerialNumber: string
Maximum Length:
80Ending serial number in a range of serial numbers. -
TransactionInterfaceId: integer
(int64)
Value that uniquely identifies the transaction.
-
VendorSerialNumber: string
Maximum Length:
80Supplier serial number corresponding to a serial number for an item.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-serials-serialAttributeDFFs-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:30Context Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
FromSerialNumber: string
Maximum Length:
80 -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-serials-serialStandardDFFs-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:30Context Value -
__FLEX_Context_DisplayValue: string
Title:
Context ValueContext Value -
FromSerialNumber: string
Maximum Length:
80 -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-SerialSummaries-item-response
Type:
Show Source
object-
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
Serialscount: number
Read Only:
trueCount of serial controlled item entries for the transaction. -
Serialsquantitysum: number
Read Only:
trueTotal quantity of serial controlled items for the transaction.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : inventoryStagedTransactions-trackingAttributesDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context SegmentMaximum Length:40Context Segment -
__FLEX_Context_DisplayValue: string
Title:
Context SegmentContext Segment -
countryOfOriginCode: string
Title:
Country of OriginMaximum Length:2Country of Origin -
countryOfOriginCode_Display: string
Title:
Country of OriginCountry of Origin -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
projectId: integer
(int64)
Title:
ProjectProject -
projectId_Display: string
Title:
ProjectProject -
taskId: integer
(int64)
Title:
TaskTask -
taskId_Display: string
Title:
TaskTask -
TransactionInterfaceId: integer
(int64)
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Links
- deleteByHeader
-
Delete all transactions for that header.
- performBulkAction
-
Processes or deletes all transactions for a search criteria.
- processByHeader
-
Process all transactions for that header.
Examples
This example describes how to get all transactions.
Example cURL Command
Use the following cURL command to submit a request on the REST resource:
curl -u username:password "https://servername/fscmRestApi/resources/version/inventoryStagedTransactions"
Example Response Body
The following shows an example of the response body in JSON format.
{
"items": [
{
"OrganizationId": 207,
"OrganizationName": "Seven Corporation",
"InventoryItemId": 606,
"ItemNumber": "CM11222",
"ItemDescription": "Battery - Extended Life",
"Revision": null,
"SubinventoryCode": "Stores",
"LocatorId": 799,
"LocatorName": "1.1.1",
...
},
{
"OrganizationId": 207,
"OrganizationName": "Seven Corporation",
"InventoryItemId": 127677,
"ItemNumber": "CR1000",
"ItemDescription": "Cisco Router",
"Revision": null,
"SubinventoryCode": "Stores",
"LocatorId": 799,
"LocatorName": "1.1.1",
...
},
...
],
"count": 23,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/inventoryStagedTransactions",
"name": "inventoryStagedTransactions",
"kind": "collection"
}
]
}