|
|
IC527 - HL7 Item Master - DBS
**Form Purpose
Run HL7 Item Master - DBS (IC527) to extract Item Master information for the
DeRoyal surgery system interface. The program creates a Health Level Seven
(HL7) format export file in the directory of $LAWDIR/productline/interface.
You can run IC527 by company and by either report group or location.
For file layout information, see the Procurement Management Technical Guide.
Here is what is reported on and captured by this program when data items
change.
- The following data items in the ITEMMAST database file: DESCRIPTION,
DESCRIPTION2, INVEN-MAJCL, INVENMINCL, STOCK-UOM, ALT-UOM (1), ALT-UOM-CONV
(1), ALT-UOM (2), ALT-UOM-CONV (2), ALT-UOM (3), ALT-UOM-CONV (3), ALT-UOM
(4), ALT-UOM-CONV (4), and the default buy ITE-ALT-UOM from the default UOM
routine for ITEMMAST.
- The following data items in the ITEMLOC database file: PREFER-BIN,
SOH-QTY, LEADTIME-DAYS, CHARGEABLE-FL, TRACKING-FL, LAST-ISSUE-DT,
ACTIVE-STATUS, UOM; if the item location is inventory tracked, then if
AVERAGE-COST is > zeroes, test it; if the item location is not inventory
tracked, then if the replenishment location exists, and its AVERAGE-COST >
zeroes, test it; if still no cost is arrived at, then if a requesting location
exists and its AVERAGE-COST is > zeroes, then test it; if still no cost is
arrived at, test the LAST-REC-COST from the original ITEMLOC.
- The following data items in the HCCHRGITEM database file: PRICE,
CHARGE-NBR.
- The following data items from the ITEMSRC database file: VENDOR,
VEN-VENDOR-VNAME from APVENMAST using VENDOR, PIV-VEN-ITEM from POITEMVEN
using VENDOR and ITEM.
- The following data items from the default routine of manufacturer code:
MANUF-CODE, MANUF-NBR, MANUF-DIVISION, LIC-CODE, DESCRIPTION.
In all, there are 33 data items that are tested for having changed, and if
they have changed, they are captured for the report and the extract file. This
is, in addition, to the new items, not before captured, that are captured in
their entirety.
Updated Files
CKPOINT - Used in the event of a program or system failure to enable a
batch update program to continue from where it left off.
ICCOMPANY - Used to validate the Inventory Control company.
ITEMLOC - Contains the information for an inventory item at a stock
location.
Referenced Files
APCOMPANY - Used to validate the Accounts Payable company.
APVENGROUP - Used in an Accounts Payable common routine.
APVENMAST - Used in an Accounts Payable common routine.
GLADDRESS - Used in a General Ledger common routine.
GLCHART - Used to validate system accounts.
GLCODES -
GLSYSTEM - Used to obtain the activity flag.
HCCHRGITEM - This is the Patient Charge Item cross-reference file.
ICBIN -
ICCATEGORY -
ICLOCATION - Used to validate the inventory location.
ICMANFCODE - Contains a user-defined list of codes used to identify
manufacturers of items.
ICRPTGRP - Stores valid report groups used to define groups of locations
for reporting purposes.
ITEMMAST - Contains information about each item such as description,
classes, units of measure, and weight.
ITEMSRC -
POITEMVEN - Contains the vendor's item identifier.
PROCUREGRP -
RQLOC -
INVOKED Programs
API4
ACAC
ACCL
IFCU
IFSG
IFAC
SLSE
SLSU
ICI1
|
