F5109CopyAccounts

F5109 Copy Accounts

Master Business Function

Object Name: B5100017

Parent DLL: CAEC

Location: Client/Server

Language: C

Purpose
To copy a F5109 into the following options.  The F5109 is keyed by CTY, SUB and OBJ.
1)   F5109 in it's entirety to another F5109.
2)   F5109 as ranges of Cost Codes and Cost Types to another F5109.
3)   F5109 as ranges of Cost Codes and Cost Types to the same F5109.  In this case, the user is using the 'From' range as a template, then changes a
character in this selected range, and creates a new 'To' cost code or cost type.
4)   F5109 in it's entirety to F0901 by prompting for the MCU.
5)   F5109 as ranges of Cost Codes and Cost Types to F0901 by prompting for the MCU.
6) F0901 to F0901 by prompting for the 'From' and 'To':  MCU, LOD, Cost Code and Cost Type Range, and Job Type.
7) F0902 to F0902 Budgets by prompting for the 'From' and 'To':  MCU, LOD, Cost Code and Cost Type Range, and Job Type.

When copying the F5109, a popup Fix/Inspect will be called that will act as a Global Update screen.  It is envisioned that this same Fix/Inspect will
serve as the functional provider for:

'Chart Type Setup' P51091
1)   F5109 in it's entirety to another F5109.
2)   F5109 as ranges of Cost Codes and Cost Types to another F5109.
3)   F5109 as ranges of Cost Codes and Cost Types to the same F5109.  In this case, the user is using the 'From' range as a template, then changes a
character in this selected range, and creates a new 'To' cost code or cost type.

'Copy Selected Master Codes' P510921
4)   F5109 in it's entirety to F0901 by prompting for the MCU.
5)   F5109 as ranges of Cost Codes and Cost Types to F0901 by prompting for the MCU.

'Copy Similar Job' P518042
6) F0901 to F0901 by prompting for the 'From' and 'To':  MCU, LOD, Cost Code and Cost Type Range, and Job Type
7)   F0902 to F0902 Budgets by prompting for the 'From' and 'To':  MCU, LOD, Cost Code and Cost Type Range, and Job Type.

Special Logic:
1)   You may not copy from 'Chart Type' to 'Job Type'. The fields that are disallowed will be grayed out.
3) If copying FROM or TO the blank chart type, the user will leave the FROM and TO lines empty.
4) After the OK button is pressed, a 'Message' form will appear asking if the user is sure Y/N.
5) 'F0901 and F0902 records added' display will appear with the number of records that were added to the list.  It will be hidden otherwise.
6) There will be an exit to P510121 to add Original Budgets.
7) Copying budgets with radio button checkboxes will call a separate business function.
8) On Fix/Inspect #2-the new cost code will utilize the same cost types as the cost code it is copying from.  The new cost codes and cost types
will be ADDED (ADD Mode) to the list.
9) If the 'Chart Type' FROM and TO are equal, ignore ranges of cost codes and type and level of detail.
10) Budget Revisions can be copied from job to job, but only F0902 period balances are created, no F0911's are copied
11) BU Security (OW Tools)
12) Edit the BU Posting Edit Code.  Cannot be a N or P. (N5100002)
13) F5108 needs to be checked and added if F0902's are copies (N or B5100001)
14) No Duplicates will be ever allows, whether Accounts, Budgets, Chart Types, etc.
15) Category Code Mapping-applicable here only if the F0902 is copied. (not this BF)
16) After this BF is complete, call the X51013 for each account.

BF Section 1:  F5109-F5109, F5109-F0901, F0901-F0901 (if they are different) in it's entirety or ranges
BF Section 2:  F0902-F0902 (with the F0901 or by itself-see #16).  Ask of the Year of Copy w/a Processing Option and Overlay any existing budgets.
BF Section 3:  F5109-F5109, F0901-F0901 (if they are equal) in it's entirety or ranges

Data Structure

D5100017 - F5109 Copy Accounts

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

szChartTypeFrom CTY char OPT 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.

szJobFrom MCU char OPT INPUT

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szChartTypeTo CTY char OPT 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.

szJobTo MCU char OPT INPUT

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

szJobTypeTo STYL char OPT INPUT

A user defined code (00/MC) that identifies the classification of the business unit.

szCostCodeFrom SUB char OPT INPUT

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

szCostCodeThru SUB char OPT INPUT

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

szCostTypeFrom OBJ char OPT 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 OPT 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 OPT 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.

cCopyType EV01 char REQ INPUT

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

cBudgetType EV02 char OPT INPUT

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

szCostCodeCopyingFrom SUB char OPT INPUT

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

szCostCodeCopyingTo SUB char OPT INPUT

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

szAmountLedgerType LT char OPT INPUT

A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You
can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.

szUnitsLedgerType ULT char OPT INPUT

The units ledger is relational to the amount ledger.  The first character in both ledgers is the same.  The second character in the units ledger
is a U. The one exception to this rule is the AZ (Cash Basis) amount ledger.  If you do not fill in a units ledger for the AZ amount ledger, a
default units ledger of ZU will be used by the G/L Post.  The units ledger must be a valid ledger type.

nF0901Counter INT01 integer OPT OUTPUT

Number of Days in Future to Query for Responses Due.

nF0902Counter INT02 integer OPT OUTPUT

Number of Days in the Past to Query for Quote Requests Received.

szCostCodeToDescription DL01 char OPT INPUT

A user defined name or remark.

szErrorMessageID DTAI char OPT 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.

Related Functions

None

Related Tables

F0901 Account Master

F0902 Account Balances

F5109 Chart Type Master

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szChartTypeFrom	CTY	char	OPT	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.
szJobFrom	MCU	char	OPT	INPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szChartTypeTo	CTY	char	OPT	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.
szJobTo	MCU	char	OPT	INPUT
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
szJobTypeTo	STYL	char	OPT	INPUT
A user defined code (00/MC) that identifies the classification of the business unit.
szCostCodeFrom	SUB	char	OPT	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCostCodeThru	SUB	char	OPT	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCostTypeFrom	OBJ	char	OPT	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	OPT	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	OPT	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.
cCopyType	EV01	char	REQ	INPUT
An option that specifies the type of processing for an event.
cBudgetType	EV02	char	OPT	INPUT
An option that specifies the type of processing for an event.
szCostCodeCopyingFrom	SUB	char	OPT	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szCostCodeCopyingTo	SUB	char	OPT	INPUT
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
szAmountLedgerType	LT	char	OPT	INPUT
A user defined code (09/LT) that specifies the type of ledger, such as AA (Actual Amounts), BA (Budget Amount), or AU (Actual Units). You can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
szUnitsLedgerType	ULT	char	OPT	INPUT
The units ledger is relational to the amount ledger. The first character in both ledgers is the same. The second character in the units ledger is a U. The one exception to this rule is the AZ (Cash Basis) amount ledger. If you do not fill in a units ledger for the AZ amount ledger, a default units ledger of ZU will be used by the G/L Post. The units ledger must be a valid ledger type.
nF0901Counter	INT01	integer	OPT	OUTPUT
Number of Days in Future to Query for Responses Due.
nF0902Counter	INT02	integer	OPT	OUTPUT
Number of Days in the Past to Query for Quote Requests Received.
szCostCodeToDescription	DL01	char	OPT	INPUT
A user defined name or remark.
szErrorMessageID	DTAI	char	OPT	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.

F0901 Account Master
F0902 Account Balances
F5109 Chart Type Master