Print Page as PDF
GENERIC INVENTORY FILE ACCESS ICR (6547)

GENERIC INVENTORY FILE ACCESS    ICR (6547)

Name Value
NUMBER 6547
IA # 6547
FILE NUMBER 445
GLOBAL ROOT PRCP(445,
DATE CREATED 2016/10/18
CUSTODIAL PACKAGE IFCAP
USAGE Controlled Subscription
TYPE File
DBIC APPROVAL STATUS APPROVED
NAME GENERIC INVENTORY FILE ACCESS
GENERAL DESCRIPTION 
Above PAR and the Advanced Prosthetics Acquisition Tool
(APAT) request permission to read and write to the GENERIC INVENTORY FILE #445
to display and edit both Distribution Points and Items within a Distribution
Point within the Inventory function.  Inventory levels are also adjusted by
the APAT stock issue and edit 2319 functionality.  Above PAR will address the
conversion of a secondary to a primary in a future version.

Above PAR Ad-Hoc Reporting includes the GENERIC INVENTORY FILE #445.  Ad-Hoc
functionality provides the ability to select fields from the file for display
on user-defined reports.  Ad-Hoc offers only FileMan read access and only if
the user has permission to view the file.
GLOBAL REFERENCE
GLOBAL REFERENCE FIELD NUMBER GLOBAL DESCRIPTION
PRCP(445,D0,0)
FIELD NUMBER ACCESS FIELD DESCRIPTION FIELD NAME LOCATION
.01 Both R/W w/Fileman 

Global r
INVENTORY POINT 0;1
.5 Both R/W w/Fileman KEEP PERPETUAL INVENTORY? 0;2
.7 Direct Global Read & R/W w/Fileman TYPE OF INVENTORY POINT 0;3
9 Both R/W w/Fileman REGULAR WHSE. ISSUES SCHEDULE 0;4
.8 Both R/W w/Fileman ABBREVIATED NAME 0;5
.6 Direct Global Read & R/W w/Fileman KEEP DETAILED TRX. HISTORY? 0;6
.9 Both R/W w/Fileman COST CENTER 0;7
5 Both R/W w/Fileman DEPARTMENT NUMBER 0;8
7 Both R/W w/Fileman PRINT STOCK AT CRITICAL LEVEL? 0;9
5.5 Both R/W w/Fileman ISSUE BOOK SORT 0;10
10 Direct Global Read & R/W w/Fileman REGULAR WHSE. ISSUES DUE DATE 0;12
12 Both R/W w/Fileman MOS INACTIVE BEFORE ITEM DEL. 0;13
7.5 Direct Global Read & R/W w/Fileman LAST PURGE USAGE 0;14
14 Both R/W w/Fileman PRIMARY UPDATED BY WAREHOUSE 0;16
7.6 Direct Global Read & R/W w/Fileman LAST PURGE RECEIPTS 0;17
7.7 Direct Global Read & R/W w/Fileman LAST PURGE TRANS REGISTER 0;18
7.8 Direct Global Read & R/W w/Fileman LAST PURGE DISTRIBUTION 0;19
15 Both R/W w/Fileman SPECIAL INVENTORY POINT TYPE 0;20
7.9 Read w/Fileman AUTOMATIC PURGE 0;21
7.4 Direct Global Read & R/W w/Fileman LAST OPEN BALANCES SET 0;22
PRCP(445,D0,1,D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman ITEM NO. 0;1
14 Both R/W w/Fileman CANCEL/BACKORDER 0;2
4.6 Both R/W w/Fileman DATE LAST RECEIVED 0;3
10.3 Both R/W w/Fileman OPTIONAL REORDER POINT 0;4
4 Direct Global Read & R/W w/Fileman UNIT OF ISSUE 0;5
5 Direct Global Read & R/W w/Fileman MAIN STORAGE LOCATION 0;6
7 Direct Global Read & R/W w/Fileman QTY.ON HAND (UNIT OF ISSUE) 0;7
9 Direct Global Read & R/W w/Fileman NORMAL STOCK LEVEL (U OF I) 0;9
10 Direct Global Read & R/W w/Fileman STANDARD REORDER POINT 0;10
11 Direct Global Read & R/W w/Fileman EMERGENCY STOCK LEVEL 0;11
.4 Direct Global Read & R/W w/Fileman MANDATORY OR REQUESTED SOURCE 0;12
14.3 Both R/W w/Fileman DO NOT BACK-ORDER INDICATOR 0;13
4.5 Direct Global Read & R/W w/Fileman UNIT OF ISSUE PACKAGE MULT. 0;14
4.7 Both R/W w/Fileman LAST COST (UNIT OF ISSUE) 0;15
16.5 Both R/W w/Fileman MINIMUM ISSUE QTY. 0;17
14.4 Both R/W w/Fileman DO NOT SUBSTITUTE INDICATOR 0;18
7.5 Both R/W w/Fileman QTY NON-ISSUABLE (U/I) 0;19
.5 Direct Global Read & R/W w/Fileman GROUP CATEGORY CODE 0;21
4.8 Both R/W w/Fileman AVERAGE COST (UNIT OF ISSUE) 0;22
9.5 Both R/W w/Fileman TEMPORARY STOCK LEVEL 0;23
9.6 Both R/W w/Fileman DATE TO DELETE TEMPORARY LEVEL 0;24
16 Both R/W w/Fileman ISSUE MULTIPLE (UNIT OF ISSUE) 0;25
17 Both R/W w/Fileman DELETE ITEM WHEN INVENTORY 0 0;26
4.81 Both R/W w/Fileman TOTAL INVENTORY VALUE 0;27
50 Both R/W w/Fileman DISPENSING UNIT 0;28
51 Both R/W w/Fileman DISPENSING UNIT CONV FACTOR 0;29
.8 Direct Global Read & R/W w/Fileman ON-DEMAND 0;30
PRCP(445,D0,1,D1,1,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman ADDITIONAL STORAGE LOCATION 0;1
PRCP(445,D0,1,D1,2,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman MONTH/YEAR USED/ISSUED 0;1
1 Both R/W w/Fileman QTY.USED/ISSUED (U OF ISSUE) 0;2
2 Both R/W w/Fileman TOTAL COST USED/ISSUED 0;3
PRCP(445,D0,1,D1,3,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman DATE RECEIVED 0;1
1 Both R/W w/Fileman QTY.RECEIVED (UNIT OF ISSUE) 0;2
PRCP(445,D0,1,D1,4,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman SUBSTITUTE ITEM(S) 0;1
PRCP(445,D0,1,D1,5,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman PROCUREMENT SOURCE 0;1
1 Both R/W w/Fileman UNIT OF RECEIPT 0;2
2 Both R/W w/Fileman UNIT OF RECEIPT PACKAGE MULT. 0;3
3 Both R/W w/Fileman UNIT CONVERSION FACTOR 0;4
PRCP(445,D0,1,D1,6)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.7 Direct Global Read & R/W w/Fileman ITEM DESCRIPTION 6;1
PRCP(445,D0,1,D1,7,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman TRANSACTION NO. 0;1
1 Direct Global Read & R/W w/Fileman QTY.ORDERED UNIT OF ISSUE 0;2
2 Both R/W w/Fileman UNIT OF RECEIPT 0;3
3 Both R/W w/Fileman UNIT OF RECEIPT PACKAGE MULT. 0;4
4 Both R/W w/Fileman UNIT CONVERSION FACTOR 0;5
PRCP(445,D0,1,D1,8,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman CASE CART/INSTRUMENT KIT ITEM 0;1
1 Both R/W w/Fileman QTY NEEDED FOR ONE CC/IK 0;2
PRCP(445,D0,1,D1,9)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.61 Direct Global Read & R/W w/Fileman SUPPLY STATION QUANTITY 9;1
.62 Read w/Fileman QTY FROM SS LAST UPDATED 9;2
PRCP(445,D0,1,D1,10,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman DATE/TIME OF CHANGE 0;1
1 Both R/W w/Fileman ON-DEMAND CHANGED BY 0;2
2 Both R/W w/Fileman REASON FOR CHANGE 0;3
3 Both R/W w/Fileman NEW ON-DEMAND SETTING 0;4
PRCP(445,D0,1,D1,'DUE')
FIELD NUMBER ACCESS FIELD NAME LOCATION
8.1 Direct Global Read & R/W w/Fileman DUE-IN (IN U/I) 'DUE';1
8.6 Both R/W w/Fileman DUE-OUT (IN U/I) 'DUE';2
PRCP(445,D0,2,D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman DISTRIBUTION POINT 0;1
PRCP(445,D0,3,D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman MIS COSTING SECTION 0;1
1 Both R/W w/Fileman % OF COSTS TO BE APPLIED 0;2
PRCP(445,D0,4,D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman INVENTORY USER 0;1
PRCP(445,D0,6)
FIELD NUMBER ACCESS FIELD NAME LOCATION
23 Read w/Fileman SS QUANTITY LAST TRANSMITTED 6;1
PRCP(445,D0,7)
FIELD NUMBER ACCESS FIELD NAME LOCATION
24 Both R/W w/Fileman QUANTITY REPLACEMENT REQUESTOR 7;1
25 Both R/W w/Fileman QUANTITY REPLACEMENT REQUESTED 7;2
PRCP(445,D0,8,D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman QUANTITY REPLACEMENT USER 0;1
PRCP(445,D0,9,D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman ON-DEMAND USER 0;1
PRCP(445,D0,'DEV')
FIELD NUMBER ACCESS FIELD NAME LOCATION
16 Both R/W w/Fileman PICKING TICKET PRINTER 'DEV';1
PRCP(445,D0,'SEC')
FIELD NUMBER ACCESS FIELD NAME LOCATION
19 Both R/W w/Fileman PRE-CONVERSION HEADER (NO EDITS) 'SEC';1
19.5 Both R/W w/Fileman CONVERTED BY 'SEC';2
19.6 Both R/W w/Fileman CONVERSION DATE 'SEC';3
19.7 Both R/W w/Fileman PRE-CONVERSION STOCKED BY 'SEC';4
PRCP(445,D0,'SECITM',D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman PRE-CONVERSION ITEM (NO EDITS) 0;1
PRCP(445,D0,'SECITM',D1,5,D2,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman PRE-CONVERSION SOURCES (NO EDITS) 0;1
PRCP(445,D0,'SECMIS',D1,0)
FIELD NUMBER ACCESS FIELD NAME LOCATION
.01 Both R/W w/Fileman PRE-CONVERSION MIS (NO EDITS) 0;1
PRCP(445,'AB' 
'AB' cross reference - used to look up by DISTRIBUTION
POINT
PRCP(445,'AC' 
'AC' cross reference - used to look up by INV POINT TYPE
PRCP(445,'AD' 
'AD' cross reference - used to look up by INVENTORY USER
PRCP(445,'AE' 
'AE' cross reference - used to look up by ITEM NO
PRCP(445,'B' 
'B' cross reference - used to look up by INVENTORY POINT
PRCP(445,D0,5)
FIELD NUMBER ACCESS FIELD NAME LOCATION
22 Direct Global Read & R/W w/Fileman SS PROVIDER 5;1
STATUS Active
KEYWORDS
  • APAT
  • ABOVE PAR
DURATION Till Otherwise Agreed
ID PRCP(445,
SUBSCRIBING PACKAGE
  • ABOVE PAR
  • ADVANCED PROSTHETICS ACQUISITION TOOL
DATE ACTIVATED 2022/03/04