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 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CXCP.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 PO32.4
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 POID.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
WHD2.1
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-REQ-LOCATION Alpha 5 AP125 AP126
Element: Req Location 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 AP21.1
AP23.1 AP25.1
This value appears as the to location AP25.2 AP26.1
on pick lists printed when you run CX100 AP27.1 AP30.4
(Pick List Print) and WH130 (Pick List API1.1 BL120
Print). BL122 BL130
BL20.1 BL20.3
Valid values are BL21.2 BL21.5
BL29.1 BL29.2
A requesting location defined in RQ01.1 BL520 BL820
(Requesting Location) for the specified BL92.1 CXCP.1
healthcare company. MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
Carts system to associate specific AP23.1 AP25.1
tasks, practitioners, preference lists, AP25.2 AP26.1
and other information with a particular AP27.1 AP30.4
treatment course. This treatment course API1.1 BL120
may consist of one or more procedures. BL122 BL130
The Case Carts system uses the case BL20.1 BL20.3
number to interface with an outside BL21.2 BL21.5
scheduling system. BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-PREF-CODE Alpha 8 AP125 AP126
Element: Proc Code This field contains the Preference List AP131 AP20.1
Code. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-PROC-TYPE Alpha 8 AP125 AP126
Element: Proc Code The 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 AP21.1
procedure code belongs. AP23.1 AP25.1
AP25.2 AP26.1
For example, you can use one of the AP27.1 AP30.4
following codes: API1.1 BL120
- CPT-4 for a code in the Current BL122 BL130
Procedural Terminology listing compiled BL20.1 BL20.3
by the American Medical Association BL21.2 BL21.5
-HCPCS for a code in HCFA's (Health BL29.1 BL29.2
Care Financing Administration's) Common BL520 BL820
Procedure Coding System, or BL92.1 CXCP.1
- A code defined for your MA180 MA41.1
organization's own procedures listing. MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-PROC-CODE Alpha 8 AP125 AP126
Element: Proc Code The 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 AP21.1
within a procedure type. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-SEQ Numeric 3 AP125 AP126
Element: Seq This field contains the sequence of the AP131 AP20.1
preference list within the case. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ITEM Alpha 32 AP125 AP126
Element: Item This field contains the item AP131 AP20.1
identifier. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
X, or X item types , update the Purchase AP23.1 AP25.1
Order interface record. AP25.2 AP26.1
I = Inventoried Item AP27.1 AP30.4
N = Non-Stock Item API1.1 BL120
S = Service Item BL122 BL130
X = Special Item BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr 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 AP21.1
Detail), see Alt Line Nbr. AP23.1 AP25.1
AP25.2 AP26.1
This file value is always 1 for the AP27.1 AP30.4
first item on a case preference. Thus, API1.1 BL120
if there are two preferences on a case, BL122 BL130
they each start with line number 1. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-UOM Alpha 4 AP125 AP126
Element: Uom This field contains the valid stock AP131 AP20.1
unit of measure for this item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
value is entered. This field is AP23.1 AP25.1
required. AP25.2 AP26.1
AP27.1 AP30.4
Note: To change a line that is API1.1 BL120
partially picked (such as for a case BL122 BL130
that has multiple care days), be sure BL20.1 BL20.3
that the quantity is equal to or greater BL21.2 BL21.5
than the quantity already picked. BL29.1 BL29.2
BL520 BL820
(Care days are the total number of BL92.1 CXCP.1
preoperative and postoperative days. For MA180 MA41.1
example, if the patient stay consists of MA41.2 MA41.4
day one for surgery and day two for MA41.7 MA43.1
postoperative care, the number of care MA43.2 MA43.3
days is one (1). You define care days in MA43.7 MA530
CX20.2 (Case Detail) in the Items tab on MA531 MA60.2
the Care Item detail tab.) MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-FROM-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP20.1
resource type = V. Identifies the HR AP20.2 AP20.3
company if the resource type = E. It is AP20.4 AP20.5
blank for type A, P or Q resources. AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-FROM-LOCATION Alpha 5 AP125 AP126
Element: Location 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-PRICE Signed 18.2 AP125 AP126
Element: Intl Amt 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ISSUE-COST Signed 18.2 AP125 AP126
Element: Intl Amt 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 AP21.1
added using CX20.1 (Case Build) with the AP23.1 AP25.1
following exception. AP25.2 AP26.1
AP27.1 AP30.4
For I or N type items, when you add a API1.1 BL120
case, the system may replace the issue BL122 BL130
cost from the template with a new value. BL20.1 BL20.3
Such replacement occurs if the values BL21.2 BL21.5
used in the cost logic have changed. For BL29.1 BL29.2
example, such a change can occur when BL520 BL820
the associated contract unit cost BL92.1 CXCP.1
changes after the template is created. MA180 MA41.1
MA41.2 MA41.4
The cost logic defaults as follows and MA41.7 MA43.1
can be manually overridden: MA43.2 MA43.3
MA43.7 MA530
For inventoried (I) type items, the MA531 MA60.2
cost defaults from the Inventory Control MA60.3 MA60.5
system costing routine. MA61.1 MA66.2
MA66.3 MA67.2
For non-inventory-tracked (N) type MA67.3 MA68.2
items, the cost defaults from the MA68.3 MA68.5
Purchase Order system unit cost default MA70.1 MA75.1
routine. MA80.1 MAI1.1
PD10.1 PD10.2
For X or S type items, the cost PD130 PD20.1
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: Acct Unit This 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 AP21.1
Account Master file, the accounting unit AP23.1 AP25.1
must be defined in the General Ledger AP25.2 AP26.1
Names file as a posting accounting unit. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
account information are stored. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-SUB-ACCOUNT Numeric 4 AP125 AP126
Element: Sub Acct 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 AP21.1
account information is stored. AP23.1 AP25.1
AP25.2 AP26.1
This value must be a valid general AP27.1 AP30.4
ledger account (defined with the Acct API1.1 BL120
Unit). When you release a case, this BL122 BL130
value updates the Purchase Order BL20.1 BL20.3
interface record. BL21.2 BL21.5
BL29.1 BL29.2
If Item Type is I or Create PO flag is BL520 BL820
Yes, this field must contain a value. BL92.1 CXCP.1
MA180 MA41.1
Defaults based on Requisition system MA41.2 MA41.4
default logic if blank and item type is MA41.7 MA43.1
I or the Create PO flag is set to Yes. MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ISSUE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Issue 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 AP21.1
status is 1 (Unreleased). The system AP23.1 AP25.1
updates this value based on changes in AP25.2 AP26.1
CX30.1 (Case Completion Feedback). AP27.1 AP30.4
API1.1 BL120
Defaults to zero (0). BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ALT-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr 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 AP21.1
preference template to a case, the AP23.1 AP25.1
system assigns numbers to the items, AP25.2 AP26.1
sequentially, starting with 1 on the AP27.1 AP30.4
first preference and continuing API1.1 BL120
sequentially through the next BL122 BL130
preferences. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-CREATE-PO-CD Alpha 1 AP125 AP126
Element: Create Po Cd This code indicates whether this AP131 AP20.1
inventory item is to be purchased by AP20.2 AP20.3
purchase order instead of picked from AP20.4 AP20.5
inventory. AP20.7 AP21.1
AP23.1 AP25.1
Select No for pick from inventory. AP25.2 AP26.1
AP27.1 AP30.4
Select Yes for create purchase order. API1.1 BL120
BL122 BL130
Defaults to No if blank. BL20.1 BL20.3
Y = Yes BL21.2 BL21.5
N = No BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-VENDOR Alpha 9 (Right Justified) AP125 AP126
Element: Vendor 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 AP21.1
with output from the Purchase Order Unit AP23.1 AP25.1
Cost Default routine. AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-TAXABLE-FLAG Alpha 1 AP125 AP126
Element: Taxable Flag This field defines whether or not the AP131 AP20.1
item is taxable. AP20.2 AP20.3
AP20.4 AP20.5
This value updates the Purchase Order AP20.7 AP21.1
interface record when the case is AP23.1 AP25.1
released. AP25.2 AP26.1
AP27.1 AP30.4
Defaults from the Item master for I and API1.1 BL120
N item types or to No for X and S item BL122 BL130
types. BL20.1 BL20.3
Y = Yes BL21.2 BL21.5
N = No BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
interface record when the case is AP23.1 AP25.1
released. AP25.2 AP26.1
AP27.1 AP30.4
If the Taxable Flag is set to Yes, this API1.1 BL120
field must contain a value. BL122 BL130
BL20.1 BL20.3
Defaults to spaces. BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-EARLY-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Early Dl 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 AP21.1
interface record. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-LATE-DL-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Late Dl Date This field contains the late delivery AP131 AP20.1
date. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-CERT-REQ-FL Alpha 1 AP125 AP126
Element: Cert Req Fl This flag indicates whether a AP131 AP20.1
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 AP21.1
purchase order line is created. AP23.1 AP25.1
Y = Certification required. AP25.2 AP26.1
N = No certification required. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
If the Create PO flag is set to Yes, AP23.1 AP25.1
this value updates the Purchase Order AP25.2 AP26.1
interface record when a case is AP27.1 AP30.4
released. API1.1 BL120
BL122 BL130
Defaults to the value in the Insp Req BL20.1 BL20.3
Fl of the Itemloc file or defaults to BL21.2 BL21.5
No. BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
1 = Intra-Op AP23.1 AP25.1
2 = Post-Op AP25.2 AP26.1
3 = Pre-Op AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-POST-DAY Numeric 2 AP125 AP126
Element: 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 AP21.1
Care Days field, this field indicates AP23.1 AP25.1
the day to start picking care items. AP25.2 AP26.1
00 AP27.1 AP30.4
99 API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
substitutions are defined. AP23.1 AP25.1
AP25.2 AP26.1
This value must be blank for N, X, and AP27.1 AP30.4
S item types. API1.1 BL120
BL122 BL130
Defaults to blank. BL20.1 BL20.3
R = Replacement BL21.2 BL21.5
S = Substitute BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ORIG-ITEM-NBR Alpha 32 AP125 AP126
Element: Item 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 AP21.1
is not blank. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-SERVICE-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Service 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 AP21.1
Patient Charge system, this date is AP23.1 AP25.1
called the Charge Date. AP25.2 AP26.1
AP27.1 AP30.4
This value must be zero (0) if the Case API1.1 BL120
status is 1 (Unreleased). BL122 BL130
BL20.1 BL20.3
Defaults to zero (0). BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-NBR-DAYS Numeric 2 AP125 AP126
Element: Nbr Days 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 AP21.1
is considered usage day 0. See note AP23.1 AP25.1
below. AP25.2 AP26.1
AP27.1 AP30.4
The Care Days * Units Per Day must API1.1 BL120
equal the Quantity if the Item Usage BL122 BL130
flag is set. BL20.1 BL20.3
BL21.2 BL21.5
Defaults: BL29.1 BL29.2
BL520 BL820
The Care Days value defaults from BL92.1 CXCP.1
CX05.1(Preference Template). MA180 MA41.1
MA41.2 MA41.4
Note: MA41.7 MA43.1
For example, if the patient stay MA43.2 MA43.3
consists of day one for both surgery and MA43.7 MA530
the use of intraoperative and MA531 MA60.2
postoperative items, the number of care MA60.3 MA60.5
days is 0. MA61.1 MA66.2
MA66.3 MA67.2
In another example, if the patient stay MA67.3 MA68.2
consists of two days, day one for the MA68.3 MA68.5
procedure (designated as usage day zero) MA70.1 MA75.1
and day two for postoperative care, the MA80.1 MAI1.1
number of care days is 1. PD10.1 PD10.2
PD130 PD20.1
In another example, if an item is not ...
used on a day in the middle of a patient
stay, you must create two lines for the
item. That is, first define the care
days for the item, up to the day of
nonusage. Next, add a new line for the
same item. Assume the day of nonusage as
a new usage day of zero and define the
care days for the new line as the total
number of remaining care days for the
item.
Use the following fields together: Item
Usage, Usage Day, Care Days, and Units
Per Day.
CPI-UNITS-PER-DAY Numeric 3 AP125 AP126
Element: Units Per Day This field defines the number of item AP131 AP20.1
units to be used per day. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-PICK-FL Alpha 1 AP125 AP126
Element: Pick Fl This 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 AP21.1
than just printing the pick list. Your AP23.1 AP25.1
selection affects whether shipment AP25.2 AP26.1
records will be created so that items AP27.1 AP30.4
are picked for the correct case (by API1.1 BL120
shipment number). The shipment records BL122 BL130
also allow for further processing. See BL20.1 BL20.3
note below. BL21.2 BL21.5
BL29.1 BL29.2
For inventoried (I) type items, you BL520 BL820
must select 1. BL92.1 CXCP.1
MA180 MA41.1
For non-inventory-tracked (N, X, or, S) MA41.2 MA41.4
type items, you can select either 1, 2, MA41.7 MA43.1
or 3. MA43.2 MA43.3
MA43.7 MA530
For printing no pick lists, select 3. MA531 MA60.2
MA60.3 MA60.5
Note: You must run the pick list MA61.1 MA66.2
program (WH130 (Pick List Print)) in the MA66.3 MA67.2
Warehouse system to have the system MA67.3 MA68.2
create shipment records. (Later, when MA68.3 MA68.5
you run CX100 (Pick List Print), the MA70.1 MA75.1
shipment number created will appear on MA80.1 MAI1.1
the CX100 pick list. The shipment number PD10.1 PD10.2
on the pick list helps you to match PD130 PD20.1
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 AP21.1
designated as a return or waste item. AP23.1 AP25.1
(Returns are received items that must be AP25.2 AP26.1
sent back to the vendor or to the AP27.1 AP30.4
inventory, noninventory, or delivering API1.1 BL120
location. Return items are replaced with BL122 BL130
no charge or credited. Waste items are BL20.1 BL20.3
items picked for a case but never used BL21.2 BL21.5
and later disposed of and reported as BL29.1 BL29.2
waste during case completion feedback.) BL520 BL820
BL92.1 CXCP.1
Select No if the Case status is 1 MA180 MA41.1
(Unreleased). MA41.2 MA41.4
MA41.7 MA43.1
Defaults to No. MA43.2 MA43.3
Y = Yes MA43.7 MA530
N = No MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ACCT-CATEGORY Alpha 5 AP125 AP126
Element: Acct Category This 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 AP21.1
system to track and report costs AP23.1 AP25.1
recorded in the Case Carts system is AP25.2 AP26.1
reserved for a future release. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
system to track and report costs AP23.1 AP25.1
recorded in the Case Carts system is AP25.2 AP26.1
reserved for a future release. AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ATN-OBJ-ID Numeric 12 AP125 AP126
Element: Obj Id This field contains a system-assigned AP131 AP20.1
identifier that provides access to data AP20.2 AP20.3
in related files. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
for a future release. AP23.1 AP25.1
Y = Yes AP25.2 AP26.1
N = No AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-AGREEMENT-REF Alpha 30 AP125 AP126
Element: Agreement Ref AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-COST-CD Alpha 1 AP125 AP126
Element: Cost Cd This field contains the unit-cost AP131 AP20.1
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 AP21.1
value updates the Purchase Order AP23.1 AP25.1
interface record. AP25.2 AP26.1
E = Entered AP27.1 AP30.4
L = Last Cost API1.1 BL120
C = Contract BL122 BL130
T = Catalog/Quote BL20.1 BL20.3
B = Blanket BL21.2 BL21.5
P = Lat PO Created BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
Y = Yes AP23.1 AP25.1
N = No AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-MANUF-CODE Alpha 4 AP125 AP126
Element: Manuf Code This 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-MANUF-DIVISION Alpha 4 AP125 AP126
Element: Manuf DivisionThis field contains a user-defined code AP131 AP20.1
that indicates which division of a AP20.2 AP20.3
manufacturer is tied to an item. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-MANUF-NBR Alpha 15 AP125 AP126
Element: Manuf Nbr This is the identifier that the AP131 AP20.1
manufacturer has assigned to an item. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-PK-PRINT-FLAG Alpha 1 AP125 AP126
Element: Pk Print Flag Select 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 AP21.1
AP23.1 AP25.1
When a line is changed, the system AP25.2 AP26.1
logic sets this flag to 4 (Reprocess) AP27.1 AP30.4
and the case status to 2 (Released). API1.1 BL120
1 = Create pick ticket BL122 BL130
2 = Process post items BL20.1 BL20.3
3 = Complete BL21.2 BL21.5
4 = Reprocess BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-IF-REF-NBR Numeric 9 AP125 AP126
Element: If Ref Nbr This 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 AP21.1
Warehouse demand record. AP23.1 AP25.1
AP25.2 AP26.1
The value prints on CX100 (Pick List AP27.1 AP30.4
Print) and on WH130 (Pick List Print). API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-ORG-LINE-NBR Numeric 6 AP125 AP126
Element: Line Nbr This field contains the original line AP131 AP20.1
number of the requisition. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-LEADTIME-DAYS Numeric 3 AP125 AP126
Element: Leadtime Days This field contains the average AP131 AP20.1
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
reduce waste and returns. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-PO-CODE Alpha 4 AP125 AP126
Element: Po Code This is the purchase order code that AP131 AP20.1
can 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
CPI-CONSIGNMENT-FL Alpha 1 AP125 AP126
Element: Consignment Fl AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
CPISET2 COMPANY KeyChange AP125 AP126
REQ-LOCATION AP131 AP20.1
CASE AP20.2 AP20.3
ALT-LINE-NBR AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
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
|