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
1 1 141 ∅ The file being sent is an update file with changes, additions, deletions Open
2 2 98 ∅ ∅ Open
3 1 302 ∅ The file being sent is a full Refresh File Open
4 5 98 ∅ ∅ Open
5 48 98 ∅ ∅ Open
6 93 5 37 (Internal Use) - Part is in the process of being released. Required fields are not completed to release it for initial orders. Open
7 79 372 ∅ ∅ Open
9 77 372 ∅ ∅ Open
10 71 372 ∅ ∅ Open
11 26 372 ∅ ∅ Open
12 33 372 ∅ ∅ Open
13 49 372 ∅ ∅ Open
14 50 372 ∅ ∅ Open
15 52 372 ∅ ∅ Open
16 53 372 ∅ ∅ Open
17 66 415 ∅ Canadian Harmonization Code Open
18 23 373 ∅ ∅ Open
19 101 386 ∅ ∅ Open
20 43 386 ∅ ∅ Open
21 98 387 ∅ ∅ Open
22 46 387 ∅ ∅ Open
23 9 388 ∅ A description used to send general information in large paragraphs. Each general copy paragraph should be sent individually for the code. To provide multiple general copy paragraphs, loop the element/code. You can also provide a display sequence if needed. Open
24 16 16 ∅ ∅ Open
25 16 17 ∅ ∅ Open
26 48 376 ∅ ∅ Open
27 5 376 ∅ ∅ Open
28 2 376 ∅ ∅ Open
29 109 414 ∅ ∅ Open
30 59 414 ∅ ∅ Open
31 34 382 ∅ ∅ Open
35 16 50 ∅ ∅ Open
36 16 49 ∅ ∅ Open
37 16 22 ∅ ∅ Open
38 16 416 ∅ ∅ Open
39 7 93 ∅ Brand Owner Code (4 Char) Open
40 7 92 ∅ Brand Parent Code (4 Char) Open
41 7 91 ∅ Brand ID Code (4 Char) Open
42 8 93 ∅ Brand Owner Code (4 Char) Open
43 8 92 ∅ Brand Parent Code (4 Char) Open
44 8 91 ∅ Brand ID Code (4 Char) Open
45 53 56 ∅ ∅ Open
46 53 284 ∅ ∅ Open
47 53 48 ∅ ∅ Open
48 53 47 ∅ ∅ Open
49 53 46 ∅ ∅ Open
50 53 44 ∅ ∅ Open
51 53 37 ∅ ∅ Open
52 53 36 ∅ ∅ Open
53 53 35 ∅ ∅ Open
54 53 34 ∅ ∅ Open