Lawson Insight Technical Documentation |
|
CXPTMPITEM
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 CXCP.1 OE114 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 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 AP125
AP126 AP131 AP25.1 AP25.2 AP26.1 AP27.1
AP30.4 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
IC28.1 MA180 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 OE10.1 OE10.2
OE10.3 OE10.4 OE10.5 OE10.6 OE10.7 OE10.8
OE11.1 OE11.4 OE11.8 OE11.9 OE110 OE111
OE113 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE81.1 OE810 OE830 OE90.1 OE90.2 PO100
PO101 PO122 PO131 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO33.1 PO34.1 PO35.1 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 POI3.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ35.1 WH20.2
WH20.7 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CTI-COMPANY Numeric 4
Element: Company This field contains the company number.
CTI-REQ-LOCATION Alpha 5
Element: To Location 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.
CTI-PREF-CODE Alpha 8
Element: Procedure CodeThis field contains the Preference List
Code.
CTI-PROC-TYPE Alpha 8
Element: Procedure CodeThe 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.
CTI-PROC-CODE Alpha 8
Element: Procedure CodeThe 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.
CTI-PRACTNR-ID Alpha 15
Element: Practitioner IThis field contains the practitioner ID.
Form CX04.1 (Practitioner) is used to
define practitioner IDs.
CTI-LINE-NBR Numeric 6
Element: Line Number This field contains the line number.
CTI-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description This field contains the item AP131 AP25.1
description. This value defaults from AP25.2 AP26.1
the item master for inventoried (I) or AP27.1 AP30.4
non-inventory-tracked (N) type items and BL120 BL122
must be added manually for all other BL130 BL20.1
types. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-ITEM-TYPE Alpha 1 AP125 AP126
Element: Item Type This field identifies the line item AP131 AP25.1
type. AP25.2 AP26.1
I = Inventoried Item AP27.1 AP30.4
N = Non-Stock Item BL120 BL122
S = Service Item BL130 BL20.1
X = Special Item BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-SERVICE-CODE Alpha 1
Element: Service Code
CTI-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This field contains the requested AP131 AP25.1
quantity to be picked. AP25.2 AP26.1
AP27.1 AP30.4
This field defaults to one (1) if no BL120 BL122
value is entered. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis field contains the valid stock AP131 AP25.1
unit of measure for this item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-ISSUE-COST Signed 18.2 AP125 AP126
Element: Intl Amt This field contains either a AP131 AP25.1
system-generated or a user-defined cost. AP25.2 AP26.1
AP27.1 AP30.4
Defaults: BL120 BL122
BL130 BL20.1
For inventoried (I) type items, the BL20.3 BL21.2
Case Carts system defaults the issue BL21.5 BL29.1
cost from the Inventory Control system BL29.2 BL520
costing routine. BL820 BL92.1
CXCP.1 IC28.1
For non-inventory tracked (N, X, or S) MA180 MA530
type items, the Case Carts system MA531 MA60.2
defaults the cost from the Purchase MA60.3 MA60.5
Order system unit cost default routine. MA61.1 MA66.2
MA66.3 MA67.1
You can override the defaulted costs by MA67.2 MA70.1
making a line change. MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-FROM-COMPANY Numeric 4 AP125 AP126
Element: Company This is the company that is the source AP131 AP25.1
of the items. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-FROM-LOCATION Alpha 5 AP125 AP126
Element: Location Code This is the inventory location that AP131 AP25.1
supplies the items or it is the purchase AP25.2 AP26.1
order ship to location that receives the AP27.1 AP30.4
items. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThe accounting unit is a shorthand AP131 AP25.1
notation representing the variable level AP25.2 AP26.1
number. When used in the General Ledger AP27.1 AP30.4
Account Master file, the accounting unit BL120 BL122
must be defined in the General Ledger BL130 BL20.1
Names file as a posting accounting unit. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field along with the accounting AP131 AP25.1
unit and subaccount make up the location AP25.2 AP26.1
(account) where amounts and other AP27.1 AP30.4
account information is stored. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-SUB-ACCOUNT Numeric 4 AP125 AP126
Element: Subaccount This field along with the accounting AP131 AP25.1
unit and subaccount make up the location AP25.2 AP26.1
(account) where amounts and other AP27.1 AP30.4
account information is stored. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-CHARGE-NBR Alpha 10 AP125 AP126
Element: Charge Nbr The number used by the patient billing AP131 AP25.1
system to charge patients for items AP25.2 AP26.1
used. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-CHARGEABLE-FL Alpha 1 AP125 AP126
Element: All Flag This field indicates whether the item AP131 AP25.1
is a patient chargeable item. AP25.2 AP26.1
AP27.1 AP30.4
Select Yes if the item is a patient BL120 BL122
chargeable item. BL130 BL20.1
Y = Yes BL20.3 BL21.2
N = No BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-PRICE Signed 18.2
Element: Intl Amt This field contains the amount that the
patient will be charged for the item.
CTI-REV-CENTER Alpha 5 AP125 AP126
Element: Rev Center The revenue center is the department or AP131 AP25.1
accounting unit to be credited by the AP25.2 AP26.1
reimbursement. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
...
CTI-POST-ITEM-FL Alpha 1
Element: Post Item Fl 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
CTI-POST-DAY Numeric 2
Element: Posting Day 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
CTI-PATIENT-CLASS Alpha 1
Element: Patient Class This provides for a category of patient.
I = Inpatient
O = Outpatient
CTI-REPEAT-FL Alpha 1
Element: All Flag This field is reserved for a future
release of the Case Carts system.
Y = Yes
N = No
CTI-NBR-DAYS Numeric 2
Element: Number of DaysCare 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.
CTI-UNITS-PER-DAY Numeric 3
Element: Units Per Day 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.
CTI-PICK-FL Alpha 1
Element: Picking OptionThis 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
CTI-ACCT-CATEGORY Alpha 5
Element: Account CategoThis 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.
CTI-ACTIVITY Alpha 15
Element: Activity 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.
CTI-ATN-OBJ-ID Numeric 12
Object This field contains a system-assigned
Identification identifier that provides access to data
in related files.
CTI-STORAGE-LOC Alpha 7
Element: Bin This field contains the storage
location identifier.
CTI-STOCKLESS-FL Alpha 1
Element: All Flag 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
CTI-AGREEMENT-REF Alpha 30
Element: Agreement Ref
CTI-COST-CD Alpha 1
Unit Cost Origin This field contains the unit cost
Code origin code.
E = Entered
L = Last Cost
C = Contract
T = Catalog/Quote
B = Blanket
P = Last PO Created
CTI-VENDOR Alpha 9 (Right Justified)
Element: Vendor ID The vendor's identification code.
CTI-CREATE-PO-CD Alpha 1
Create Purchase This code indicates whether this
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-PO-CODE Alpha 4
Element: Po Code This is the purchase order code.
CTI-TAXABLE-FLAG Alpha 1
Taxable or This field defines whether or not the
Non-Taxable Flag item is taxable.
Y = Yes
N = No
CTI-TAX-CODE Alpha 10
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
CTI-CERT-REQ-FL Alpha 1
Certification This flag indicates whether a
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
Element: All Flag This flag indicates whether this item
has to be inspected when received via
PO.
Y = Yes
N = No
CTI-COST-OPTION Alpha 1
Element: Cost Option 1 = Cost Required
2 = No Charge
3 = Vendor Determined
CTI-MANUF-CODE Alpha 4
Element: Manufacturer'sThis field contains a user-defined code
that indicates the manufacturer of an
item.
CTI-MANUF-DIVISION Alpha 4
Manufacturer's This field contains a user-defined code
Division that indicates which division of a
manufacturer is tied to an item.
CTI-MANUF-NBR Alpha 15
Manufacturer's Item This is the identifier that the
Number manufacturer has assigned to an item.
CTI-LEADTIME-DAYS Numeric 3
Leadtime Number of This value (in days) indicates whether
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
Element: Put Out Fl 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.
CTI-USE-IDENTIFIER Alpha 1
Element: Use Identifier
CTI-CONSIGNMENT-FL Alpha 1
Element: Consignment Fl
CXPTMPITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CTISET1 COMPANY BL92.1 CXCP.1
REQ-LOCATION OE114 WH130
PREF-CODE WH132 WH190
PROC-TYPE WH222 WH30.1
PROC-CODE WH30.2 WH30.3
PRACTNR-ID WH30.4 WH31.1
LINE-NBR WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.5
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
CTISET2 COMPANY AP125 AP126
REQ-LOCATION AP131 AP25.1
ITEM AP25.2 AP26.1
PREF-CODE AP27.1 AP30.4
PROC-TYPE BL120 BL122
PROC-CODE BL130 BL20.1
PRACTNR-ID BL20.3 BL21.2
LINE-NBR BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 IC28.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
...
CXPTMPITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cxpreftemp CXPREFTEMP Required
CTI-COMPANY -> -COMPANY
CTI-REQ-LOCATION -> -REQ-LOCATION
CTI-PREF-CODE -> -PREF-CODE
CTI-PROC-TYPE -> -PROC-TYPE
CTI-PROC-CODE -> -PROC-CODE
CTI-PRACTNR-ID -> -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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemsub ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
CTI-ITEM -> ITS-ITEM
"S" -> ITS-SUBTYPE
ITS-SUB-ITEM
|