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 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. |
|
||
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. |
|
||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
OCISET1 |
COMPANY CUSTOMER ITEM CUST-ITEM |
|
| ||||||||
OCISET2 |
COMPANY CUSTOMER CUST-ITEM ITEM |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Arcomp | ARCOMP |
Required
| ||||||
Arcustgrp | ARCUSTGRP |
Required
| ||||||
Custdesc | CUSTDESC |
Required
| ||||||
Iccompany | ICCOMPANY |
Not Required
| ||||||
Itemmast | ITEMMAST |
Required
| ||||||
Oecompany | OECOMPANY |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.