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.
REFERENCED BY
PO100 CX230 CX240
UPDATED BY
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 OE114
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE830 OE950 PO31.1 RQ35.1
WH130 WH132 WH190 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPI-COMPANY Numeric 4 BL92.1 CX100
Company This field contains the company number. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-REQ-LOCATION Alpha 5 BL92.1 CX100
To Location This field contains the location CX20.1 CX20.2
requisitioning items and to be charged CX20.4 CX20.5
for the items. This location can be an CX220 CX30.1
inventory or noninventory location. CX300 CX506
CXCP.1 OE114
This value appears as the to location OE30.1 OE30.2
on pick lists printed when you run CX100 OE30.3 OE30.4
(Pick List Print) and WH130 (Pick List OE30.5 OE30.6
Print). OE30.7 OE30.9
OE830 OE950
Valid values are PO31.1 RQ35.1
WH130 WH132
A requesting location defined in RQ01.1 WH190 WH20.7
(Requesting Location) for the specified WH222 WH30.1
healthcare company. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-CASE Alpha 10 BL92.1 CX100
Case This field contains the unique CX20.1 CX20.2
identifier for the case. CX20.4 CX20.5
CX220 CX30.1
A case identifier is used in the Case CX300 CX506
Carts system to associate specific CXCP.1 OE114
tasks, practitioners, preference lists, OE30.1 OE30.2
and other information with a particular OE30.3 OE30.4
treatment course. This treatment course OE30.5 OE30.6
may consist of one or more procedures. OE30.7 OE30.9
The Case Carts system uses the case OE830 OE950
number to interface with an outside PO31.1 RQ35.1
scheduling system. WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-PREF-CODE Alpha 8 BL92.1 CX100
Preference Code This field contains the Preference List CX20.1 CX20.2
Code. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-PROC-TYPE Alpha 8 BL92.1 CX100
Procedure Type The procedure type is the first of two CX20.1 CX20.2
fields that uniquely identify a CX20.4 CX20.5
procedure. The procedure type can CX220 CX30.1
identify the code set to which the CX300 CX506
procedure code belongs. CXCP.1 OE114
OE30.1 OE30.2
For example, you can use one of the OE30.3 OE30.4
following codes: OE30.5 OE30.6
- CPT-4 for a code in the Current OE30.7 OE30.9
Procedural Terminology listing compiled OE830 OE950
by the American Medical Association PO31.1 RQ35.1
-HCPCS for a code in HCFA's (Health WH130 WH132
Care Financing Administration's) Common WH190 WH20.7
Procedure Coding System, or WH222 WH30.1
- A code defined for your WH30.2 WH30.3
organization's own procedures listing. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-PROC-CODE Alpha 8 BL92.1 CX100
Procedure Code The procedure code is the second of two CX20.1 CX20.2
fields that uniquely identify a CX20.4 CX20.5
procedure. The procedure code is an CX220 CX30.1
identifier for a specific procedure CX300 CX506
within a procedure type. CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-SEQ Numeric 3 BL92.1 CX100
Sequence Number This field contains the sequence of the CX20.1 CX20.2
preference list within the case. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ITEM Alpha 32 BL92.1 CX100
Item Number This field contains the item CX20.1 CX20.2
identifier. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ITEM-TYPE Alpha 1 BL92.1 CX100
Item Type This field identifies the line item CX20.1 CX20.2
type. CX20.4 CX20.5
CX220 CX30.1
Changes to this field that result in N, CX300 CX506
X, or X item types , update the Purchase CXCP.1 OE114
Order interface record. OE30.1 OE30.2
I = Inventoried Item OE30.3 OE30.4
N = Non-Stock Item OE30.5 OE30.6
S = Service Item OE30.7 OE30.9
X = Special Item OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-DESCRIPTION Alpha 30 (Lower Case) BL92.1 CX100
Description This field contains the description. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX240
CX30.1 CX300
CX506 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
CPI-LINE-NBR Numeric 6 BL92.1 CX100
Line Number This field contains the original item CX20.1 CX20.2
line number assigned by the Case Carts CX20.4 CX20.5
system when the item is added. For the CX220 CX30.1
line number displayed in CX20.2 (Case CX300 CX506
Detail), see Alt Line Nbr. CXCP.1 OE114
OE30.1 OE30.2
This file value is always 1 for the OE30.3 OE30.4
first item on a case preference. Thus, OE30.5 OE30.6
if there are two preferences on a case, OE30.7 OE30.9
they each start with line number 1. OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-UOM Alpha 4 BL92.1 CX100
Unit of Measure This field contains the valid stock CX20.1 CX20.2
unit of measure for this item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-QUANTITY Signed 13.4 BL92.1 CX100
Quantity This field contains the requested CX20.1 CX20.2
quantity to be picked. CX20.4 CX20.5
CX220 CX30.1
This field defaults to one (1) if no CX300 CX506
value is entered. This field is CXCP.1 OE114
required. OE30.1 OE30.2
OE30.3 OE30.4
Note: To change a line that is OE30.5 OE30.6
partially picked (such as for a case OE30.7 OE30.9
that has multiple care days), be sure OE830 OE950
that the quantity is equal to or greater PO31.1 RQ35.1
than the quantity already picked. WH130 WH132
WH190 WH20.7
(Care days are the total number of WH222 WH30.1
preoperative and postoperative days. For WH30.2 WH30.3
example, if the patient stay consists of WH31.1 WH31.2
day one for surgery and day two for WH31.3 WH32.1
postoperative care, the number of care WH32.2 WH32.3
days is one (1). You define care days in WH33.1 WH33.2
CX20.2 (Case Detail) in the Items tab on WH33.3 WH33.4
the Care Item detail tab.) WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-QUANTITY-USED Signed 13.4 BL92.1 CX100
Quantity Used This field contains the actual quantity CX20.1 CX20.2
of items used for this case. This amount CX20.4 CX20.5
can be more or less than the issued CX220 CX30.1
amount. CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-FROM-COMPANY Numeric 4 BL92.1 CX100
From-Company This is the company that is the source CX20.1 CX20.2
of the items. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-FROM-LOCATION Alpha 5 BL92.1 CX100
From-Location This is the inventory location that CX20.1 CX20.2
supplies the items or it is the purchase CX20.4 CX20.5
order ship to location that receives the CX220 CX240
items. CX30.1 CX300
CX506 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
CPI-PRICE Signed 15.2 BL92.1 CX100
Price This field contains the amount that the CX20.1 CX20.2
patient will be charged for the item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ISSUE-COST Signed 15.2 BL92.1 CX100
Issue Cost This field contains the issue cost. CX20.1 CX20.2
CX20.4 CX20.5
This cost defaults from CX05.1 CX220 CX30.1
(Preference Template) when a case is CX300 CX506
added using CX20.1 (Case Build) with the CXCP.1 OE114
following exception. OE30.1 OE30.2
OE30.3 OE30.4
For I or N type items, when you add a OE30.5 OE30.6
case, the system may replace the issue OE30.7 OE30.9
cost from the template with a new value. OE830 OE950
Such replacement occurs if the values PO31.1 RQ35.1
used in the cost logic have changed. For WH130 WH132
example, such a change can occur when WH190 WH20.7
the associated contract unit cost WH222 WH30.1
changes after the template is created. WH30.2 WH30.3
WH31.1 WH31.2
The cost logic defaults as follows and WH31.3 WH32.1
can be manually overridden: WH32.2 WH32.3
WH33.1 WH33.2
For inventoried (I) type items, the WH33.3 WH33.4
cost defaults from the Inventory Control WH33.5 WH33.6
system costing routine. WH33.8 WH33.9
WH34.1 WH34.2
For non-inventory-tracked (N) type WH34.3 WH34.4
items, the cost defaults from the WH40.1 WH40.2
Purchase Order system unit cost default WH520 WH830
routine. WO132 WO140
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 BL92.1 CX100
Accounting Unit This field contains the accounting CX20.1 CX20.2
unit. The accounting unit is a shorthand CX20.4 CX20.5
notation representing the variable level CX220 CX30.1
number. When used in the General Ledger CX300 CX506
Account Master file, the accounting unit CXCP.1 OE114
must be defined in the General Ledger OE30.1 OE30.2
Names file as a posting accounting unit. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ACCOUNT Numeric 6 BL92.1 CX100
Account This field contains the account. This CX20.1 CX20.2
field, along with the accounting unit CX20.4 CX20.5
and subaccount, make up the location CX220 CX30.1
(account) where amounts and other CX300 CX506
account information are stored. CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-SUB-ACCOUNT Numeric 4 BL92.1 CX100
Subaccount This field contains the subaccount. CX20.1 CX20.2
This field along with the accounting CX20.4 CX20.5
unit and subaccount make up the location CX220 CX30.1
(account) where amounts and other CX300 CX506
account information is stored. CXCP.1 OE114
OE30.1 OE30.2
This value must be a valid general OE30.3 OE30.4
ledger account (defined with the Acct OE30.5 OE30.6
Unit). When you release a case, this OE30.7 OE30.9
value updates the Purchase Order OE830 OE950
interface record. PO31.1 RQ35.1
WH130 WH132
If Item Type is I or Create PO flag is WH190 WH20.7
Yes, this field must contain a value. WH222 WH30.1
WH30.2 WH30.3
Defaults based on Requisition system WH31.1 WH31.2
default logic if blank and item type is WH31.3 WH32.1
I or the Create PO flag is set to Yes. WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-CHARGE-NBR Alpha 10 BL92.1 CX100
Charge Number This field contains the number, such as CX20.1 CX20.2
CDM (Charge Description Master), used by CX20.4 CX20.5
the patient billing system to charge CX220 CX30.1
patients for items used. CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-CHARGEABLE-FL Alpha 1 BL92.1 CX100
Chargeable Flag This flag indicates that this item is a CX20.1 CX20.2
patient chargeable item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ISSUE-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Issued Date This field contains the date of the CX20.1 CX20.2
transaction. CX20.4 CX20.5
CX220 CX30.1
The value must be zero (0) if the Case CX300 CX506
status is 1 (Unreleased). The system CXCP.1 OE114
updates this value based on changes in OE30.1 OE30.2
CX30.1 (Case Completion Feedback). OE30.3 OE30.4
OE30.5 OE30.6
Defaults to zero (0). OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ALT-LINE-NBR Numeric 6 BL92.1 CX100
Alternate Line Nbr This field contains the display value CX20.1 CX20.2
of the item line number. CX20.4 CX20.5
CX220 CX30.1
When you assign more than one CX300 CX506
preference template to a case, the CXCP.1 OE114
system assigns numbers to the items, OE30.1 OE30.2
sequentially, starting with 1 on the OE30.3 OE30.4
first preference and continuing OE30.5 OE30.6
sequentially through the next OE30.7 OE30.9
preferences. OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-CREATE-PO-CD Alpha 1 BL92.1 CX100
Create Purchase This code indicates whether this CX20.1 CX20.2
Order Code inventory item is to be purchased by CX20.4 CX20.5
purchase order instead of picked from CX220 CX30.1
inventory. CX300 CX506
CXCP.1 OE114
Select No for pick from inventory. OE30.1 OE30.2
OE30.3 OE30.4
Select Yes for create purchase order. OE30.5 OE30.6
OE30.7 OE30.9
Defaults to No if blank. OE830 OE950
Y = Yes PO31.1 RQ35.1
N = No WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-VENDOR Alpha 9 BL92.1 CX100
Vendor ID This field contains the vendor's CX20.1 CX20.2
identification code. CX20.4 CX20.5
CX220 CX30.1
The system may overwrite this value CX300 CX506
with output from the Purchase Order Unit CXCP.1 OE114
Cost Default routine. OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-TAXABLE-FLAG Alpha 1 BL92.1 CX100
Taxable or This field defines whether or not the CX20.1 CX20.2
Non-Taxable Flag item is taxable. CX20.4 CX20.5
CX220 CX30.1
This value updates the Purchase Order CX300 CX506
interface record when the case is CXCP.1 OE114
released. OE30.1 OE30.2
OE30.3 OE30.4
Defaults from the Item master for I and OE30.5 OE30.6
N item types or to No for X and S item OE30.7 OE30.9
types. OE830 OE950
Y = Yes PO31.1 RQ35.1
N = No WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-TAX-CODE Alpha 10 BL92.1 CX100
Tax Code This field contains a valid tax code CX20.1 CX20.2
representing specific tax information. CX20.4 CX20.5
CX220 CX30.1
This value updates the Purchase Order CX300 CX506
interface record when the case is CXCP.1 OE114
released. OE30.1 OE30.2
OE30.3 OE30.4
If the Taxable Flag is set to Yes, this OE30.5 OE30.6
field must contain a value. OE30.7 OE30.9
OE830 OE950
Defaults to spaces. PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-EARLY-DL-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Early Delivery Date This field contains the early delivery CX20.1 CX20.2
(Rqst DT) date. CX20.4 CX20.5
CX220 CX30.1
This value updates the Purchase Order CX300 CX506
interface record. CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-LATE-DL-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Late Delivery Date This field contains the late delivery CX20.1 CX20.2
date. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-CERT-REQ-FL Alpha 1 BL92.1 CX100
Certification This flag indicates whether a CX20.1 CX20.2
Required Flag certification is required for this line CX20.4 CX20.5
when it is purchased. This field value CX220 CX30.1
is passed to the purchase order when the CX300 CX506
purchase order line is created. CXCP.1 OE114
Y = Certification required. OE30.1 OE30.2
N = No certification required. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-INSP-REQ-FL Alpha 1 BL92.1 CX100
Inspection Required This flag indicates whether this item CX20.1 CX20.2
Flag has to be inspected when received in the CX20.4 CX20.5
Purchase Order system. CX220 CX30.1
CX300 CX506
If the Create PO flag is set to Yes, CXCP.1 OE114
this value updates the Purchase Order OE30.1 OE30.2
interface record when a case is OE30.3 OE30.4
released. OE30.5 OE30.6
OE30.7 OE30.9
Defaults to the value in the Insp Req OE830 OE950
Fl of the Itemloc file or defaults to PO31.1 RQ35.1
No. WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-REV-CENTER Alpha 5 BL92.1 CX100
Revenue Center The revenue center is the department CX20.1 CX20.2
that charges are associated with. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-POST-ITEM-FL Alpha 1 BL92.1 CX100
Post Item Flag This field indicates whether or not CX20.1 CX20.2
this line item is part of the procedure CX20.4 CX20.5
(an intraoperative item) or is a CX220 CX30.1
postoperative or preoperative item. CX300 CX506
1 = Intra-Op CXCP.1 OE114
2 = Post-Op OE30.1 OE30.2
3 = Pre-Op OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-POST-DAY Numeric 2 BL92.1 CX100
Posting Day This field defines the day of the CX20.1 CX20.2
patient visit when the item is to be CX20.4 CX20.5
used. A value of zero indicates the day CX220 CX30.1
of the procedure. When used with the CX300 CX506
Care Days field, this field indicates CXCP.1 OE114
the day to start picking care items. OE30.1 OE30.2
00 OE30.3 OE30.4
99 OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-SUB-ITEM-FL Alpha 1 BL92.1 CX100
Substitute Item Flag This field defines whether an item is a CX20.1 CX20.2
substitute or a replacement item. CX20.4 CX20.5
CX220 CX30.1
Blank indicates that no replacements or CX300 CX506
substitutions are defined. CXCP.1 OE114
OE30.1 OE30.2
This value must be blank for N, X, and OE30.3 OE30.4
S item types. OE30.5 OE30.6
OE30.7 OE30.9
Defaults to blank. OE830 OE950
R = Replacement PO31.1 RQ35.1
S = Substitute WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ORIG-ITEM-NBR Alpha 32 BL92.1 CX100
Original Item Number This field contains the original item CX20.1 CX20.2
number. CX20.4 CX20.5
CX220 CX30.1
A value must be provided if Sub Item Fl CX300 CX506
is not blank. CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-SERVICE-DATE Numeric 8 (yyyymmdd) BL92.1 CX100
Service Date This field identifies the date the item CX20.1 CX20.2
was used. This date is used by the CX20.4 CX20.5
billing system to identify the charges CX220 CX30.1
associated with this case. In the CX300 CX506
Patient Charge system, this date is CXCP.1 OE114
called the Charge Date. OE30.1 OE30.2
OE30.3 OE30.4
This value must be zero (0) if the Case OE30.5 OE30.6
status is 1 (Unreleased). OE30.7 OE30.9
OE830 OE950
Defaults to zero (0). PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-REPEAT-FL Alpha 1 BL92.1 CX100
Repeat Flag This field is reserved for a future CX20.1 CX20.2
release of the Case Carts system. CX20.4 CX20.5
Y = Yes CX220 CX30.1
N = No CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-NBR-DAYS Numeric 2 BL92.1 CX100
Number of Days Care days are the total number of days CX20.1 CX20.2
a preoperative or postoperative item CX20.4 CX20.5
will be used on the case, starting with CX220 CX30.1
the usage day. The day of the procedure CX300 CX506
is considered usage day 0. See note CXCP.1 OE114
below. OE30.1 OE30.2
OE30.3 OE30.4
The Care Days * Units Per Day must OE30.5 OE30.6
equal the Quantity if the Item Usage OE30.7 OE30.9
flag is set. OE830 OE950
PO31.1 RQ35.1
Defaults: WH130 WH132
WH190 WH20.7
The Care Days value defaults from WH222 WH30.1
CX05.1(Preference Template). WH30.2 WH30.3
WH31.1 WH31.2
Note: WH31.3 WH32.1
For example, if the patient stay WH32.2 WH32.3
consists of day one for both surgery and WH33.1 WH33.2
the use of intraoperative and WH33.3 WH33.4
postoperative items, the number of care WH33.5 WH33.6
days is 0. WH33.8 WH33.9
WH34.1 WH34.2
In another example, if the patient stay WH34.3 WH34.4
consists of two days, day one for the WH40.1 WH40.2
procedure (designated as usage day zero) WH520 WH830
and day two for postoperative care, the WO132 WO140
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 BL92.1 CX100
Units for a Day This field defines the number of item CX20.1 CX20.2
units to be used per day. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-PICK-FL Alpha 1 BL92.1 CX100
Picking Option Flag This field indicates in which system to CX20.1 CX20.2
print pick lists and pick items. CX20.4 CX20.5
CX220 CX30.1
Important: Your selection affects more CX300 CX506
than just printing the pick list. Your CXCP.1 OE114
selection affects whether shipment OE30.1 OE30.2
records will be created so that items OE30.3 OE30.4
are picked for the correct case (by OE30.5 OE30.6
shipment number). The shipment records OE30.7 OE30.9
also allow for further processing. See OE830 OE950
note below. PO31.1 RQ35.1
WH130 WH132
For inventoried (I) type items, you WH190 WH20.7
must select 1. WH222 WH30.1
WH30.2 WH30.3
For non-inventory-tracked (N, X, or, S) WH31.1 WH31.2
type items, you can select either 1, 2, WH31.3 WH32.1
or 3. WH32.2 WH32.3
WH33.1 WH33.2
For printing no pick lists, select 3. WH33.3 WH33.4
WH33.5 WH33.6
Note: You must run the pick list WH33.8 WH33.9
program (WH130 (Pick List Print)) in the WH34.1 WH34.2
Warehouse system to have the system WH34.3 WH34.4
create shipment records. (Later, when WH40.1 WH40.2
you run CX100 (Pick List Print), the WH520 WH830
shipment number created will appear on WO132 WO140
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 BL92.1 CX100
Returns and Waste This field indicates whether the item CX20.1 CX20.2
Flag is a return or waste item. CX20.4 CX20.5
CX220 CX30.1
Select Yes if the item is to be CX300 CX506
designated as a return or waste item. CXCP.1 OE114
(Returns are received items that must be OE30.1 OE30.2
sent back to the vendor or to the OE30.3 OE30.4
inventory, noninventory, or delivering OE30.5 OE30.6
location. Return items are replaced with OE30.7 OE30.9
no charge or credited. Waste items are OE830 OE950
items picked for a case but never used PO31.1 RQ35.1
and later disposed of and reported as WH130 WH132
waste during case completion feedback.) WH190 WH20.7
WH222 WH30.1
Select No if the Case status is 1 WH30.2 WH30.3
(Unreleased). WH31.1 WH31.2
WH31.3 WH32.1
Defaults to No. WH32.2 WH32.3
Y = Yes WH33.1 WH33.2
N = No WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ACCT-CATEGORY Alpha 5 BL92.1 CX100
Account Category This field contains a valid account CX20.1 CX20.2
category as defined in the Activity CX20.4 CX20.5
Management system. CX220 CX30.1
Note: Use of the Activity Management CX300 CX506
system to track and report costs CXCP.1 OE114
recorded in the Case Carts system is OE30.1 OE30.2
reserved for a future release. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ACTIVITY Alpha 15 BL92.1 CX100
Activity This field contains a valid activity CX20.1 CX20.2
code as defined in the Activity CX20.4 CX20.5
Management system. CX220 CX30.1
Note: Use of the Activity Management CX300 CX506
system to track and report costs CXCP.1 OE114
recorded in the Case Carts system is OE30.1 OE30.2
reserved for a future release. OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ATN-OBJ-ID Numeric 12 BL92.1 CX100
AC System Object ID This field contains a system-assigned CX20.1 CX20.2
(Sales) identifier that provides access to data CX20.4 CX20.5
in related files. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-STORAGE-LOC Alpha 7 BL92.1 CX100
Storage Location This field contains the storage CX20.1 CX20.2
location identifier. CX20.4 CX20.5
CX220 CX240
CX30.1 CX300
CX506 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WO132
WO140
CPI-STOCKLESS-FL Alpha 1 BL92.1 CX100
Stockless Flag This flag indicates whether or not the CX20.1 CX20.2
item is a stockless item. CX20.4 CX20.5
CX220 CX30.1
Note: Use of this field is reserved CX300 CX506
for a future release. CXCP.1 OE114
Y = Yes OE30.1 OE30.2
N = No OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-CONTRACT-NBR Alpha 14 BL92.1 CX100
Contract Number This is a number to indicate to the CX20.1 CX20.2
vendor which price agreement applies to CX20.4 CX20.5
an item or items. CX220 CX30.1
CX300 CX506
The system defaults this value from the CXCP.1 OE114
Purchase Order Unit Cost default OE30.1 OE30.2
routine. OE30.3 OE30.4
OE30.5 OE30.6
If this number is entered on or OE30.7 OE30.9
defaulted to a purchase order line, it OE830 OE950
is an indication of the vendor contract PO31.1 RQ35.1
to which that line is tied. The contract WH130 WH132
number can be defaulted to the purchase WH190 WH20.7
order line. This defaulting occurs by WH222 WH30.1
leaving the field blank when creating WH30.2 WH30.3
the purchase order. In such a case, the WH31.1 WH31.2
system attempts to find a contract WH31.3 WH32.1
number from a contract-type standard WH32.2 WH32.3
order based on the item number for the WH33.1 WH33.2
line and vendor for the purchase order. WH33.3 WH33.4
WH33.5 WH33.6
If no contract number is entered on or WH33.8 WH33.9
defaulted to the line from a WH34.1 WH34.2
contract-type standard order, a contract WH34.3 WH34.4
number entered on the purchase order WH40.1 WH40.2
header will default to the line. WH520 WH830
WO132 WO140
A contract number can also be tied to a
blanket type standard order, and any
purchase orders created from the blanket
order will have the contract number from
the blanket on the header and lines.
The contract number can also be
defaulted to a requisition line as the
requisition line is created. The
contract number will then be carried
over to the purchase order line that is
created from the requisition line.
This value updates the Purchase Order
interface record.
CPI-COST-CD Alpha 1 BL92.1 CX100
Unit Cost Origin This field contains the unit-cost CX20.1 CX20.2
Code origin code. When you build a case, this CX20.4 CX20.5
value is defaulted from the Purchase CX220 CX30.1
Order Unit Cost Default routine. The CX300 CX506
value updates the Purchase Order CXCP.1 OE114
interface record. OE30.1 OE30.2
E = Entered OE30.3 OE30.4
L = Last Cost OE30.5 OE30.6
Q = Quote OE30.7 OE30.9
S = Standard Order OE830 OE950
O = Order Entry PO31.1 RQ35.1
C = Contract WH130 WH132
N = Last PO Created WH190 WH20.7
Y = Copied From PO WH222 WH30.1
P = Override Contract WH30.2 WH30.3
D = Standard Cost WH31.1 WH31.2
A = Average Cost WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-NO-COST Alpha 1 BL92.1 CX100
No Cost This field indicates whether or not the CX20.1 CX20.2
item is a No Charge item. CX20.4 CX20.5
CX220 CX30.1
The value updates the Purchase Order CX300 CX506
interface record. CXCP.1 OE114
OE30.1 OE30.2
Defaults to No. OE30.3 OE30.4
Y = Yes OE30.5 OE30.6
N = No OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-SHIPPED-QTY Signed 13.4 BL92.1 CX100
Shipped Quantity This field contains the item shipped CX20.1 CX20.2
quantity. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-DEMAND-CREATED Alpha 1 BL92.1 CX100
Demand Created This field indicates whether demand was CX20.1 CX20.2
created. CX20.4 CX20.5
CX220 CX30.1
Select Yes if the demand was created. CX300 CX506
Y = Yes CXCP.1 OE114
N = No OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-PATIENT-CLASS Alpha 1 BL92.1 CX100
Patient Class This provides for a category of patient. CX20.1 CX20.2
I = Inpatient CX20.4 CX20.5
O = Outpatient CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-MANUF-CODE Alpha 4 BL92.1 CX100
Manufacturer's Code This field contains a user-defined code CX20.1 CX20.2
that indicates the manufacturer of an CX20.4 CX20.5
item. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-MANUF-DIVISION Alpha 4 BL92.1 CX100
Manufacturer's This field contains a user-defined code CX20.1 CX20.2
Division that indicates which division of a CX20.4 CX20.5
manufacturer is tied to an item. CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-MANUF-NBR Alpha 15 BL92.1 CX100
Manufacturer's Item This is the identifier that the CX20.1 CX20.2
Number manufacturer has assigned to an item. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-PK-PRINT-FLAG Alpha 1 BL92.1 CX100
Pick-List Print Flag Select the proper value to create a CX20.1 CX20.2
pick ticket, post items, complete the CX20.4 CX20.5
case, or reprocess a pick list for the CX220 CX30.1
item. CX300 CX506
CXCP.1 OE114
When a line is changed, the system OE30.1 OE30.2
logic sets this flag to 4 (Reprocess) OE30.3 OE30.4
and the case status to 2 (Released). OE30.5 OE30.6
1 = Create pick ticket OE30.7 OE30.9
2 = Process post items OE830 OE950
3 = Complete PO31.1 RQ35.1
4 = Reprocess WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-IF-REF-NBR Numeric 9 BL92.1 CX100
Reference Number This field contains an internally CX20.1 CX20.2
generated reference number used to track CX20.4 CX20.5
the case line item when creating a CX220 CX30.1
Purchase Order interface record or a CX300 CX506
Warehouse demand record. CXCP.1 OE114
OE30.1 OE30.2
The value prints on CX100 (Pick List OE30.3 OE30.4
Print) and on WH130 (Pick List Print). OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-ORG-LINE-NBR Numeric 6 BL92.1 CX100
Organization Line This field contains the original line CX20.1 CX20.2
Number number of the requisition. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-LEADTIME-DAYS Numeric 3 BL92.1 CX100
Leadtime Number of This field contains the average CX20.1 CX20.2
Days lead-time days. The average of the last CX20.4 CX20.5
and the previous lead-time days if CX220 CX30.1
system calculated. CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WO132 WO140
CPI-PUT-OUT-FL Numeric 3
Put Out Flag This field will show up on the printed
pick list and preference list to show
the quantity of an item that must be
opened for the procedure. This will help
reduce waste and returns.
CXPREFITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPISET1 COMPANY BL92.1 CX100
REQ-LOCATION CX20.1 CX20.2
CASE CX20.4 CX20.5
SEQ CX220 CX30.1
LINE-NBR CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO100 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
...
CPISET2 COMPANY KeyChange BL92.1 CX100
REQ-LOCATION CX20.1 CX20.2
CASE CX20.4 CX20.5
ALT-LINE-NBR CX220 CX230
CX240 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
...
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
CPISET6 COMPANY KeyChange
REQ-LOCATION
PROC-TYPE
PROC-CODE
PREF-CODE
CASE
SEQ
ALT-LINE-NBR
CPISET7 COMPANY KeyChange CX20.2
REQ-LOCATION
CASE
SEQ
ALT-LINE-NBR
CPISET8 COMPANY KeyChange, Subset BL92.1 CX100
REQ-LOCATION Where DEMAND-CREATED = "Y" CX20.1 CX20.2
CASE CX20.4 CX20.5
IF-REF-NBR CX220 CX30.1
CX300 CX506
CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
WH190 WH20.7
WH222 WH30.1
...
CPISET9 COMPANY KeyChange, Subset
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 (CXHSET1)
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
Po Item Vendor POITEMVEN Not Required
Valid When CPI-VENDOR != Spaces
CPI-COMPANY -> PIV-COMPANY
CPI-ITEM -> PIV-ITEM
CPI-VENDOR -> PIV-VENDOR
Pointerfac POINTERFAC Required
When ((CPI-CREATE-PO-CD = "Y" )
And (CPI-IF-REF-NBR != Zeroes ))
CPI-COMPANY -> PIF-COMPANY
"CX" -> PIF-ORIGIN-CD
CPI-IF-REF-NBR -> PIF-IF-REF-NBR
Zeroes -> PIF-ORDER-NBR
CPI-LINE-NBR -> PIF-LINE-NBR
CPI-SEQ -> PIF-SEQ
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 -> VEN-VENDOR-GROUP
CPI-VENDOR -> VEN-VENDOR
Vendor Group APCOMPANY Required
CPI-COMPANY -> CPY-COMPANY
Whdemand WHDEMAND Required
When CPI-DEMAND-CREATED = "Y"
CPI-COMPANY -> WDM-COMPANY
"CX" -> WDM-SYSTEM-CD
CPI-CASE -> WDM-DOC-NBR
CPI-IF-REF-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
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
ITS-SUB-ITEM
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
|