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
WH126 WH224 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OCI-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
OCI-CUSTOMER Alpha 9 (Right Justified)
Element: Customer NumbeThis field contains the number that
represents a customer.
OCI-ITEM Alpha 32 WH20.2 WH20.7
Element: Item Number The item's identifier as set up in the
Inventory Control system.
OCI-CUST-ITEM Alpha 32
Element: Item Number The customer's number for your
inventory item.
OCI-CUST-DESC Alpha 30 WH126 WH224
Element: Item DescriptiThe customer's description for your
item.
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 WH126 WH224
CUSTOMER
ITEM
CUST-ITEM
OCISET2 COMPANY WH20.2 WH20.7
CUSTOMER
CUST-ITEM
ITEM
OECUSTITEM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
OCI-COMPANY -> -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
|
