 |
Lawson Insight Technical Documentation |
|
CXPREFITEM FILE
Preference Items
The Preference Items file contains the items that are defined for use in a
procedure. Use CX20.1 (Case Build) to create this file. When you assign a
preference template to a case and add the case, the items for the preference
template automatically default to this file. Use CX20.2 (Case Detail) to add,
substitute, or delete items from a case.
Releasing a case causes the Case Carts system logic to access this file. The
system uses this data to add or re-add demand records, allocate inventory (if
allocation criteria are met), and create a Purchase Order interface record if
Create PO in this file is set to Yes.
UPDATED BY
CXCP.1 POIJ.1 WH130 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPI-COMPANY Numeric 4 CXCP.1 POIJ.1
Company This field contains the company number. WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-REQ-LOCATION Alpha 5 CXCP.1 POIJ.1
To Location This field contains the location WH130 WH33.1
requisitioning items and to be charged WH33.2 WH33.3
for the items. This location can be an WH33.4 WH33.5
inventory or noninventory location. WH33.6 WH33.8
WH33.9 WH34.1
This value appears as the to location WH34.2 WH34.3
on pick lists printed when you run CX100 WH34.4
(Pick List Print) and WH130 (Pick List
Print).
Valid values are
A requesting location defined in RQ01.1
(Requesting Location) for the specified
healthcare company.
CPI-CASE Alpha 15 CXCP.1 POIJ.1
Case This field contains the unique WH130 WH33.1
identifier for the case. WH33.2 WH33.3
WH33.4 WH33.5
A case identifier is used in the Case WH33.6 WH33.8
Carts system to associate specific WH33.9 WH34.1
tasks, practitioners, preference lists, WH34.2 WH34.3
and other information with a particular WH34.4
treatment course. This treatment course
may consist of one or more procedures.
The Case Carts system uses the case
number to interface with an outside
scheduling system.
CPI-PREF-CODE Alpha 8 CXCP.1 POIJ.1
Preference Code This field contains the Preference List WH130 WH33.1
Code. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-PROC-TYPE Alpha 8 CXCP.1 POIJ.1
Proc Type The procedure type is the first of two WH130 WH33.1
fields that uniquely identify a WH33.2 WH33.3
procedure. The procedure type can WH33.4 WH33.5
identify the code set to which the WH33.6 WH33.8
procedure code belongs. WH33.9 WH34.1
WH34.2 WH34.3
For example, you can use one of the WH34.4
following codes:
- CPT-4 for a code in the Current
Procedural Terminology listing compiled
by the American Medical Association
-HCPCS for a code in HCFA's (Health
Care Financing Administration's) Common
Procedure Coding System, or
- A code defined for your
organization's own procedures listing.
CPI-PROC-CODE Alpha 8 CXCP.1 POIJ.1
Procedure Code The procedure code is the second of two WH130 WH33.1
fields that uniquely identify a WH33.2 WH33.3
procedure. The procedure code is an WH33.4 WH33.5
identifier for a specific procedure WH33.6 WH33.8
within a procedure type. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-SEQ Numeric 3 CXCP.1 POIJ.1
Sequence Number This field contains the sequence of the WH130 WH33.1
preference list within the case. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-ITEM Alpha 32 CXCP.1 POIJ.1
Item Number This field contains the item WH130 WH33.1
identifier. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-ITEM-TYPE Alpha 1 CXCP.1 POIJ.1
Item Type This field identifies the line item WH130 WH33.1
type. WH33.2 WH33.3
WH33.4 WH33.5
Changes to this field that result in N, WH33.6 WH33.8
X, or X item types , update the Purchase WH33.9 WH34.1
Order interface record. WH34.2 WH34.3
I = Inventoried Item WH34.4
N = Non-Stock Item
S = Service Item
X = Special Item
CPI-SERVICE-CODE Alpha 1 CXCP.1 POIJ.1
Service Code " " = Not A Service Item WH130 WH33.1
A = Amount WH33.2 WH33.3
Q = Quantity WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-DESCRIPTION Alpha 30 (Lower Case) CXCP.1 POIJ.1
Description This field contains the description. WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-LINE-NBR Numeric 6 CXCP.1 POIJ.1
Line Number This field contains the original item WH130 WH33.1
line number assigned by the Case Carts WH33.2 WH33.3
system when the item is added. For the WH33.4 WH33.5
line number displayed in CX20.2 (Case WH33.6 WH33.8
Detail), see Alt Line Nbr. WH33.9 WH34.1
WH34.2 WH34.3
This file value is always 1 for the WH34.4
first item on a case preference. Thus,
if there are two preferences on a case,
they each start with line number 1.
CPI-UOM Alpha 4 CXCP.1 POIJ.1
Unit of Measure This field contains the valid stock WH130 WH33.1
unit of measure for this item. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-QUANTITY Signed 13.4 CXCP.1 POIJ.1
Quantity This field contains the requested WH130 WH33.1
quantity to be picked. WH33.2 WH33.3
WH33.4 WH33.5
This field defaults to one (1) if no WH33.6 WH33.8
value is entered. This field is WH33.9 WH34.1
required. WH34.2 WH34.3
WH34.4
Note: To change a line that is
partially picked (such as for a case
that has multiple care days), be sure
that the quantity is equal to or greater
than the quantity already picked.
(Care days are the total number of
preoperative and postoperative days. For
example, if the patient stay consists of
day one for surgery and day two for
postoperative care, the number of care
days is one (1). You define care days in
CX20.2 (Case Detail) in the Items tab on
the Care Item detail tab.)
CPI-QUANTITY-USED Signed 13.4 CXCP.1 POIJ.1
Quantity Used This field contains the actual quantity WH130 WH33.1
of items used for this case. This amount WH33.2 WH33.3
can be more or less than the issued WH33.4 WH33.5
amount. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-FROM-COMPANY Numeric 4 CXCP.1 POIJ.1
From Company This is the company that is the source WH130 WH33.1
of the items. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-FROM-LOCATION Alpha 5 CXCP.1 POIJ.1
From Location This is the inventory location that WH130 WH33.1
supplies the items or it is the purchase WH33.2 WH33.3
order ship to location that receives the WH33.4 WH33.5
items. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-PRICE Signed 15.2 CXCP.1 POIJ.1
Price This field contains the amount that the WH130 WH33.1
patient will be charged for the item. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-ISSUE-COST Signed 15.2 CXCP.1 POIJ.1
Issue Cost This field contains the issue cost. WH130 WH33.1
WH33.2 WH33.3
This cost defaults from CX05.1 WH33.4 WH33.5
(Preference Template) when a case is WH33.6 WH33.8
added using CX20.1 (Case Build) with the WH33.9 WH34.1
following exception. WH34.2 WH34.3
WH34.4
For I or N type items, when you add a
case, the system may replace the issue
cost from the template with a new value.
Such replacement occurs if the values
used in the cost logic have changed. For
example, such a change can occur when
the associated contract unit cost
changes after the template is created.
The cost logic defaults as follows and
can be manually overridden:
For inventoried (I) type items, the
cost defaults from the Inventory Control
system costing routine.
For non-inventory-tracked (N) type
items, the cost defaults from the
Purchase Order system unit cost default
routine.
For X or S type items, the cost
defaults from the template (CX05.1
(Preference Template)).
If the Create PO flag is set to Yes,
this value updates the Purchase Order
interface record.
CPI-ACCT-UNIT Alpha 15 CXCP.1 POIJ.1
Accounting Unit This field contains the accounting WH130 WH33.1
unit. The accounting unit is a shorthand WH33.2 WH33.3
notation representing the variable level WH33.4 WH33.5
number. When used in the General Ledger WH33.6 WH33.8
Account Master file, the accounting unit WH33.9 WH34.1
must be defined in the General Ledger WH34.2 WH34.3
Names file as a posting accounting unit. WH34.4
CPI-ACCOUNT Numeric 6 CXCP.1 POIJ.1
Account This field contains the account. This WH130 WH33.1
field, along with the accounting unit WH33.2 WH33.3
and subaccount, make up the location WH33.4 WH33.5
(account) where amounts and other WH33.6 WH33.8
account information are stored. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-SUB-ACCOUNT Numeric 4 CXCP.1 POIJ.1
Subaccount This field contains the subaccount. WH130 WH33.1
This field along with the accounting WH33.2 WH33.3
unit and subaccount make up the location WH33.4 WH33.5
(account) where amounts and other WH33.6 WH33.8
account information is stored. WH33.9 WH34.1
WH34.2 WH34.3
This value must be a valid general WH34.4
ledger account (defined with the Acct
Unit). When you release a case, this
value updates the Purchase Order
interface record.
If Item Type is I or Create PO flag is
Yes, this field must contain a value.
Defaults based on Requisition system
default logic if blank and item type is
I or the Create PO flag is set to Yes.
CPI-CHARGE-NBR Alpha 10 CXCP.1 POIJ.1
Charge Nbr This field contains the number, such as WH130 WH33.1
CDM (Charge Description Master), used by WH33.2 WH33.3
the patient billing system to charge WH33.4 WH33.5
patients for items used. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-CHARGEABLE-FL Alpha 1 CXCP.1 POIJ.1
Chargeable Fl This flag indicates that this item is a WH130 WH33.1
patient chargeable item. WH33.2 WH33.3
N = No WH33.4 WH33.5
Y = Yes WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-ISSUE-DATE Numeric 8 (yyyymmdd) CXCP.1 POIJ.1
Issued Date This field contains the date of the WH130 WH33.1
transaction. WH33.2 WH33.3
WH33.4 WH33.5
The value must be zero (0) if the Case WH33.6 WH33.8
status is 1 (Unreleased). The system WH33.9 WH34.1
updates this value based on changes in WH34.2 WH34.3
CX30.1 (Case Completion Feedback). WH34.4
Defaults to zero (0).
CPI-ALT-LINE-NBR Numeric 6 CXCP.1 POIJ.1
Alt Line Nbr This field contains the display value WH130 WH33.1
of the item line number. WH33.2 WH33.3
WH33.4 WH33.5
When you assign more than one WH33.6 WH33.8
preference template to a case, the WH33.9 WH34.1
system assigns numbers to the items, WH34.2 WH34.3
sequentially, starting with 1 on the WH34.4
first preference and continuing
sequentially through the next
preferences.
CPI-CREATE-PO-CD Alpha 1 CXCP.1 POIJ.1
Create Purchase This code indicates whether this WH130 WH33.1
Order Code inventory item is to be purchased by WH33.2 WH33.3
purchase order instead of picked from WH33.4 WH33.5
inventory. WH33.6 WH33.8
WH33.9 WH34.1
Select No for pick from inventory. WH34.2 WH34.3
WH34.4
Select Yes for create purchase order.
Defaults to No if blank.
Y = Yes
N = No
CPI-VENDOR Alpha 9 (Right Justified) CXCP.1 POIJ.1
Vendor ID This field contains the vendor's WH130 WH33.1
identification code. WH33.2 WH33.3
WH33.4 WH33.5
The system may overwrite this value WH33.6 WH33.8
with output from the Purchase Order Unit WH33.9 WH34.1
Cost Default routine. WH34.2 WH34.3
WH34.4
CPI-TAXABLE-FLAG Alpha 1 CXCP.1 POIJ.1
Taxable or This field defines whether or not the WH130 WH33.1
Non-Taxable Flag item is taxable. WH33.2 WH33.3
WH33.4 WH33.5
This value updates the Purchase Order WH33.6 WH33.8
interface record when the case is WH33.9 WH34.1
released. WH34.2 WH34.3
WH34.4
Defaults from the Item master for I and
N item types or to No for X and S item
types.
Y = Yes
N = No
CPI-TAX-CODE Alpha 10 CXCP.1 POIJ.1
Tax Code This field contains a valid tax code WH130 WH33.1
representing specific tax information. WH33.2 WH33.3
WH33.4 WH33.5
This value updates the Purchase Order WH33.6 WH33.8
interface record when the case is WH33.9 WH34.1
released. WH34.2 WH34.3
WH34.4
If the Taxable Flag is set to Yes, this
field must contain a value.
Defaults to spaces.
CPI-EARLY-DL-DATE Numeric 8 (yyyymmdd) CXCP.1 POIJ.1
Early Delivery Date This field contains the early delivery WH130 WH33.1
(Rqst DT) date. WH33.2 WH33.3
WH33.4 WH33.5
This value updates the Purchase Order WH33.6 WH33.8
interface record. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-LATE-DL-DATE Numeric 8 (yyyymmdd) CXCP.1 POIJ.1
Late Delivery Date This field contains the late delivery WH130 WH33.1
date. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-CERT-REQ-FL Alpha 1 CXCP.1 POIJ.1
Certification This flag indicates whether a WH130 WH33.1
Required Flag certification is required for this line WH33.2 WH33.3
when it is purchased. This field value WH33.4 WH33.5
is passed to the purchase order when the WH33.6 WH33.8
purchase order line is created. WH33.9 WH34.1
Y = Certification required. WH34.2 WH34.3
N = No certification required. WH34.4
CPI-INSP-REQ-FL Alpha 1 CXCP.1 POIJ.1
Inspection Required This flag indicates whether this item WH130 WH33.1
Flag has to be inspected when received in the WH33.2 WH33.3
Purchase Order system. WH33.4 WH33.5
WH33.6 WH33.8
If the Create PO flag is set to Yes, WH33.9 WH34.1
this value updates the Purchase Order WH34.2 WH34.3
interface record when a case is WH34.4
released.
Defaults to the value in the Insp Req
Fl of the Itemloc file or defaults to
No.
CPI-REV-CENTER Alpha 5 CXCP.1 POIJ.1
Rev Center The revenue center is the department WH130 WH33.1
that charges are associated with. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-POST-ITEM-FL Alpha 1 CXCP.1 POIJ.1
Post Item Fl This field indicates whether or not WH130 WH33.1
this line item is part of the procedure WH33.2 WH33.3
(an intraoperative item) or is a WH33.4 WH33.5
postoperative or preoperative item. WH33.6 WH33.8
1 = Intra-Op WH33.9 WH34.1
2 = Post-Op WH34.2 WH34.3
3 = Pre-Op WH34.4
CPI-POST-DAY Numeric 2 CXCP.1 POIJ.1
Posting Day This field defines the day of the WH130 WH33.1
patient visit when the item is to be WH33.2 WH33.3
used. A value of zero indicates the day WH33.4 WH33.5
of the procedure. When used with the WH33.6 WH33.8
Care Days field, this field indicates WH33.9 WH34.1
the day to start picking care items. WH34.2 WH34.3
00 WH34.4
99
CPI-SUB-ITEM-FL Alpha 1 CXCP.1 POIJ.1
Sub Item Fl This field defines whether an item is a WH130 WH33.1
substitute or a replacement item. WH33.2 WH33.3
WH33.4 WH33.5
Blank indicates that no replacements or WH33.6 WH33.8
substitutions are defined. WH33.9 WH34.1
WH34.2 WH34.3
This value must be blank for N, X, and WH34.4
S item types.
Defaults to blank.
R = Replacement
S = Substitute
CPI-ORIG-ITEM-NBR Alpha 32 CXCP.1 POIJ.1
Orig Item Nbr This field contains the original item WH130 WH33.1
number. WH33.2 WH33.3
WH33.4 WH33.5
A value must be provided if Sub Item Fl WH33.6 WH33.8
is not blank. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-SERVICE-DATE Numeric 8 (yyyymmdd) CXCP.1 POIJ.1
Service Date This field identifies the date the item WH130 WH33.1
was used. This date is used by the WH33.2 WH33.3
billing system to identify the charges WH33.4 WH33.5
associated with this case. In the WH33.6 WH33.8
Patient Charge system, this date is WH33.9 WH34.1
called the Charge Date. WH34.2 WH34.3
WH34.4
This value must be zero (0) if the Case
status is 1 (Unreleased).
Defaults to zero (0).
CPI-REPEAT-FL Alpha 1 CXCP.1 POIJ.1
Repeat Fl This field is reserved for a future WH130 WH33.1
release of the Case Carts system. WH33.2 WH33.3
Y = Yes WH33.4 WH33.5
N = No WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-NBR-DAYS Numeric 2 CXCP.1 POIJ.1
Number of Days Care days are the total number of days WH130 WH33.1
a preoperative or postoperative item WH33.2 WH33.3
will be used on the case, starting with WH33.4 WH33.5
the usage day. The day of the procedure WH33.6 WH33.8
is considered usage day 0. See note WH33.9 WH34.1
below. WH34.2 WH34.3
WH34.4
The Care Days * Units Per Day must
equal the Quantity if the Item Usage
flag is set.
Defaults:
The Care Days value defaults from
CX05.1(Preference Template).
Note:
For example, if the patient stay
consists of day one for both surgery and
the use of intraoperative and
postoperative items, the number of care
days is 0.
In another example, if the patient stay
consists of two days, day one for the
procedure (designated as usage day zero)
and day two for postoperative care, the
number of care days is 1.
In another example, if an item is not
used on a day in the middle of a patient
stay, you must create two lines for the
item. That is, first define the care
days for the item, up to the day of
nonusage. Next, add a new line for the
same item. Assume the day of nonusage as
a new usage day of zero and define the
care days for the new line as the total
number of remaining care days for the
item.
Use the following fields together: Item
Usage, Usage Day, Care Days, and Units
Per Day.
CPI-UNITS-PER-DAY Numeric 3 CXCP.1 POIJ.1
Units Per Day This field defines the number of item WH130 WH33.1
units to be used per day. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-PICK-FL Alpha 1 CXCP.1 POIJ.1
Picking Option Flag This field indicates in which system to WH130 WH33.1
print pick lists and pick items. WH33.2 WH33.3
WH33.4 WH33.5
Important: Your selection affects more WH33.6 WH33.8
than just printing the pick list. Your WH33.9 WH34.1
selection affects whether shipment WH34.2 WH34.3
records will be created so that items WH34.4
are picked for the correct case (by
shipment number). The shipment records
also allow for further processing. See
note below.
For inventoried (I) type items, you
must select 1.
For non-inventory-tracked (N, X, or, S)
type items, you can select either 1, 2,
or 3.
For printing no pick lists, select 3.
Note: You must run the pick list
program (WH130 (Pick List Print)) in the
Warehouse system to have the system
create shipment records. (Later, when
you run CX100 (Pick List Print), the
shipment number created will appear on
the CX100 pick list. The shipment number
on the pick list helps you to match
picked items with a case procedure.)
Additionally, once the shipment records
are created, shipping feedback (in
WH32.1 (Shipping Feedback by Shipment)),
and reduction of stock on hand and
deletion of demand records by shipment
release (in WH190 (Shipment Release))
can proceed.
1 = Pick through Warehouse system
2 = Pick through Case Cart system
3 = Do not pick
CPI-RTN-WST-FL Alpha 1 CXCP.1 POIJ.1
Rtn Wst Fl This field indicates whether the item WH130 WH33.1
is a return or waste item. WH33.2 WH33.3
WH33.4 WH33.5
Select Yes if the item is to be WH33.6 WH33.8
designated as a return or waste item. WH33.9 WH34.1
(Returns are received items that must be WH34.2 WH34.3
sent back to the vendor or to the WH34.4
inventory, noninventory, or delivering
location. Return items are replaced with
no charge or credited. Waste items are
items picked for a case but never used
and later disposed of and reported as
waste during case completion feedback.)
Select No if the Case status is 1
(Unreleased).
Defaults to No.
Y = Yes
N = No
CPI-ACCT-CATEGORY Alpha 5 CXCP.1 POIJ.1
Account Category This field contains a valid account WH130 WH33.1
category as defined in the Activity WH33.2 WH33.3
Management system. WH33.4 WH33.5
Note: Use of the Activity Management WH33.6 WH33.8
system to track and report costs WH33.9 WH34.1
recorded in the Case Carts system is WH34.2 WH34.3
reserved for a future release. WH34.4
CPI-ACTIVITY Alpha 15 CXCP.1 POIJ.1
Activity This field contains a valid activity WH130 WH33.1
code as defined in the Activity WH33.2 WH33.3
Management system. WH33.4 WH33.5
Note: Use of the Activity Management WH33.6 WH33.8
system to track and report costs WH33.9 WH34.1
recorded in the Case Carts system is WH34.2 WH34.3
reserved for a future release. WH34.4
CPI-ATN-OBJ-ID Numeric 12 CXCP.1 POIJ.1
Atn Object ID This field contains a system-assigned WH130 WH33.1
identifier that provides access to data WH33.2 WH33.3
in related files. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-STORAGE-LOC Alpha 7 CXCP.1 POIJ.1
Storage Loc This field contains the storage WH130 WH33.1
location identifier. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-STOCKLESS-FL Alpha 1 CXCP.1 POIJ.1
Stockless Fl This flag indicates whether or not the WH130 WH33.1
item is a stockless item. WH33.2 WH33.3
WH33.4 WH33.5
Note: Use of this field is reserved WH33.6 WH33.8
for a future release. WH33.9 WH34.1
Y = Yes WH34.2 WH34.3
N = No WH34.4
CPI-AGREEMENT-REF Alpha 30 CXCP.1 POIJ.1
Agreement Ref WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-COST-CD Alpha 1 CXCP.1 POIJ.1
Unit Cost Origin This field contains the unit-cost WH130 WH33.1
Code origin code. When you build a case, this WH33.2 WH33.3
value is defaulted from the Purchase WH33.4 WH33.5
Order Unit Cost Default routine. The WH33.6 WH33.8
value updates the Purchase Order WH33.9 WH34.1
interface record. WH34.2 WH34.3
E = Entered WH34.4
L = Last Cost
C = Contract
T = Catalog/Quote
B = Blanket
P = Lat PO Created
CPI-COST-OPTION Alpha 1 CXCP.1 POIJ.1
Cost Option 1 = Cost Required WH130 WH33.1
2 = No Charge WH33.2 WH33.3
3 = Vendor Determined WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-SHIPPED-QTY Signed 13.4 CXCP.1 POIJ.1
Shipped Quantity This field contains the item shipped WH130 WH33.1
quantity. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-DEMAND-CREATED Alpha 1 CXCP.1 POIJ.1
Demand Created This field indicates whether demand was WH130 WH33.1
created. WH33.2 WH33.3
WH33.4 WH33.5
Select Yes if the demand was created. WH33.6 WH33.8
Y = Yes WH33.9 WH34.1
N = No WH34.2 WH34.3
WH34.4
CPI-PATIENT-CLASS Alpha 1 CXCP.1 POIJ.1
Patient Class This provides for a category of patient. WH130 WH33.1
I = Inpatient WH33.2 WH33.3
O = Outpatient WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-MANUF-CODE Alpha 4 CXCP.1 POIJ.1
Manufacturer's Code This field contains a user-defined code WH130 WH33.1
that indicates the manufacturer of an WH33.2 WH33.3
item. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-MANUF-DIVISION Alpha 4 CXCP.1 POIJ.1
Manufacturer's This field contains a user-defined code WH130 WH33.1
Division that indicates which division of a WH33.2 WH33.3
manufacturer is tied to an item. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-MANUF-NBR Alpha 15 CXCP.1 POIJ.1
Manufacturer's Item This is the identifier that the WH130 WH33.1
Number manufacturer has assigned to an item. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-PK-PRINT-FLAG Alpha 1 CXCP.1 POIJ.1
Pick-List Print Flag Select the proper value to create a WH130 WH33.1
pick ticket, post items, complete the WH33.2 WH33.3
case, or reprocess a pick list for the WH33.4 WH33.5
item. WH33.6 WH33.8
WH33.9 WH34.1
When a line is changed, the system WH34.2 WH34.3
logic sets this flag to 4 (Reprocess) WH34.4
and the case status to 2 (Released).
1 = Create pick ticket
2 = Process post items
3 = Complete
4 = Reprocess
CPI-IF-REF-NBR Numeric 9 CXCP.1 POIJ.1
Reference Number This field contains an internally WH130 WH33.1
generated reference number used to track WH33.2 WH33.3
the case line item when creating a WH33.4 WH33.5
Purchase Order interface record or a WH33.6 WH33.8
Warehouse demand record. WH33.9 WH34.1
WH34.2 WH34.3
The value prints on CX100 (Pick List WH34.4
Print) and on WH130 (Pick List Print).
CPI-ORG-LINE-NBR Numeric 6 CXCP.1 POIJ.1
Org Line Nbr This field contains the original line WH130 WH33.1
number of the requisition. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-LEADTIME-DAYS Numeric 3 CXCP.1 POIJ.1
Leadtime Number of This field contains the average WH130 WH33.1
Days lead-time days. The average of the last WH33.2 WH33.3
and the previous lead-time days if WH33.4 WH33.5
system calculated. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-PUT-OUT-FL Numeric 3 CXCP.1 POIJ.1
Put Out Fl This field will show up on the printed WH130 WH33.1
pick list and preference list to show WH33.2 WH33.3
the quantity of an item that must be WH33.4 WH33.5
opened for the procedure. This will help WH33.6 WH33.8
reduce waste and returns. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-PO-CODE Alpha 4 CXCP.1 POIJ.1
Po Code This is the purchase order code that can WH130 WH33.1
be entered for a defaulted to a case WH33.2 WH33.3
item, and will be used on a purchase WH33.4 WH33.5
order created from the case item. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-FILL-OR-KILL Alpha 1
Fill Or Kill F = Fill Backorders
K = Kill Backorders
CPI-USE-IDENTIFIER Alpha 1 CXCP.1 POIJ.1
Use Identifier WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPI-CONSIGNMENT-FL Alpha 1 CXCP.1 POIJ.1
Consignment Fl WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CXPREFITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPISET1 COMPANY CXCP.1 POIJ.1
REQ-LOCATION WH130 WH33.1
CASE WH33.2 WH33.3
SEQ WH33.4 WH33.5
LINE-NBR WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPISET2 COMPANY KeyChange CXCP.1 POIJ.1
REQ-LOCATION WH130 WH33.1
CASE WH33.2 WH33.3
ALT-LINE-NBR WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPISET3 COMPANY KeyChange
REQ-LOCATION
POST-ITEM-FL
CASE
SEQ
LINE-NBR
ALT-LINE-NBR
CPISET4 COMPANY KeyChange
REQ-LOCATION
CASE
ITEM-TYPE
ITEM
SEQ
LINE-NBR
CPISET5 ATN-OBJ-ID KeyChange, Duplicates, Subset
Where ATN-OBJ-ID != Zeroes
CPISET6 COMPANY KeyChange
REQ-LOCATION
PROC-TYPE
PROC-CODE
PREF-CODE
CASE
SEQ
ALT-LINE-NBR
CPISET7 COMPANY KeyChange
REQ-LOCATION
CASE
SEQ
ALT-LINE-NBR
CPISET8 COMPANY KeyChange, Subset CXCP.1 POIJ.1
REQ-LOCATION Where DEMAND-CREATED = "Y" WH130 WH33.1
CASE WH33.2 WH33.3
IF-REF-NBR WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
CPISET9 COMPANY KeyChange, Subset POIJ.1
IF-REF-NBR Where((CREATE-PO-CD = "Y" )
And (IF-REF-NBR != Zeroes ))
CXPREFITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ccasehead CXCASEHEAD Not Required
CPI-COMPANY -> CXH-COMPANY
CPI-REQ-LOCATION -> CXH-REQ-LOCATION
CPI-CASE -> CXH-CASE
Cccasepref CXCASEPREF Required
CPI-COMPANY -> CXP-COMPANY
CPI-REQ-LOCATION -> CXP-REQ-LOCATION
CPI-CASE -> CXP-CASE
CPI-SEQ -> CXP-SEQ
From Location ICLOCATION Required
When CPI-FROM-LOCATION != Spaces
CPI-COMPANY -> ICL-COMPANY
CPI-FROM-LOCATION -> ICL-LOCATION
Gen Temp Item CXPTMPITEM Not Required
CPI-COMPANY -> CTI-COMPANY
CPI-REQ-LOCATION -> CTI-REQ-LOCATION
CPI-ITEM -> CTI-ITEM
CPI-PREF-CODE -> CTI-PREF-CODE
CPI-PROC-TYPE -> CTI-PROC-TYPE
CPI-PROC-CODE -> CTI-PROC-CODE
Spaces -> CTI-PRACTNR-ID
CPI-LINE-NBR -> CTI-LINE-NBR
Hcchrgitem HCCHRGITEM Not Required
CPI-COMPANY -> HCI-COMPANY
CPI-ITEM -> HCI-ITEM
CPI-REV-CENTER -> HCI-REV-CENTER
Iccompany ICCOMPANY Required
CPI-COMPANY -> ICC-COMPANY
Item Location ITEMLOC Not Required
Valid When CPI-FROM-LOCATION != Spaces
CPI-COMPANY -> ITL-COMPANY
CPI-FROM-LOCATION -> ITL-LOCATION
CPI-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When CPI-ITEM-TYPE = "I"
Or CPI-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
CPI-ITEM -> ITE-ITEM
Prac Temp Item CXPTMPITEM Not Required
CPI-COMPANY -> CTI-COMPANY
CPI-REQ-LOCATION -> CTI-REQ-LOCATION
CPI-ITEM -> CTI-ITEM
CPI-PREF-CODE -> CTI-PREF-CODE
CPI-PROC-TYPE -> CTI-PROC-TYPE
CPI-PROC-CODE -> CTI-PROC-CODE
CXP-PRACTNR-ID -> CTI-PRACTNR-ID
CPI-LINE-NBR -> CTI-LINE-NBR
Vendor APVENMAST Required
When CPI-VENDOR != Spaces
CPY-VENDOR-GROUP -> x u u ( -VENDOR-GROUP
CPI-VENDOR -> x u u ( -VENDOR
Vendor Group APCOMPANY Required
CPI-COMPANY -> CPY-COMPANY
Whdemand WHDEMAND Required
CPI-COMPANY -> WDM-COMPANY
"CX" -> WDM-SYSTEM-CD
CPI-CASE -> WDM-DOC-NBR
CPI-IF-REF-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
CPI-FROM-LOCATION -> WDM-LOCATION
Whdemndhdr WHDEMNDHDR Not Required
CPI-COMPANY -> WDH-COMPANY
"CX" -> WDH-SYSTEM-CD
CPI-CASE -> WDH-DOC-NBR
CXPREFITEM FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemsub ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
CPI-ITEM -> ITS-ITEM
"S" -> ITS-SUBTYPE
ITS-SUB-ITEM
Polinesrc POLINESRC
Valid When CPI-CREATE-PO-CD = "Y"
CPI-FROM-COMPANY -> PLS-OPER-COMPANY
CPI-IF-REF-NBR -> PLS-SOURCE-DOC-N
PLS-PO-CODE
PLS-PO-NUMBER
PLS-PO-RELEASE
PLS-LINE-NBR
Whshipline WHSHIPLINE
Valid When CPI-DEMAND-CREATED = "Y"
CPI-COMPANY -> WHL-COMPANY
"CX" -> WHL-SYSTEM-CD
CPI-CASE -> WHL-DOC-NBR
CPI-IF-REF-NBR -> WHL-LINE-NBR
WHL-SHIPMENT-NBR
Whshipment WHSHIPMENT
CPI-COMPANY -> WHS-COMPANY
CPI-FROM-LOCATION -> WHS-LOCATION
CPI-CASE -> WHS-DOC-NBR
WHS-SHIPMENT-NBR
|