PhysicalInventories
The Physical Inventories resource manages operations on physical inventories.
Columns
| Name | Type | Description |
| OrganizationId | String | Value that uniquely identifies the organization. |
| OrganizationCode | String | Abbreviation that identifies the organization. |
| PhysicalInventoryId | String | Value that uniquely identifies the physical inventory. |
| PhysicalInventoryName | String | Name of the physical inventory. |
| Description | String | Description of the physical inventory. |
| PhysicalInventoryDate | Date | Date when the person physically counted the inventory. |
| FreezeDate | Datetime | Date when the application no longer allows changes to inventory. |
| ApprovalRequiredCode | String | Value that indicates the level of approval required to post physical inventory adjustments. A list of accepted values is defined in the lookup type INV_REQ_APPROVALS. This attribute does not have a default value. |
| ApprovalRequired | String | Value that indicates the level of approval required to post the physical inventory adjustments. A list of accepted values is defined in the lookup type INV_REQ_APPROVALS. This attribute does not have a default value. |
| ApprovalTolerancePositive | String | Percent above the on-hand quantity that the adjustment transaction can vary. If the adjustment transaction exceeds the percent, then the adjustment transaction requires approval. For example, if Positive Quantity Tolerance Percentage is 10, and if the adjustment transaction requires an 11% positive adjustment to on-hand quantity, then the transaction requires approval. |
| ApprovalToleranceNegative | String | Percent below the on-hand quantity that the adjustment transaction can vary. If the adjustment transaction exceeds the percent, then the adjustment transaction requires approval. For example, if Negative Quantity Tolerance Percentage is 10, and if the adjustment transaction requires an 11% negative adjustment to on-hand quantity, then the transaction requires approval. |
| CostVariancePositive | String | Total value of a physical inventory adjustment that is greater than the current value of the item. The user specifies this limit. |
| CostVarianceNegative | String | Total value of a physical inventory adjustment that is less than the current value of the item. The user specifies this limit. |
| AllowAllSubinventoriesCode | String | Value that indicates all or specific subinventories included in the physical inventory. A list of accepted values is defined in the lookup type INV_SUBINVENTORIES_FLAG. The default value is 1. |
| AllowAllSubinventories | String | Value that indicates whether all or specific subinventories must be included in the physical inventory. A list of accepted values is defined in the lookup type INV_SUBINVENTORIES_FLAG. The default value is All. |
| NextTagNumber | String | Next tag number in the sequence of tag numbers that the application creates for this physical inventory. |
| AllowDynamicTagsCode | String | Value that indicates if the dynamic tag creation is permitted in the physical Inventory. Contains one of the following values: 1 or 2. If 1, then dynamic tag creation is permitted. If 2, then dynamic tag creation is not permitted. This attribute does not have a default value. |
| AllowDynamicTags | String | Value that indicates if the dynamic tag creation is permitted in the physical inventory. Contains one of the following values: Yes or No. If Yes, then dynamic tag creation is permitted. If No, then dynamic tag creation is not permitted. This attribute does not have a default value. |
| ExcludeZeroBalanceCode | String | Value that indicates that items with zero on-hand balances are excluded from physical counts. Contains one of the following values: Y or N. If Y, then items with negative on-hand balances are excluded from physical count. If N, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value. |
| ExcludeZeroBalance | String | Value that indicates that items with zero on-hand balances are excluded from physical counts. Contains one of the following values: Yes or No. If Yes, then items with negative on-hand balances are excluded from physical count. If No, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value. |
| ExcludeNegativeBalanceCode | String | Value that indicates that items with negative on-hand balances are excluded from physical counts. Contains one of the following values: Y or N. If Y, then items with negative on-hand balances are excluded from physical count. If N, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value. |
| ExcludeNegativeBalance | String | Value that indicates if the items with negative on-hand balances are excluded from physical counts. Contains one of the following values: Yes or No. If Yes, then items with negative on-hand balances are excluded from physical count. If No, then items with negative on-hand balances are not excluded from physical count. This attribute does not have a default value. |
| TagTypeCode | String | Value that indicates the types of physical inventory tags generated when the generate tags action is started. A list of accepted values is defined in the lookup type INV_GENERATE_TAG_TYPE. This attribute does not have a default value. |
| TagType | String | Type of physical inventory tags generated when the generate tags action is started. A list of accepted values is defined in the lookup type INV_GENERATE_TAG_TYPE. This attribute does not have a default value. |
| ShowSerialNumbersCode | String | Value that indicates if the dynamic tag creation is permitted in the physical Inventory. Contains one of the following values: 1 or 2. If 1, then serial numbers are displayed on physical inventory tags. If 2, then serial numbers are not displayed on physical inventory tags. This attribute does not have a default value. |
| ShowSerialNumbers | String | Value that indicates if the dynamic tag creation is permitted in the physical inventory. Contains one of the following values: Yes or No. If Yes, then serial numbers are displayed on physical inventory tags. If No, then serial numbers are not displayed on physical inventory tags. This attribute does not have a default value. |
| StartBlankTagNumber | String | Starting empty tag number or the next empty tag number to create. |
| FirstTagGenerationSequenceCode | String | Abbreviation that identifies the first sequence that the user defines when the application creates the physical inventory tag. |
| SecondTagGenerationSequenceCode | String | Abbreviation that identifies the second sequence that the user defines when the application creates the physical inventory tag. |
| ThirdTagGenerationSequenceCode | String | Abbreviation that identifies the third sequence that the user defines when the application creates the physical inventory tag. |
| FourthTagGenerationSequenceCode | String | Abbreviation that identifies the fourth sequence that the user defines when the application creates the physical inventory tag. |
| FifthTagGenerationSequenceCode | String | Abbreviation that identifies the fifth sequence that the user defines when the application creates the physical inventory tag. |
| SixthTagGenerationSequenceCode | String | Abbreviation that identifies the sixth sequence that the user defines when the application creates the physical inventory tag. |
| SeventhTagGenerationSequenceCode | String | Abbreviation that identifies the seventh sequence that the user defines when the application creates the physical inventory tag. |
| FirstTagGenerationSequence | String | First user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value. |
| SecondTagGenerationSequence | String | Second user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value. |
| ThirdTagGenerationSequence | String | Third user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value. |
| FourthTagGenerationSequence | String | Fourth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. This attribute does not have a default value. |
| FifthTagGenerationSequence | String | Fifth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute. |
| SixthTagGenerationSequence | String | Sixth user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute. |
| SeventhTagGenerationSequence | String | Seventh user-defined sequence in which the physical inventory tags are generated. A list of accepted values is defined in the lookup type INV_TAG_GEN_SEQUENCE. There is no default value for this attribute. |
| LastAdjustmentDate | Datetime | Date when the application most recently adjusted the transaction. |
| TotalAdjustmentValue | String | Total value of all adjustments in physical inventory. |
| NumberOfSkus | String | Number of stock keeping units where the application no longer permits changes. These units reside in physical inventory. |
| NumberBlankTags | String | Number of empty tags to create. |