aaia_pcdb.piesexpicode

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

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

piesexpicodeid expicode expicodedescription piesexpigroupid PK row
1 CCL Core Class 1 Open
2 CGR Core Group 1 Open
3 CPN Core Part Number 1 Open
4 CXP Core Return Days to Expiry 1 Open
5 EMS Emission Code 2 Open
6 MSD SDS Sheet Number 2 Open
7 MSR SDR Required Flag 2 Open
8 OEM Original Equipment Manufacturer 3 Open
9 OEP OEM's Part Number 3 Open
10 OSN Original Supplier 3 Open
11 OSP Original Supplier Part Number 3 Open
12 PTN Part Number - Old 3 Open
13 PTS Part Number Superseded To 3 Open
16 RCC Regulating Country 4 Open
17 RCS Regulating County, State 4 Open
18 RCT Regulating City, State 4 Open
19 RDE Regulating Description 4 Open
20 RPC Regulating Postal Code 4 Open
21 RST Regulating State 4 Open
22 RET Return Code 5 Open
23 WD1 Warranty Distance 5 Open
24 WD2 Warranty Distance UOM 5 Open
25 WS1 Warranty Special 5 Open
26 WS2 Warranty Special UOM 5 Open
27 WT1 Warranty Time 5 Open
28 WT2 Warranty Time UOM 5 Open
29 CTO Country of Origin (Primary) 6 Open
30 CTP Country of Origin 2 6 Open
31 CTQ Country of Origin 3 6 Open
32 CTR Country of Origin 4 6 Open
33 CTS Country of Origin 5 6 Open
34 HAC Canadian Harmonizing Tariff Code 6 Open
35 HSB Harmonized Tariff Code (Schedule B) 6 Open
36 HTS Harmonized Tariff Code (HTS) 6 Open
37 LIF Life Cycle Status Code 6 Open
38 LIS Life Cycle Status Description 6 Open
39 NAF NAFTA Preference Criterion Code 6 Open
40 TAX Taxable 6 Open
41 HZ1 Item (SKU) Level Special Handling Code 7 Open
42 NPC National Popularity Code 7 Open
43 NPD National Popularity Description 7 Open
45 PLM Pallet Layer Maximum 7 Open
46 STA Stock Status 7 Open
47 TMC Trading Partner Movement Code 7 Open
48 PLC Maximum Cases per Pallet Layer 7 Open
49 PRC Product Condition 3 Open
50 GCT Green Certification, Regulation or Standard Met 4 Open
51 GPV Additional Green Attributes 4 Open
52 LTM Estimated Lead Time 6 Open
53 ECN ECCN 6 Open