OECUSTITEM – Customer Item Xref
- System
- Billing (BL)
- Prefix
OCI- Primary key
COMPANY,CUSTOMER,ITEM,CUST-ITEM- Fields
- 7
- Updated by
- 0 programs
- Referenced by
- 0 programs
OECUSTITEM is the Customer Item Xref table in Lawson Billing (prefix OCI). It is indexed by COMPANY, CUSTOMER, ITEM, CUST-ITEM (OCISET1); alternate indexes: OCISET2. It is related 1:1 to ARCOMP, ARCUSTGRP, CUSTDESC, ICCOMPANY, ITEMMAST and OECOMPANY. The table has 7 fields, 2 indexes and 6 documented relations.
About OECUSTITEM
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.
Fields (7)
Column = COBOL field name without the OCI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
OCI-COMPANY PKCOMPANY | 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 PKCUSTOMER | Alpha 9 (Right Justified) | This field contains the number that represents a customer. | — |
OCI-ITEM PKITEM | Alpha 32 | The item's identifier as set up in the Inventory Control system. | WH20.2, WH20.7 |
OCI-CUST-ITEM PKCUST_ITEM | Alpha 32 | The customer's number for your inventory item. | — |
OCI-CUST-DESCCUST_DESC | Alpha 30 | The customer's description for your item. | WH126, WH224 |
OCI-CUST-ITEM-16CUST_ITEM_16 | Derived | This field contains the 16-character customer number for your item. | — |
OCI-ITEM-16ITEM_16 | Derived | This field contains the first 16 characters of the item's identifier. This information is used by inquiries and reports. | — |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
OCISET1 | COMPANY, CUSTOMER, ITEM, CUST-ITEM | Primary | WH126, WH224 | |
OCISET2 | COMPANY, CUSTOMER, CUST-ITEM, ITEM | WH20.2, WH20.7 |
Relations
One to one (6) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
Programs
No Lawson programs are documented as updating or referencing this table.