AMA
temp
consumption
S1 farbe1
Z1 feet
P pillow
K corpus
kennung
ist null - no value
ä change
Z additional
E service parts
S storno
datum bestatig - date of confirmation from wk-team
datum termin orginal - elements manufactured, but delayed
DB tables
MATERIAL
MAT_BET - consumption
ABPOSTEXT - description of element for manufacturers
ABPOS - positions
ABKOPF - orders
ARTICLES
General
POS - company that deals w reclamations for candy, candy organizes the reclamations
werk = wk-team produzent = kroslak, benco, merasicky
sort results - right click on field -> sort
searching date fields: "zwischen 01-01-08 and 02-02-08"
ctrl + pause - cancel search
*, ? wildcards
F4 - search -> F3 results
F1 - close window / return to last used
structure
invoice -> ABs -> Positions ~ Articles -> elements (colli)
MENU
materialverwaltung
candy materialpreis in ABs andern
actualization of prices of opened orders
material umlagerungen - deprecated
materialpreise
old/new prices of already bought leder
intrastat
for katarina
inventur NEU
zw_stand - what's left in warehouse, planned, stand
double click for details on zugang, abgang, eingeplant
browse through the material
material rechnungen
stand material - how much $$ candy owes wkteam
materialabzuge - difference btw the material on central warehouse and balance in candy
material ruecklieferung
lether returning to candy, because of bad quality
material lieferungen
abgang: wk-team -> candy
zugang: candy -> wk-team
how fabrics and leather are selling and prediction
rechnungsverwaltung - invoices
rechafgabe nach stoffpreis
every week send to candy to check how much material per invoice is delivered to TO
for accounting
errinerung/mannung
please pay invoices
offen rechnungen
open invoices for specified dates
provisionslisten
rechnungslisten
list of invoices
AB number aus rechnung stornieren
to delete AB from invoice
zahlung eintragen form
quick mark invoice as paid
zahlung eintragen
all opened invoices, here you can check if something is paid
schnittstelle wk-team - deprecated
rechnungen wkteam - all invoicing
tagesrechnung - grouped by invoice number, daily invoices, check-in notes
rechnung eingeben/bearbeiten -
function to send to email to wkteam/candy
berechnen = recalculate/add tour or AB into invoice
multiple AB per invoice
erfasste positionen - will show invoices
auftragsverwaltung - for orders
positionsdaten aktualizieren - aktualizacia cien z furnitechu -> odrazi sa do objednavok
hilfsprogramme -> suche nach artickel oder material offen - what's left to produce
managementinformation - pass admin
wochenumsatz gesamt - nice statistics of umsatz
wk-statisticen - grouped by invoice
produktions liefershein - candy delivery note
ettikettendruck
ettikettendruck candy/sprankel/diverse - beipackzettell - dokumentacia k posteliam bude sa pouzivat
candy barcode lesen - for benco, probably not used, was used for warenpass (inventory label)
wk_Produzenten
Kissenliste - for maja
reklas in KW/produzent - reclamations
umsatzliste nach datum - for duras only, what will be invoiced
ausgabeidaten erstellen - old Hubinak barcode reader output
bezugsstoffe sortieren - for cutting fabric
wk-team - special reports
objectkunden - candy stuff
kunden - candy stuff
summenlisten - modell umsatz, for josef, elemente for production - only different when different factor is used
artikel - prodlist nach artikeln - how many specific artikels were in tour
tour und article
materialverbr nach produzent under rechnungsdatum (after wkteam bills candy)
material consumption for manufacturer
wochenliste an modell auswertung exportieren - export for external program
modell umsatz nur modell up to 6 characters to group by model numbers
umsatz mit familien - grouped by family, useful for manufacturers
dispolisten - show or save dispolisten to excel
vershiedene listen - tourliste offen erstellen - planned tours, which orders go to this tour
rest not important
nicht bestatige ABs - unconfirmed AB orders
artikel delivered and opened - how many were delivered, how many are opened
offene auftrage - werk = wk-team, kunde = candy, all opened orders
auftrag - etikettendruck, dispoliste; date termin - should be delivered, datum bestatig - confirmation from wkteam
stammdaten
abpos_spezification - text mining
abios - toDelete info from candy
fehlercode_candy - ide na production etikette, ked sa vyraba novy produkt po reklamacii stareho
einh - units
bearbeiter - when furnitech enter the order
zahlungsbedien
liefervbedinungen - terms, cost insurance
kennzeichen material -
infotext - just a raw text to make info for material
material - fabrics/leather
zubehor - feet/pillows
modelle mit zulieferteile - models w special parts from candy
modelle familien - model family = same skeleton
modelle mit faktor - not used now
model varianten mr 4500 - special case for this model
modelle mit verschiedene fusse - models w/ different feets
suchenach.. - not for candy, only
article -
addressen - billing info
