| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|
| mnViewNumber | VWNM | MATH_NUMERIC | REQ | NONE |
A number from 1 to 10 that specifies how the system posts records from the Account Ledger table (F0911) to the Cost Analyzer Balances
table (F1602). This number also specifies which managerial accounting posting code (PM01 - PM10) in the F0911 table to update as
posted.
For example, if the view number is 1, then the system updates PM01 with a P when the F0911 record is marked as being posted.
|
| szLedgerType | LT | char | REQ | NONE |
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.
|
| cCostObjectType1 | ABT1 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
be added or modified using the Cost Object Types program (P1620).
|
| szCostObject1 | ABR1 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in
the cost object code field to the Account Balances file (F0902).
|
| cCostObjectType2 | ABT2 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
be added or modified using the Cost Object Types program (P1620).
|
| szCostObject2 | ABR2 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in
the cost object code field to the Account Balances file (F0902).
|
| cCostObjectType3 | ABT3 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
be added or modified using the Cost Object Types program (P1620).
|
| szCostObject3 | ABR3 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in
the cost object code field to the Account Balances file (F0902).
|
| cCostObjectType4 | ABT4 | char | OPT | NONE |
A code that specifies the type of cost object and the type of editing. Valid types are stored in the Cost Object Types table (F1620) and can
be added or modified using the Cost Object Types program (P1620).
|
| szCostObject4 | ABR4 | char | OPT | NONE |
A cost object code, such as an equipment item number or an address book number. If you enter a cost object code, you must also specify
the cost object type. This field functions the same and is validated the same as the subledger field, but the system does not post the data in
the cost object code field to the Account Balances file (F0902).
|
| mnShortItem | ITM | MATH_NUMERIC | OPT | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:
o Item Number (short) - An eight-digit, computer-assigned item number
o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number
o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number |
| szActivityCode | ACTB | char | OPT | NONE |
The aggregation of actions performed within an organization that are useful for purposes of activity-based costing. |
| cLevelOfDetailAcctCde | LDA | char | REQ | NONE |
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. |
| cSubledgerType | SBLT | char | OPT | NONE |
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger
editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded
or user defined. Valid values include:
A
Alphanumeric field, do not edit
N
Numeric field, right justify and zero fill
C
Alphanumeric field, right
justify and blank fill
|
| szSubledger | SBL | char | OPT | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
address book number. If you enter a subledger, you must also specify the subledger type. |
| mnFromPeriod | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number
is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the
preparation of financial reports.
|
| mnThruPeriod | PN | MATH_NUMERIC | OPT | NONE |
A number indicating the current accounting period. This number, used in conjunction with the Company Constants table (F0010) and the
General Constants table (F0009), allows the user to define up to 14 accounting periods. See General Ledger Date. The current period number
is used to determine posted before and posted after cut off warning messages. It is also used as the default accounting period in the
preparation of financial reports.
|
| mnCenturyFiscalYear | CFY | MATH_NUMERIC | REQ | NONE |
A field used to store the century concatenated with the fiscal year. |
| mnTotalNetBalanceAmount | AA | MATH_NUMERIC | OPT | NONE |
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a
minus sign (-) either before or after the amount.
|
| cRequestedLevelOfDetail | LDA | char | REQ | NONE |
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 | OPT | NONE |
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. |
| szCompany | CO | char | OPT | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany
transactions.
Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000
for transaction entries.
|
| szBusinessUnit | MCU | char | OPT | NONE |
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.
|
| szObjectAccount | OBJ | char | OPT | NONE |
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. |
| szSubsidiary | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account.
|
| szAccountId | AID | char | OPT | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it.
|
| szEndingCOGObjAcct | OBJ | char | OPT | NONE |
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. |