Required No DB Column EBTStockLocalThreshold.Cln_ID Code ID Clinic table lookup Current Inventory This is the current inventory quantity at the agency or clinic level. Type Text Box Required NA Length 8 Validation Mask of Z,ZZ9 Display Only Yes Calculated Yes NA DB Column Received Last 12 This is the quantity of the EBT cards that has been received over Months the last 12 months at the local agency or clinic level. This is to give the user a sense of the pace of usage of the EBT cards. Type Text Box Required NA Length 8 Validation Mask of Z,ZZ9 Yes Yes Display Only Calculated DB Column NA Inventory Months This is the amount of current inventory expressed in months on pace of last 12 months received). Text Box Type Required NA Length NA Validation Mask of Z9.9 Display Only Yes Calculated Yes DB Column NA Replenishment This is the amount of inventory at the local agency or clinic level Threshold that is set to control when a warning alert occurs. It is compared to the Current Inventory + the Currently On Order. Type Text Box Required Yes Length Integer 8 Validation Numeric, Mask of Z,ZZ9
Required No DB Column EBTStockLocalThreshold.Cln_ID Code ID Clinic table lookup Current Inventory This is the current inventory quantity at the agency or clinic level. Type Text Box Required NA Length 8 Validation Mask of Z,ZZ9 Display Only Yes Calculated Yes DB Column NA Received Last 12 Months This is the quantity of the EBT cards that has been received over the last 12 months at the local agency or clinic level. This is to give the user a sense of the pace of usage of the EBT cards. Type Text Box Required NA Length 8 Validation Mask of Z,ZZ9 Display Only Yes Calculated Yes DB Column NA Inventory Months This is the amount of current inventory expressed in months on pace of last 12 months received). Type Text Box Required NA Length NA Validation Mask of Z9.9 Display Only Yes Calculated Yes DB Column NA Replenishment Threshold This is the amount of inventory at the local agency or clinic level that is set to control when a warning alert occurs. It is compared to the Current Inventory + the Currently On Order. Type Text Box Required Yes Length Integer 8 Validation Numeric, Mask of Z,ZZ9
DFDD%20OP%202b%20EBT%20Inventory%20Screens.docx