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 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 OE113 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 WH20.2 WH20.7
UPDATED BY
BL04.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OCI-COMPANY Numeric 4 BL04.1
Company The company number represents an
established company and is entered on
all function codes.
OCI-CUSTOMER Alpha 9 (Right Justified) BL04.1
Customer Number This field contains the number that
represents a customer.
OCI-ITEM Alpha 32 BL04.1 BL92.1
Item Number The item's identifier as set up in the OE10.1 OE10.2
Inventory Control system. OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
WH20.2 WH20.7
OCI-CUST-ITEM Alpha 32 BL04.1
Customer Item Number The customer's number for your
inventory item.
OCI-CUST-DESC Alpha 30 BL04.1 BL122
Cust Desc The customer's description for your OE112 OE114
item. WH126 WH224
OCI-CUST-ITEM-16 Derived
Cust Item 16 This field contains the 16-character
customer number for your item.
OCI-ITEM-16 Derived
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 BL92.1
CUSTOMER OE10.1 OE10.2
CUST-ITEM OE10.3 OE10.4
ITEM OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
WH20.2 WH20.7
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
|