CXPTMPITEM

Template Items

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.

REFERENCED 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 API2.1
DR100 IC140 IC66.1 IC83.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 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 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO54.5 POCP.1 POI3.1 POID.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQIF.1 WH20.2 WH20.7


UPDATED BY
CX05.1 CX05.2 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX205 CX220 CX30.1 CX300 CX506
CX805 CXCP.1 CXMC.1 WH130 WH132 WH190
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 WH32.5 WH33.5 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTI-COMPANY
Element: Company
Numeric 4
This field contains the company number.
CX05.1 CX05.2
CX805 CXMC.1
CTI-REQ-LOCATION
Element: Req Location
Alpha 5
This 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
Element: Proc Code
Alpha 8
This field contains the Preference List Code.
CX05.1 CX05.2
CX805 CXMC.1
CTI-PROC-TYPE
Element: Proc Code
Alpha 8
The 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
Element: Proc Code
Alpha 8
The 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
Element: Practnr Id
Alpha 15
This 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
Element: Line Nbr
Numeric 6
This field contains the line number.
CX05.1 CX05.2
CX805
CTI-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
...
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 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-DESCRIPTION
Element: 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-ITEM-TYPE
Element: Item Type
Alpha 1
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-SERVICE-CODE
Element: Service Code
Alpha 1
CX05.1 CX05.2
CX805
CTI-QUANTITY
Element: Quantity
Signed 13.4
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-UOM
Element: Uom
Alpha 4
This field contains the valid stock unit of measure for this item.
...
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 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-ISSUE-COST
Element: Intl Amt
Signed 18.2
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-FROM-COMPANY
Element: Company
Numeric 4
Identifies 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-FROM-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
...
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 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-ACCT-UNIT
Element: Acct Unit
Alpha 15
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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-ACCOUNT
Element: Account
Numeric 6
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-CHARGE-NBR
Element: Charge Nbr
Alpha 10
The 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-CHARGEABLE-FL
Element: All Flag
Alpha 1
This 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-PRICE
Element: Intl Amt
Signed 18.2
This field contains the amount that the patient will be charged for the item.
CX05.1 CX05.2
CX805
CTI-REV-CENTER
Element: Rev Center
Alpha 5
The 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
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CX805
CXCP.1 DR100
IC140 IC66.1
IC83.1 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
MA43.7 MA44.1
MA44.2 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
CTI-POST-ITEM-FL
Element: Post Item Fl
Alpha 1
This 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
Element: Day
Numeric 2
This 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
99
CX05.1 CX05.2
CX805
CTI-PATIENT-CLASS
Element: Patient Class
Alpha 1
This provides for a category of patient.
I = Inpatient
O = Outpatient
CX05.1 CX05.2
CX805
CTI-REPEAT-FL
Element: All Flag
Alpha 1
This field is reserved for a future release of the Case Carts system.
Y = Yes
N = No
CX05.1 CX05.2
CX805
CTI-NBR-DAYS
Element: Nbr Days
Numeric 2
Care 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
Element: Units Per Day
Numeric 3
This 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
Element: Pick Fl
Alpha 1
This 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
Element: Acct Category
Alpha 5
This 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
Element: Activity
Alpha 15
This 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
Element: Obj Id
Numeric 12
This field contains a system-assigned identifier that provides access to data in related files.
CX05.1 CX05.2
CX805
CTI-STORAGE-LOC
Element: Bin
Alpha 7
This field contains the storage location identifier.
CX05.1 CX05.2
CX805
CTI-STOCKLESS-FL
Element: All Flag
Alpha 1
This 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
Element: Agreement Ref
Alpha 30
CX05.1 CX05.2
CX805
CTI-COST-CD
Element: Cost Cd
Alpha 1
This 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
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
CX05.1 CX05.2
CX805
CTI-CREATE-PO-CD
Element: Create Po Cd
Alpha 1
This 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
Element: Po Code
Alpha 4
This is the purchase order code.
CX05.1 CX05.2
CX805
CTI-TAXABLE-FLAG
Element: Taxable Flag
Alpha 1
This field defines whether or not the item is taxable.
Y = Yes
N = No
CX05.1 CX05.2
CX805
CTI-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
CX05.1 CX05.2
CX805
CTI-CERT-REQ-FL
Element: Cert Req Fl
Alpha 1
This 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
Element: All Flag
Alpha 1

Y = Yes
N = No
CX05.1 CX05.2
CX805
CTI-COST-OPTION
Element: Cost Option
Alpha 1

1 = Cost Required
2 = No Charge
3 = Vendor Determined
CX05.1 CX05.2
CX805
CTI-MANUF-CODE
Element: Manuf Code
Alpha 4
This field contains a user-defined code that indicates the manufacturer of an item.
CX05.1 CX05.2
CX805
CTI-MANUF-DIVISION
Element: Manuf Division
Alpha 4
This 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
Element: Manuf Nbr
Alpha 35
This is the identifier that the manufacturer has assigned to an item.
CX05.1 CX05.2
CX805
CTI-LEADTIME-DAYS
Element: Leadtime Days
Numeric 3
This 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
Element: Put Out Fl
Numeric 3
This 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
Element: Use Identifier
Alpha 1
CX05.1 CX05.2
CX805
CTI-CONSIGNMENT-FL
Element: Consignment Fl
Alpha 1
CX05.1 CX05.2
CX805


CXPTMPITEM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTISET1 COMPANY
REQ-LOCATION
PREF-CODE
PROC-TYPE
PROC-CODE
PRACTNR-ID
LINE-NBR
...
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
CXMC.1 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
CTISET2 COMPANY
REQ-LOCATION
ITEM
PREF-CODE
PROC-TYPE
PROC-CODE
PRACTNR-ID
LINE-NBR
...
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 API2.1
CX05.1 CX05.2
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX220 CX30.1
CX300 CX506


CXPTMPITEM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cxpreftemp CXPREFTEMP Required
CTI-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 Location ICLOCATION Required
When CTI-FROM-LOCATION !=Spaces
CTI-COMPANY->ICL-COMPANY
CTI-FROM-LOCATION->ICL-LOCATION
Ic Company ICCOMPANY Required
CTI-COMPANY->ICC-COMPANY
Item ITEMMAST Not Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
CTI-ITEM->ITE-ITEM
Item Location ITEMLOC Not Required
Valid When CTI-FROM-LOCATION !=Spaces
CTI-COMPANY->ITL-COMPANY
CTI-FROM-LOCATION->ITL-LOCATION
CTI-ITEM->ITL-ITEM
Vendor APVENMAST Required
When CTI-VENDOR !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
CTI-VENDOR->VEN-VENDOR
Vendor Group APCOMPANY Required
CTI-COMPANY->CPY-COMPANY


CXPTMPITEM FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemsub ITEMSUB
ICC-ITEM-GROUP->ITS-ITEM-GROUP
CTI-ITEM->ITS-ITEM
"S"->ITS-SUBTYPE
  ITS-SUB-ITEM


File created: Thu Jun 09 11:12:31 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.