Column

Data
Type

 
Length

Description

Allow
Nulls

P

pKey

bigint

8

Items primary key.

Automatically generated.

Internally used only.

id

varchar

20

Item unique tracking ID.

refId

varchar

20

Item reference ID of Item.

Note: The reference ID can be seen through the PRT_UI.

fItemType

bigint

8

Foreign Key to the Item’s Item Type; Item Type is found in the ItemTypes table.

created

datetime

8

Date and time the Item was created.

modified

datetime

8

Date and time the Item was last modified.

active

bit

1

Flag to indicate the Item is actively in the production process.

Internally used

For Historical TADB configuration only

To support the Archive method.

externalHoldActive

bit

1

Flag indicating if an External Hold is active on the Item

groupID

varchar

20

Foreign key to the Tracking Group Id; Group ID is found  in the TrkGroups table

internalHoldActive

bit

1

Flag to indicate if an Internal Hold is active for the Item

internalHoldReason

varchar

40

Reason for an active Internal Hold

itemStatusHI

int

4

High word of Item status bits.

2. TADB SQL table structure overview.