SUPPOSE THAT WE WANT TO PURCHASE A ITEM,(SPARE) ,THEN WE SHOULD FULLFILL ALL CRITRIEA
OF THAT ITEM,
FOR EXAMPLE,
ITEM DESCRIPTION (FOR THAT WE HAV 30 FIELDS)
UMC NO-(UNIQUE MACHINE CODE) TYPE- AN (ALPHA NUMERIC)
AREA-AN
**SUB AREA-AN
EQUIPMENT.
item description-an
item location- an
part/specification- an
make- an
storage location- main -AN
sub -AN
UNIT COST- CURRENCY
**COMPONENT TYPE
CRITICAL/GENERAL/CONSUMABLE-AN
MIN STOCK-N (NUMBER)
PLANT- 019/073/OTHER
PREREQUISTIC NO- N
RESERVATION NO- N
PO- N
PARTY-AN
DELINERY DATE- DATE/TIME
STATUS-AN
REMARKS- TEXT
INVENTRY- AN
INVENTRY DATE-DATE/TIME
MAX STOCK- N
PRESENT STOCK- N
USE LOCATION-AN (MEMO)
** COMPONENT TYPE
PROXIMITY
LIMIT SWITCH
MPCB
SENSOR
SPECIAL H/W(HARDWARE)
DC MOTOR
AC MOTOR
CONTACTOR
RELAY
CABLE
FUSE
THYRISTOR
ELECTRONICS EQUIPMENT
PB/IL/SS/ILPB
TIMER
HOOTER
TOOLS
AVIATION LAMP
ELECTRONOCS CARD
**SUB AREA
CASTER COM
CASTER#1
CASTER #2
CASTER#3
CASTER AUX
SCARFING
TRANSFER TROLLY
CTRT
SYMS
AUXILIARIES
NEW RCPH
OLD RCPH
AFTER THAT WE HAV CREAT FORMS
1). MASTER DATA FORM - IN WHICH ALL INFORMATION ABOUT THE ITEM WILL PRESENT.AND ALSO SUB FIELDS ARE BE PRESENT.THAT MEANS ALL THE 30 DESCRIPTION OF THE ITEM.
2). ORDER DATA FORM - IN WHICH ALL INFORMATION ABOUT ORDER WILL BE PRESENT THAT IS...........
PRE. REQUISTIC NO
RESERVATION NO
PO
DO
PARTY
DELIVERED
RECIVED
STATUS
3). INVENTRY FORM:-
INVENTRY NO-N
INVENTRY DATE- DATE/TIME
MAX STOCK -N
PRESENT STOCK-N
USE LOCATION-AN
USE NO'S -N
USE DATE -DATE/TIME
ORDER QUANTITY --NO'S
GENERATING QUERIES
EXAMPLE SEEN ON THE SENDED DATA BASE
THESE ARE:-
STATUS QUERY
LESS THAN MIN STOCK
GREATER THAN MAX STOCK
MATERIAL PURCHASE HISTORY
MATERIAL USE HISORY MATERIAL INVENTORY HISTORY MATERIAL ACTUAL VS INVENTORY MISMATCH
tell me how can i make adatabase in ACCESS using this fields, nd how can these are properly related to other relations