 |
Lawson Insight Technical Documentation |
|
CXPREFITEM FILE
Preference Items
The Preference Items file contains the items that are defined for use in a
procedure. Use CX20.1 (Case Build) to create this file. When you assign a
preference template to a case and add the case, the items for the preference
template automatically default to this file. Use CX20.2 (Case Detail) to add,
substitute, or delete items from a case.
Releasing a case causes the Case Carts system logic to access this file. The
system uses this data to add or re-add demand records, allocate inventory (if
allocation criteria are met), and create a Purchase Order interface record if
Create PO in this file is set to Yes.
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 CXCP.1 IC28.1 MA180 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.3
MA67.1 MA67.2 MA70.1 MAI1.1 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CPI-COMPANY Numeric 4 AP125 AP126
Company This field contains the company number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-REQ-LOCATION Alpha 5 AP125 AP126
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 CXCP.1
inventory or noninventory location. IC28.1 MA180
MA43.9 MA530
This value appears as the to location MA531 MA60.2
on pick lists printed when you run CX100 MA60.3 MA60.5
(Pick List Print) and WH130 (Pick List MA61.1 MA66.3
Print). MA67.1 MA67.2
MA70.1 MAI1.1
Valid values are PO100 PO101
PO122 PO131
A requesting location defined in RQ01.1 PO20.1 PO21.2
(Requesting Location) for the specified PO21.3 PO21.4
healthcare company. 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
...
CPI-CASE Alpha 15 AP125 AP126
Case This field contains the unique AP131 AP25.1
identifier for the case. AP25.2 AP26.1
AP27.1 CXCP.1
A case identifier is used in the Case IC28.1 MA180
Carts system to associate specific MA43.9 MA530
tasks, practitioners, preference lists, MA531 MA60.2
and other information with a particular MA60.3 MA60.5
treatment course. This treatment course MA61.1 MA66.3
may consist of one or more procedures. MA67.1 MA67.2
The Case Carts system uses the case MA70.1 MAI1.1
number to interface with an outside PO100 PO101
scheduling system. 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
...
CPI-PREF-CODE Alpha 8 AP125 AP126
Preference Code This field contains the Preference List AP131 AP25.1
Code. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-PROC-TYPE Alpha 8 AP125 AP126
Proc Type The 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 CXCP.1
identify the code set to which the IC28.1 MA180
procedure code belongs. MA43.9 MA530
MA531 MA60.2
For example, you can use one of the MA60.3 MA60.5
following codes: MA61.1 MA66.3
- CPT-4 for a code in the Current MA67.1 MA67.2
Procedural Terminology listing compiled MA70.1 MAI1.1
by the American Medical Association PO100 PO101
-HCPCS for a code in HCFA's (Health PO122 PO131
Care Financing Administration's) Common PO20.1 PO21.2
Procedure Coding System, or PO21.3 PO21.4
- A code defined for your PO21.5 PO22.1
organization's own procedures listing. 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
...
CPI-PROC-CODE Alpha 8 AP125 AP126
Procedure Code The 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 CXCP.1
identifier for a specific procedure IC28.1 MA180
within a procedure type. MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-SEQ Numeric 3 AP125 AP126
Sequence Number This field contains the sequence of the AP131 AP25.1
preference list within the case. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ITEM-TYPE Alpha 1 AP125 AP126
Item Type This field identifies the line item AP131 AP25.1
type. AP25.2 AP26.1
AP27.1 CXCP.1
Changes to this field that result in N, IC28.1 MA180
X, or X item types , update the Purchase MA43.9 MA530
Order interface record. MA531 MA60.2
I = Inventoried Item MA60.3 MA60.5
N = Non-Stock Item MA61.1 MA66.3
S = Service Item MA67.1 MA67.2
X = Special Item MA70.1 MAI1.1
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
...
CPI-SERVICE-CODE Alpha 1 AP125 AP126
Service Code " " = Not A Service Item AP131 AP25.1
A = Amount AP25.2 AP26.1
Q = Quantity AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description This field contains the description. AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-LINE-NBR Numeric 6 AP125 AP126
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 CXCP.1
line number displayed in CX20.2 (Case IC28.1 MA180
Detail), see Alt Line Nbr. MA43.9 MA530
MA531 MA60.2
This file value is always 1 for the MA60.3 MA60.5
first item on a case preference. Thus, MA61.1 MA66.3
if there are two preferences on a case, MA67.1 MA67.2
they each start with line number 1. MA70.1 MAI1.1
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
...
CPI-UOM Alpha 4 AP125 AP126
Unit of Measure This field contains the valid stock AP131 AP25.1
unit of measure for this item. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-QUANTITY Signed 13.4 AP125 AP126
Quantity This field contains the requested AP131 AP25.1
quantity to be picked. AP25.2 AP26.1
AP27.1 CXCP.1
This field defaults to one (1) if no IC28.1 MA180
value is entered. This field is MA43.9 MA530
required. MA531 MA60.2
MA60.3 MA60.5
Note: To change a line that is MA61.1 MA66.3
partially picked (such as for a case MA67.1 MA67.2
that has multiple care days), be sure MA70.1 MAI1.1
that the quantity is equal to or greater PO100 PO101
than the quantity already picked. PO122 PO131
PO20.1 PO21.2
(Care days are the total number of PO21.3 PO21.4
preoperative and postoperative days. For PO21.5 PO22.1
example, if the patient stay consists of PO23.1 PO29.1
day one for surgery and day two for PO30.1 PO30.2
postoperative care, the number of care PO30.3 PO300
days is one (1). You define care days in PO31.1 PO31.2
CX20.2 (Case Detail) in the Items tab on PO32.2 PO33.1
the Care Item detail tab.) 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
...
CPI-QUANTITY-USED Signed 13.4 AP125 AP126
Quantity Used 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 CXCP.1
amount. IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-FROM-COMPANY Numeric 4 AP125 AP126
From Company This is the company that is the source AP131 AP25.1
of the items. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-FROM-LOCATION Alpha 5 AP125 AP126
From Location 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 CXCP.1
items. IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-PRICE Signed 15.2 AP125 AP126
Price This field contains the amount that the AP131 AP25.1
patient will be charged for the item. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ISSUE-COST Signed 15.2 AP125 AP126
Issue Cost This field contains the issue cost. AP131 AP25.1
AP25.2 AP26.1
This cost defaults from CX05.1 AP27.1 CXCP.1
(Preference Template) when a case is IC28.1 MA180
added using CX20.1 (Case Build) with the MA43.9 MA530
following exception. MA531 MA60.2
MA60.3 MA60.5
For I or N type items, when you add a MA61.1 MA66.3
case, the system may replace the issue MA67.1 MA67.2
cost from the template with a new value. MA70.1 MAI1.1
Such replacement occurs if the values PO100 PO101
used in the cost logic have changed. For PO122 PO131
example, such a change can occur when PO20.1 PO21.2
the associated contract unit cost PO21.3 PO21.4
changes after the template is created. PO21.5 PO22.1
PO23.1 PO29.1
The cost logic defaults as follows and PO30.1 PO30.2
can be manually overridden: PO30.3 PO300
PO31.1 PO31.2
For inventoried (I) type items, the PO32.2 PO33.1
cost defaults from the Inventory Control PO34.1 PO35.1
system costing routine. PO38.1 PO39.1
PO39.2 PO44.1
For non-inventory-tracked (N) type PO50.1 PO52.1
items, the cost defaults from the PO520 POI3.1
Purchase Order system unit cost default POIE.1 POII.1
routine. POIJ.1 RQ10.1
RQ10.2 RQ35.1
For X or S type items, the cost WH130 WH132
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
Accounting Unit This 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 CXCP.1
number. When used in the General Ledger IC28.1 MA180
Account Master file, the accounting unit MA43.9 MA530
must be defined in the General Ledger MA531 MA60.2
Names file as a posting accounting unit. MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ACCOUNT Numeric 6 AP125 AP126
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 CXCP.1
(account) where amounts and other IC28.1 MA180
account information are stored. MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-SUB-ACCOUNT Numeric 4 AP125 AP126
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 CXCP.1
(account) where amounts and other IC28.1 MA180
account information is stored. MA43.9 MA530
MA531 MA60.2
This value must be a valid general MA60.3 MA60.5
ledger account (defined with the Acct MA61.1 MA66.3
Unit). When you release a case, this MA67.1 MA67.2
value updates the Purchase Order MA70.1 MAI1.1
interface record. PO100 PO101
PO122 PO131
If Item Type is I or Create PO flag is PO20.1 PO21.2
Yes, this field must contain a value. PO21.3 PO21.4
PO21.5 PO22.1
Defaults based on Requisition system PO23.1 PO29.1
default logic if blank and item type is PO30.1 PO30.2
I or the Create PO flag is set to Yes. 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
...
CPI-CHARGE-NBR Alpha 10 AP125 AP126
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 CXCP.1
patients for items used. IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-CHARGEABLE-FL Alpha 1 AP125 AP126
Chargeable Fl This flag indicates that this item is a AP131 AP25.1
patient chargeable item. AP25.2 AP26.1
N = No AP27.1 CXCP.1
Y = Yes IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ISSUE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Issued Date This field contains the date of the AP131 AP25.1
transaction. AP25.2 AP26.1
AP27.1 CXCP.1
The value must be zero (0) if the Case IC28.1 MA180
status is 1 (Unreleased). The system MA43.9 MA530
updates this value based on changes in MA531 MA60.2
CX30.1 (Case Completion Feedback). MA60.3 MA60.5
MA61.1 MA66.3
Defaults to zero (0). MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ALT-LINE-NBR Numeric 6 AP125 AP126
Alt Line Nbr This field contains the display value AP131 AP25.1
of the item line number. AP25.2 AP26.1
AP27.1 CXCP.1
When you assign more than one IC28.1 MA180
preference template to a case, the MA43.9 MA530
system assigns numbers to the items, MA531 MA60.2
sequentially, starting with 1 on the MA60.3 MA60.5
first preference and continuing MA61.1 MA66.3
sequentially through the next MA67.1 MA67.2
preferences. MA70.1 MAI1.1
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
...
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 CXCP.1
inventory. IC28.1 MA180
MA43.9 MA530
Select No for pick from inventory. MA531 MA60.2
MA60.3 MA60.5
Select Yes for create purchase order. MA61.1 MA66.3
MA67.1 MA67.2
Defaults to No if blank. MA70.1 MAI1.1
Y = Yes PO100 PO101
N = No 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
...
CPI-VENDOR Alpha 9 (Right Justified) AP125 AP126
Vendor ID This field contains the vendor's AP131 AP25.1
identification code. AP25.2 AP26.1
AP27.1 CXCP.1
The system may overwrite this value IC28.1 MA180
with output from the Purchase Order Unit MA43.9 MA530
Cost Default routine. MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 CXCP.1
This value updates the Purchase Order IC28.1 MA180
interface record when the case is MA43.9 MA530
released. MA531 MA60.2
MA60.3 MA60.5
Defaults from the Item master for I and MA61.1 MA66.3
N item types or to No for X and S item MA67.1 MA67.2
types. MA70.1 MAI1.1
Y = Yes PO100 PO101
N = No 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
...
CPI-TAX-CODE Alpha 10 AP125 AP126
Tax Code This field contains a valid tax code AP131 AP25.1
representing specific tax information. AP25.2 AP26.1
AP27.1 CXCP.1
This value updates the Purchase Order IC28.1 MA180
interface record when the case is MA43.9 MA530
released. MA531 MA60.2
MA60.3 MA60.5
If the Taxable Flag is set to Yes, this MA61.1 MA66.3
field must contain a value. MA67.1 MA67.2
MA70.1 MAI1.1
Defaults to spaces. 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
...
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 CXCP.1
This value updates the Purchase Order IC28.1 MA180
interface record. MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-LATE-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Late Delivery Date This field contains the late delivery AP131 AP25.1
date. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 CXCP.1
is passed to the purchase order when the IC28.1 MA180
purchase order line is created. MA43.9 MA530
Y = Certification required. MA531 MA60.2
N = No certification required. MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-INSP-REQ-FL Alpha 1 AP125 AP126
Inspection Required This flag indicates whether this item AP131 AP25.1
Flag has to be inspected when received in the AP25.2 AP26.1
Purchase Order system. AP27.1 CXCP.1
IC28.1 MA180
If the Create PO flag is set to Yes, MA43.9 MA530
this value updates the Purchase Order MA531 MA60.2
interface record when a case is MA60.3 MA60.5
released. MA61.1 MA66.3
MA67.1 MA67.2
Defaults to the value in the Insp Req MA70.1 MAI1.1
Fl of the Itemloc file or defaults to PO100 PO101
No. 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
...
CPI-REV-CENTER Alpha 5 AP125 AP126
Rev Center The revenue center is the department AP131 AP25.1
that charges are associated with. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-POST-ITEM-FL Alpha 1 AP125 AP126
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 CXCP.1
postoperative or preoperative item. IC28.1 MA180
1 = Intra-Op MA43.9 MA530
2 = Post-Op MA531 MA60.2
3 = Pre-Op MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-POST-DAY Numeric 2 AP125 AP126
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 CXCP.1
of the procedure. When used with the IC28.1 MA180
Care Days field, this field indicates MA43.9 MA530
the day to start picking care items. MA531 MA60.2
00 MA60.3 MA60.5
99 MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-SUB-ITEM-FL Alpha 1 AP125 AP126
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 CXCP.1
Blank indicates that no replacements or IC28.1 MA180
substitutions are defined. MA43.9 MA530
MA531 MA60.2
This value must be blank for N, X, and MA60.3 MA60.5
S item types. MA61.1 MA66.3
MA67.1 MA67.2
Defaults to blank. MA70.1 MAI1.1
R = Replacement PO100 PO101
S = Substitute 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
...
CPI-ORIG-ITEM-NBR Alpha 32 AP125 AP126
Orig Item Nbr This field contains the original item AP131 AP25.1
number. AP25.2 AP26.1
AP27.1 CXCP.1
A value must be provided if Sub Item Fl IC28.1 MA180
is not blank. MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-SERVICE-DATE Numeric 8 (yyyymmdd) AP125 AP126
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 CXCP.1
associated with this case. In the IC28.1 MA180
Patient Charge system, this date is MA43.9 MA530
called the Charge Date. MA531 MA60.2
MA60.3 MA60.5
This value must be zero (0) if the Case MA61.1 MA66.3
status is 1 (Unreleased). MA67.1 MA67.2
MA70.1 MAI1.1
Defaults to zero (0). 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
...
CPI-REPEAT-FL Alpha 1 AP125 AP126
Repeat Fl This field is reserved for a future AP131 AP25.1
release of the Case Carts system. AP25.2 AP26.1
Y = Yes AP27.1 CXCP.1
N = No IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-NBR-DAYS Numeric 2 AP125 AP126
Number of Days Care 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 CXCP.1
the usage day. The day of the procedure IC28.1 MA180
is considered usage day 0. See note MA43.9 MA530
below. MA531 MA60.2
MA60.3 MA60.5
The Care Days * Units Per Day must MA61.1 MA66.3
equal the Quantity if the Item Usage MA67.1 MA67.2
flag is set. MA70.1 MAI1.1
PO100 PO101
Defaults: PO122 PO131
PO20.1 PO21.2
The Care Days value defaults from PO21.3 PO21.4
CX05.1(Preference Template). PO21.5 PO22.1
PO23.1 PO29.1
Note: PO30.1 PO30.2
For example, if the patient stay PO30.3 PO300
consists of day one for both surgery and PO31.1 PO31.2
the use of intraoperative and PO32.2 PO33.1
postoperative items, the number of care PO34.1 PO35.1
days is 0. PO38.1 PO39.1
PO39.2 PO44.1
In another example, if the patient stay PO50.1 PO52.1
consists of two days, day one for the PO520 POI3.1
procedure (designated as usage day zero) POIE.1 POII.1
and day two for postoperative care, the POIJ.1 RQ10.1
number of care days is 1. RQ10.2 RQ35.1
WH130 WH132
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
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 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-PICK-FL Alpha 1 AP125 AP126
Picking Option Flag This field indicates in which system to AP131 AP25.1
print pick lists and pick items. AP25.2 AP26.1
AP27.1 CXCP.1
Important: Your selection affects more IC28.1 MA180
than just printing the pick list. Your MA43.9 MA530
selection affects whether shipment MA531 MA60.2
records will be created so that items MA60.3 MA60.5
are picked for the correct case (by MA61.1 MA66.3
shipment number). The shipment records MA67.1 MA67.2
also allow for further processing. See MA70.1 MAI1.1
note below. PO100 PO101
PO122 PO131
For inventoried (I) type items, you PO20.1 PO21.2
must select 1. PO21.3 PO21.4
PO21.5 PO22.1
For non-inventory-tracked (N, X, or, S) PO23.1 PO29.1
type items, you can select either 1, 2, PO30.1 PO30.2
or 3. PO30.3 PO300
PO31.1 PO31.2
For printing no pick lists, select 3. PO32.2 PO33.1
PO34.1 PO35.1
Note: You must run the pick list PO38.1 PO39.1
program (WH130 (Pick List Print)) in the PO39.2 PO44.1
Warehouse system to have the system PO50.1 PO52.1
create shipment records. (Later, when PO520 POI3.1
you run CX100 (Pick List Print), the POIE.1 POII.1
shipment number created will appear on POIJ.1 RQ10.1
the CX100 pick list. The shipment number RQ10.2 RQ35.1
on the pick list helps you to match WH130 WH132
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
Rtn Wst Fl This field indicates whether the item AP131 AP25.1
is a return or waste item. AP25.2 AP26.1
AP27.1 CXCP.1
Select Yes if the item is to be IC28.1 MA180
designated as a return or waste item. MA43.9 MA530
(Returns are received items that must be MA531 MA60.2
sent back to the vendor or to the MA60.3 MA60.5
inventory, noninventory, or delivering MA61.1 MA66.3
location. Return items are replaced with MA67.1 MA67.2
no charge or credited. Waste items are MA70.1 MAI1.1
items picked for a case but never used PO100 PO101
and later disposed of and reported as PO122 PO131
waste during case completion feedback.) PO20.1 PO21.2
PO21.3 PO21.4
Select No if the Case status is 1 PO21.5 PO22.1
(Unreleased). PO23.1 PO29.1
PO30.1 PO30.2
Defaults to No. PO30.3 PO300
Y = Yes PO31.1 PO31.2
N = No 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
...
CPI-ACCT-CATEGORY Alpha 5 AP125 AP126
Account Category This field contains a valid account AP131 AP25.1
category as defined in the Activity AP25.2 AP26.1
Management system. AP27.1 CXCP.1
Note: Use of the Activity Management IC28.1 MA180
system to track and report costs MA43.9 MA530
recorded in the Case Carts system is MA531 MA60.2
reserved for a future release. MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ACTIVITY Alpha 15 AP125 AP126
Activity This field contains a valid activity AP131 AP25.1
code as defined in the Activity AP25.2 AP26.1
Management system. AP27.1 CXCP.1
Note: Use of the Activity Management IC28.1 MA180
system to track and report costs MA43.9 MA530
recorded in the Case Carts system is MA531 MA60.2
reserved for a future release. MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ATN-OBJ-ID Numeric 12 AP125 AP126
Atn Object ID This field contains a system-assigned AP131 AP25.1
identifier that provides access to data AP25.2 AP26.1
in related files. AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-STORAGE-LOC Alpha 7 AP125 AP126
Storage Loc This field contains the storage AP131 AP25.1
location identifier. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-STOCKLESS-FL Alpha 1 AP125 AP126
Stockless Fl This flag indicates whether or not the AP131 AP25.1
item is a stockless item. AP25.2 AP26.1
AP27.1 CXCP.1
Note: Use of this field is reserved IC28.1 MA180
for a future release. MA43.9 MA530
Y = Yes MA531 MA60.2
N = No MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-AGREEMENT-REF Alpha 30 AP125 AP126
Agreement Ref AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 CXCP.1
Order Unit Cost Default routine. The IC28.1 MA180
value updates the Purchase Order MA43.9 MA530
interface record. MA531 MA60.2
E = Entered MA60.3 MA60.5
L = Last Cost MA61.1 MA66.3
C = Contract MA67.1 MA67.2
T = Catalog/Quote MA70.1 MAI1.1
B = Blanket PO100 PO101
P = Lat PO Created 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
...
CPI-COST-OPTION Alpha 1 AP125 AP126
Cost Option 1 = Cost Required AP131 AP25.1
2 = No Charge AP25.2 AP26.1
3 = Vendor Determined AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-SHIPPED-QTY Signed 13.4 AP125 AP126
Shipped Quantity This field contains the item shipped AP131 AP25.1
quantity. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-DEMAND-CREATED Alpha 1 AP125 AP126
Demand Created This field indicates whether demand was AP131 AP25.1
created. AP25.2 AP26.1
AP27.1 CXCP.1
Select Yes if the demand was created. IC28.1 MA180
Y = Yes MA43.9 MA530
N = No MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-PATIENT-CLASS Alpha 1 AP125 AP126
Patient Class This provides for a category of patient. AP131 AP25.1
I = Inpatient AP25.2 AP26.1
O = Outpatient AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-MANUF-CODE Alpha 4 AP125 AP126
Manufacturer's Code This field contains a user-defined code AP131 AP25.1
that indicates the manufacturer of an AP25.2 AP26.1
item. AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-PK-PRINT-FLAG Alpha 1 AP125 AP126
Pick-List Print Flag Select 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 CXCP.1
item. IC28.1 MA180
MA43.9 MA530
When a line is changed, the system MA531 MA60.2
logic sets this flag to 4 (Reprocess) MA60.3 MA60.5
and the case status to 2 (Released). MA61.1 MA66.3
1 = Create pick ticket MA67.1 MA67.2
2 = Process post items MA70.1 MAI1.1
3 = Complete PO100 PO101
4 = Reprocess 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
...
CPI-IF-REF-NBR Numeric 9 AP125 AP126
Reference Number This 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 CXCP.1
Purchase Order interface record or a IC28.1 MA180
Warehouse demand record. MA43.9 MA530
MA531 MA60.2
The value prints on CX100 (Pick List MA60.3 MA60.5
Print) and on WH130 (Pick List Print). MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-ORG-LINE-NBR Numeric 6 AP125 AP126
Org Line Nbr This field contains the original line AP131 AP25.1
number of the requisition. AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 CXCP.1
system calculated. IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-PUT-OUT-FL Numeric 3 AP125 AP126
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 CXCP.1
opened for the procedure. This will help IC28.1 MA180
reduce waste and returns. MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-PO-CODE Alpha 4 AP125 AP126
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 CXCP.1
order created from the case item. IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-FILL-OR-KILL Alpha 1
Fill Or Kill F = Fill Backorders
K = Kill Backorders
CPI-USE-IDENTIFIER Alpha 1 AP125 AP126
Use Identifier AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
CPI-CONSIGNMENT-FL Alpha 1 AP125 AP126
Consignment Fl AP131 AP25.1
AP25.2 AP26.1
AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
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
...
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 CXCP.1
LINE-NBR IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
CPISET2 COMPANY KeyChange AP125 AP126
REQ-LOCATION AP131 AP25.1
CASE AP25.2 AP26.1
ALT-LINE-NBR AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
CPISET3 COMPANY KeyChange
REQ-LOCATION
POST-ITEM-FL
CASE
SEQ
LINE-NBR
ALT-LINE-NBR
CPISET4 COMPANY KeyChange
REQ-LOCATION
CASE
ITEM-TYPE
ITEM
SEQ
LINE-NBR
CPISET5 ATN-OBJ-ID KeyChange, Duplicates, Subset
Where ATN-OBJ-ID != Zeroes
CPISET6 COMPANY KeyChange
REQ-LOCATION
PROC-TYPE
PROC-CODE
PREF-CODE
CASE
SEQ
ALT-LINE-NBR
CPISET7 COMPANY KeyChange
REQ-LOCATION
CASE
SEQ
ALT-LINE-NBR
CPISET8 COMPANY KeyChange, Subset AP125 AP126
REQ-LOCATION Where DEMAND-CREATED = "Y" AP131 AP25.1
CASE AP25.2 AP26.1
IF-REF-NBR AP27.1 CXCP.1
IC28.1 MA180
MA43.9 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.3
MA67.1 MA67.2
MA70.1 MAI1.1
PO100 PO101
PO122 PO131
PO20.1 PO21.2
PO21.3 PO21.4
...
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 IC28.1
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
...
CXPREFITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ccasehead CXCASEHEAD Not Required
CPI-COMPANY -> CXH-COMPANY
CPI-REQ-LOCATION -> CXH-REQ-LOCATION
CPI-CASE -> CXH-CASE
Cccasepref CXCASEPREF Required
CPI-COMPANY -> CXP-COMPANY
CPI-REQ-LOCATION -> CXP-REQ-LOCATION
CPI-CASE -> CXP-CASE
CPI-SEQ -> CXP-SEQ
From Location ICLOCATION Required
When CPI-FROM-LOCATION != Spaces
CPI-COMPANY -> ICL-COMPANY
CPI-FROM-LOCATION -> ICL-LOCATION
Gen Temp Item CXPTMPITEM Not Required
CPI-COMPANY -> CTI-COMPANY
CPI-REQ-LOCATION -> CTI-REQ-LOCATION
CPI-ITEM -> CTI-ITEM
CPI-PREF-CODE -> CTI-PREF-CODE
CPI-PROC-TYPE -> CTI-PROC-TYPE
CPI-PROC-CODE -> CTI-PROC-CODE
Spaces -> CTI-PRACTNR-ID
CPI-LINE-NBR -> CTI-LINE-NBR
Hcchrgitem HCCHRGITEM Not Required
CPI-COMPANY -> HCI-COMPANY
CPI-ITEM -> HCI-ITEM
CPI-REV-CENTER -> HCI-REV-CENTER
Iccompany ICCOMPANY Required
CPI-COMPANY -> ICC-COMPANY
Item Location ITEMLOC Not Required
Valid When CPI-FROM-LOCATION != Spaces
CPI-COMPANY -> ITL-COMPANY
CPI-FROM-LOCATION -> ITL-LOCATION
CPI-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When CPI-ITEM-TYPE = "I"
Or CPI-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
CPI-ITEM -> ITE-ITEM
Prac Temp Item CXPTMPITEM Not Required
CPI-COMPANY -> CTI-COMPANY
CPI-REQ-LOCATION -> CTI-REQ-LOCATION
CPI-ITEM -> CTI-ITEM
CPI-PREF-CODE -> CTI-PREF-CODE
CPI-PROC-TYPE -> CTI-PROC-TYPE
CPI-PROC-CODE -> CTI-PROC-CODE
CXP-PRACTNR-ID -> CTI-PRACTNR-ID
CPI-LINE-NBR -> CTI-LINE-NBR
Vendor APVENMAST Required
When CPI-VENDOR != Spaces
CPY-VENDOR-GROUP -> -VENDOR-GROUP
CPI-VENDOR -> -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
|