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

OECUSTITEM FILE RELATIONS

ONE TO ONE RELATIONS

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