aaia_pcdb.piesfield

Paginated SELECT * (all columns). Approximate table size from stats: 116 rows.

Below: searchable, sortable DataTable for this server page only (50 rows). Use Previous/Next above for other pages.

piesfieldid fieldname referencefieldnumber piessegmentid PK row
52 Container Type B34 5 Open
53 Item Quantity Size UOM B33 5 Open
54 ACES Applications B30 5 Open
55 GTIN Qualifiers B11 5 Open
56 Hazardous Material Code B03 5 Open
57 Maintenance Type F02 9 Open
58 Background M40 4 Open
59 Duration UOM M82 4 Open
60 Description Code C05 6 Open
61 Maintenance Type H02 10 Open
62 Maintenance Type J02 11 Open
63 Language Code K12 12 Open
64 Country of Origin 2 E10 8 Open
65 Country of Origin (Primary) E10 8 Open
66 EXPI Code E05 8 Open
67 Language Code J70 11 Open
68 Language Code M99 4 Open
69 Component ID Qualifier K08 12 Open
70 Maintenance Type D02 7 Open
71 Quantity UOM K20 12 Open
72 Maintenance Type K02 12 Open
73 Description Code K09 12 Open
74 Maintenance Type E02 8 Open
75 Language Code E15 8 Open
76 Maintenance Type N02 13 Open
77 Item Equivalent UOM N16 13 Open
78 Quality Grade Level N25 13 Open
79 Interchange Quantity UOM N27 13 Open
80 Language Code N40 13 Open
81 Warranty Special E10 8 Open
82 Taxable E10 8 Open
83 Stock Status E10 8 Open
86 PIES Standard National Popularity (Velocity) Descriptions E10 8 Open
87 PIES Standard National Popularity (Velocity) Codes E10 8 Open
88 NAFTA Preference Criterion Code E10 8 Open
89 Country of Origin 3 E10 8 Open
90 Country of Origin 4 E10 8 Open
91 Country of Origin 5 E10 8 Open
92 Emission Code E10 8 Open
93 Life Cycle Status Code E10 8 Open
94 Life Cycle Status Description E10 8 Open
95 SDR Required Flag E10 8 Open
96 Maintenance Type P02 14 Open
97 Asset Type P10 14 Open
98 File Type P15 14 Open
99 Representation P20 14 Open
100 Resolution P30 14 Open
101 Color Mode P35 14 Open
102 Background P40 14 Open
103 Orientation View P45 14 Open