ddr summary/file/tables

Base Table Name: Inventory

Base Table id: 129
Fields: 20
records: 2
number and ratio of field types
Normal1785%
Calculated315%
Summary00%
Invalid00%
number and ratio of data types
Text840%
Number945%
Date210%
Time00%
TimeStamp00%
Binary15%
20 Fields defined in “Inventory”
#metadataid_fieldnamedataTypefieldTypeserialcommentuses
#metadataid_fieldnamedataTypefieldTypeserialcommentuses
1show1ITEM ID MATCH FIELDNumberNormal3uses
2show2Date EnteredDateNormaluses
3show7CategoryTextNormaluses
4show3ItemTextNormaluses
5show8ManufacturerTextNormaluses
6show23Model YearNumberNormaluses
7show4Part NumberTextNormaluses
8show29Bar CodeTextNormaluses
9show6DescriptionTextNormaluses
10show11Image | ContainerBinaryNormaluses
11show33LocationTextNormaluses
12show32TaxableNumberNormaluses
13show31Unit CostNumberNormaluses
14show5Unit PriceNumberNormaluses
15show27Units on HandNumberCalculateduses
16show41Reorder LevelNumberNormaluses
17show43Last OrderDateNormaluses
18show42AvailabilityTextCalculateduses
19show40Stock ValueNumberCalculateduses
20show56freightNumberNormaluses