ITEMADDON – Item Add On Cost

System
Billing (BL)
Prefix
ITA
Primary key
COMPANY, ITEM, STATE, CUSTOMER, MISC
Fields
5
Updated by
0 programs
Referenced by
0 programs

ITEMADDON is the Item Add On Cost table in Lawson Billing (prefix ITA). It is indexed by COMPANY, ITEM, STATE, CUSTOMER, MISC (ITASET1). It is related 1:1 to ICCOMPANY, ITEMMAST and OECOMPANY and 1:M to OEMISC. The table has 5 fields, 1 index and 4 documented relations.

About ITEMADDON

The Item Add-on Cost file. Whenever a line is added to an order or invoice, the program checks this file. If an Item Add-on record exists for the company, item, and state in this file (or for the company, item, and a blank state), an add-on charge record is attached to the order and/or invoice line automatically.

Fields (5)

Column = COBOL field name without the ITA- 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
#ITA-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.—
#ITA-ITEM PK
ITEM		Alpha 32This field contains the item identifier.—
#ITA-STATE PK
STATE		Alpha 2This field contains the two-character state code of the address of customers that are to be assessed this charge.—
#ITA-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)This field contains the number that represents a customer.—
#ITA-MISC PK
MISC		Alpha 16This is the add-on charge code that is attached to a percentage or amount that is to be assessed to the line of the order or invoice.—

Indexes (1)

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
ITASET1
  1. COMPANY
  2. ITEM
  3. STATE
  4. CUSTOMER
  5. MISC
PrimaryWH20.2, WH20.7

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
ITA-COMPANY→ICC-COMPANY
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
ITA-ITEM→ITE-ITEM
OecompanyOECOMPANYRequired
ITA-COMPANY→OEC-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
OemiscOEMISCRequired
ITA-COMPANY→OEM-COMPANY
ITA-MISC→OEM-MISC
—→OEM-CURRENCY-CODE

Programs

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