|
|
ITEMADDON FILE
Item Add On Cost
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.
REFERENCED BY
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITA-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
ITA-ITEM Alpha 32
Element: Item Number This field contains the item
identifier.
ITA-STATE Alpha 2
Element: State or ProviThis field contains the two-character
state code of the address of customers
that are to be assessed this charge.
ITA-MISC Alpha 16
Element: Misc This 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.
ITEMADDON FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ITASET1 COMPANY WH20.2 WH20.7
ITEM
STATE
ITEMADDON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
ITA-COMPANY -> ICC-COMPANY
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ITA-ITEM -> ITE-ITEM
Oecompany OECOMPANY Required
ITA-COMPANY -> OEC-COMPANY
ITEMADDON FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Oemisc OEMISC Required
ITA-COMPANY -> OEM-COMPANY
ITA-MISC -> OEM-MISC
OEM-CURRENCY-CODE
|
