Difference between revisions of "Master and Detail in Document"

From AutoCount Resource Center
Jump to navigation Jump to search
(Created page with "{{NavigateDeveloper}} ===What is '''MasterColumn''' and '''DetailColumn'''?=== All document entry, whether it is Sales Invoice or AR Payment, they consist of at least 2 Data...")
 
m
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{NavigateDeveloper}}
 
 
===What is '''MasterColumn''' and '''DetailColumn'''?===
 
===What is '''MasterColumn''' and '''DetailColumn'''?===
  
Line 16: Line 15:
 
which are master and detail area respectively.<br />
 
which are master and detail area respectively.<br />
 
]]
 
]]
 +
 +
[[Category:Programmer]]
 +
[[Category:Programmer FAQ]]
 +
{{NavigateDeveloper}}

Latest revision as of 04:54, 17 January 2018

What is MasterColumn and DetailColumn?

All document entry, whether it is Sales Invoice or AR Payment, they consist of at least 2 DataTable, master table and detail table.
Some may have more than 2 tables, such as AR Payment.
Usually the master table is where it stores the document information, such as document number, document date, company name and etc...
Whereas, detail table stores multiple records that are related to this document. Such as Items and account double entry transactions.
MasterColumn refers to the value of a field in master table.
Likewise, DetailColumn is referring to the value of a field in detail table.


Invoice Entry Form
This screen shows there are two highlighted areas in Green and Red,
which are master and detail area respectively.

Go to menu

IconAC81.png Go to top
ProgrammerGo.jpg Resources For AutoCount Software Developers