TransactionReason
A transaction reason classifies the cause for an inventory transaction. For example, a backorder during pick confirmation or a cycle-count adjustment during cycle counting.
Label, Plural Label
Transaction Reason, Transaction Reasons
Qualified Label, Qualified Plural Label
Inventory Transaction Reason, Inventory Transaction Reasons
Module
oraScmCoreInventorySetup
Keys
-
$primary: id (default)
Fields
* Field can't be null- contextCode (enumeration: TransactionReasonContext)
Code that identifies which context of a transaction flow can use this transaction reason, for example, change project or task for pick flow.
Label
Context Code
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: TransactionReasonContext
Properties
- creatable
- updatable
Valid Values
- PLT
- PPT
- PQ
- PQB
- PQC
- PQS
- PSL
-
- createdBy (string)*
The user who created the record.
Label
Created By
Properties
- not readable
- not nullable
- description (string)
Description of the transaction reason.
Label
Description
Properties
- creatable
- translatable
- updatable
- disableDate (date)
Date when the inventory transaction reason is no longer valid.
Label
End Date
Properties
- creatable
- searchable
- sortable
- updatable
- enableDate (date)*
Date when the inventory transaction reason can be used.
Label
Start Date
Properties
- creatable
- searchable
- sortable
- not nullable
- id (int64)*
Value that uniquely identifies the transaction reason.
Label
ID
Properties
- searchable
- sortable
- not nullable
- name (string)*
Name of the transaction reason. A list of accepted values is defined in the lookup type INV_REASON_TYPES in FND_LOOKUPS.
Label
Name
Properties
- creatable
- translatable
- not nullable
- updatable
- timeCreated (date-time)*
The date and time when the record was created.
Label
Creation Date
Properties
- sortable
- not nullable
- timeUpdated (date-time)*
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- typeCode (enumeration: TransactionReasonType)
Type of the transaction reason.
Label
Type Code
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: TransactionReasonType
Properties
- creatable
- updatable
Valid Values
- 1
- 3
- 4
- 5
- 6
- 7
- 8
- 9
-
- updatedBy (string)*
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- $sourceLang (string)*
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.
Label
Source Language
Properties
- translatable
- not nullable
- $translations (object-collection)*
Code that identifies the language into which the contents of the translatable columns are translated.
Label
Translations
Cardinality Target Object One to many - Module: oraScmCoreInventorySetup
- Business Object: TransactionReasonTranslation
Additional Mapping Details
Mapped by relationship: transactionReason
Business Views
** Available for extracting data- default
Data Source
RDBMS
Fields
- description (string)
Description of the transaction reason.
Label
Description
Properties
- creatable
- translatable
- updatable
- id (int64)
Value that uniquely identifies the transaction reason.
Label
ID
Properties
- searchable
- sortable
- not nullable
- name (string)
Name of the transaction reason. A list of accepted values is defined in the lookup type INV_REASON_TYPES in FND_LOOKUPS.
Label
Name
Properties
- creatable
- translatable
- not nullable
- updatable
- description (string)
- transactionReasonsExtract**
A transaction reason classifies the cause for an inventory transaction. For example, a backorder during pick confirmation or a cycle-count adjustment during cycle counting.
Label
Inventory Transaction Reasons
Data Source
Read-optimized data store
Fields
- contextCode (enumeration: TransactionReasonContext)
Code that identifies which context of a transaction flow can use this transaction reason, for example, change project or task for pick flow.
Label
Context Code
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: TransactionReasonContext
Properties
- creatable
- updatable
Valid Values
- PLT
- PPT
- PQ
- PQB
- PQC
- PQS
- PSL
-
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not readable
- not nullable
- description (string)
Description of the transaction reason.
Label
Description
Properties
- creatable
- translatable
- updatable
- disableDate (date)
Date when the inventory transaction reason is no longer valid.
Label
End Date
Properties
- creatable
- searchable
- sortable
- updatable
- enableDate (date)
Date when the inventory transaction reason can be used.
Label
Start Date
Properties
- creatable
- searchable
- sortable
- not nullable
- id (int64)
Value that uniquely identifies the transaction reason.
Label
ID
Properties
- searchable
- sortable
- not nullable
- name (string)
Name of the transaction reason. A list of accepted values is defined in the lookup type INV_REASON_TYPES in FND_LOOKUPS.
Label
Name
Properties
- creatable
- translatable
- not nullable
- updatable
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- sortable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- sortable
- not nullable
- typeCode (enumeration: TransactionReasonType)
Type of the transaction reason.
Label
Type Code
Type
-
Module: oraScmCoreInventorySetup
-
Enumeration Type: TransactionReasonType
Properties
- creatable
- updatable
Valid Values
- 1
- 3
- 4
- 5
- 6
- 7
- 8
- 9
-
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
- contextCode (enumeration: TransactionReasonContext)
Other Properties
| Property | Value |
|---|---|
| Application Package Name | ora_scm_core_inventorySetup |
| Extensible | Yes |