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
BL123 BL204 BL80.1 WH126 WH224
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
Item Number The item's identifier as set up in the
Inventory Control system.
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 WH126
Cust Desc The customer's description for your WH224
item.
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 BL123
CUSTOMER BL204 BL80.1
ITEM WH126 WH224
CUST-ITEM
OCISET2 COMPANY BL04.1
CUSTOMER
CUST-ITEM
ITEM
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
|