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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#OCI-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.—
#OCI-ITEM PK
ITEM		Alpha 32The item's identifier as set up in the Inventory Control system.WH20.2, WH20.7
#OCI-CUST-ITEM PK
CUST_ITEM		Alpha 32The customer's number for your inventory item.—
#OCI-CUST-DESC
CUST_DESC		Alpha 30The customer's description for your item.WH126, WH224
#OCI-CUST-ITEM-16
CUST_ITEM_16		DerivedThis field contains the 16-character customer number for your item.—
#OCI-ITEM-16
ITEM_16		DerivedThis field contains the first 16 characters of the item's identifier. This information is used by inquiries and reports.—

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OCISET1
  1. COMPANY
  2. CUSTOMER
  3. ITEM
  4. CUST-ITEM
PrimaryWH126, WH224
OCISET2
  1. COMPANY
  2. CUSTOMER
  3. CUST-ITEM
  4. ITEM
WH20.2, WH20.7

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPARCUSTGRPCUSTDESCICCOMPANYITEMMASTOECOMPANYOECUSTITEM

One to one (6) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
OCI-COMPANY→ACO-COMPANY
ArcustgrpARCUSTGRPRequired
ACO-CUST-GROUP→ACG-CUST-GROUP
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
OCI-CUSTOMER→CUD-CUSTOMER
IccompanyICCOMPANYNot Required
OCI-COMPANY→ICC-COMPANY
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
OCI-ITEM→ITE-ITEM
OecompanyOECOMPANYRequired
OCI-COMPANY→OEC-COMPANY

Programs

No Lawson programs are documented as updating or referencing this table.