| TITLE | VALUE | |
|---|---|---|
| NAME | DSIYGNI7 ITSCH INV ITEM SCH | |
| DESCRIPTION | ITSCH Item search for Inventory which allows search for an item within a distribution point by various fields and allows a "contains" search for some of the search types NOTE: When this search is used to ADD items to a Primary Distribution Point (items are searched in the ITEM MASTER) or to a Secondary Distribution Point (items are searched in the Primary Distribution Point) - only items which DO NOT EXIST in the target Distribution Point will be shown. | |
| TAG | ITSCH | |
| ROUTINE | DSIYGNI7 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 1 |
| INPUT PARAMETER | TERM | |
| DESCRIPTION | TERM Search term (20 character max) | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 20 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 2 |
| INPUT PARAMETER | SCHBY | |
| DESCRIPTION | SCHBY Type of search - allowable values are: I: Item IEN NM Item or Synonym name (Contains allowed) NS NSN # (can use first part or last 7 digits) G Group Category code (Contains allowed) ST Main storage location (Contains allowed) MV Mandatory Vendor (Contains allowed) MS Mandatory Source (Contains allowed) UI Unit of Issue (Contains allowed) NF NIF Number (Contains allowed) VS Vendor Stock # (Contains allowed) FS FSC # (Contains allowed) IN INC (Contains allowed) AL Search by all If a search shows "contains allowed", the user can search within the data for the TERM entered - this search will be slower. | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | YES | |
| MAXIMUM DATA LENGTH | 2 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 3 |
| INPUT PARAMETER | DPIEN | |
| DESCRIPTION | DPIEN Depending on the type of search, this shows the distribution points: When Searching for an item that EXISTS in a Primary Distribution Point: DPIEN = "P:PRIMARY IEN" When Searching for an item that EXISTS in a Secondary Distribution Point: DPIEN = "S:SECONDARY IEN" When searching the ITEM MASTER file to ADD an item to a Primary DP: DPIEN = "IM:PRIMARY IEN" When searching the Primary DP to ADD an item to a Secondary DP: DPIEN = "P:PRIMARY IEN:S:SECONDARY IEN" When searching for an item that EXISTS in the ITEM MASTER file: DPIEN = "IMSCH" | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | YES | |
| MAXIMUM DATA LENGTH | 20 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 4 |
| INPUT PARAMETER | NOREC | |
| DESCRIPTION | NOREC Number of records to return, if nothing sent will default to 1000 | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 4 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 5 |
| INPUT PARAMETER | SCHTXT | |
| DESCRIPTION | SCHTXT If set to "1" look for the TERM within any strings - not just at the beginning of strings. This is not allowed for all search types. This search will be slower | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 1 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 6 |
| INPUT PARAMETER | ACT | |
| DESCRIPTION | ACT Leave blank or set to 1 if only active inventory items to be returned. Entering "N" for this returns all items whether active or not. | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | 1 | |
| INPUT PARAMETERS | SEQUENCE NUMBER | 7 |
| INPUT PARAMETER | STRTREC | |
| DESCRIPTION | The IEN of the record that was returned in the prior search. The next proceding record will be the first returned that matches the search criteria. | |
| PARAMETER TYPE | LITERAL | |
| REQUIRED | NO | |
| MAXIMUM DATA LENGTH | ||
| RETURN VALUE TYPE | GLOBAL ARRAY | |
| RETURN PARAMETER DESCRIPTION | RETURN PARAMETER DSIYRET(1)="0^ DSIYRET(1)="-1^ DSIYRET(ITIEN)= P1: ITIEN P2: ITEM DESCRIPTION (441) or (445) P3: NSN P4: GROUP (Only returned for Primary DP top-level search) P5: NIF Pieces 6-14 are only returned with values when doing a top-level search at the Primary Distribution Point (meaningless otherwise) P6: O/H P7: D/I P8: D/O P9: NORMAL STOCK LEVEL P10: EMERGENCY STOCK LEVEL P11: TEMP STOCK LEVEL P12: STANDARD REORDER POINT P13: OPTIONAL REORDER POINT P14: MAIN STORAGE LOCATION Pieces 15-17 are only returned when searching through the ITEM MASTER FILE using IMSCHFILE P15: FSC P16: INC P17: SKU P18: DATE INACTIVATED Piece 19 is used for recognizing Prosthetic Items P19: HCPCS CODE Pieces 20-21 are for all P20: VENDOR LAST ORDERED P21: STOCK # P22: ON DEMAND P23: UNIT OF ISSUE P24: DETACH FLAG | |
| AVAILABILITY | ||
| INACTIVE | ||
| CLIENT MANAGER | ||
| WORD WRAP ON | TRUE | |
| VERSION | ||
| SUPPRESS RDV USER SETUP | ||
| APP PROXY ALLOWED | ||