Adding unique tag identifiers and descriptors to a default table

The default tag identifiers are Batch Number, Revision Number, and Lot Number. You might 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 are 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 might want to use a custom tag identifier that is named Steel and has both Mill and Grade attributes. Since these custom tag identifiers are not provided by default, you must extend the set of tables 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