|
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 WH126 WH224
BL120 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 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 This field contains the number that
represents a customer.
OCI-ITEM Alpha 32 BL04.1 BL120
Element: Item 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 WH20.2
WH20.7
OCI-CUST-ITEM Alpha 32 BL04.1
Element: Item The customer's number for your
inventory item.
OCI-CUST-DESC Alpha 30 BL04.1 BL122
Element: Item Desc The customer's description for your WH126 WH224
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 BL04.1 BL122
CUSTOMER BL123 BL204
ITEM BL80.1 WH126
CUST-ITEM 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 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
|