CXPTMPITEM FILE
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
BL92.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX205 CX220 CX30.1 CX300 CX506 CXCP.1
OE114 WH130 WH132 WH190 WH222 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE830 OE950 PO31.1 RQ35.1
WH20.7 WO132 WO140
UPDATED BY
CX05.1 CX05.2 CX805 CXMC.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTI-COMPANY Numeric 4 CX05.1 CX05.2
Company This field contains the company number. CX805 CXMC.1
CTI-REQ-LOCATION Alpha 5 CX05.1 CX05.2
To Location This field contains the location CX805 CXMC.1
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.
CTI-PREF-CODE Alpha 8 CX05.1 CX05.2
Preference Code This field contains the Preference List CX805 CXMC.1
Code.
CTI-PROC-TYPE Alpha 8 CX05.1 CX05.2
Procedure Type The procedure type is the first of two CX805 CXMC.1
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.
CTI-PROC-CODE Alpha 8 CX05.1 CX05.2
Procedure Code The procedure code is the second of two CX805 CXMC.1
fields that uniquely identify a
procedure. The procedure code is an
identifier for a specific procedure
within a procedure type.
CTI-PRACTNR-ID Alpha 15 CX05.1 CX05.2
Practitioner ID This field contains the practitioner ID. CX805 CXMC.1
Form CX04.1 (Practitioner) is used to
define practitioner IDs.
CTI-LINE-NBR Numeric 6 CX05.1 CX05.2
Line Number This field contains the line number. CX805
CTI-ITEM Alpha 32 BL92.1 CX05.1
Item Number This field contains the item CX05.2 CX100
identifier. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-DESCRIPTION Alpha 30 (Lower Case) BL92.1 CX05.1
Description This field contains the item CX05.2 CX100
description. This value defaults from CX20.1 CX20.2
the item master for inventoried (I) or CX20.4 CX20.5
non-inventory-tracked (N) type items and CX220 CX30.1
must be added manually for all other CX300 CX506
types. CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-ITEM-TYPE Alpha 1 BL92.1 CX05.1
Item Type This field identifies the line item CX05.2 CX100
type. CX20.1 CX20.2
I = Inventoried Item CX20.4 CX20.5
N = Non-Stock Item CX220 CX30.1
S = Service Item CX300 CX506
X = Special Item CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-QUANTITY Signed 13.4 BL92.1 CX05.1
Quantity This field contains the requested CX05.2 CX100
quantity to be picked. CX20.1 CX20.2
CX20.4 CX20.5
This field defaults to one (1) if no CX220 CX30.1
value is entered. CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-UOM Alpha 4 BL92.1 CX05.1
Unit of Measure This field contains the valid stock CX05.2 CX100
unit of measure for this item. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-ISSUE-COST Signed 15.2 BL92.1 CX05.1
Issue Cost This field contains either a CX05.2 CX100
system-generated or a user-defined cost. CX20.1 CX20.2
CX20.4 CX20.5
Defaults: CX220 CX30.1
CX300 CX506
For inventoried (I) type items, the CX805 CXCP.1
Case Carts system defaults the issue OE114 OE30.1
cost from the Inventory Control system OE30.2 OE30.3
costing routine. OE30.4 OE30.5
OE30.6 OE30.7
For non-inventory tracked (N, X, or S) OE30.9 OE830
type items, the Case Carts system OE950 PO31.1
defaults the cost from the Purchase RQ35.1 WH130
Order system unit cost default routine. WH132 WH190
WH20.7 WH222
You can override the defaulted costs by WH30.1 WH30.2
making a line change. WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-FROM-COMPANY Numeric 4 BL92.1 CX05.1
From-Company This is the company that is the source CX05.2 CX100
of the items. CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-FROM-LOCATION Alpha 5 BL92.1 CX05.1
From-Location This is the inventory location that CX05.2 CX100
supplies the items or it is the purchase CX20.1 CX20.2
order ship to location that receives the CX20.4 CX20.5
items. CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-ACCT-UNIT Alpha 15 BL92.1 CX05.1
Accounting Unit The accounting unit is a shorthand CX05.2 CX100
notation representing the variable level CX20.1 CX20.2
number. When used in the General Ledger CX20.4 CX20.5
Account Master file, the accounting unit CX220 CX30.1
must be defined in the General Ledger CX300 CX506
Names file as a posting accounting unit. CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-ACCOUNT Numeric 6 BL92.1 CX05.1
Account This field along with the accounting CX05.2 CX100
unit and subaccount make up the location CX20.1 CX20.2
(account) where amounts and other CX20.4 CX20.5
account information is stored. CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-SUB-ACCOUNT Numeric 4 BL92.1 CX05.1
Subaccount This field along with the accounting CX05.2 CX100
unit and subaccount make up the location CX20.1 CX20.2
(account) where amounts and other CX20.4 CX20.5
account information is stored. CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-CHARGE-NBR Alpha 10 BL92.1 CX05.1
Charge Number The number used by the patient billing CX05.2 CX100
system to charge patients for items CX20.1 CX20.2
used. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-CHARGEABLE-FL Alpha 1 BL92.1 CX05.1
Chargeable Flag This field indicates whether the item CX05.2 CX100
is a patient chargeable item. CX20.1 CX20.2
CX20.4 CX20.5
Select Yes if the item is a patient CX220 CX30.1
chargeable item. CX300 CX506
Y = Yes CX805 CXCP.1
N = No OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-PRICE Signed 15.2 CX05.1 CX05.2
Price This field contains the amount that the CX805
patient will be charged for the item.
CTI-REV-CENTER Alpha 5 BL92.1 CX05.1
Revenue Center The revenue center is the department or CX05.2 CX100
accounting unit to be credited by the CX20.1 CX20.2
reimbursement. CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CX805 CXCP.1
OE114 OE30.1
OE30.2 OE30.3
OE30.4 OE30.5
OE30.6 OE30.7
OE30.9 OE830
OE950 PO31.1
RQ35.1 WH130
WH132 WH190
WH20.7 WH222
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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 WO132
WO140
CTI-POST-ITEM-FL Alpha 1 CX05.1 CX05.2
Post Item Flag This field indicates whether or not the CX805
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
CTI-POST-DAY Numeric 2 CX05.1 CX05.2
Posting Day This field defines the day of the CX805
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
CTI-PATIENT-CLASS Alpha 1 CX05.1 CX05.2
Patient Class This provides for a category of patient. CX805
I = Inpatient
O = Outpatient
CTI-REPEAT-FL Alpha 1 CX05.1 CX05.2
Repeat Flag This field is reserved for a future CX805
release of the Case Carts system.
Y = Yes
N = No
CTI-NBR-DAYS Numeric 2 CX05.1 CX05.2
Number of Days Care days are the total number of days CX805
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.
CTI-UNITS-PER-DAY Numeric 3 CX05.1 CX05.2
Units for a Day This value defines the number of item CX805
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.
CTI-PICK-FL Alpha 1 CX05.1 CX05.2
Picking Option Flag This field indicates in which system to CX805
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
CTI-ACCT-CATEGORY Alpha 5 CX05.1 CX05.2
Account Category This field contains a valid account CX805
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.
CTI-ACTIVITY Alpha 15 CX05.1 CX05.2
Activity This field contains a valid activity CX805
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.
CTI-ATN-OBJ-ID Numeric 12 CX05.1 CX05.2
AC System Object ID This field contains a system-assigned CX805
(Sales) identifier that provides access to data
in related files.
CTI-STORAGE-LOC Alpha 7 CX05.1 CX05.2
Storage Location This field contains the storage CX805
location identifier.
CTI-STOCKLESS-FL Alpha 1 CX05.1 CX05.2
Stockless Flag This flag indicates whether or not the CX805
item is a stockless item.
Note: Use of this field is reserved
for a future release.
Y = Yes
N = No
CTI-CONTRACT-NBR Alpha 14 CX05.1 CX05.2
Contract Number This is a number to indicate to the CX805
vendor which price agreement an item or
items are operating under.
If this number is entered on or
defaulted to a purchase order line, it
is an indication of the vendor contract
that line is tied to. The contract
number can be defaulted to the purchase
order line. The default occurs by
leaving the field blank when creating
the purchase order and having the system
attempt to find a contract number from a
contract-type standard order. The system
finds the number based on the item
number for the line and vendor for the
purchase order.
If no contract number is entered on or
defaulted to the line from a contract
type standard order, a contract number
entered on the purchase order header
will default to the line.
A contract number can also be tied to a
blanket type standard order, and any
purchase orders created from the blanket
order will have the contract number from
the blanket on the header and lines.
The contract number can also be
defaulted to a requisition line as the
requisition line is created. The
contract number will then be carried
over to the purchase order line that is
created from the requisition line.
CTI-COST-CD Alpha 1 CX05.1 CX05.2
Unit Cost Origin This field contains the unit cost CX805
Code origin code.
E = Entered
L = Last Cost
Q = Quote
S = Standard Order
O = Order Entry
C = Contract
N = Last PO Created
Y = Copied from PO
P = Override Contract
D = Standard Cost
A = Average Cost
CTI-VENDOR Alpha 9 CX05.1 CX05.2
Vendor ID The vendor's identification code. CX805
CTI-CREATE-PO-CD Alpha 1 CX05.1 CX05.2
Create Purchase This code indicates whether this CX805
Order Code 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.
CTI-TAXABLE-FLAG Alpha 1 CX05.1 CX05.2
Taxable or This field defines whether or not the CX805
Non-Taxable Flag item is taxable.
Y = Yes
N = No
CTI-TAX-CODE Alpha 10 CX05.1 CX05.2
Tax Code This field contains a code representing CX805
specific tax information. This must be
valid Tax Code.
CTI-CERT-REQ-FL Alpha 1 CX05.1 CX05.2
Certification This flag indicates whether a CX805
Required Flag 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
CTI-INSP-REQ-FL Alpha 1 CX05.1 CX05.2
Inspection Required This flag indicates whether this item CX805
Flag has to be inspected when received via
PO.
Y = Yes
N = No
CTI-NO-COST Alpha 1 CX05.1 CX05.2
No Cost This field indicates whether or not the CX805
item is a No Charge item.
Y = Yes
N = No
CTI-MANUF-CODE Alpha 4 CX05.1 CX05.2
Manufacturer's Code This field contains a user-defined code CX805
that indicates the manufacturer of an
item.
CTI-MANUF-DIVISION Alpha 4 CX05.1 CX05.2
Manufacturer's This field contains a user-defined code CX805
Division that indicates which division of a
manufacturer is tied to an item.
CTI-MANUF-NBR Alpha 15 CX05.1 CX05.2
Manufacturer's Item This is the identifier that the CX805
Number manufacturer has assigned to an item.
CTI-LEADTIME-DAYS Numeric 3 CX05.1 CX05.2
Leadtime Number of This value (in days) indicates whether CX805
Days 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.
CTI-PUT-OUT-FL Numeric 3
Put Out Flag 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.
CXPTMPITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTISET1 COMPANY BL92.1 CX05.1
REQ-LOCATION CX05.2 CX100
PREF-CODE CX20.1 CX20.2
PROC-TYPE CX20.4 CX20.5
PROC-CODE CX205 CX220
PRACTNR-ID CX30.1 CX300
LINE-NBR CX506 CX805
CXCP.1 CXMC.1
OE114 WH130
WH132 WH190
WH222 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
...
CTISET2 COMPANY BL92.1 CX05.1
REQ-LOCATION CX05.2 CX100
ITEM CX20.1 CX20.2
PREF-CODE CX20.4 CX20.5
PROC-TYPE CX205 CX220
PROC-CODE CX30.1 CX300
PRACTNR-ID CX506 CX805
LINE-NBR CXCP.1 OE114
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE830 OE950
PO31.1 RQ35.1
WH130 WH132
...
CTISET3 ATN-OBJ-ID KeyChange, Duplicates
CXPTMPITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxpreftemp CXPREFTEMP Required
CTI-COMPANY -> CPT-COMPANY (CPTSET1)
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
Po Item Vendor POITEMVEN Not Required
Valid When CTI-VENDOR != Spaces
CTI-COMPANY -> PIV-COMPANY
CTI-ITEM -> PIV-ITEM
CTI-VENDOR -> PIV-VENDOR
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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemsub ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
CTI-ITEM -> ITS-ITEM
ITS-SUB-ITEM
|