CXPREFITEM – Preference Items

System
Case Carts (CX)
Prefix
CPI
Primary key
COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR
Fields
68
Updated by
221 programs
Referenced by
3 programs

CXPREFITEM is the Preference Items table in Lawson Case Carts (prefix CPI). It is indexed by COMPANY, REQ-LOCATION, CASE, SEQ, LINE-NBR (CPISET1); alternate indexes: CPISET2, CPISET3, CPISET4, CPISET6, CPISET7, CPISET8 and CPISET9. It is related 1:1 to CXCASEHEAD, CXCASEPREF, ICLOCATION, CXPTMPITEM, HCCHRGITEM, ICCOMPANY, ITEMLOC, ITEMMAST and 4 more and 1:M to ITEMSUB, POLINESRC, WHSHIPLINE and WHSHIPMENT. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 213 more and referenced by CX230, CX240 and CX55.1. The table has 68 fields, 8 indexes and 17 documented relations.

About CXPREFITEM

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.

Fields (68)

Column = COBOL field name without the CPI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CPI-COMPANY PK
COMPANY		Numeric 4This field contains the company number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-REQ-LOCATION PK
REQ_LOCATION		Alpha 5This field contains the location requisitioning items and to be charged for the items. This location can be an inventory or noninventory location. This value appears as the to location on pick lists printed when you run CX100 (Pick List Print) and WH130 (Pick List Print). Valid values are A requesting location defined in RQ01.1 (Requesting Location) for the specified healthcare company.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-CASE PK
CASE		Alpha 15This field contains the unique identifier for the case. A case identifier is used in the Case Carts system to associate specific tasks, practitioners, preference lists, and other information with a particular treatment course. This treatment course may consist of one or more procedures. The Case Carts system uses the case number to interface with an outside scheduling system.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PREF-CODE SET6
PREF_CODE		Alpha 8This field contains the Preference List Code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PROC-TYPE SET6
PROC_TYPE		Alpha 8The procedure type is the first of two fields that uniquely identify a procedure. The procedure type can identify the code set to which the procedure code belongs. For example, you can use one of the following codes: - CPT-4 for a code in the Current Procedural Terminology listing compiled by the American Medical Association -HCPCS for a code in HCFA's (Health Care Financing Administration's) Common Procedure Coding System, or - A code defined for your organization's own procedures listing.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PROC-CODE SET6
PROC_CODE		Alpha 8The procedure code is the second of two fields that uniquely identify a procedure. The procedure code is an identifier for a specific procedure within a procedure type.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-SEQ PK
SEQ		Numeric 3This field contains the sequence of the preference list within the case.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ITEM SET4
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ITEM-TYPE SET4
ITEM_TYPE		Alpha 1This field identifies the line item type. Changes to this field that result in N, X, or X item types , update the Purchase Order interface record.
  • I Inventoried Item
  • N Non-Stock Item
  • S Service Item
  • X Special Item
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-SERVICE-CODE
SERVICE_CODE		Alpha 1" " = Not A Service Item
  • A Amount
  • Q Quantity
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the original item line number assigned by the Case Carts system when the item is added. For the line number displayed in CX20.2 (Case Detail), see Alt Line Nbr. This file value is always 1 for the first item on a case preference. Thus, if there are two preferences on a case, they each start with line number 1.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-UOM
UOM		Alpha 4This field contains the valid stock unit of measure for this item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-QUANTITY
QUANTITY		Signed 13.4This field contains the requested quantity to be picked. This field defaults to one (1) if no value is entered. This field is required. Note: To change a line that is partially picked (such as for a case that has multiple care days), be sure that the quantity is equal to or greater than the quantity already picked. (Care days are the total number of preoperative and postoperative days. For example, if the patient stay consists of day one for surgery and day two for postoperative care, the number of care days is one (1). You define care days in CX20.2 (Case Detail) in the Items tab on the Care Item detail tab.)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-QUANTITY-USED
QUANTITY_USED		Signed 13.4This field contains the actual quantity of items used for this case. This amount can be more or less than the issued amount.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-FROM-COMPANY
FROM_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-FROM-LOCATION
FROM_LOCATION		Alpha 5This is the inventory location that supplies the items or it is the purchase order ship to location that receives the items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PRICE
PRICE		Signed 18.2This field contains the amount that the patient will be charged for the item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ISSUE-COST
ISSUE_COST		Signed 18.2This field contains the issue cost. This cost defaults from CX05.1 (Preference Template) when a case is added using CX20.1 (Case Build) with the following exception. For I or N type items, when you add a case, the system may replace the issue cost from the template with a new value. Such replacement occurs if the values used in the cost logic have changed. For example, such a change can occur when the associated contract unit cost changes after the template is created. The cost logic defaults as follows and can be manually overridden: For inventoried (I) type items, the cost defaults from the Inventory Control system costing routine. For non-inventory-tracked (N) type items, the cost defaults from the Purchase Order system unit cost default routine. For X or S type items, the cost defaults from the template (CX05.1 (Preference Template)). If the Create PO flag is set to Yes, this value updates the Purchase Order interface record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ACCT-UNIT
ACCT_UNIT		Alpha 15This field contains the accounting unit. The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ACCOUNT
ACCOUNT		Numeric 6This field contains the account. This field, along with the accounting unit and subaccount, make up the location (account) where amounts and other account information are stored.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This field contains the subaccount. This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. This value must be a valid general ledger account (defined with the Acct Unit). When you release a case, this value updates the Purchase Order interface record. If Item Type is I or Create PO flag is Yes, this field must contain a value. Defaults based on Requisition system default logic if blank and item type is I or the Create PO flag is set to Yes.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-CHARGE-NBR
CHARGE_NBR		Alpha 80This field contains the number, such as CDM (Charge Description Master), used by the patient billing system to charge patients for items used.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-CHARGEABLE-FL
CHARGEABLE_FL		Alpha 1This flag indicates that this item is a patient chargeable item.
  • N No
  • Y Yes
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ISSUE-DATE
ISSUE_DATE		Numeric 8 (yyyymmdd)This field contains the date of the transaction. The value must be zero (0) if the Case status is 1 (Unreleased). The system updates this value based on changes in CX30.1 (Case Completion Feedback). Defaults to zero (0).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ALT-LINE-NBR SET2 SET3 SET6 SET7
ALT_LINE_NBR		Numeric 6This field contains the display value of the item line number. When you assign more than one preference template to a case, the system assigns numbers to the items, sequentially, starting with 1 on the first preference and continuing sequentially through the next preferences.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-CREATE-PO-CD
CREATE_PO_CD		Alpha 1This code indicates whether this inventory item is to be purchased by purchase order instead of picked from inventory. Select No for pick from inventory. Select Yes for create purchase order. Defaults to No if blank.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-VENDOR
VENDOR		Alpha 9 (Right Justified)This field contains the vendor's identification code. The system may overwrite this value with output from the Purchase Order Unit Cost Default routine.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1This field defines whether or not the item is taxable. This value updates the Purchase Order interface record when the case is released. Defaults from the Item master for I and N item types or to No for X and S item types.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-TAX-CODE
TAX_CODE		Alpha 10This field contains a valid tax code representing specific tax information. This value updates the Purchase Order interface record when the case is released. If the Taxable Flag is set to Yes, this field must contain a value. Defaults to spaces.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-EARLY-DL-DATE
EARLY_DL_DATE		Numeric 8 (yyyymmdd)This field contains the early delivery date. This value updates the Purchase Order interface record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-LATE-DL-DATE
LATE_DL_DATE		Numeric 8 (yyyymmdd)This field contains the late delivery date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-CERT-REQ-FL
CERT_REQ_FL		Alpha 1This flag indicates whether a certification is required for this line when it is purchased. This field value is passed to the purchase order when the purchase order line is created.
  • Y Certification required.
  • N No certification required.
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-INSP-REQ-FL
INSP_REQ_FL		Alpha 1This flag indicates whether this item has to be inspected when received in the Purchase Order system. If the Create PO flag is set to Yes, this value updates the Purchase Order interface record when a case is released. Defaults to the value in the Insp Req Fl of the Itemloc file or defaults to No.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-REV-CENTER
REV_CENTER		Alpha 5The revenue center is the department that charges are associated with.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-POST-ITEM-FL SET3
POST_ITEM_FL		Alpha 1This field indicates whether or not this line item is part of the procedure (an intraoperative item) or is a postoperative or preoperative item.
  • 1 Intra-Op
  • 2 Post-Op
  • 3 Pre-Op
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-POST-DAY
POST_DAY		Numeric 2This field defines the day of the patient visit when the item is to be used. A value of zero indicates the day of the procedure. When used with the Care Days field, this field indicates the day to start picking care items. 00 99AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-SUB-ITEM-FL
SUB_ITEM_FL		Alpha 1This field defines whether an item is a substitute or a replacement item. Blank indicates that no replacements or substitutions are defined. This value must be blank for N, X, and S item types. Defaults to blank.
  • R Replacement
  • S Substitute
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ORIG-ITEM-NBR
ORIG_ITEM_NBR		Alpha 32This field contains the original item number. A value must be provided if Sub Item Fl is not blank.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-SERVICE-DATE
SERVICE_DATE		Numeric 8 (yyyymmdd)This field identifies the date the item was used. This date is used by the billing system to identify the charges associated with this case. In the Patient Charge system, this date is called the Charge Date. This value must be zero (0) if the Case status is 1 (Unreleased). Defaults to zero (0).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-REPEAT-FL
REPEAT_FL		Alpha 1This field is reserved for a future release of the Case Carts system.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-NBR-DAYS
NBR_DAYS		Numeric 2Care days are the total number of days a preoperative or postoperative item will be used on the case, starting with the usage day. The day of the procedure is considered usage day 0. See note below. The Care Days * Units Per Day must equal the Quantity if the Item Usage flag is set. Defaults: The Care Days value defaults from CX05.1(Preference Template). Note: For example, if the patient stay consists of day one for both surgery and the use of intraoperative and postoperative items, the number of care days is 0. In another example, if the patient stay consists of two days, day one for the procedure (designated as usage day zero) and day two for postoperative care, the number of care days is 1. In another example, if an item is not used on a day in the middle of a patient stay, you must create two lines for the item. That is, first define the care days for the item, up to the day of nonusage. Next, add a new line for the same item. Assume the day of nonusage as a new usage day of zero and define the care days for the new line as the total number of remaining care days for the item. Use the following fields together: Item Usage, Usage Day, Care Days, and Units Per Day.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-UNITS-PER-DAY
UNITS_PER_DAY		Numeric 3This field defines the number of item units to be used per day.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PICK-FL
PICK_FL		Alpha 1This field indicates in which system to print pick lists and pick items. Important: Your selection affects more than just printing the pick list. Your selection affects whether shipment records will be created so that items are picked for the correct case (by shipment number). The shipment records also allow for further processing. See note below. For inventoried (I) type items, you must select 1. For non-inventory-tracked (N, X, or, S) type items, you can select either 1, 2, or 3. For printing no pick lists, select 3. Note: You must run the pick list program (WH130 (Pick List Print)) in the Warehouse system to have the system create shipment records. (Later, when you run CX100 (Pick List Print), the shipment number created will appear on the CX100 pick list. The shipment number on the pick list helps you to match picked items with a case procedure.) Additionally, once the shipment records are created, shipping feedback (in WH32.1 (Shipping Feedback by Shipment)), and reduction of stock on hand and deletion of demand records by shipment release (in WH190 (Shipment Release)) can proceed.
  • 1 Pick through Warehouse system
  • 2 Pick through Case Cart system
  • 3 Do not pick
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-RTN-WST-FL
RTN_WST_FL		Alpha 1This field indicates whether the item is a return or waste item. Select Yes if the item is to be designated as a return or waste item. (Returns are received items that must be sent back to the vendor or to the inventory, noninventory, or delivering location. Return items are replaced with no charge or credited. Waste items are items picked for a case but never used and later disposed of and reported as waste during case completion feedback.) Select No if the Case status is 1 (Unreleased). Defaults to No.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5This field contains a valid account category as defined in the Activity Management system. Note: Use of the Activity Management system to track and report costs recorded in the Case Carts system is reserved for a future release.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ACTIVITY
ACTIVITY		Alpha 15This field contains a valid activity code as defined in the Activity Management system. Note: Use of the Activity Management system to track and report costs recorded in the Case Carts system is reserved for a future release.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12This field contains a system-assigned identifier that provides access to data in related files.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-STORAGE-LOC
STORAGE_LOC		Alpha 7This field contains the storage location identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-STOCKLESS-FL
STOCKLESS_FL		Alpha 1This flag indicates whether or not the item is a stockless item. Note: Use of this field is reserved for a future release.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-AGREEMENT-REF
AGREEMENT_REF		Alpha 30—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-COST-CD
COST_CD		Alpha 1This field contains the unit-cost origin code. When you build a case, this value is defaulted from the Purchase Order Unit Cost Default routine. The value updates the Purchase Order interface record.
  • E Entered
  • L Last Cost
  • C Contract
  • T Catalog/Quote
  • B Blanket
  • P Lat PO Created
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-COST-OPTION
COST_OPTION		Alpha 1—
  • 1 Cost Required
  • 2 No Charge
  • 3 Vendor Determined
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-SHIPPED-QTY
SHIPPED_QTY		Signed 13.4This field contains the item shipped quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-DEMAND-CREATED
DEMAND_CREATED		Alpha 1This field indicates whether demand was created. Select Yes if the demand was created.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PATIENT-CLASS
PATIENT_CLASS		Alpha 1This provides for a category of patient.
  • I Inpatient
  • O Outpatient
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-MANUF-CODE
MANUF_CODE		Alpha 4This field contains a user-defined code that indicates the manufacturer of an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-MANUF-DIVISION
MANUF_DIVISION		Alpha 4This field contains a user-defined code that indicates which division of a manufacturer is tied to an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-MANUF-NBR
MANUF_NBR		Alpha 35This is the identifier that the manufacturer has assigned to an item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PK-PRINT-FLAG
PK_PRINT_FLAG		Alpha 1Select the proper value to create a pick ticket, post items, complete the case, or reprocess a pick list for the item. When a line is changed, the system logic sets this flag to 4 (Reprocess) and the case status to 2 (Released).
  • 1 Create pick ticket
  • 2 Process post items
  • 3 Complete
  • 4 Reprocess
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-IF-REF-NBR SET8 SET9
IF_REF_NBR		Numeric 9This field contains an internally generated reference number used to track the case line item when creating a Purchase Order interface record or a Warehouse demand record. The value prints on CX100 (Pick List Print) and on WH130 (Pick List Print).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-ORG-LINE-NBR
ORG_LINE_NBR		Numeric 6This field contains the original line number of the requisition.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-LEADTIME-DAYS
LEADTIME_DAYS		Numeric 3This field contains the average lead-time days. The average of the last and the previous lead-time days if system calculated.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PUT-OUT-FL
PUT_OUT_FL		Numeric 3This field will show up on the printed pick list and preference list to show the quantity of an item that must be opened for the procedure. This will help reduce waste and returns.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-PO-CODE
PO_CODE		Alpha 4This is the purchase order code that can be entered for a defaulted to a case item, and will be used on a purchase order created from the case item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-FILL-OR-KILL
FILL_OR_KILL		Alpha 1—
  • F Fill Backorders
  • K Kill Backorders
—
#CPI-USE-IDENTIFIER
USE_IDENTIFIER		Alpha 1—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#CPI-CONSIGNMENT-FL
CONSIGNMENT_FL		Alpha 1—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (8)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CPISET1
  1. COMPANY
  2. REQ-LOCATION
  3. CASE
  4. SEQ
  5. LINE-NBR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CPISET2
  1. COMPANY
  2. REQ-LOCATION
  3. CASE
  4. ALT-LINE-NBR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CPISET3
  1. COMPANY
  2. REQ-LOCATION
  3. POST-ITEM-FL
  4. CASE
  5. SEQ
  6. LINE-NBR
  7. ALT-LINE-NBR
KeyChange—
CPISET4
  1. COMPANY
  2. REQ-LOCATION
  3. CASE
  4. ITEM-TYPE
  5. ITEM
  6. SEQ
  7. LINE-NBR
KeyChange—
CPISET6
  1. COMPANY
  2. REQ-LOCATION
  3. PROC-TYPE
  4. PROC-CODE
  5. PREF-CODE
  6. CASE
  7. SEQ
  8. ALT-LINE-NBR
KeyChange—
CPISET7
  1. COMPANY
  2. REQ-LOCATION
  3. CASE
  4. SEQ
  5. ALT-LINE-NBR
KeyChangeCX20.2
CPISET8
  1. COMPANY
  2. REQ-LOCATION
  3. CASE
  4. IF-REF-NBR
KeyChange, SubsetWhere DEMAND-CREATED = "Y"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
CPISET9
  1. COMPANY
  2. IF-REF-NBR
KeyChange, SubsetWhere ((CREATE-PO-CD = "Y") And (IF-REF-NBR != Zeroes))AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CXCASEHEADCXCASEPREFICLOCATIONCXPTMPITEMHCCHRGITEMICCOMPANYITEMLOCITEMMASTAPVENMASTAPCOMPANYWHDEMANDWHDEMNDHDRITEMSUBPOLINESRCWHSHIPLINEWHSHIPMENTCXPREFITEM

One to one (13) — lookups and parents

RelationTableRulesConditionField map
CcaseheadCXCASEHEADNot Required
CPI-COMPANY→CXH-COMPANY
CPI-REQ-LOCATION→CXH-REQ-LOCATION
CPI-CASE→CXH-CASE
CccaseprefCXCASEPREFRequired
CPI-COMPANY→CXP-COMPANY
CPI-REQ-LOCATION→CXP-REQ-LOCATION
CPI-CASE→CXP-CASE
CPI-SEQ→CXP-SEQ
From LocationICLOCATIONRequiredWhen CPI-FROM-LOCATION != Spaces
CPI-COMPANY→ICL-COMPANY
CPI-FROM-LOCATION→ICL-LOCATION
Gen Temp ItemCXPTMPITEMNot 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
HcchrgitemHCCHRGITEMNot Required
CPI-COMPANY→HCI-COMPANY
CPI-ITEM→HCI-ITEM
CPI-REV-CENTER→HCI-REV-CENTER
IccompanyICCOMPANYRequired
CPI-COMPANY→ICC-COMPANY
Item LocationITEMLOCNot RequiredValid When CPI-FROM-LOCATION != Spaces
CPI-COMPANY→ITL-COMPANY
CPI-FROM-LOCATION→ITL-LOCATION
CPI-ITEM→ITL-ITEM
ItemmastITEMMASTRequiredWhen CPI-ITEM-TYPE = "I" Or CPI-ITEM-TYPE = "N"
ICC-ITEM-GROUP→ITE-ITEM-GROUP
CPI-ITEM→ITE-ITEM
Prac Temp ItemCXPTMPITEMNot 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
VendorAPVENMASTRequiredWhen CPI-VENDOR != Spaces
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
CPI-VENDOR→VEN-VENDOR
Vendor GroupAPCOMPANYRequired
CPI-COMPANY→CPY-COMPANY
WhdemandWHDEMANDRequired
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
WhdemndhdrWHDEMNDHDRNot Required
CPI-COMPANY→WDH-COMPANY
"CX"→WDH-SYSTEM-CD
CPI-CASE→WDH-DOC-NBR

One to many (4) — child tables

RelationTableRulesConditionField map
ItemsubITEMSUB
ICC-ITEM-GROUP→ITS-ITEM-GROUP
CPI-ITEM→ITS-ITEM
"S"→ITS-SUBTYPE
—→ITS-SUB-ITEM
PolinesrcPOLINESRCValid 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
WhshiplineWHSHIPLINEValid 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
WhshipmentWHSHIPMENT
CPI-COMPANY→WHS-COMPANY
CPI-FROM-LOCATION→WHS-LOCATION
CPI-CASE→WHS-DOC-NBR
—→WHS-SHIPMENT-NBR

Programs

Updated by (221)

Referenced by (3)