pt
/
plist_builder
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
11 Commits 1 Branch 0 Tags 50 KiB
SQL 52.8%
VBA 47.2%
Go to file
Paul Trowbridge 3e12704241 join to accessories based on product structure 2021-01-13 00:16:38 -05:00
db_schema join to accessories based on product structure 2021-01-13 00:16:38 -05:00
vba init 2021-01-08 14:51:59 -05:00
.gitignore init 2021-01-08 14:51:59 -05:00
readme.md init 2021-01-08 14:51:59 -05:00

readme.md

Start with a generic listing of conceptual prices and build a full-20 part listing with volume breaks denominated in per 1000 units.

stlc coltier branding accs suff pckg pack mp bulk
HTO10752 B S CSE 1337.61 1157 1099.15
HTO10752 B SH CSE 1337.61 1157 1099.15
HTO10752 B CSE 1337.61 1157 1099.15
HTO10752 T S CSE 1337.61 1157 1099.15
HTO10752 T SH CSE 1337.61 1157 1099.15
HTO10752 T CSE 1337.61 1157 1099.15
HTO10752 L S CSE 1337.61 1157 1099.15
HTO10752 L SH CSE 1337.61 1157 1099.15
HTO10752 L CSE 1337.61 1157 1099.15

The mold plus basic attributes form a conceptual framework, and have to be attributed to full-20 codes in order for this to work:

  • mold/part group: first 8 digits (rlarp.itemm.styc)
  • color tier: rlarp.itemm.coltier
  • branding: rlarp.branding
  • accessories: rlarp.accs_ps
  • suffix: rlarp.suffix
  • package: rlarp.uomp

Any part numbers that match these columns in rlarp.itemm would qualify for listed pricing. The only exception is that the "bulk column" only applies to uomp value PLT (bulk pricing only applies to part numbers with PLT default pack unit (v6cntr))

the accs_ps and suff columns in itemm are calculated and not materialized anywhere, and are a large dependency