OECUSTITEM

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.
UPDATED BY
WH126 WH20.2 WH20.7 WH224

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
OCI-COMPANY
Element: Company
Numeric 4
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
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
OCI-ITEM
Element: Item
Alpha 32
The item's identifier as set up in the Inventory Control system.
WH20.2 WH20.7
OCI-CUST-ITEM
Element: Item
Alpha 32
The customer's number for your inventory item.
OCI-CUST-DESC
Element: Item Desc
Alpha 30
The customer's description for your item.
WH126 WH224
OCI-CUST-ITEM-16
Element: Cust Item 16
Derived
This field contains the 16-character customer number for your item.
OCI-ITEM-16
Element: Item 16
Derived
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
CUSTOMER
ITEM
CUST-ITEM
WH126 WH224
OCISET2 COMPANY
CUSTOMER
CUST-ITEM
ITEM
WH20.2 WH20.7


OECUSTITEM FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:09:30 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.