Data Dictionary Sample

Only available on StudyMode
  • Topic: Purchase order, Order, Sales order
  • Pages : 2 (620 words )
  • Download(s) : 207
  • Published : September 27, 2012
Open Document
Text Preview
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|...
tracking img