Lawson Insight Technical Documentation |
|
CXPREFITEM
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 CXCP.1 IC28.1 MA180 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 POI3.1 POIE.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ35.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 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 AP125 AP126
Element: Company This field contains the company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-REQ-LOCATION Alpha 5 AP125 AP126
Element: To Location This field contains the location AP131 AP25.1
requisitioning items and to be charged AP25.2 AP26.1
for the items. This location can be an AP27.1 AP30.4
inventory or noninventory location. BL120 BL122
BL130 BL20.1
This value appears as the to location BL20.3 BL21.2
on pick lists printed when you run CX100 BL21.5 BL29.1
(Pick List Print) and WH130 (Pick List BL29.2 BL520
Print). BL820 BL92.1
CXCP.1 IC28.1
Valid values are MA180 MA530
MA531 MA60.2
A requesting location defined in RQ01.1 MA60.3 MA60.5
(Requesting Location) for the specified MA61.1 MA66.2
healthcare company. MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-CASE Alpha 15 AP125 AP126
Element: Case This field contains the unique AP131 AP25.1
identifier for the case. AP25.2 AP26.1
AP27.1 AP30.4
A case identifier is used in the Case BL120 BL122
Carts system to associate specific BL130 BL20.1
tasks, practitioners, preference lists, BL20.3 BL21.2
and other information with a particular BL21.5 BL29.1
treatment course. This treatment course BL29.2 BL520
may consist of one or more procedures. BL820 BL92.1
The Case Carts system uses the case CXCP.1 IC28.1
number to interface with an outside MA180 MA530
scheduling system. MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PREF-CODE Alpha 8 AP125 AP126
Element: Procedure CodeThis field contains the Preference List AP131 AP25.1
Code. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PROC-TYPE Alpha 8 AP125 AP126
Element: Procedure CodeThe procedure type is the first of two AP131 AP25.1
fields that uniquely identify a AP25.2 AP26.1
procedure. The procedure type can AP27.1 AP30.4
identify the code set to which the BL120 BL122
procedure code belongs. BL130 BL20.1
BL20.3 BL21.2
For example, you can use one of the BL21.5 BL29.1
following codes: BL29.2 BL520
- CPT-4 for a code in the Current BL820 BL92.1
Procedural Terminology listing compiled CXCP.1 IC28.1
by the American Medical Association MA180 MA530
-HCPCS for a code in HCFA's (Health MA531 MA60.2
Care Financing Administration's) Common MA60.3 MA60.5
Procedure Coding System, or MA61.1 MA66.2
- A code defined for your MA66.3 MA67.1
organization's own procedures listing. MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PROC-CODE Alpha 8 AP125 AP126
Element: Procedure CodeThe procedure code is the second of two AP131 AP25.1
fields that uniquely identify a AP25.2 AP26.1
procedure. The procedure code is an AP27.1 AP30.4
identifier for a specific procedure BL120 BL122
within a procedure type. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeThis field contains the sequence of the AP131 AP25.1
preference list within the case. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ITEM-TYPE Alpha 1 AP125 AP126
Element: Item Type This field identifies the line item AP131 AP25.1
type. AP25.2 AP26.1
AP27.1 AP30.4
Changes to this field that result in N, BL120 BL122
X, or X item types , update the Purchase BL130 BL20.1
Order interface record. BL20.3 BL21.2
I = Inventoried Item BL21.5 BL29.1
N = Non-Stock Item BL29.2 BL520
S = Service Item BL820 BL92.1
X = Special Item CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-SERVICE-CODE Alpha 1 AP125 AP126
Element: Service Code " " = Not A Service Item AP131 AP25.1
A = Amount AP25.2 AP26.1
Q = Quantity AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description This field contains the description. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the original item AP131 AP25.1
line number assigned by the Case Carts AP25.2 AP26.1
system when the item is added. For the AP27.1 AP30.4
line number displayed in CX20.2 (Case BL120 BL122
Detail), see Alt Line Nbr. BL130 BL20.1
BL20.3 BL21.2
This file value is always 1 for the BL21.5 BL29.1
first item on a case preference. Thus, BL29.2 BL520
if there are two preferences on a case, BL820 BL92.1
they each start with line number 1. CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the valid stock AP131 AP25.1
unit of measure for this item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the requested AP131 AP25.1
quantity to be picked. AP25.2 AP26.1
AP27.1 AP30.4
This field defaults to one (1) if no BL120 BL122
value is entered. This field is BL130 BL20.1
required. BL20.3 BL21.2
BL21.5 BL29.1
Note: To change a line that is BL29.2 BL520
partially picked (such as for a case BL820 BL92.1
that has multiple care days), be sure CXCP.1 IC28.1
that the quantity is equal to or greater MA180 MA530
than the quantity already picked. MA531 MA60.2
MA60.3 MA60.5
(Care days are the total number of MA61.1 MA66.2
preoperative and postoperative days. For MA66.3 MA67.1
example, if the patient stay consists of MA67.2 MA70.1
day one for surgery and day two for MA75.1 MA80.1
postoperative care, the number of care MAI1.1 OE10.1
days is one (1). You define care days in OE10.2 OE10.3
CX20.2 (Case Detail) in the Items tab on OE10.4 OE10.5
the Care Item detail tab.) OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-QUANTITY-USED Signed 13.4 AP125 AP126
Element: Quantity This field contains the actual quantity AP131 AP25.1
of items used for this case. This amount AP25.2 AP26.1
can be more or less than the issued AP27.1 AP30.4
amount. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-FROM-COMPANY Numeric 4 AP125 AP126
Element: Company This is the company that is the source AP131 AP25.1
of the items. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-FROM-LOCATION Alpha 5 AP125 AP126
Element: Location Code This is the inventory location that AP131 AP25.1
supplies the items or it is the purchase AP25.2 AP26.1
order ship to location that receives the AP27.1 AP30.4
items. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PRICE Signed 18.2 AP125 AP126
Element: Intl Amt This field contains the amount that the AP131 AP25.1
patient will be charged for the item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ISSUE-COST Signed 18.2 AP125 AP126
Element: Intl Amt This field contains the issue cost. AP131 AP25.1
AP25.2 AP26.1
This cost defaults from CX05.1 AP27.1 AP30.4
(Preference Template) when a case is BL120 BL122
added using CX20.1 (Case Build) with the BL130 BL20.1
following exception. BL20.3 BL21.2
BL21.5 BL29.1
For I or N type items, when you add a BL29.2 BL520
case, the system may replace the issue BL820 BL92.1
cost from the template with a new value. CXCP.1 IC28.1
Such replacement occurs if the values MA180 MA530
used in the cost logic have changed. For MA531 MA60.2
example, such a change can occur when MA60.3 MA60.5
the associated contract unit cost MA61.1 MA66.2
changes after the template is created. MA66.3 MA67.1
MA67.2 MA70.1
The cost logic defaults as follows and MA75.1 MA80.1
can be manually overridden: MAI1.1 OE10.1
OE10.2 OE10.3
For inventoried (I) type items, the OE10.4 OE10.5
cost defaults from the Inventory Control OE10.6 OE10.7
system costing routine. OE10.8 OE11.1
OE11.4 OE11.8
For non-inventory-tracked (N) type OE11.9 OE110
items, the cost defaults from the OE111 OE113
Purchase Order system unit cost default OE114 OE116
routine. OE129 OE13.2
OE13.3 OE13.5
For X or S type items, the cost OE13.6 OE14.4
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 AP125 AP126
Element: Accounting UniThis field contains the accounting AP131 AP25.1
unit. The accounting unit is a shorthand AP25.2 AP26.1
notation representing the variable level AP27.1 AP30.4
number. When used in the General Ledger BL120 BL122
Account Master file, the accounting unit BL130 BL20.1
must be defined in the General Ledger BL20.3 BL21.2
Names file as a posting accounting unit. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field contains the account. This AP131 AP25.1
field, along with the accounting unit AP25.2 AP26.1
and subaccount, make up the location AP27.1 AP30.4
(account) where amounts and other BL120 BL122
account information are stored. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-SUB-ACCOUNT Numeric 4 AP125 AP126
Element: Subaccount This field contains the subaccount. AP131 AP25.1
This field along with the accounting AP25.2 AP26.1
unit and subaccount make up the location AP27.1 AP30.4
(account) where amounts and other BL120 BL122
account information is stored. BL130 BL20.1
BL20.3 BL21.2
This value must be a valid general BL21.5 BL29.1
ledger account (defined with the Acct BL29.2 BL520
Unit). When you release a case, this BL820 BL92.1
value updates the Purchase Order CXCP.1 IC28.1
interface record. MA180 MA530
MA531 MA60.2
If Item Type is I or Create PO flag is MA60.3 MA60.5
Yes, this field must contain a value. MA61.1 MA66.2
MA66.3 MA67.1
Defaults based on Requisition system MA67.2 MA70.1
default logic if blank and item type is MA75.1 MA80.1
I or the Create PO flag is set to Yes. MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-CHARGE-NBR Alpha 10 AP125 AP126
Element: Charge Nbr This field contains the number, such as AP131 AP25.1
CDM (Charge Description Master), used by AP25.2 AP26.1
the patient billing system to charge AP27.1 AP30.4
patients for items used. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-CHARGEABLE-FL Alpha 1 AP125 AP126
Element: All Flag This flag indicates that this item is a AP131 AP25.1
patient chargeable item. AP25.2 AP26.1
N = No AP27.1 AP30.4
Y = Yes BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ISSUE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Issued Date This field contains the date of the AP131 AP25.1
transaction. AP25.2 AP26.1
AP27.1 AP30.4
The value must be zero (0) if the Case BL120 BL122
status is 1 (Unreleased). The system BL130 BL20.1
updates this value based on changes in BL20.3 BL21.2
CX30.1 (Case Completion Feedback). BL21.5 BL29.1
BL29.2 BL520
Defaults to zero (0). BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ALT-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the display value AP131 AP25.1
of the item line number. AP25.2 AP26.1
AP27.1 AP30.4
When you assign more than one BL120 BL122
preference template to a case, the BL130 BL20.1
system assigns numbers to the items, BL20.3 BL21.2
sequentially, starting with 1 on the BL21.5 BL29.1
first preference and continuing BL29.2 BL520
sequentially through the next BL820 BL92.1
preferences. CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-CREATE-PO-CD Alpha 1 AP125 AP126
Create Purchase This code indicates whether this AP131 AP25.1
Order Code inventory item is to be purchased by AP25.2 AP26.1
purchase order instead of picked from AP27.1 AP30.4
inventory. BL120 BL122
BL130 BL20.1
Select No for pick from inventory. BL20.3 BL21.2
BL21.5 BL29.1
Select Yes for create purchase order. BL29.2 BL520
BL820 BL92.1
Defaults to No if blank. CXCP.1 IC28.1
Y = Yes MA180 MA530
N = No MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor ID This field contains the vendor's AP131 AP25.1
identification code. AP25.2 AP26.1
AP27.1 AP30.4
The system may overwrite this value BL120 BL122
with output from the Purchase Order Unit BL130 BL20.1
Cost Default routine. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-TAXABLE-FLAG Alpha 1 AP125 AP126
Taxable or This field defines whether or not the AP131 AP25.1
Non-Taxable Flag item is taxable. AP25.2 AP26.1
AP27.1 AP30.4
This value updates the Purchase Order BL120 BL122
interface record when the case is BL130 BL20.1
released. BL20.3 BL21.2
BL21.5 BL29.1
Defaults from the Item master for I and BL29.2 BL520
N item types or to No for X and S item BL820 BL92.1
types. CXCP.1 IC28.1
Y = Yes MA180 MA530
N = No MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-TAX-CODE Alpha 10 AP125 AP126
Element: Tax Code This field contains a valid tax code AP131 AP25.1
representing specific tax information. AP25.2 AP26.1
AP27.1 AP30.4
This value updates the Purchase Order BL120 BL122
interface record when the case is BL130 BL20.1
released. BL20.3 BL21.2
BL21.5 BL29.1
If the Taxable Flag is set to Yes, this BL29.2 BL520
field must contain a value. BL820 BL92.1
CXCP.1 IC28.1
Defaults to spaces. MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-EARLY-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Early Delivery Date This field contains the early delivery AP131 AP25.1
(Rqst DT) date. AP25.2 AP26.1
AP27.1 AP30.4
This value updates the Purchase Order BL120 BL122
interface record. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-LATE-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Late Delivery This field contains the late delivery AP131 AP25.1
date. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-CERT-REQ-FL Alpha 1 AP125 AP126
Certification This flag indicates whether a AP131 AP25.1
Required Flag certification is required for this line AP25.2 AP26.1
when it is purchased. This field value AP27.1 AP30.4
is passed to the purchase order when the BL120 BL122
purchase order line is created. BL130 BL20.1
Y = Certification required. BL20.3 BL21.2
N = No certification required. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-INSP-REQ-FL Alpha 1 AP125 AP126
Element: All Flag This flag indicates whether this item AP131 AP25.1
has to be inspected when received in the AP25.2 AP26.1
Purchase Order system. AP27.1 AP30.4
BL120 BL122
If the Create PO flag is set to Yes, BL130 BL20.1
this value updates the Purchase Order BL20.3 BL21.2
interface record when a case is BL21.5 BL29.1
released. BL29.2 BL520
BL820 BL92.1
Defaults to the value in the Insp Req CXCP.1 IC28.1
Fl of the Itemloc file or defaults to MA180 MA530
No. MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-REV-CENTER Alpha 5 AP125 AP126
Element: Rev Center The revenue center is the department AP131 AP25.1
that charges are associated with. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-POST-ITEM-FL Alpha 1 AP125 AP126
Element: Post Item Fl This field indicates whether or not AP131 AP25.1
this line item is part of the procedure AP25.2 AP26.1
(an intraoperative item) or is a AP27.1 AP30.4
postoperative or preoperative item. BL120 BL122
1 = Intra-Op BL130 BL20.1
2 = Post-Op BL20.3 BL21.2
3 = Pre-Op BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-POST-DAY Numeric 2 AP125 AP126
Element: Posting Day This field defines the day of the AP131 AP25.1
patient visit when the item is to be AP25.2 AP26.1
used. A value of zero indicates the day AP27.1 AP30.4
of the procedure. When used with the BL120 BL122
Care Days field, this field indicates BL130 BL20.1
the day to start picking care items. BL20.3 BL21.2
00 BL21.5 BL29.1
99 BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-SUB-ITEM-FL Alpha 1 AP125 AP126
Element: Sub Item Fl This field defines whether an item is a AP131 AP25.1
substitute or a replacement item. AP25.2 AP26.1
AP27.1 AP30.4
Blank indicates that no replacements or BL120 BL122
substitutions are defined. BL130 BL20.1
BL20.3 BL21.2
This value must be blank for N, X, and BL21.5 BL29.1
S item types. BL29.2 BL520
BL820 BL92.1
Defaults to blank. CXCP.1 IC28.1
R = Replacement MA180 MA530
S = Substitute MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ORIG-ITEM-NBR Alpha 32 AP125 AP126
Element: Item Number This field contains the original item AP131 AP25.1
number. AP25.2 AP26.1
AP27.1 AP30.4
A value must be provided if Sub Item Fl BL120 BL122
is not blank. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-SERVICE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Service Date This field identifies the date the item AP131 AP25.1
was used. This date is used by the AP25.2 AP26.1
billing system to identify the charges AP27.1 AP30.4
associated with this case. In the BL120 BL122
Patient Charge system, this date is BL130 BL20.1
called the Charge Date. BL20.3 BL21.2
BL21.5 BL29.1
This value must be zero (0) if the Case BL29.2 BL520
status is 1 (Unreleased). BL820 BL92.1
CXCP.1 IC28.1
Defaults to zero (0). MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-REPEAT-FL Alpha 1 AP125 AP126
Element: All Flag This field is reserved for a future AP131 AP25.1
release of the Case Carts system. AP25.2 AP26.1
Y = Yes AP27.1 AP30.4
N = No BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-NBR-DAYS Numeric 2 AP125 AP126
Element: Number of DaysCare days are the total number of days AP131 AP25.1
a preoperative or postoperative item AP25.2 AP26.1
will be used on the case, starting with AP27.1 AP30.4
the usage day. The day of the procedure BL120 BL122
is considered usage day 0. See note BL130 BL20.1
below. BL20.3 BL21.2
BL21.5 BL29.1
The Care Days * Units Per Day must BL29.2 BL520
equal the Quantity if the Item Usage BL820 BL92.1
flag is set. CXCP.1 IC28.1
MA180 MA530
Defaults: MA531 MA60.2
MA60.3 MA60.5
The Care Days value defaults from MA61.1 MA66.2
CX05.1(Preference Template). MA66.3 MA67.1
MA67.2 MA70.1
Note: MA75.1 MA80.1
For example, if the patient stay MAI1.1 OE10.1
consists of day one for both surgery and OE10.2 OE10.3
the use of intraoperative and OE10.4 OE10.5
postoperative items, the number of care OE10.6 OE10.7
days is 0. OE10.8 OE11.1
OE11.4 OE11.8
In another example, if the patient stay OE11.9 OE110
consists of two days, day one for the OE111 OE113
procedure (designated as usage day zero) OE114 OE116
and day two for postoperative care, the OE129 OE13.2
number of care days is 1. OE13.3 OE13.5
OE13.6 OE14.4
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 AP125 AP126
Element: Units Per Day This field defines the number of item AP131 AP25.1
units to be used per day. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PICK-FL Alpha 1 AP125 AP126
Element: Picking OptionThis field indicates in which system to AP131 AP25.1
print pick lists and pick items. AP25.2 AP26.1
AP27.1 AP30.4
Important: Your selection affects more BL120 BL122
than just printing the pick list. Your BL130 BL20.1
selection affects whether shipment BL20.3 BL21.2
records will be created so that items BL21.5 BL29.1
are picked for the correct case (by BL29.2 BL520
shipment number). The shipment records BL820 BL92.1
also allow for further processing. See CXCP.1 IC28.1
note below. MA180 MA530
MA531 MA60.2
For inventoried (I) type items, you MA60.3 MA60.5
must select 1. MA61.1 MA66.2
MA66.3 MA67.1
For non-inventory-tracked (N, X, or, S) MA67.2 MA70.1
type items, you can select either 1, 2, MA75.1 MA80.1
or 3. MAI1.1 OE10.1
OE10.2 OE10.3
For printing no pick lists, select 3. OE10.4 OE10.5
OE10.6 OE10.7
Note: You must run the pick list OE10.8 OE11.1
program (WH130 (Pick List Print)) in the OE11.4 OE11.8
Warehouse system to have the system OE11.9 OE110
create shipment records. (Later, when OE111 OE113
you run CX100 (Pick List Print), the OE114 OE116
shipment number created will appear on OE129 OE13.2
the CX100 pick list. The shipment number OE13.3 OE13.5
on the pick list helps you to match OE13.6 OE14.4
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 AP125 AP126
Element: All Flag This field indicates whether the item AP131 AP25.1
is a return or waste item. AP25.2 AP26.1
AP27.1 AP30.4
Select Yes if the item is to be BL120 BL122
designated as a return or waste item. BL130 BL20.1
(Returns are received items that must be BL20.3 BL21.2
sent back to the vendor or to the BL21.5 BL29.1
inventory, noninventory, or delivering BL29.2 BL520
location. Return items are replaced with BL820 BL92.1
no charge or credited. Waste items are CXCP.1 IC28.1
items picked for a case but never used MA180 MA530
and later disposed of and reported as MA531 MA60.2
waste during case completion feedback.) MA60.3 MA60.5
MA61.1 MA66.2
Select No if the Case status is 1 MA66.3 MA67.1
(Unreleased). MA67.2 MA70.1
MA75.1 MA80.1
Defaults to No. MAI1.1 OE10.1
Y = Yes OE10.2 OE10.3
N = No OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ACCT-CATEGORY Alpha 5 AP125 AP126
Element: Account CategoThis field contains a valid account AP131 AP25.1
category as defined in the Activity AP25.2 AP26.1
Management system. AP27.1 AP30.4
Note: Use of the Activity Management BL120 BL122
system to track and report costs BL130 BL20.1
recorded in the Case Carts system is BL20.3 BL21.2
reserved for a future release. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ACTIVITY Alpha 15 AP125 AP126
Element: Activity This field contains a valid activity AP131 AP25.1
code as defined in the Activity AP25.2 AP26.1
Management system. AP27.1 AP30.4
Note: Use of the Activity Management BL120 BL122
system to track and report costs BL130 BL20.1
recorded in the Case Carts system is BL20.3 BL21.2
reserved for a future release. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ATN-OBJ-ID Numeric 12 AP125 AP126
Object This field contains a system-assigned AP131 AP25.1
Identification identifier that provides access to data AP25.2 AP26.1
in related files. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-STORAGE-LOC Alpha 7 AP125 AP126
Element: Bin This field contains the storage AP131 AP25.1
location identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-STOCKLESS-FL Alpha 1 AP125 AP126
Element: All Flag This flag indicates whether or not the AP131 AP25.1
item is a stockless item. AP25.2 AP26.1
AP27.1 AP30.4
Note: Use of this field is reserved BL120 BL122
for a future release. BL130 BL20.1
Y = Yes BL20.3 BL21.2
N = No BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-AGREEMENT-REF Alpha 30 AP125 AP126
Element: Agreement Ref AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-COST-CD Alpha 1 AP125 AP126
Unit Cost Origin This field contains the unit-cost AP131 AP25.1
Code origin code. When you build a case, this AP25.2 AP26.1
value is defaulted from the Purchase AP27.1 AP30.4
Order Unit Cost Default routine. The BL120 BL122
value updates the Purchase Order BL130 BL20.1
interface record. BL20.3 BL21.2
E = Entered BL21.5 BL29.1
L = Last Cost BL29.2 BL520
C = Contract BL820 BL92.1
T = Catalog/Quote CXCP.1 IC28.1
B = Blanket MA180 MA530
P = Lat PO Created MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-COST-OPTION Alpha 1 AP125 AP126
Element: Cost Option 1 = Cost Required AP131 AP25.1
2 = No Charge AP25.2 AP26.1
3 = Vendor Determined AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-SHIPPED-QTY Signed 13.4 AP125 AP126
Element: Quantity This field contains the item shipped AP131 AP25.1
quantity. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-DEMAND-CREATED Alpha 1 AP125 AP126
Element: All Flag This field indicates whether demand was AP131 AP25.1
created. AP25.2 AP26.1
AP27.1 AP30.4
Select Yes if the demand was created. BL120 BL122
Y = Yes BL130 BL20.1
N = No BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PATIENT-CLASS Alpha 1 AP125 AP126
Element: Patient Class This provides for a category of patient. AP131 AP25.1
I = Inpatient AP25.2 AP26.1
O = Outpatient AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-MANUF-CODE Alpha 4 AP125 AP126
Element: Manufacturer'sThis field contains a user-defined code AP131 AP25.1
that indicates the manufacturer of an AP25.2 AP26.1
item. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-MANUF-DIVISION Alpha 4 AP125 AP126
Manufacturer's This field contains a user-defined code AP131 AP25.1
Division that indicates which division of a AP25.2 AP26.1
manufacturer is tied to an item. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-MANUF-NBR Alpha 15 AP125 AP126
Manufacturer's Item This is the identifier that the AP131 AP25.1
Number manufacturer has assigned to an item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PK-PRINT-FLAG Alpha 1 AP125 AP126
Element: Pick-List PrinSelect the proper value to create a AP131 AP25.1
pick ticket, post items, complete the AP25.2 AP26.1
case, or reprocess a pick list for the AP27.1 AP30.4
item. BL120 BL122
BL130 BL20.1
When a line is changed, the system BL20.3 BL21.2
logic sets this flag to 4 (Reprocess) BL21.5 BL29.1
and the case status to 2 (Released). BL29.2 BL520
1 = Create pick ticket BL820 BL92.1
2 = Process post items CXCP.1 IC28.1
3 = Complete MA180 MA530
4 = Reprocess MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-IF-REF-NBR Numeric 9 AP125 AP126
Element: Reference NumbThis field contains an internally AP131 AP25.1
generated reference number used to track AP25.2 AP26.1
the case line item when creating a AP27.1 AP30.4
Purchase Order interface record or a BL120 BL122
Warehouse demand record. BL130 BL20.1
BL20.3 BL21.2
The value prints on CX100 (Pick List BL21.5 BL29.1
Print) and on WH130 (Pick List Print). BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-ORG-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the original line AP131 AP25.1
number of the requisition. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-LEADTIME-DAYS Numeric 3 AP125 AP126
Leadtime Number of This field contains the average AP131 AP25.1
Days lead-time days. The average of the last AP25.2 AP26.1
and the previous lead-time days if AP27.1 AP30.4
system calculated. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PUT-OUT-FL Numeric 3 AP125 AP126
Element: Put Out Fl This field will show up on the printed AP131 AP25.1
pick list and preference list to show AP25.2 AP26.1
the quantity of an item that must be AP27.1 AP30.4
opened for the procedure. This will help BL120 BL122
reduce waste and returns. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code that can AP131 AP25.1
be entered for a defaulted to a case AP25.2 AP26.1
item, and will be used on a purchase AP27.1 AP30.4
order created from the case item. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-FILL-OR-KILL Alpha 1
Element: Fill Or Kill F = Fill Backorders
K = Kill Backorders
CPI-USE-IDENTIFIER Alpha 1 AP125 AP126
Element: Use Identifier AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CPI-CONSIGNMENT-FL Alpha 1 AP125 AP126
Element: Consignment Fl AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CXPREFITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CPISET1 COMPANY AP125 AP126
REQ-LOCATION AP131 AP25.1
CASE AP25.2 AP26.1
SEQ AP27.1 AP30.4
LINE-NBR BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
CPISET2 COMPANY KeyChange AP125 AP126
REQ-LOCATION AP131 AP25.1
CASE AP25.2 AP26.1
ALT-LINE-NBR AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
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
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 AP125 AP126
REQ-LOCATION Where DEMAND-CREATED = "Y" AP131 AP25.1
CASE AP25.2 AP26.1
IF-REF-NBR AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
CPISET9 COMPANY KeyChange, Subset AP125 AP126
IF-REF-NBR Where((CREATE-PO-CD = "Y" ) AP131 AP25.1
And (IF-REF-NBR != Zeroes )) AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
CXPREFITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ccasehead CXCASEHEAD Not Required
CPI-COMPANY -> -COMPANY
CPI-REQ-LOCATION -> -REQ-LOCATION
CPI-CASE -> -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 -> VEN-VENDOR-GROUP
CPI-VENDOR -> VEN-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
|