Lawson Insight Technical Documentation |
|
OECUSTITEM
OECUSTITEM FILE
Customer Item Xref
This file stores cross-reference relationships established between your
company item identifier and your customer's identifier for those items. These
relationships are optional and allow the person entering orders into the
system to use the customer's number when entering line items.
REFERENCED BY
BL122 BL123 BL204 BL80.1 OE112 OE114
WH126 WH224 BL120 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.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 OE810 OE830 WH20.2
WH20.7
UPDATED BY
BL04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OCI-COMPANY Numeric 4 BL04.1
Element: Company 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.
OCI-CUSTOMER Alpha 9 (Right Justified) BL04.1
Element: Customer NumbeThis field contains the number that
represents a customer.
OCI-ITEM Alpha 32 BL04.1 BL120
Element: Item Number The item's identifier as set up in the BL122 BL130
Inventory Control system. BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.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
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.2 WH20.7
OCI-CUST-ITEM Alpha 32 BL04.1
Element: Item Number The customer's number for your
inventory item.
OCI-CUST-DESC Alpha 30 BL04.1 BL122
Element: Item DescriptiThe customer's description for your OE112 OE114
item. WH126 WH224
OCI-CUST-ITEM-16 Derived
Element: Cust Item 16 This field contains the 16-character
customer number for your item.
OCI-ITEM-16 Derived
Element: Item 16 This field contains the first 16
characters of the item's identifier.
This information is used by inquiries
and reports.
OECUSTITEM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OCISET1 COMPANY BL04.1 BL122
CUSTOMER BL123 BL204
ITEM BL80.1 OE112
CUST-ITEM OE114 WH126
WH224
OCISET2 COMPANY BL04.1 BL120
CUSTOMER BL122 BL130
CUST-ITEM BL20.1 BL20.3
ITEM BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.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
...
OECUSTITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OCI-COMPANY -> ACO-COMPANY
Arcustgrp ARCUSTGRP Required
ACO-CUST-GROUP -> ACG-CUST-GROUP
Custdesc CUSTDESC Required
ACO-CUST-GROUP -> CUD-CUST-GROUP
OCI-CUSTOMER -> CUD-CUSTOMER
Iccompany ICCOMPANY Not Required
OCI-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
OCI-ITEM -> ITE-ITEM
Oecompany OECOMPANY Required
OCI-COMPANY -> OEC-COMPANY
|