Purpose
Locates and Retrieves appropriate depreciation defaults from the F12003 for use with newly created F1202 records. Uses the F12002 Accounting
Constants to determine the correct cost obj and sub account to use as key to the F12003.
Setup Notes and Prerequisites
Requires input of key fields for lookup
Requires existence of fields on the calling app or report to catch returned defaults
There is an optional delete of F1202 depending on successful retrieval of defaults. This is used in
R12800 and requires the fields noted below. If you aren't interested in the optional delete, you do
not need these F1202 key fields. The delete will not occur if these fields are not passed in.
There are a number of output flags and fields that are also used in the R12800 processing that may
or may not have value in other apps or ubes. They are noted below.
The Balance Character Code is an account type and should be provided to this function as input. The
code can be determined by running N12920 and returning the code to a variable which is then passed
into this NER function or it can be passed as a literal if the type of account is known, i.e. 1= Cost
Account, 2 or 3= Accumulated Depreciation, 4, 5,or 6 = Depreciation Expense for the purposes of
retrieving Cost Obj and Sub from the F12002.
If you have already retrieved or know the Cost Obj and Sub, as in Beginning Balances, you can pass
the Cost Obj and Sub into this function and set the FetchF12002Flag to a '1'. This allows you to bypass
the F12002 while loops.
^
D1200120 - Retrieve Depreciation Defaults for F1202
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAssetItemNumber | NUMB | MATH_NUMERIC | NONE | NONE |
An 8-digit number that uniquely identifies an asset. | ||||
szAccountId | AID | char | NONE | NONE |
A number that the system assigns to each general ledger account in the Account Master table (F0901) to uniquely identify it. | ||||
mnCentury | CTRY | MATH_NUMERIC | NONE | NONE |
The calendar century associated with the year. Enter is the first two digits of
the year. For example, 19 indicates any year beginning with 19
| ||||
mnFiscalYear1 | FY | MATH_NUMERIC | NONE | NONE |
A number that identifies the fiscal year. Generally, you can either enter a number in this field or leave it blank to indicate the current fiscal
| ||||
szFiscalQtrFutureUse | FQ | char | NONE | NONE |
A data field reserved for future use. | ||||
szSubledger | SBL | char | NONE | NONE |
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an
| ||||
cSubledgerType | SBLT | char | NONE | 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
| ||||
cBalanceCharacterCode | CHCD | char | NONE | NONE |
A code that indicates in which range of accounts the account in the Item Balance falls.
Valid values are:
1
Cost
2
Accumulated Depreciation
| ||||
szObjectAccount | OBJ | char | NONE | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szSubsidiary | SUB | char | NONE | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
szLedgerType | LT | char | NONE | 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
| ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
mnLifeMonths | ADLM | MATH_NUMERIC | NONE | NONE |
The life of an asset in months or periods. The system uses months or periods only to express the life of an asset. For example, if your
| ||||
szDepreciationMethod | ADM | char | NONE | NONE |
The user defined code (12/DM) that indicates the method of depreciation for the specified book. In addition to any user defined
| ||||
cDepreciationInformation | ITAC | char | NONE | NONE |
A code for additional depreciation information. This code is used for investment tax credit (ITC) and averaging conventions. The system
| ||||
mnMethod | ADMP | MATH_NUMERIC | NONE | NONE |
A number that specifies what percentage you want the system to use when calculating depreciation. You must use whole numbers. For
| ||||
szScheduleMethod9 | ADSN | char | NONE | NONE |
The alphanumeric code you assign to a units of production schedule. You must set up the schedules you want to use for method 09 (Units
| ||||
cCompMethodItdOrRem | DIR1 | char | NONE | NONE |
A code that specifies the method that the system uses to calculate depreciation based on the depreciation method you specify. Valid
| ||||
jdDateDepreStarted | DSD | JDEDATE | NONE | NONE |
The date when the depreciation computations start for an asset. This date can be different from the date the asset was acquired. | ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
cDepreciationCalculationF | DPCF | char | NONE | NONE |
A code that indicates whether a record in the Asset Account Balances table (F1202) is the result of running the Depreciation Projections
| ||||
mnCostBalanceCrossReferenc | CBXR | MATH_NUMERIC | NONE | NONE |
(Future Use) | ||||
cContinueFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorsFoundFlag | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cFetched12002Flag | EV04 | char | NONE | NONE |
PeopleSoft event point processing flag 04. | ||||
szErrorMessageID | DTAI | char | NONE | 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
| ||||
szFetchedLT | LT | char | NONE | 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
|
None |
F12002 Default Accounting Constants | ||||
F12003 Default Depreciation Constants | ||||
F1202 Asset Account Balances File |