The Sterling Selling and Fulfillment
Foundation default
tag identifiers are Batch Number, Revision Number, and Lot Number.
You may have a need to extend the application database to define
unique tag identifiers or descriptors.
It is recommended that the data type of any unique tag identifiers
or descriptors that you add be CHAR or VARCHAR.
Note: Whenever you extend the tag attributes you must
also extend the console because the templates for the APIs do not
contain these extended tag attributes.
For example, if you work in the metal industry, you may want to
use a custom tag identifier named Steel which has both Mill and Grade
attributes. Since these are not supplied by default, you must extend
the set of tables listed below to include the Steel tag identifier
column in each table.
Extending tables when adding unique tag identifiers
You must extend
each of the following tables whenever you add unique tag identifiers
to the application database:
- YFS_COUNT_RESULT_TAG
- YFS_COUNT_TAG
- YFS_INVENTORY_AUDIT
- YFS_INVENTORY_TAG
- YFS_ITEM_TAG - The data type to be used for this table is CHAR(2).
- YFS_MOVE_REQUEST_LINE_TAG
- YFS_ORDER_KIT_LINE_SCHEDULE
- YFS_ORDER_KIT_LINE_SCHEDULE_H
- YFS_ORDER_LINE_REQ_TAG
- YFS_ORDER_LINE_REQ_TAG_H
- YFS_ORDER_LINE_SCHEDULE
- YFS_ORDER_LINE_SCHEDULE_H
- YFS_ORDER_LINE_RESERVATION
- YFS_RECEIPT_LINE
- YFS_RECEIPT_LINE_H
- YFS_SHIPMENT_LINE_REQ_TAG
- YFS_SHIPMENT_LINE_REQ_TAG_H
- YFS_SHIPMENT_TAG_SERIAL
- YFS_SHIPMENT_TAG_SERIAL_H
- YFS_WORK_ORDER_COMP_TAG
- YFS_WORK_ORDER_COMP_TAG_H
- YFS_WORK_ORDER_TAG
- YFS_WORK_ORDER_TAG_H
Extending tables when adding unique tag descriptors
You must extend
each of the following tables whenever you add unique tag descriptors
to the application database:
- YFS_COUNT_RESULT_TAG
- YFS_COUNT_TAG
- YFS_INVENTORY_TAG
- YFS_ITEM_TAG The data type to be used for this table is CHAR(2).
- YFS_ORDER_LINE_REQ_TAG
- YFS_ORDER_LINE_REQ_TAG_H
- YFS_RECEIPT_LINE
- YFS_RECEIPT_LINE_H
- YFS_SHIPMENT_LINE_REQ_TAG
- YFS_SHIPMENT_LINE_REQ_TAG_H
- YFS_SHIPMENT_TAG_SERIAL
- YFS_SHIPMENT_TAG_SERIAL_H
- YFS_WORK_ORDER_COMP_TAG
- YFS_WORK_ORDER_TAG
- YFS_WORK_ORDER_TAG_H