CXPTMPITEM – Template Items

System
Case Carts (CX)
Prefix
CTI
Primary key
COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR
Fields
52
Updated by
4 programs
Referenced by
221 programs

CXPTMPITEM is the Template Items table in Lawson Case Carts (prefix CTI). It is indexed by COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBR (CTISET1); alternate indexes: CTISET2. It is related 1:1 to CXPREFTEMP, ICLOCATION, ICCOMPANY, ITEMMAST, ITEMLOC, APVENMAST and APCOMPANY and 1:M to ITEMSUB. It is updated by CX05.1, CX05.2, CX805 and CXMC.1 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 213 more. The table has 52 fields, 2 indexes and 8 documented relations.

About CXPTMPITEM

The Template Items file contains the items that are included in a preference template. The information in this record is used to provide default item information in Preference Items file records when adding preference templates to a case. Use CX05.1 (Preference Template) to add or delete items from a preference template.

Fields (52)

Column = COBOL field name without the CTI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CTI-COMPANY PK
COMPANY		Numeric 4This field contains the company number.CX05.1, CX05.2, CX805, CXMC.1
CTI-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.CX05.1, CX05.2, CX805, CXMC.1
CTI-PREF-CODE PK
PREF_CODE		Alpha 8This field contains the Preference List Code.CX05.1, CX05.2, CX805, CXMC.1
CTI-PROC-TYPE PK
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.CX05.1, CX05.2, CX805, CXMC.1
CTI-PROC-CODE PK
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.CX05.1, CX05.2, CX805, CXMC.1
CTI-PRACTNR-ID PK
PRACTNR_ID		Alpha 15This field contains the practitioner ID. Form CX04.1 (Practitioner) is used to define practitioner IDs.CX05.1, CX05.2, CX805, CXMC.1
CTI-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.CX05.1, CX05.2, CX805
CTI-ITEM
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)
CTI-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the item description. This value defaults from the item master for inventoried (I) or non-inventory-tracked (N) type items and must be added manually for all other types.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-ITEM-TYPE
ITEM_TYPE		Alpha 1This field identifies the line item type.
  • 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)
CTI-SERVICE-CODE
SERVICE_CODE		Alpha 1—CX05.1, CX05.2, CX805
CTI-QUANTITY
QUANTITY		Signed 13.4This field contains the requested quantity to be picked. This field defaults to one (1) if no value is entered.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-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)
CTI-ISSUE-COST
ISSUE_COST		Signed 18.2This field contains either a system-generated or a user-defined cost. Defaults: For inventoried (I) type items, the Case Carts system defaults the issue cost from the Inventory Control system costing routine. For non-inventory tracked (N, X, or S) type items, the Case Carts system defaults the cost from the Purchase Order system unit cost default routine. You can override the defaulted costs by making a line change.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-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)
CTI-FROM-LOCATION
FROM_LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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)
CTI-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-CHARGE-NBR
CHARGE_NBR		Alpha 80The number 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)
CTI-CHARGEABLE-FL
CHARGEABLE_FL		Alpha 1This field indicates whether the item is a patient chargeable item. Select Yes if the item is a patient chargeable item.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-PRICE
PRICE		Signed 18.2This field contains the amount that the patient will be charged for the item.CX05.1, CX05.2, CX805
CTI-REV-CENTER
REV_CENTER		Alpha 5The revenue center is the department or accounting unit to be credited by the reimbursement.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
CTI-POST-ITEM-FL
POST_ITEM_FL		Alpha 1This field indicates whether or not the item is used in the procedure (an intraoperative item) or is a postoperative or preoperative item.
  • 1 Intra-Op
  • 2 Post-Op
  • 3 Pre-Op
CX05.1, CX05.2, CX805
CTI-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 value indicates the day to start picking care items. 00 99CX05.1, CX05.2, CX805
CTI-PATIENT-CLASS
PATIENT_CLASS		Alpha 1This provides for a category of patient.
  • I Inpatient
  • O Outpatient
CX05.1, CX05.2, CX805
CTI-REPEAT-FL
REPEAT_FL		Alpha 1This field is reserved for a future release of the Case Carts system.
  • Y Yes
  • N No
CX05.1, CX05.2, CX805
CTI-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: None. 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 0) 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 0 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.CX05.1, CX05.2, CX805
CTI-UNITS-PER-DAY
UNITS_PER_DAY		Numeric 3This value defines the number of item units to be used per care day. Use this field with the Item Usage flag. Be aware that you do not use this field with Care Days and Units Per Day fields.CX05.1, CX05.2, CX805
CTI-PICK-FL
PICK_FL		Alpha 1This field indicates in which system to run the pick list program. Important: Your selection affects more than just printing the pick list. Your decision also affects whether shipment records will be created so that items are picked for the correct case by shipment number. The shipment records also exist 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 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 helps you 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
CX05.1, CX05.2, CX805
CTI-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.CX05.1, CX05.2, CX805
CTI-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.CX05.1, CX05.2, CX805
CTI-ATN-OBJ-ID
ATN_OBJ_ID		Numeric 12This field contains a system-assigned identifier that provides access to data in related files.CX05.1, CX05.2, CX805
CTI-STORAGE-LOC
STORAGE_LOC		Alpha 7This field contains the storage location identifier.CX05.1, CX05.2, CX805
CTI-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
CX05.1, CX05.2, CX805
CTI-AGREEMENT-REF
AGREEMENT_REF		Alpha 30—CX05.1, CX05.2, CX805
CTI-COST-CD
COST_CD		Alpha 1This field contains the unit cost origin code.
  • E Entered
  • L Last Cost
  • C Contract
  • T Catalog/Quote
  • B Blanket
  • P Last PO Created
CX05.1, CX05.2, CX805
CTI-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.CX05.1, CX05.2, CX805
CTI-CREATE-PO-CD
CREATE_PO_CD		Alpha 1This code indicates whether this inventory item is to be purchased by a purchase order instead of picked from inventory.
  • N No, pick from inventory.
  • Y Yes, create purchase order.
CX05.1, CX05.2, CX805
CTI-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.CX05.1, CX05.2, CX805
CTI-TAXABLE-FLAG
TAXABLE_FLAG		Alpha 1This field defines whether or not the item is taxable.
  • Y Yes
  • N No
CX05.1, CX05.2, CX805
CTI-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.CX05.1, CX05.2, CX805
CTI-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. Select No if Certification not required. Select Yes if Certification required.
  • Y Yes
  • N No
CX05.1, CX05.2, CX805
CTI-INSP-REQ-FL
INSP_REQ_FL		Alpha 1—
  • Y Yes
  • N No
CX05.1, CX05.2, CX805
CTI-COST-OPTION
COST_OPTION		Alpha 1—
  • 1 Cost Required
  • 2 No Charge
  • 3 Vendor Determined
CX05.1, CX05.2, CX805
CTI-MANUF-CODE
MANUF_CODE		Alpha 4This field contains a user-defined code that indicates the manufacturer of an item.CX05.1, CX05.2, CX805
CTI-MANUF-DIVISION
MANUF_DIVISION		Alpha 4This field contains a user-defined code that indicates which division of a manufacturer is tied to an item.CX05.1, CX05.2, CX805
CTI-MANUF-NBR
MANUF_NBR		Alpha 35This is the identifier that the manufacturer has assigned to an item.CX05.1, CX05.2, CX805
CTI-LEADTIME-DAYS
LEADTIME_DAYS		Numeric 3This value (in days) indicates whether the allocation for the item should be done immediately or at some future date. (For example, if a purchase order must be created for the item, the leadtime must allow time to create the order, send it, and receive the item.) The future date for allocation is calculated using this value. If blank, the value defaults from the lead-time days defined on the Main tab of the template.CX05.1, CX05.2, CX805
CTI-PUT-OUT-FL
PUT_OUT_FL		Numeric 3This field will show up on the printed pick list and preference list to show how many of an item needs to opened for the procedure. This will help in reducing waste and returns. For example, if the item quantity is 4 but the practitioner wants only 2 opened, this value would be 2.CX05.1, CX05.2, CX805
CTI-USE-IDENTIFIER
USE_IDENTIFIER		Alpha 1—CX05.1, CX05.2, CX805
CTI-CONSIGNMENT-FL
CONSIGNMENT_FL		Alpha 1—CX05.1, CX05.2, CX805

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CTISET1COMPANY, REQ-LOCATION, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBRPrimaryCX05.1, CX05.2, CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX205 +22 more (list truncated in source)
CTISET2COMPANY, REQ-LOCATION, ITEM, PREF-CODE, PROC-TYPE, PROC-CODE, PRACTNR-ID, LINE-NBRAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
CxpreftempCXPREFTEMPRequiredCTI-COMPANY → CPT-COMPANY, CTI-REQ-LOCATION → CPT-REQ-LOCATION, CTI-PREF-CODE → CPT-PREF-CODE, CTI-PROC-TYPE → CPT-PROC-TYPE, CTI-PROC-CODE → CPT-PROC-CODE, CTI-PRACTNR-ID → CPT-PRACTNR-ID
From LocationICLOCATIONRequiredWhen CTI-FROM-LOCATION != SpacesCTI-COMPANY → ICL-COMPANY, CTI-FROM-LOCATION → ICL-LOCATION
Ic CompanyICCOMPANYRequiredCTI-COMPANY → ICC-COMPANY
ItemITEMMASTNot RequiredICC-ITEM-GROUP → ITE-ITEM-GROUP, CTI-ITEM → ITE-ITEM
Item LocationITEMLOCNot RequiredValid When CTI-FROM-LOCATION != SpacesCTI-COMPANY → ITL-COMPANY, CTI-FROM-LOCATION → ITL-LOCATION, CTI-ITEM → ITL-ITEM
VendorAPVENMASTRequiredWhen CTI-VENDOR != SpacesCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, CTI-VENDOR → VEN-VENDOR
Vendor GroupAPCOMPANYRequiredCTI-COMPANY → CPY-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
ItemsubITEMSUBICC-ITEM-GROUP → ITS-ITEM-GROUP, CTI-ITEM → ITS-ITEM, "S" → ITS-SUBTYPE, → ITS-SUB-ITEM

Programs

Updated by (4)

Referenced by (221)