|
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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL210 BL29.1 BL29.2 BL520 BL820
BL92.1 WH20.2 WH20.7
UPDATED BY
BL10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITA-COMPANY Numeric 4 BL10.1
Element: Company 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 Alpha 32 BL10.1
Element: Item This field contains the item
identifier.
ITA-STATE Alpha 2 BL10.1
Element: State This field contains the two-character
state code of the address of customers
that are to be assessed this charge.
ITA-CUSTOMER Alpha 9 (Right Justified) BL10.1
Element: Customer This field contains the number that
represents a customer.
ITA-MISC Alpha 16 BL10.1
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 BL10.1 BL120
ITEM BL122 BL130
STATE BL20.1 BL20.3
CUSTOMER BL21.2 BL21.5
MISC BL210 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.2 WH20.7
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
|