|
|
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 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL210 BL29.1 BL29.2 BL520 BL820 BL92.1
BL940 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE920
OE950 WH20.2 WH20.7
UPDATED BY
BL10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ITA-COMPANY Numeric 4 BL10.1
Company The company number represents an
established company and is entered on
all function codes.
ITA-ITEM Alpha 32 BL10.1
Item Number This field contains the item
identifier.
ITA-STATE Alpha 2 BL10.1
State or Province This field contains the two-character
state code of the address of customers
that are to be assessed this charge.
ITA-MISC Alpha 16 BL10.1
Miscellaneous 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 BL130 BL20.1
STATE BL20.3 BL21.2
BL21.5 BL210
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE110 OE113
OE114 OE129
...
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
|