Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au
Object: AQB__Inventory__c
- praveen.sampath
Analytics
Fields
Name | Label | Type | Description |
|---|---|---|---|
Id | Record ID | ID |
|
OwnerId | Owner ID | LOOKUP |
|
IsDeleted | Deleted | CHECKBOX |
|
Name | Item Name | TEXT(80) |
|
CreatedDate | Created Date | DATETIME |
|
CreatedById | Created By ID | LOOKUP |
|
LastModifiedDate | Last Modified Date | DATETIME |
|
LastModifiedById | Last Modified By ID | LOOKUP |
|
SystemModstamp | System Modstamp | DATETIME |
|
LastActivityDate | Last Activity Date | DATE |
|
LastViewedDate | Last Viewed Date | DATETIME |
|
LastReferencedDate | Last Referenced Date | DATETIME |
|
AQB__AcquisitionCost__c | Acquisition Cost | CURRENCY(9,2) | The purchase price of the items. |
AQB__DivisionUnit__c | Division/Unit | PICKLIST |
|
AQB__FairMarketValue__c | Fair Market Value | CURRENCY(9,2) | The market value of the items. |
AQB__LowInventoryWarning__c | Low Inventory Warning | NUMBER(6,0) | This defines the point at which the system will indicate that the inventory of this item is low. Institution defined. |
AQB__NumberonHand__c | Number on Hand | NUMBER(6,0) | A count of the number of units of this item that are currently available. Once the starting number has been entered, the system will decrement this number automatically when Quid Pro Quo records indicate that the item has been sent to a donor. |
AQB__OwnerUnit__c | Owner Unit | PICKLIST | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
AQB__SalesCost__c | Sales Cost | CURRENCY(9,2) | If the item is to be sold, this is the purchase price of one unit. |
AQB__Type__c | Type | PICKLIST |
|
aqcv_conversionid__c | aqcv conversionid | TEXT(255) | Unique id |
Triggers
Name | Label |
|---|---|
InventoryTrigger | AQB.InventoryTrigger |
Fields Details
Name | Id |
Label | Record ID |
Type | ID |
Required | Yes |
Name | OwnerId |
Label | Owner ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Item Name |
Type | TEXT(80) |
Name | CreatedDate |
Label | Created Date |
Type | DATETIME |
Required | Yes |
Name | CreatedById |
Label | Created By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | LastModifiedDate |
Label | Last Modified Date |
Type | DATETIME |
Required | Yes |
Name | LastModifiedById |
Label | Last Modified By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | SystemModstamp |
Label | System Modstamp |
Type | DATETIME |
Required | Yes |
Name | LastActivityDate |
Label | Last Activity Date |
Type | DATE |
Name | LastViewedDate |
Label | Last Viewed Date |
Type | DATETIME |
Name | LastReferencedDate |
Label | Last Referenced Date |
Type | DATETIME |
Name | AQB__AcquisitionCost__c |
Label | Acquisition Cost |
Type | CURRENCY(9,2) |
Help Text | The purchase price of the items. |
Description | The purchase price of the items. |
Name | AQB__DivisionUnit__c |
Label | Division/Unit |
Type | PICKLIST |
Help Text | The Division or Unit that purchased or owns this inventory item. |
Picklist values | Division One |
Name | AQB__FairMarketValue__c |
Label | Fair Market Value |
Type | CURRENCY(9,2) |
Required | Yes |
Help Text | The market value of the items. |
Description | The market value of the items. |
Name | AQB__LowInventoryWarning__c |
Label | Low Inventory Warning |
Type | NUMBER(6,0) |
Help Text | This defines the point at which the system will indicate that the inventory of this item is low. Institution defined. |
Description | This defines the point at which the system will indicate that the inventory of this item is low. Institution defined. |
Name | AQB__NumberonHand__c |
Label | Number on Hand |
Type | NUMBER(6,0) |
Help Text | A count of the number of units of this item that are currently available. Once the starting number has been entered, the system will decrement this number automatically when Quid Pro Quo records indicate that the item has been sent to a donor. |
Description | A count of the number of units of this item that are currently available. Once the starting number has been entered, the system will decrement this number automatically when Quid Pro Quo records indicate that the item has been sent to a donor. |
Name | AQB__OwnerUnit__c |
Label | Owner Unit |
Type | PICKLIST |
Help Text | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
Picklist values | Advancement Services |
Description | Designates the Unit of the User that created this record. This field is intended for use in creating Sharing Rules for the purpose of controlling access to the record. |
Name | AQB__SalesCost__c |
Label | Sales Cost |
Type | CURRENCY(9,2) |
Help Text | If the item is to be sold, this is the purchase price of one unit. |
Description | If the item is to be sold, this is the purchase price of one unit. |
Name | AQB__Type__c |
Label | Type |
Type | PICKLIST |
Help Text | Indicates if this inventory item is utilized as a Quid Pro Quo item, Thank You Token, or both. |
Picklist values | Quid Pro Quo |
Name | aqcv_conversionid__c |
Label | aqcv conversionid |
Type | TEXT(255) |
Unique | Yes |
Description | Unique id |