Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
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.
|
cLevelOfDetailAcctCde | LDA | char | OPT | 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. |
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. |
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
|
szLedgerType1 | 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.
|
szLedgerType2 | LT | char | OPT | 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.
|
mnNetVarianceAmt | 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.
|
mnOriginalVarianceAmt | 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.
|
mnTotalOriginalAmt1 | 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.
|
mnTotalNetAmt2 | 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.
|
cVarianceCalcMethod | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
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.
|
cRequestedLevelOfDetail | LDA | char | OPT | 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. |
mnCenturyFiscalYear2 | CFY | MATH_NUMERIC | OPT | NONE |
A field used to store the century concatenated with the fiscal year. |
mnFromPeriodNumber2 | 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.
|
mnThruPeriodNumber2 | 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.
|
mnFromPeriodNumber1 | 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.
|
mnThruPeriodNumber1 | 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.
|
mnCenturyFiscalYear1 | CFY | MATH_NUMERIC | REQ | NONE |
A field used to store the century concatenated with the fiscal year. |
mnTotalNetAmt1 | 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.
|
mnTotalOriginalAmt2 | 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.
|
szActivityCode | ACTB | char | OPT | NONE |
The aggregation of actions performed within an organization that are useful for purposes of activity-based costing. |
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).
|
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).
|
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).
|
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).
|
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).
|
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).
|
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).
|
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).
|
mnItem | 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 |
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.
|
szMultiLevelIndex | S11 | char | OPT | NONE |
User Defined Codes (10 separate codes are allowed) which can be used to generate selective reporting based on user assigned values
of these codes. |
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. |
cCostObjDetailCache | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
idCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. |
cCacheCodeError | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event.
|
szACTBDescription | DL01 | char | OPT | NONE |
A user defined name or remark. |
szErrorMessageID | DTAI | char | OPT | NONE |
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 | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
runtime error message handling.
1 = suppress runtime error message handling. |
cAssignmentFlag | ASMF | char | OPT | NONE |
This field indicates whether this record in the Cost Analyzer Balance table (F1602) has been affected by an assignment. |
mnAmountWtd | AWTD | MATH_NUMERIC | OPT | NONE |
The net amount from the week-to-date postings for an account. |
mnAmtOriginalBeginBud | BORG | MATH_NUMERIC | OPT | NONE |
Field that tracks amounts for an annual budget amount by ledger type in the Account Balances file (F0902). |
mnBudgetRequested | BREQ | MATH_NUMERIC | OPT | NONE |
A code that specifies the ledger type with which to track amounts in the Account Balances table (F0902). Valid values are:
BA/BU
Requested budget from Budget by Business Unit or Account. When you update this field, the system updates BAPR (Approved Budget) and BORG
(Final or original budget to expedite budget changes.)
PA/PU
Pending commitments from purchase orders. The Repost Committed Cost
program (R00932) uses processing options to determine the status code for pending (unapproved) purchase orders. (Total commitments are
posted to the Original Budget field BORG, and open commitments update the monthly or period amounts.) The Fixed Assets system also
uses this field in the Asset Account Balances File table (F1202) to record transfers. Debit journal entries to asset cost accounts and credits to
accumulated depreciation accounts with Document Type AT (Asset Transfer) update this field in the Fixed Asset Post program (R12800). |
mnBudgetApproved | BAPR | MATH_NUMERIC | OPT | NONE |
This field tracks the following amounts in the Account Balances file (F0902):
Ledger type - BA/BU. Approved Budget from Budget by
Business Unit or by Account. (Changes to this field also update the Final/Original Budget field BORG to expedite entry of the final budget.)
Fixed
Assets also uses this field in the Item Balances file (F1202) to record transfers out. Credit journal entries to asset cost accounts and debits to
accumulated depreciation accounts with Document Type AT (Asset Transfer) update this field in the F/A Post program. |
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction.
|
szCurrencyCodeDenom | CRCX | char | OPT | NONE |
A code that indicates the currency in which an amount is denominated.
|