|
|
ITCOMMENT FILE
The Item Comments file stores the comments associated with an Item Master
record. Each item can have up to 999 comments. These comments can be selected
to print on various reports in the Inventory Control, Purchase Order, Order
Entry, and Work Order systems.
REFERENCED BY
BL122 BL80.1 IC110 IC210 IC211 IC212
SEA1.1 OE110 OE111 OE112 OE113 OE114
OE129 OE229 PO130 PO220 PO230 POCP.1
POI7.1 WH130 WH222 WH224 WO131
UPDATED BY
IC11.1 IC18.1 IC811
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ICO-ITEM-GROUP Alpha 5 IC18.1 IC811
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
ICO-ITEM Alpha 32 IC18.1 IC811
Element: Item Number This field contains the item
identifier.
ICO-SEQ Numeric 3 IC18.1 IC811
Element: Sequence NumbeThis field contains the sequential
number assigned to a line of comments.
ICO-COMMENT Alpha 40 (Lower Case)
Element: Comment Line This field contains the comment text
about the item.
ICO-BEGIN-DATE Numeric 8 (yyyymmdd) IC18.1 IC811
Element: Begin Date This field contains the beginning date
for the comment line to be printed on
any report.
ICO-END-DATE Numeric 8 (yyyymmdd) IC18.1 IC811
Element: Ending Date This field contains the ending date for
the line comment that is printed on any
report.
ICO-COM-TYPE Alpha 1 IC18.1 IC811
Element: Comment Type This type code determines on which
report this line prints.
ICO-LANGUAGE-CODE Alpha 10 IC18.1
Element: Language Code Language Code (LOCALE).
ITCOMMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ICOSET1 ITEM-GROUP BL122 BL80.1
ITEM IC11.1 IC110
LANGUAGE-CODE IC18.1 IC210
SEQ IC211 IC212
IC811 SEA1.1
OE110 OE111
OE112 OE113
OE114 OE129
OE229 PO130
PO220 PO230
POCP.1 POI7.1
WH130 WH222
WH224 WO131
ITCOMMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Required
ICO-ITEM-GROUP -> ITG-ITEM-GROUP
Itemmaster ITEMMAST Required
ICO-ITEM-GROUP -> ITE-ITEM-GROUP
ICO-ITEM -> ITE-ITEM
|
