Data Dictionary Sample

Topics: Purchase order, Order, Sales order Pages: 2 (620 words) Published: September 27, 2012
PARTS REQUISITION SLIP|
FIELD NAME| FIELD TYPE| LENGTH| DECIMAL| DESCRIPTION| FORMAT| Job Order No.| Numeric| 3| -| Serves as a unique code for the number of job order| 9(3)| Customer| Alpha| 30| -| Name of the Customer| A(30)|

Model| Alphanumeric| 30| -| The model of the part| X(30)| Part Number| Alphanumeric| 15| -| The serial number of the part ordered| X(15)| Description| Alpha| 50| -| Description of the parts | A(50)| Quantity| Numeric| 3| -| The number of parts ordered| 9(3)| Date Requested| Alphanumeric| 10| -| Date when the part is requested| DD/MM/YY| Requested By| Alpha| 30| -| Name of the person requesting for the job order| A(30)| In House| Symbol| -| -| The part that came from the company itself| -| Home Service Localized| Symbol| -| -| The part that comes from the head office| -| Out Warranty| Symbol| -| -| The part is not already in warranty| -| Under Warranty| Symbol| -| -| The part is still under warranty| -| Stock| Symbol| -| -| The part that the shop has on hand| -| Back-job| Symbol| -| -| | -|

Ext Warranty| Symbol| -| -| | -|
H.O| Symbol| -| -| If the part came from the Head Office| -| P.O. #| Numeric| 5| -| Number of purchase order| X(5)|

r
GOOD PARTS RETURN|
FIELD NAME| FIELD TYPE| LENGTH| DECIMAL| DESCRIPTION| FORMAT| L/N| Numeric| 3| -| List Number| 9(3)|
Part Number| Alphanumeric| 15| -| The serial number of the part ordered| X(15)| Description| Alphanumeric| 50| -| Description of the parts ordered through codes| X(50)| Quantity| Numeric| 3| -| The number of parts ordered| 9(3)| Sales Invoice| Numeric| 12| -| Records the sale of goods or services from a vendor to a customer.| 9(12)| Delivery Number| Numeric| -| -| The number of deliveries| -| Credit Request Number| Numeric| 12| -| The number of credit requested| 9(8)| Credit Request Date|...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Data Structures: Vb and Vba Offer Two Options: Arrays and Collections Essay
  • Data Dictionary Essay
  • What Is a Data Dictionary? Essay
  • Steps Involved in the Data Preparation Process Essay
  • Data Dictionary Research Paper
  • Statistics
  • Database and Data Dictionary Management Essay
  • Data Dictionary for Proposed System Essay

Become a StudyMode Member

Sign Up - It's Free