Adding unique tag identifiers and descriptors to a standard table

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