aaia_pcdb.piesreferencefieldcode

Paginated SELECT * (all columns). Approximate table size from stats: 2,816 rows.

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

piesreferencefieldcodeid piesfieldid piescodeid piesexpicodeid referencenotes PK row
106 49 56 ∅ ∅ Open
107 49 284 ∅ ∅ Open
108 49 48 ∅ ∅ Open
109 49 47 ∅ ∅ Open
110 49 46 ∅ ∅ Open
111 49 44 ∅ ∅ Open
112 49 37 ∅ ∅ Open
113 49 36 ∅ ∅ Open
114 49 35 ∅ ∅ Open
115 49 34 ∅ ∅ Open
116 49 33 ∅ ∅ Open
117 60 177 ∅ A description, specifically used in places where there is a very low character count restraint, to describe what the product is. This code should only be used once for a part number number. Open
118 60 283 ∅ ∅ Open
121 47 176 ∅ ∅ Open
122 47 190 ∅ ∅ Open
123 33 56 ∅ ∅ Open
124 33 284 ∅ ∅ Open
125 33 48 ∅ ∅ Open
126 33 47 ∅ ∅ Open
127 33 46 ∅ ∅ Open
128 33 44 ∅ ∅ Open
129 33 37 ∅ ∅ Open
130 33 36 ∅ ∅ Open
131 33 35 ∅ ∅ Open
132 33 34 ∅ ∅ Open
133 33 33 ∅ ∅ Open
134 77 307 ∅ ∅ Open
141 53 307 ∅ ∅ Open
142 52 307 ∅ ∅ Open
143 50 307 ∅ ∅ Open
144 49 307 ∅ ∅ Open
145 33 307 ∅ ∅ Open
146 26 307 ∅ ∅ Open
147 71 307 ∅ ∅ Open
148 66 84 ∅ Manufacturers Class for Core Returns Open
149 66 82 ∅ Manufacturers Group for Core Returns Open
150 94 286 38 Part has been announced to customers on a paper New Number Announcement. Part is active. Open
151 65 280 29 ∅ Open
152 64 280 30 ∅ Open
153 93 57 37 Part is released to customers for ordering. Open
154 93 66 37 Part has been announced to customers via electronic data files. Part is active but needs paper announcement. Open
155 93 122 37 Part has been announced to customers on a paper New Number Announcement. Part is active. Open
156 93 128 37 Part is suspended from shipment due to lack of availability or a hold on production. Open
157 93 125 37 Existing inventory of this part should be renumbered to the surviving part number. Open
158 90 280 32 ∅ Open
159 89 280 31 ∅ Open
160 91 280 33 ∅ Open
161 79 303 ∅ ∅ Open
162 77 303 ∅ ∅ Open
163 71 303 ∅ ∅ Open