Inventory files |
Top Previous Next |
|
ECORVN Core vendor tracking
INVNUM C 20 Part number ACPNUM C 6 Accounts payable number CORUSD L 1 Core has been used flag
EINCOR Inventory core parts tracking
INVCQU N 6,2 Core quantity used INVCOV N 8,2 Core value (vendor's charge to shop) INVCOC N 8,2 Core charge (shop's charge to client) WRKDAT D 8 Date of installation of core WRKORD C 5 Workorder number INVCRS N 6,2 Core's returned from client INVCRM N 6,2 Core's returned to manufacturer INVNUM C 20 Partnumber ACRNUM C 5 Client's account number COMPLE C 1 Completion INVCAC N 6,2 Activity temp. Y/N INVCOU N 8,2 Core outstanding INVCIN N 8,2 Core returned ACPNUM C 6 Vendor of core
EINMST Inventory parts master file
INVNUM C 20 Partnumber INVDES C 30 Part description INVCOS N 8,2 Cost of part (average) INVLPP N 8,2 Last price paid for part INVCHG N 8,2 Retail charge INVSTK N 8,2 Current stock INVMIN N 8,2 Desired minimum INVYTD N 8,2 Year to date sales INVMTD N 8,2 Month to date sales INVLDP D 8 Last date of purchase INVONO N 8,2 Quantity currently on order INVCOD C 12 Cross reference code INVMAN C 15 Manufacturer INVLOC C 5 Location INVAP1 C 6 Vendor 1 INVAP2 C 6 Vendor 2 INVAP3 C 6 Vendor 3 INVAP4 C 6 Vendor 4 INVDEL C 3 Sort code for german vehicles INVWHL N 8,2 Wholesale level 1 proce INVSTL N 8,2 Desired stocking level INVCOH N 8,2 Core on hand (used) INVCOR N 8,2 Core with client's (used) INVLDS D 8 Last date of sale INVCOF L 1 Is this a core ? INVTXF L 1 Is this taxable ? INVMUT C 5 Pricing mark up table INVACR C 1 German Sort Code INVCOV N 8,2 Core value INVCOC N 8,2 Core charge INVWH2 N 8,2 Wholesale pricing level 2 INVWH3 N 8,2 Wholesale pricing level 3 INVHB1 N 8,2 Sales total back 1 year INVWH4 N 8,2 Wholesale pricing level 4 INVHB2 N 8,2 Sales total back 2 years INVAPA L 1 Parts attached flag INVAPC C 15 Parts attached code INVLBS N 8,2 Weight INVFET N 8,2 Federal excise tax INVHWD N 8,2 Hazardous waste disposal INVM01 - 12 N 8,2 Monthly totals INVTYP L 1 Stock / non-stock flag INVSUP C 20 Supplanted by partnumber
EINORD / EINORH Inventory purchase order - individual parts
ORDNUM C 5 Purchase order number ORDDAT D 8 Date of order ORDQUN N 8,2 Quantity ordered ORDCST N 8,2 Cost of part INVNUM C 20 Part number ACPNUM C 5 Vendor account number ORDRED D 8 Date parts received ORDREQ N 8,2 Quantity requested ORDREC N 8,2 Quantity received ORDREF C 30 Reference ORDCOM L 1 Order is complete Y/N WRKORD C 5 Assign to workorder number .... INVCHG N 8,2 Invoice charge ACTCST N 8,2 Actual cost BAKORD N 8,2 Backorder count ACTQUN N 8,2 Actual quantity INVPAR C 1 Inventory Part
EINPUP Inventory purchase order master file
ORDNUM C 5 Purchase order number ORDDAT D 8 Purchase order date ACPNUM C 5 Vendor account number ORDEXP D 8 Date the order is expected ORDREP C 20 Sales representative ORDCOM C 24 Vendor name COMPLE L 1 Completion flag
EINTAB Inventory price table
TABLENO C 2 Pricing table number MARKUP N 8,4 Percentage of markup DISCO1 N 6,4 Discount wholesale level 1 DISCO2 N 6,4 Discount wholesale level 2 DISCO3 N 6,4 Discount wholesale level 3 DISCO4 N 6,4 Discount wholesale level 4
ESTKDF Deficit Stock
INVNUM C 20 Part number INVDES C 30 Part description DEFQUA N 8,2 Deficit quantity DEFCST N 8,2 Deficit cost DEFTOT N 8,2 Deficit total DEFDTE D 8 Report date |