Creating database Master Table
***SYSTEM GENERATED TABLE***
File Name: SGF
File Description: System Generator File
Record Key: SGF YEAR
Field Name Description Variable Type Lenght
SGFYear System Generated Fiscal Year Text 4
SuppNo System Generated Supplier Code Numeric 6
EmpNo System Generated Employee Code Numeric 6
MNo System Generated Material Code Numeric 6
PRNo System Generated PR Code Numeric 6
PONo System Generated PO Code Numeric 6
RRNo System Generated RR Code Numeric 6
Comname Company Name Text 40
Address Company Name Text 50
RecStatus System Generated Status Text 1
[O] -Open
[C]-Close
***MATERIAL MASTER FILE***
File Name: MMF
File Discription: Material Master file
Record Key: MNo
Field Name Description Variable Type Lenght
MNo Material Code Numeric 6
Description Material Description Text 40
U_msr Unit Measure Text 5
Qty_Hand Quantity on Hand Integer 0
CategoryName Material Type Text 10
LastPRNo Last PR Number Numeric 6
LastPONo Last PO Number Numeric 6
LastRRNo Last RR Number Numeric 6
MMFRecStat Material Status Text 1
[A]-Active
[I]-Inactive
***SUPPLIER MASTER TABLE***
File Name: SMF
File Description: Supplier Master File
Record Key: SuppNo
Field Name Description Variable Type Lenght
SuppNo Supplier Code Numeric 6
SLName Supplier Last Name Text 20
SfName Supplier First Name Text 20
SuppAddress Supplier Address Text 40
TelNo Supplier Tel Number Text 15
FaxNo Supplier Fax Number Text 15
Rating Supplier Rating Text 10
-Very Good
-Good
- Poor
Price Structure Supplier Price Structure Text 20
SMFRecStatus Supplier Status Text 1
[A] -Active
[I] -Inactive
***EMPLOOYEE MASTER TABLE***
File Name: EMF
File Description: Employee Master File
Record key: EmpNo
Field Name Description Variable Type Lenght
EmpNo Employee Code Numeric 6
ELName Employee Last Name Text 20
EfName Employee First Name Text 20
MName Employee Middle Name Text 2
TelNo Employee Telephone Number Text 15
Civil Status Employee Civil Status Text 15
-Single
-Married
- Widow
SMFRecStatus Supplier Status Text 1
[A] -Active
[I] -Inactive
***PURCHASE REQUISITION MASTER TABLE***
File Name: PRMF
File Description: Purchase Requisition Master File
Record Key: PRNo
Field Name Description Variable Type Lenght
PRNo Purchase Requisition Number Numeric 6
PR_DateRequested Purchase Requisition Date Prepared Date/Time 0
PR_DateNeeded Purchase Requisition Date Needed Date/Time 0
RequestedBy Requested by Numeric 6
ApprovedBy Approved by Numeric 6
PRMFRecStatus Purchase Requisition Status Text 1
[O] -Open
[C]-Close
***PURCHASE ORDER MASTER TABLE***
File Name: POMF
File Description: Purchase Order Master File
Record Key: PONo
Field Name Description Variable Type Lenght
PONo Purchase Order Number Numeric 6
SuppNo Purchase Order Supplier Number Numeric 6
PO_DatePrepared Purchase Order Date Prepared Date/Time 0
PO_DateNeeded Purchase Oder Date Needed Date/Time 0
PreparedBy Prepared by Numeric 6
ApprovedBy Approved by Numeric 6
POMFRecStatus Purchase Order Status Text 1
[O] -Open
[C]-Close
***RECEIVING REPORT MASTER TABLE***
File Name: RRMF
File Description: Receiving Report Master File
Record Key: RRNo
Field Name Description Variable Type Lenght
RRNo Receiving Report Number Numeric 6
PONo Receiving Report PO Number Numeric 6
RR_DatePrepared Purchase Order Date Prepared Date/Time 0
RR_DateReceived Purchase Oder Date Received Date/Time 0
QuantityCheckedBy Received by Numeric 6
ApprovedBy Approved by Numeric 6
RecStatus Receiving Report Status Text 1
[O] -Open
[C]-Close
No comments:
Post a Comment