Importing Distribution Codes

Header

Distribution Codes can be imported into the system. If you are importing distribution codes that apply to Accounting only, you must import using the DISTCODE_USE_IN_MODULE field and the value A. If the distribution codes only apply to Payroll, you must import using the DISTCODE_USE_IN_MODULE field and the value P. Distribution codes that apply to both General Ledger and Payroll, can be imported into the system using the DISTCODE_USE_IN_MODULE field and the value B. B (Both) is the default value.

The following tables define the field references to be used in the Distribution Codes section of the MasterGL.DEF file:

Table: tblDistCode
Context Section: CONTEXT,DISTCODE,HEADER,HDIST
Field ID	Req'd	Field Length	Default Value	Notes
DISTCODE_CODE	Y	User Defined		Distribution Code
DISTCODE_ DESCRIPTION	Y	User Defined		Distribution Code Description
DISTCODE_STATUS	Y	2	A	A (Active), I (Inactive), or D (Discontinued)
DISTCODE_MCURRENCY	Y	3		Active or inactive Currency code.
DISTCODE_USE_IN_ MODULE	Y	2	B	B (Both Accounting and Payroll), A (Accounting only), or P (Payroll only)

Detail

Table: tblDistCodeDetail
Context Section: CONTEXT,DISTCODE,DETAIL,DDIST
Field ID	Req'd	Field Length	Default Value	Notes
DISTDETAIL_SEGMENT_ {SEGMENTNAME}	Y	User Defined		Replace {segment name} with the actual segment name (one line for each).
DISTDETAIL_UNITS	N	8	0.0000	See note below.
DISTDETAIL_PERCENTAGE	N	Single	000.0000	Enter 5% as 05 or 5. See note below.
DISTDETAIL_AMOUNT	N	Currency	0.00	See note below.