ITEMADDON

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.
UPDATED BY
WH20.2 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITA-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.
ITA-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
ITA-STATE
Element: State
Alpha 2
This field contains the two-character state code of the address of customers that are to be assessed this charge.
ITA-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
This field contains the number that represents a customer.
ITA-MISC
Element: Misc
Alpha 16
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
ITEM
STATE
CUSTOMER
MISC
WH20.2 WH20.7


ITEMADDON FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oemisc OEMISC Required
ITA-COMPANY->OEM-COMPANY
ITA-MISC->OEM-MISC
  OEM-CURRENCY-CODE


File created: Thu Jun 09 11:09:29 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.