Which default fields should a table have in an ERP project?

Source: Internet
Author: User
1. Several fields are required PKID (auto-increment), Business ID (self-controlled can be equal to PKID), Operator, company ID (BranchNo ),

CreateDate, OperateDate, IsActive, department ID)

(1) Business ID (which can be equal to PKID under self-control). For example, you must control the IP address of a sub-Table. Otherwise, data import and export will be very troublesome.

(2) Operator and other fields should be unified by a company: The company will sort out all the projects, and if the names are different, it will be miserable (experience !)

(3) For the OperateDate field, operations on this table must be changed. For example, you have created a pick-up details. The pick-up details are associated with the order. In this case, you must change the OperateDate field in addition to changing the pick-up mark in the order.

(4) data cannot be deleted. Deletion can only mark IsActive. This is a good habit. Because this can be well documented.

(5) CreateDate is also necessary.

Please participate in the discussion! Thank you.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.