Assets
Usage information for the operation Assets.rsd.
Columns
| Name | Type | ReadOnly | References | Description |
| AssetId [KEY] | Long | False |
The unique identifier of the Asset. | |
| AssetAmount | Decimal | False |
The cost amount of the asset in the transaction currency. | |
| AssetDescription | String | False |
The description field of the asset. | |
| AssetGroup | String | False |
The name of the asset group. | |
| AssetName | String | False |
The name that describes the asset. | |
| AssetNumber | String | False |
The number that identifies the asset. | |
| AssetOrigSystem | String | False |
A source system code that identifies the original source system of the asset | |
| AssetOrigSystemReference | String | False |
A source system reference that identifies the unique ID of the asset in user's legacy or external system. | |
| AssetTag | String | False |
The tag number associated with the asset. | |
| AttributeCategory | String | False |
Standard column used in Fusion tables. | |
| BatchId | Long | False |
The batch ID for importing process. | |
| CompetitiveAsset | String | False |
Indicates if the asset belongs to a competitor. | |
| CorpCurrencyCode | String | False |
Corporate currency code | |
| CreatedBy | String | False |
The user who created the record or imported the record. | |
| CreationDate | Datetime | False |
The time stamp when the record was created. | |
| CrmConvRate | String | False |
CRM Currency convert rate | |
| CurcyConvRateType | String | False |
Currency convert rate type | |
| CustomerId | Long | False |
The unique ID for the existing customer party record in the Oracle Fusion destination table. | |
| CustomerPartyNumber | String | False | ||
| DeleteFlag | Bool | False |
Delete Flag for soft deletes, Y for Yes and NULL or N for No | |
| Description | String | False |
Asset item description | |
| EndDate | Date | False |
The date when the asset ends. | |
| EnteredCurrencyCode | String | False |
The code that represents the currency for the asset amounts. | |
| IBAssetId | Long | False |
Unique ID of the associated Install Base asset record. | |
| IBAssetSyncedVersionNumber | Int | False |
Last synced Version Number of the Install Base Asset | |
| InstallDate | Date | False |
The date the asset was installed. | |
| InterfaceRowId | Long | False |
The interface table row's unique ID. | |
| InventoryItemId | Long | False |
The unique ID for the existing sales catalog product (item) record in the Oracle Fusion destination table. | |
| InventoryOrgId | Long | False |
Item Organization Id as created by Fusion CRM | |
| ItemNumber | String | False |
Item Number | |
| LastUpdateDate | Datetime | False |
The time stamp when the record was last updated. | |
| LastUpdateLogin | String | False |
The ID of the user who last updated the record in the interface table or submitted the import process. | |
| LastUpdatedBy | String | False |
The session sign in of the user that last updated the row. | |
| Manufacturer | String | False |
The name of the manufacturer. | |
| Model | String | False |
The name of the model. | |
| OrganizationId | Long | False |
Organization ID | |
| PartyType | String | False | ||
| PartyUniqueName | String | False | ||
| PrContactPartyId | Long | False |
The party identifier of the asset's primary contact. | |
| PrContactPartyNumber | String | False | ||
| ProdGroupId | Long | False |
Product Group ID in sales catalog | |
| ProdGroupName | String | False |
Product Group Name | |
| ProdGroupReferenceNumber | String | False | ||
| Product | String | False |
The name of the product. | |
| ProductType | String | False | ||
| PurchaseDate | Date | False |
The date the asset was purchased. | |
| Quantity | Decimal | False |
The quantity purchased. | |
| ResourceOwnerId | Long | False |
The identifier of the asset's resource owner. | |
| ResourceOwnerPartyNumber | String | False | ||
| SearchFilter | String | False | ||
| SerialNumber | String | False |
The asset's serial number. | |
| StartDate | Date | False |
The date when the asset starts. | |
| StatusCode | String | False |
The lookup code that represents the asset status, such as active or expired. | |
| UOMCode | String | False |
Unit of Measure | |
| Version | String | False |
The version of the asset product. | |
| Year | String | False |
The year of manufacture or the nominal model year of the asset product. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |
| PartyId | String |
The unique identifier of the party used to find the account by hierarchy. |
| PartyIdAttribute | String |
The unique identifier attribute name of the party used to find the account by hierarchy. |
| AttributeName | String |
The rollup attribute name to find a rollups. |
| RollupId | String |
The unique identifier of a rollup used to find the rollup. |
| SourceObject | String |
The source object code used to find the rollup. |
| SourceObjectId | String |
The source object identifier of the party associated with the rollup. |