Staged Inventory Transaction Version 2
An object to create inventory transactions.
QName: {http://xmlns.oracle.com/apps/scm/inventory/materialTransactions/pendingTransactions/stagedInventoryTransactionServiceV2/}StagedInventoryTransaction
Logical Business Objects
-
SCM : Inventory Management : Pending Inventory Transaction
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Contains |
|
Contains |
Staged Inventory Transaction Serial Number Only SDO Version 2 |
Contains |
|
Handled by |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
AccountPeriodId |
long |
Accounting period identifier. |
AccountingClass |
string |
Accounting class to be used for the flow schedule. |
AlternateBOMDesignator |
string |
Alternate BOM designator. |
AlternateRoutingDesignator |
string |
Alternate Routing designator. |
AssessableValue |
decimal |
The deemed price at which a product is valued, by a tax authority, for tax calculation purposes. The same product can have more than one assessable value, as given by different tax authorities. |
Attribute1 |
string |
Descriptive flexfield segment. |
Attribute10 |
string |
Descriptive flexfield segment. |
Attribute11 |
string |
Descriptive flexfield segment. |
Attribute12 |
string |
Descriptive flexfield segment. |
Attribute13 |
string |
Descriptive flexfield segment. |
Attribute14 |
string |
Descriptive flexfield segment. |
Attribute15 |
string |
Descriptive flexfield segment. |
Attribute16 |
string |
Descriptive flexfield segment. |
Attribute17 |
string |
Descriptive flexfield segment. |
Attribute18 |
string |
Descriptive flexfield segment. |
Attribute19 |
string |
Descriptive flexfield segment. |
Attribute2 |
string |
Descriptive flexfield segment. |
Attribute20 |
string |
Descriptive flexfield segment. |
Attribute3 |
string |
Descriptive flexfield segment. |
Attribute4 |
string |
Descriptive flexfield segment. |
Attribute5 |
string |
Descriptive flexfield segment. |
Attribute6 |
string |
Descriptive flexfield segment. |
Attribute7 |
string |
Descriptive flexfield segment. |
Attribute8 |
string |
Descriptive flexfield segment. |
Attribute9 |
string |
Descriptive flexfield segment. |
AttributeCategory |
string |
Descriptive flexfield structure definition. |
AttributeDate1 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
AttributeDate2 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
AttributeDate3 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
AttributeDate4 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
AttributeDate5 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Descriptive flexfield segment. |
AttributeNumber1 |
decimal |
Descriptive flexfield segment. |
AttributeNumber10 |
decimal |
Descriptive flexfield segment. |
AttributeNumber2 |
decimal |
Descriptive flexfield segment. |
AttributeNumber3 |
decimal |
Descriptive flexfield segment. |
AttributeNumber4 |
decimal |
Descriptive flexfield segment. |
AttributeNumber5 |
decimal |
Descriptive flexfield segment. |
AttributeNumber6 |
decimal |
Descriptive flexfield segment. |
AttributeNumber7 |
decimal |
Descriptive flexfield segment. |
AttributeNumber8 |
decimal |
Descriptive flexfield segment. |
AttributeNumber9 |
decimal |
Descriptive flexfield segment. |
AttributeTimestamp1 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
AttributeTimestamp2 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
AttributeTimestamp3 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
AttributeTimestamp4 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
AttributeTimestamp5 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Descriptive flexfield segment. |
BOMRevision |
string |
Item revision used for getting the bill information while backflushing the flow schedule. |
BOMRevisionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date of inventory item revision used for exploding the bill for the flow schedule. |
BuildBreakToUOM |
string |
UOM used during standard pack. |
BuildBreakToUnitOfMeasure |
string |
UOM used during standard pack. |
BuildSequence |
decimal |
Specifies the sequence to be built. |
CategoryId |
long |
Tax Category Classification Identifier |
CategoryName |
string |
Tax Category Classification Name. |
CompletionTransactionId |
long |
Completion transaction identifier |
ConsignmentAgreementNumber |
string |
Consignment agreement number for the consigned material. Mostly to be populated if the the Vendor Name, Vendor Number, Procurement Business Unit Name, Vendor Site Code is insufficient to derive the Vendor Site Id (OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID). |
Containers |
decimal |
Number of packing units on a shipment. |
ContentLPNId |
long |
Content license plate number identifier. |
CostTypeId |
long |
Type of organization cost. |
CurrencyCode |
string |
The three-letter ISO code associated with a currency. |
CurrencyConversionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date that determines the conversion rate. |
CurrencyConversionRate |
decimal |
The ratio at which the principal unit of one currency can be converted into another currency. |
CurrencyConversionType |
string |
The source of a currency conversion rate, such as user defined, spot, or corporate. |
CurrencyName |
string |
The three-letter ISO code associated with a currency. |
CustomerShipId |
long |
Customer ship-to address identifier for sales order. |
CycleCountId |
long |
Cycle count identifier. |
DefaultTaxationCountry |
string |
The country where the transaction is deemed to have taken place for taxation purposes. |
DemandClass |
string |
Class associated to the demand. |
DemandId |
long |
Identifier associated with the demand. |
DemandSourceDelivery |
string |
Demand source delivery identifier. |
DemandSourceHeaderId |
long |
Number used to identify the demand document. |
DemandSourceLine |
string |
Numeric identifier associated with the demand document line. |
DepartmentId |
long |
Identifier associated with the WIP department. |
DistributionAccountId |
long |
The account to which transactions using this account alias will be charged. |
DocumentSubType |
string |
A classification used by a tax authority to categorize a document associated with a transaction for a tax. |
DspSegment1 |
string |
Transaction source segment 1. |
DspSegment10 |
string |
Transaction source segment 10. |
DspSegment11 |
string |
Transaction source segment 11. |
DspSegment12 |
string |
Transaction source segment 12. |
DspSegment13 |
string |
Transaction source segment 13. |
DspSegment14 |
string |
Transaction source segment 14. |
DspSegment15 |
string |
Transaction source segment 15. |
DspSegment16 |
string |
Transaction source segment 16. |
DspSegment17 |
string |
Transaction source segment 17. |
DspSegment18 |
string |
Transaction source segment 18. |
DspSegment19 |
string |
Transaction source segment 19. |
DspSegment2 |
string |
Transaction source segment 2. |
DspSegment20 |
string |
Transaction source segment 20. |
DspSegment21 |
string |
Transaction source segment 21. |
DspSegment22 |
string |
Transaction source segment 22. |
DspSegment23 |
string |
Transaction source segment 23. |
DspSegment24 |
string |
Transaction source segment 24. |
DspSegment25 |
string |
Transaction source segment 25. |
DspSegment26 |
string |
Transaction source segment 26. |
DspSegment27 |
string |
Transaction source segment 27. |
DspSegment28 |
string |
Transaction source segment 28. |
DspSegment29 |
string |
Transaction source segment 29. |
DspSegment3 |
string |
Transaction source segment 3. |
DspSegment30 |
string |
Transaction source segment 30. |
DspSegment4 |
string |
Transaction source segment 4. |
DspSegment5 |
string |
Transaction source segment 5. |
DspSegment6 |
string |
Transaction source segment 6. |
DspSegment7 |
string |
Transaction source segment 7. |
DspSegment8 |
string |
Transaction source segment 8. |
DspSegment9 |
string |
Transaction source segment 9. |
DstSegment1 |
string |
Distribution account segment 1. |
DstSegment10 |
string |
Distribution account segment 10. |
DstSegment11 |
string |
Distribution account segment 11. |
DstSegment12 |
string |
Distribution account segment 12. |
DstSegment13 |
string |
Distribution account segment 13. |
DstSegment14 |
string |
Distribution account segment 14. |
DstSegment15 |
string |
Distribution account segment 15. |
DstSegment16 |
string |
Distribution account segment 16. |
DstSegment17 |
string |
Distribution account segment 17. |
DstSegment18 |
string |
Distribution account segment 18. |
DstSegment19 |
string |
Distribution account segment 19. |
DstSegment2 |
string |
Distribution account segment 2. |
DstSegment20 |
string |
Distribution account segment 20. |
DstSegment21 |
string |
Distribution account segment 21. |
DstSegment22 |
string |
Distribution account segment 22. |
DstSegment23 |
string |
Distribution account segment 23. |
DstSegment24 |
string |
Distribution account segment 24. |
DstSegment25 |
string |
Distribution account segment 25. |
DstSegment26 |
string |
Distribution account segment 26. |
DstSegment27 |
string |
Distribution account segment 27. |
DstSegment28 |
string |
Distribution account segment 28. |
DstSegment29 |
string |
Distribution account segment 29. |
DstSegment3 |
string |
Distribution account segment 3. |
DstSegment30 |
string |
Distribution account segment 30. |
DstSegment4 |
string |
Distribution account segment 4. |
DstSegment5 |
string |
Distribution account segment 5. |
DstSegment6 |
string |
Distribution account segment 6. |
DstSegment7 |
string |
Distribution account segment 7. |
DstSegment8 |
string |
Distribution account segment 8. |
DstSegment9 |
string |
Distribution account segment 9. |
EmployeeCode |
string |
Identifier associated with the employee. |
EndItemUnitNumber |
string |
End item unit number. |
ErrorCode |
string |
Indicates that there is a problem associated with the object. |
ErrorExplanation |
string |
Indicates the reason for error. |
ExemptCertificateNumber |
string |
A number associated with the tax certificate issued by the taxing authority. |
ExemptReasonCode |
string |
The code associated with the reason a tax exemption was granted and taken. |
ExpectedArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date the shipment is expected to arrive. |
ExternalSystemPackingUnit |
string |
The license plate number (LPN) of the external/third party Warehouse Management System |
FinalCompletionFlag |
boolean |
Indicates if job costs must be flushed out for this Job completion. |
FinalDischargeLocCode |
string |
The final destination location for the purchases made by the customer. The location of the final customer or where the goods would be used is not necessarily the same as the initial ship-to location. |
FinalDischargeLocationId |
long |
Final Discharge Location Identifier |
FirstPtyNumber |
string |
The number of an internal party that can enter into business relationships. |
FirstPtyRegId |
long |
A unique sequence of letters and/or numbers assigned to a first party, by a tax authority, when it is registered and by which the first party registration will be identified. |
FlowSchedule |
string |
Specifies whether the WIP transaction is a flow or schedule type transaction. |
FreightCarrierId |
long |
A company that transports goods from one point to another by land, sea, or air. |
FromProjectId |
long |
From project identifier. |
FromTaskId |
long |
From task identifier. |
IntendedUse |
string |
A tax classification based on the purpose for which a product is used. |
IntendedUseClassifId |
long |
Indicates the source for the intended use fiscal classification codes. The codes can either be maintained directly (non-inventory based), or based on an inventory category set (inventory based). |
InventoryItem |
string |
Any part, material, product or service that is unique as compared with other items by nature of its attributes. |
InventoryItemId |
long |
Any part, material, product or service that is unique as compared with other items by nature of its attributes. |
ItemNumber |
string |
Any part, material, product or service that is unique as compared with other items by nature of its attributes. |
KanbanCardId |
long |
Kanban card identifier. |
LPNId |
long |
License plate number identifier. |
LineItemNumber |
decimal |
Line item number for purchase order. |
LoadRequestId |
long |
Used by Enterprise Service Scheduler to indicate the request ID of the Interface load job that created the row. |
LocSegment1 |
string |
Locator segment 1. |
LocSegment10 |
string |
Locator segment 10. |
LocSegment11 |
string |
Locator segment 11. |
LocSegment12 |
string |
Locator segment 12. |
LocSegment13 |
string |
Locator segment 13. |
LocSegment14 |
string |
Locator segment 14. |
LocSegment15 |
string |
Locator segment 15. |
LocSegment16 |
string |
Locator segment 16. |
LocSegment17 |
string |
Locator segment 17. |
LocSegment18 |
string |
Locator segment 18. |
LocSegment19 |
string |
Locator segment 19. |
LocSegment2 |
string |
Locator segment 2. |
LocSegment20 |
string |
Locator segment 20. |
LocSegment3 |
string |
Locator segment 3. |
LocSegment4 |
string |
Locator segment 4. |
LocSegment5 |
string |
Locator segment 5. |
LocSegment6 |
string |
Locator segment 6. |
LocSegment7 |
string |
Locator segment 7. |
LocSegment8 |
string |
Locator segment 8. |
LocSegment9 |
string |
Locator segment 9. |
LocationType |
string |
Unique identifier for ship-to location. |
LocatorId |
long |
Physical area within a subinventory, such as a row, aisle, bin, or shelf, where you store material. |
LocatorName |
string |
Physical area within a subinventory, such as a row, aisle, bin, or shelf, where you store material. |
LockCode |
string |
Indicates if the transaction is locked for further processing. |
LotExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when an asset becomes obsolete or unserviceable. |
LotNumber |
string |
A quantity of items that are produced together and that share the same production costs and specifications. |
MRPCode |
decimal |
Indicates whether MRP should be relieved for WIP. |
MoveTransactionId |
long |
Move transaction identifier. |
MovementId |
long |
Movement statistics cross reference. |
NegativeRequisitionCode |
decimal |
Negative requirement code. |
NewAverageCost |
decimal |
New average cost used for average cost update. |
OperationSequenceNumber |
decimal |
Operation sequence number within a routing. |
OrganizationId |
long |
An organizing unit in the internal or external structure of an enterprise, representing a physical structure, such as a warehouse. |
OrganizationName |
string |
An organizing unit in the internal or external structure of an enterprise, representing a physical structure, such as a warehouse. |
OrganizationType |
string |
Type of organization. |
OvercompletionPrimaryQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Over completion quantity. |
OvercompletionTransactionId |
long |
Over completion transaction identifier. |
OvercompletionTransactionQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Over completion transaction quantity. |
OwningOrganizationId |
long |
Owning organization identifier. Refers to the supplier site id when OWNING_TP_TYPE is 1 and inventory organization id when OWNING_TP_TYPE is 2 |
OwningOrganizationName |
string |
Owning Organization Name. Stores supplier site code when OWNING_TP_TYPE is 1 and inventory organization name in INV_ORGANIZATION_DEFINITIONS_V when OWNING_TP_TYPE is 2 |
OwningTpType |
string |
Owning Trading Partner Type. The values are based on INV_OWNING_TYPES lookup. 1- Consigned Material, 2- Owned Material |
ParentId |
long |
Indicates the parent completion record's transaction interface identifier. |
PercentageChange |
decimal |
Percentage change for average cost update. |
PhysicalAdjustmentId |
long |
Physical inventory adjustment identifier. |
PickingLineId |
long |
Reservation picking line identifier. |
PjcBillableFlag |
boolean |
Indicates if a project-related item is available to be billed to customers. |
PjcCapitalizableFlag |
boolean |
Indicates if a project-related item is eligible for capitalization. |
PjcContextCategory |
string |
Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. |
PjcContractId |
decimal |
Contract identifier. |
PjcContractLineId |
decimal |
Tracks contract line information. |
PjcExpenditureItemDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date on which a project-related transaction is incurred. |
PjcExpenditureTypeId |
decimal |
Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
PjcFundingAllocationId |
decimal |
Specifies the name of the project funding override. |
PjcOrganizationId |
decimal |
Identifier of expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
PjcProjectId |
decimal |
Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. |
PjcReservedAttribute1 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute10 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute2 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute3 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute4 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute5 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute6 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute7 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute8 |
string |
Reserved for future project-related functionality. |
PjcReservedAttribute9 |
string |
Reserved for future project-related functionality. |
PjcTaskId |
decimal |
Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. |
PjcUserDefAttribute1 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute10 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute2 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute3 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute4 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute5 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute6 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute7 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute8 |
string |
Reserved for future project-related functionality. |
PjcUserDefAttribute9 |
string |
Reserved for future project-related functionality. |
PjcWorkTypeId |
decimal |
Tracks contract line information. |
PlanningOrganizationId |
long |
Planning organization identifier |
PlanningTpType |
string |
Type of planning trading partner. |
PrcBUName |
string |
Procurement Business Unit Name in case the material transacted is consigned. This is required for deriving OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID for the consigned material. |
PrimaryQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity of an item expressed in its primary unit of measure. |
PrimaryQuantityUOM |
string |
UOM associated with the primary quantity. |
PrimarySwitch |
decimal |
Indicates whether the inventory item is a primary assembly for WIP. |
ProcessCode |
string |
Indicates the processing status of the transaction. |
ProductCategory |
string |
A type of product fiscal classification used to classify products. Related term(s): product fiscal classification. |
ProductType |
string |
The nature or the product involved in a taxable transaction. For example, goods or services. |
ProjectId |
decimal |
Project identifier. |
QACollectionId |
long |
QA results identifier. |
RMALineId |
long |
RMA line identifier. |
RcvTransactionId |
long |
Receiving transaction identifier. |
ReasonId |
long |
Transaction reason identifier. |
ReasonName |
string |
Reason for the inventory transaction. |
RebuildActivityId |
long |
Maintenance activity that needs to be done on rebuildable items. |
RebuildItemId |
long |
Rebuildable item that needs to be replaced or repaired. |
RebuildJobName |
string |
Name of rebuild work order that has been defined for rebuildable items. |
RebuildSerialNumber |
string |
Serial number of the rebuildable item. |
ReceivingDocument |
string |
Receiving document identifier. |
RelieveHighLevelRsvFlag |
boolean |
Indicates whether to check for high level reservations that need to be relieved during transaction processing. |
RelieveReservationsFlag |
boolean |
Indicates whether to relieve the reservations during transaction processing. |
RepetitiveLineId |
long |
Repetitive line identifier. |
RepresentativeLotNumber |
string |
Representative lot. |
RequiredFlag |
boolean |
Required flag. |
RequisitionDistributionId |
long |
Identifier associated with the requisition distribution. |
RequisitionLineId |
long |
Line number of the requested item. A requisition can include multiple requested items each identified by a line number. |
ReservationQTYUOM |
string |
UOM associated with the reserved quantity. |
ReservationQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Reserved quantity associated with the item. |
Revision |
string |
Identifies the revision of an item. |
RoutingRevision |
string |
Routing revision used for getting the routing information while charging the flow schedule. |
RoutingRevisionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date of item routing revision used for exploding the routing for the flow schedule. |
ScheduleGroup |
decimal |
Specifies the schedule group. |
ScheduleId |
long |
WIP repetitive schedule identifier. |
ScheduleNumber |
string |
Flow schedule number. |
ScheduleUpdateCode |
decimal |
Indicates whether or not to update the master production schedule. |
ScheduledCode |
decimal |
Specifies whether flow schedule is scheduled or not. |
ScheduledPaybackDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Need clarification on this. |
SecondaryTransactionQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Transaction quantity of an item expressed in its secondary unit of measure. |
SecondaryUOMCode |
string |
A unit of measure that does not have a fixed conversion from the primary UOM. Also, part of 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 name. |
SerialNumber |
string |
A unique number assigned for identification to a single piece that will never be repeated for similar pieces. |
SetupTeardownCode |
decimal |
Set up teardown code. |
ShipFromLocationId |
long |
A location that is designated as the place where goods are to be shipped. |
ShipToLocationId |
long |
Unique identifier for the ship-to location. |
ShipmentNumber |
string |
A separately identifiable collection of goods or materials to be carried under the terms of a single bill of lading. |
ShippableFlag |
boolean |
Indicates if the item is shippable. |
ShippedQTYUOM |
string |
UOM associated with the shipped quantity. |
ShippedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Shipped quantity associated the item. |
SourceCode |
string |
Transaction source identifier. |
SourceHeaderId |
long |
Transaction source group identifier. |
SourceLineId |
long |
Transaction source line identifier. |
SourceLotNumber |
string |
Indicates the source lot. |
StagedInventoryTransactionCost |
Staged Inventory Transaction Cost SDO. |
|
StagedInventoryTransactionLot |
Staged Inventory Transaction Lot SDO. |
|
StagedInventoryTransactionSerial |
Staged Inventory Transaction Serial Number Only SDO. |
|
SubinventoryCode |
string |
Defines a physical or logical separation of material within an organization. |
SubstitutionItemId |
long |
Substitution item's inventory item. |
SubstitutionTypeId |
long |
Identifies the kind of substitution allowed. |
TaskId |
decimal |
Task identifier. |
TaxClassificationCode |
string |
A code for the tax classification, a grouping of taxes for reporting and processing purposes. |
TaxInvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date of the tax invoice used to meet specific tax reporting requirements of different countries. |
TaxInvoiceNumber |
string |
The number of the tax invoice used to meet specific tax reporting requirements of different countries. |
ThirdPartyTypeCode |
string |
A classification code used to categorize a party. For example, organization, individual, group, or relationship. |
ThirdPtyNumber |
string |
The number of an additional party to the internal party and the external party, that participates in a business relationship. |
ThirdPtyRegId |
long |
A unique sequence of letters and/or numbers assigned to a third party or third party site, by a tax authority, when it is registered and by which the party or party site registration will be identified. |
ThirdPtySiteNumber |
string |
The number of the logical or physical establishment of a third party at a given location. |
ToProjectId |
long |
To project identifier. |
ToTaskId |
long |
To task identifier. |
TransactionActionId |
string |
Transaction action identifier. |
TransactionActionName |
string |
The transaction action associated with the transaction type. |
TransactionBatchId |
long |
Transaction batch identifier. |
TransactionBatchSequence |
long |
Transaction batch sequence. |
TransactionCost |
decimal |
Transaction cost. |
TransactionCostIdentifier |
string |
Transaction cost identifier |
TransactionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date the transaction occurred. |
TransactionGroupId |
long |
Transaction group identifier. |
TransactionGroupSequence |
decimal |
Sequence number in a transaction group. |
TransactionHeaderId |
long |
Transaction group identifier. |
TransactionInterfaceId |
long |
Transaction interface line identifier.
|
TransactionMode |
string |
The mode associated with the transaction. |
TransactionQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity of an item transacted in the transaction UOM. |
TransactionReference |
string |
Transaction reference. |
TransactionSequenceId |
long |
Transaction sequence identifier. |
TransactionSourceId |
long |
Transaction source identifier. |
TransactionSourceName |
string |
Indicates the source of the transaction. |
TransactionSourceTypeId |
long |
Transaction source type identifier. |
TransactionSourceTypeName |
string |
Name of the transaction source type. |
TransactionTypeId |
long |
Transaction type identifier. |
TransactionTypeName |
string |
Name of the transaction type. |
TransactionUOM |
string |
UOM associated with the transaction. |
TransactionUnitOfMeasure |
string |
Transaction unit of measure name. |
TransferCost |
decimal |
The total value, in functional currency, that should be added as transfer charge in the destination organization. |
TransferLPNId |
long |
Transfer license plate number identifier. |
TransferLocator |
long |
Locator where the material is transferred. |
TransferLocatorName |
string |
Physical area within a subinventory, such as a row, aisle, bin, or shelf, where you store material. |
TransferOrganization |
long |
Organization where the material is transferred. |
TransferOrganizationName |
string |
The organization where the material is transferred. |
TransferOrganizationType |
string |
Type of transfer organization. |
TransferOwningTpType |
string |
Transfer Owning Trading Partner Type. The values are based on INV_OWNING_TYPES lookup. 1- Consigned Material, 2- Owned Material. |
TransferPercentage |
decimal |
Indicates the percentage of value to be attributed to transfer costs in an interorganization transfer. |
TransferPlanningTpType |
string |
Type of transfer planning trading partner. |
TransferPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Transfer price. |
TransferSubinventory |
string |
Subinventory where the material is transferred. |
TransportationAccount |
decimal |
Transportation account identifier. |
TransportationCost |
decimal |
Transportation cost associated with the transaction. |
TrxBusinessCategory |
string |
A business classification used by Oracle Fusion Tax to identify and categorize an external transaction into a Fusion Tax transaction. |
TrxSourceDeliveryId |
long |
Shipment identifier for sales order. |
TrxSourceLineId |
long |
Line identifier for sales order. |
USSGLTransactionCode |
string |
USSGL transaction code. |
UseCurrentCost |
string |
Indicates whether the current item cost will be used or if the cost will be entered by item cost component. Y - Yes signifies current cost will be used. N - No signifies item cost will be entered in the nested cost payload. |
UserDefinedFiscClass |
string |
A classification for any tax requirement that you cannot define using the existing fiscal classification types. |
ValidationRequired |
decimal |
Indicates if validation is required. |
ValueChange |
decimal |
Value change used for average cost update. |
VendorLotNumber |
string |
Lot assigned to the item by the supplier. |
VendorName |
string |
Vendor name in case the material transacted is consigned. This is required for deriving OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID for the consigned material. |
VendorNumber |
string |
Vendor number in case the material transacted is consigned. This is required for deriving OWNING_ORGANIZATION_ID/ XFR_OWNING_ORGANIZATION_ID for the consigned material. |
WIPEntityType |
decimal |
Type of WIP entity. |
WIPSupplyType |
decimal |
WIP supply type. |
WaybillAirbill |
string |
Non-negotiable document describing the contract for transporting cargo. |
XferLocSegment1 |
string |
Transfer locator segment 1. |
XferLocSegment10 |
string |
Transfer locator segment 10. |
XferLocSegment11 |
string |
Transfer locator segment 11. |
XferLocSegment12 |
string |
Transfer locator segment 12. |
XferLocSegment13 |
string |
Transfer locator segment 13. |
XferLocSegment14 |
string |
Transfer locator segment 14. |
XferLocSegment15 |
string |
Transfer locator segment 15. |
XferLocSegment16 |
string |
Transfer locator segment 16. |
XferLocSegment17 |
string |
Transfer locator segment 17. |
XferLocSegment18 |
string |
Transfer locator segment 18. |
XferLocSegment19 |
string |
Transfer locator segment 19. |
XferLocSegment2 |
string |
Transfer locator segment 2. |
XferLocSegment20 |
string |
Transfer locator segment 20. |
XferLocSegment3 |
string |
Transfer locator segment 3. |
XferLocSegment4 |
string |
Transfer locator segment 4. |
XferLocSegment5 |
string |
Transfer locator segment 5. |
XferLocSegment6 |
string |
Transfer locator segment 6. |
XferLocSegment7 |
string |
Transfer locator segment 7. |
XferLocSegment8 |
string |
Transfer locator segment 8. |
XferLocSegment9 |
string |
Transfer locator segment 9. |
XfrOwningOrganizationId |
long |
Transfer owning organization identifier. Refers to the supplier site id when TRANSFER_OWNING_TP_TYPE is 1 and inventory organization id when TRANSFER_OWNING_TP_TYPE is 2 |
XfrOwningOrganizationName |
string |
Transfer Owning Organization Name. Stores supplier site code when TRANSFER_OWNING_TP_TYPE is 1 and inventory organization name in INV_ORGANIZATION_DEFINITIONS_V when TRANSFER_OWNING_TP_TYPE is 2. |
XfrPlanningOrganizationId |
long |
Transfer planning organization identifier. |
XmlDocumentId |
string |
XML document identifier. |