ValidateChartTypeAccount

Validate Chart Type Account

Minor Business Rule

Object Name: N5100006

Parent DLL: CAEC

Location: Client/Server

Language: NER

Purpose
To edit certain Account Master(F0901) fields against similar fields in the Chart Type Master(F5109). The fields which can be edited are:
Object(OBJ), Subsidiary(SUB), Alternate Subsidiary(SUBA), Level of Detail(LDA), Method of Computation(CCT), Unit of Measure(UM), Workers
Comp(WCMP), Equipment Rate Code(ERC), Posting Edit Code(PEC) and Account Category Codes 1-4(R001-R004). A Processing Options controls if the editing
occurs and other Processing Options can narrow down which range of accounts are to be edited . The edit occurs when adding new accounts or
changing existing accounts. Which fields are edited are on UDC table 51/ED except Object and Subsidiary. Additional fields added to the UDC table will
not be edited. If any of the above fields are taken off the 51/ED, the fields will not be edited.

Data Structure

DN5100006 - Validate Chart Type Account

Parameter Name Data Item Data Type Req/Opt I/O/Both

szChartType CTY char REQ INPUT

A defined code (51/TC) that identifies a model chart of accounts. You can set up a different model for each type of job or standard section
of a job. A blank chart type can be used to identify the the most commonly used model.

szCostCodeFrom SUB char REQ INPUT

A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.

szCostCodeThru SUB char REQ INPUT

A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.

szCostTypeFrom OBJ char REQ INPUT

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

szCostTypeThru OBJ char REQ INPUT

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

cLevelOfDetailThru LDA char REQ INPUT

A number used to summarize and classify accounts in the general ledger by level of detail. Level 9 is the most detailed and Level 1 is the
least detailed. Levels 1 and 2 are reserved for company and business unit totals. Levels 8 and 9 are reserved for job cost posting accounts in
the Job Cost system. Examples of the other levels are: 3 Assets, Liabilities, Revenues, Expenses   4 Current Assets, Fixed Assets, Current
Liabilities, and so on   5 Cash, Accounts Receivable, Inventories, Salaries, and so on 6 Petty Cash, Cash in Banks, Trade Accounts Receivable,
and so on   7 Petty Cash - Dallas, Petty Cash - Houston, and so on 8 More Detail   9 More Detail Do not skip levels of detail when you assign a
level of detail to an account. Nonsequential levels of detail cause rollup errors in financial reports.

szCostCode SUB char REQ INPUT

A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.

szCostType OBJ char REQ INPUT

The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of
accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not
the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.

cLevelOfDetail LDA char REQ BOTH

A number used to summarize and classify accounts in the general ledger by level of detail. Level 9 is the most detailed and Level 1 is the
least detailed. Levels 1 and 2 are reserved for company and business unit totals. Levels 8 and 9 are reserved for job cost posting accounts in
the Job Cost system. Examples of the other levels are: 3 Assets, Liabilities, Revenues, Expenses   4 Current Assets, Fixed Assets, Current
Liabilities, and so on   5 Cash, Accounts Receivable, Inventories, Salaries, and so on 6 Petty Cash, Cash in Banks, Trade Accounts Receivable,
and so on   7 Petty Cash - Dallas, Petty Cash - Houston, and so on 8 More Detail   9 More Detail Do not skip levels of detail when you assign a
level of detail to an account. Nonsequential levels of detail cause rollup errors in financial reports.

cPostingEditCode PEC char REQ BOTH

A code that controls G/L posting and account balance updates in the Account Master table (F0901). Valid values are: Blank Allows all
posting. Posts subledgers in detailed format for every account transaction. Does not require subledger entry. B Only allows posting to budget
ledger types starting with B or J. I Inactive account. No posting allowed. L Subledger and type are required for all transactions. Posts subledgers in
detailed format for every account. The system stores the subledger and type in the Account Ledger (F0911) and Account Balances (F0902)
tables. If you want to report on subledgers in the Financial Reporting feature, use this code. M Machine-generated transactions only (post
program creates offsets). N Non-posting. Does not allow any post or account balance updates. In the Job Cost system, you can still post budget
quantities. S Subledger and type are required for all transactions. Posts subledgers in summary format for every transaction. The system
stores the subledger detail in the Account Ledger table. This code is not valid for budget entry programs. U Unit quantities are required for all
transactions. X Subledger and type must be blank for all transactions. Does not allow subledger entry for the account.

szUnitOfMeasure UM char REQ BOTH

A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
cubic meter, liter, hour, and so on.

szWorkersCompInsurCode WCMP char REQ BOTH

A user defined code (00/W) that represents a workers' compensation insurance (WCI) code. This code should correspond to the
classifications on your periodic workers' compensation insurance reports.

cMethodOfComputation CCT char REQ BOTH

The method the system uses to calculate the percent complete, the projected final cost, and unit quantity for an account. Method of
computation is a user defined code (51/MC).

szCategoryCode1 R001 char REQ BOTH

Category code 1 associated with the Account Master table (F0901). This is a user defined code (09/01) for use in flex account mapping and
in printing selected information on reports.

szCategoryCode2 R002 char REQ BOTH

Category code 2 associated with the Account Master table (F0901). This is a user defined code (09/02) for use in flex account mapping and
in printing selected account information on reports.

szCategoryCode3 R003 char REQ BOTH

Category code 3 associated with the Account Master table (F0901). The system uses this user defined code (09/03) in mapping flexible
account numbers and printing selected account information on reports.

szCategoryCode4 R004 char REQ BOTH

Category code 4 associated with the Account Master table (F0901). This is a user defined code (09/04) for use in flex account mapping and
in printing selected account information on reports.

szAlternateCostCode SUBA char REQ BOTH

An alternate subsidiary account that allows you to comply with a regulatory chart of accounts, parent company requirements, or third party
coding scheme.

szEquipmentRateCode ERC char REQ BOTH

A user defined code (00/RC) that indicates a billing rate, such as DY for daily, MO for monthly, and WK for weekly. You can set up multiple
billing rates for a piece of equipment. If you leave this field blank, the system searches for a valid billing rate in the following sequence: 1.
Account Ledger Master (F0901) This table contains the most detailed rate information. You can assign multiple rates for a job. For example, you
can set up separate rates for different equipment working conditions. 2.  Job or Business Unit Master (F0006) This table contains less detailed
rate information than the Account Ledger Master. You can only set up a single rate for a job based on this table. 3.  Rental Rules (F1302) This
table contains the least detailed rate code information. The system searches this table according to the criteria you establish when setting up
the table.

szErrorMessage DTAI char REQ OUTPUT

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

cSuppressErrorMessage EV01 char REQ INPUT

An option that specifies the type of processing for an event.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szChartType	CTY	char	REQ	INPUT
A defined code (51/TC) that identifies a model chart of accounts. You can set up a different model for each type of job or standard section of a job. A blank chart type can be used to identify the the most commonly used model.
szCostCodeFrom	SUB	char	REQ	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCostCodeThru	SUB	char	REQ	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCostTypeFrom	OBJ	char	REQ	INPUT
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
szCostTypeThru	OBJ	char	REQ	INPUT
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
cLevelOfDetailThru	LDA	char	REQ	INPUT
A number used to summarize and classify accounts in the general ledger by level of detail. Level 9 is the most detailed and Level 1 is the least detailed. Levels 1 and 2 are reserved for company and business unit totals. Levels 8 and 9 are reserved for job cost posting accounts in the Job Cost system. Examples of the other levels are: 3 Assets, Liabilities, Revenues, Expenses 4 Current Assets, Fixed Assets, Current Liabilities, and so on 5 Cash, Accounts Receivable, Inventories, Salaries, and so on 6 Petty Cash, Cash in Banks, Trade Accounts Receivable, and so on 7 Petty Cash - Dallas, Petty Cash - Houston, and so on 8 More Detail 9 More Detail Do not skip levels of detail when you assign a level of detail to an account. Nonsequential levels of detail cause rollup errors in financial reports.
szCostCode	SUB	char	REQ	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCostType	OBJ	char	REQ	INPUT
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into subcategories. For example, you can divide the Cost Code for labor into regular time, premium time, and burden. Note: If you use a flexible chart of accounts and the object account is set to 6 digits, J.D. Edwards recommends that you use all 6 digits. For example, entering 000456 is not the same as entering 456 because if you enter 456 the system enters three blank spaces to fill a 6-digit object.
cLevelOfDetail	LDA	char	REQ	BOTH
A number used to summarize and classify accounts in the general ledger by level of detail. Level 9 is the most detailed and Level 1 is the least detailed. Levels 1 and 2 are reserved for company and business unit totals. Levels 8 and 9 are reserved for job cost posting accounts in the Job Cost system. Examples of the other levels are: 3 Assets, Liabilities, Revenues, Expenses 4 Current Assets, Fixed Assets, Current Liabilities, and so on 5 Cash, Accounts Receivable, Inventories, Salaries, and so on 6 Petty Cash, Cash in Banks, Trade Accounts Receivable, and so on 7 Petty Cash - Dallas, Petty Cash - Houston, and so on 8 More Detail 9 More Detail Do not skip levels of detail when you assign a level of detail to an account. Nonsequential levels of detail cause rollup errors in financial reports.
cPostingEditCode	PEC	char	REQ	BOTH
A code that controls G/L posting and account balance updates in the Account Master table (F0901). Valid values are: Blank Allows all posting. Posts subledgers in detailed format for every account transaction. Does not require subledger entry. B Only allows posting to budget ledger types starting with B or J. I Inactive account. No posting allowed. L Subledger and type are required for all transactions. Posts subledgers in detailed format for every account. The system stores the subledger and type in the Account Ledger (F0911) and Account Balances (F0902) tables. If you want to report on subledgers in the Financial Reporting feature, use this code. M Machine-generated transactions only (post program creates offsets). N Non-posting. Does not allow any post or account balance updates. In the Job Cost system, you can still post budget quantities. S Subledger and type are required for all transactions. Posts subledgers in summary format for every transaction. The system stores the subledger detail in the Account Ledger table. This code is not valid for budget entry programs. U Unit quantities are required for all transactions. X Subledger and type must be blank for all transactions. Does not allow subledger entry for the account.
szUnitOfMeasure	UM	char	REQ	BOTH
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box, cubic meter, liter, hour, and so on.
szWorkersCompInsurCode	WCMP	char	REQ	BOTH
A user defined code (00/W) that represents a workers' compensation insurance (WCI) code. This code should correspond to the classifications on your periodic workers' compensation insurance reports.
cMethodOfComputation	CCT	char	REQ	BOTH
The method the system uses to calculate the percent complete, the projected final cost, and unit quantity for an account. Method of computation is a user defined code (51/MC).
szCategoryCode1	R001	char	REQ	BOTH
Category code 1 associated with the Account Master table (F0901). This is a user defined code (09/01) for use in flex account mapping and in printing selected information on reports.
szCategoryCode2	R002	char	REQ	BOTH
Category code 2 associated with the Account Master table (F0901). This is a user defined code (09/02) for use in flex account mapping and in printing selected account information on reports.
szCategoryCode3	R003	char	REQ	BOTH
Category code 3 associated with the Account Master table (F0901). The system uses this user defined code (09/03) in mapping flexible account numbers and printing selected account information on reports.
szCategoryCode4	R004	char	REQ	BOTH
Category code 4 associated with the Account Master table (F0901). This is a user defined code (09/04) for use in flex account mapping and in printing selected account information on reports.
szAlternateCostCode	SUBA	char	REQ	BOTH
An alternate subsidiary account that allows you to comply with a regulatory chart of accounts, parent company requirements, or third party coding scheme.
szEquipmentRateCode	ERC	char	REQ	BOTH
A user defined code (00/RC) that indicates a billing rate, such as DY for daily, MO for monthly, and WK for weekly. You can set up multiple billing rates for a piece of equipment. If you leave this field blank, the system searches for a valid billing rate in the following sequence: 1. Account Ledger Master (F0901) This table contains the most detailed rate information. You can assign multiple rates for a job. For example, you can set up separate rates for different equipment working conditions. 2. Job or Business Unit Master (F0006) This table contains less detailed rate information than the Account Ledger Master. You can only set up a single rate for a job based on this table. 3. Rental Rules (F1302) This table contains the least detailed rate code information. The system searches this table according to the criteria you establish when setting up the table.
szErrorMessage	DTAI	char	REQ	OUTPUT
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
cSuppressErrorMessage	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.