| NAME |
DSIYGNI7 ITSCH INV ITEM SCH |
| TAG |
ITSCH |
| ROUTINE |
DSIYGNI7 |
| RETURN VALUE TYPE |
GLOBAL ARRAY |
| WORD WRAP ON |
TRUE |
| DESCRIPTION |
ITSCH
- only items which DO NOT EXIST in the target Distribution Point will be
shown.
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)
|
| INPUT PARAMETER |
-
- TERM
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 20
- REQUIRED: NO
- SEQUENCE NUMBER: 1
- DESCRIPTION:
TERM
Search term (20 character max)
-
- SCHBY
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 2
- REQUIRED: YES
- SEQUENCE NUMBER: 2
- DESCRIPTION:
SCHBY
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.
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)
-
- DPIEN
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 20
- REQUIRED: YES
- SEQUENCE NUMBER: 3
- DESCRIPTION:
DPIEN
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"
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"
-
- NOREC
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 4
- REQUIRED: NO
- SEQUENCE NUMBER: 4
- DESCRIPTION:
NOREC
Number of records to return, if nothing sent will default to 1000
-
- SCHTXT
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 1
- REQUIRED: NO
- SEQUENCE NUMBER: 5
- 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
-
- ACT
- PARAMETER TYPE: LITERAL
- MAXIMUM DATA LENGTH: 1
- REQUIRED: NO
- SEQUENCE NUMBER: 6
- 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.
-
- STRTREC
- PARAMETER TYPE: LITERAL
- REQUIRED: NO
- SEQUENCE NUMBER: 7
- 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.
|
| RETURN PARAMETER DESCRIPTION |
RETURN PARAMETER
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
DSIYRET(1)="0^<Warning Message> If there are warnings/no data
Pieces 20-21 are for all
P20: VENDOR LAST ORDERED
P21: STOCK #
P22: ON DEMAND
P23: UNIT OF ISSUE
P24: DETACH FLAG
DSIYRET(1)="-1^<Error Message> If there are errors
DSIYRET(ITIEN)=
P1: ITIEN
P2: ITEM DESCRIPTION (441) or (445)
P3: NSN
P4: GROUP (Only returned for Primary DP top-level search)
|
