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