Business Function Specification
Source NameB1600220DesignerAnna Kyazyan
Data Structure D1600220ProgrammerAnna Knyazyan
Function NameCache F1602 Cost Objects Details
System Code16
Function CategoryCache Function
Function Use
Revisions Log
DateModifications bySAR NumberDescription
03/02/99Anna Knyazyan2466234Created
1.Functional Description
1.1Purpose
This business function is used to load the cache with F1602 records to retrieve records. The
function is called from B1600230, it is created for Activity Cost Inquiry (P1641) and Cost Object Inquiry
(P16021). The cache holds detail records of activities or accounts selected in P1641 or in P16021.
1.2Setup Notes and Prerequisites
1.2Special Logic
This cache function is multiple index cache. It has to indexes which are used to fetch the records
in the desire sequence.
Index 1 (Key 1) is used to sequence the records by MultiLevelIndex and Activity Code
Index 2 (Key 2) is used to sequence the records by Business Unit, Object Account and Subsidiary
Keys to the cache are:
typedef struct tagDSD1600220CacheKey1
DSD1600220CacheKey1,*LPDS1600220CacheKey1;
typedef struct tagDSD1600220CacheKey2
DSD1600220CacheKey2,*LPDS1600220CacheKey2;
Mode 1 - Fetches the first record from the cache
Before fetching depending on the key passed in the corresponding index is set and the cursor is reset
to fetch according the specified index
Mode 2 - Add records to cache
B1600230.c gets records from F1602 and adds them to the cache by calling B1600220.c and passing Mode
= 2
2.Technical Specifications
2.1Parameters:
Data Item DescriptionI/ORequiredNotes
JOBSJob NumberIY
GENLNGID CursorIY
MODEModeIN'1' = Fetch first record
'2' = Add to cache
'6' = Get next record
'8' = Terminate cache
Other modes can be modified for future use
EV01Cache Code Error IN'1' = Call Data Sequencing window
Note: Either Key 1 or Key 2 are required as input parameter to be able to fetch records from cache
2.2Related Tables
Table Table Description
F1602Cost Analyzer Balances
2.3Related Business Functions
Source NameFunction Name
B1600230Cost Object Inquiry Total Amounts
2.4Processing
Depending on what key is passed in with Mode = 1, the corresponding index is set and cursor is reset^
D1600220 - Cache F1602 Cost Objects Details
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cMode_EV01 | EV01 | char | REQ | NONE |
An option that specifies the type of processing for an event. | ||||
cCacheCodeError_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessage_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szErrorMessageID_DTAI | 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
| ||||
mnJobnumber_JOBS | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
idCursor_GENLNG | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cReturnCursor_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cValidFlag_EV01 | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
nNumberOfKeys_INT01 | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szMultiLevelIndex_S11 | 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
| ||||
mnViewNumber_VWNM | VWNM | MATH_NUMERIC | OPT | 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
| ||||
szActivityCode_ACTB | ACTB | char | OPT | NONE |
The aggregation of actions performed within an organization that are useful for purposes of activity-based costing. | ||||
szAccountId_AID | 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. | ||||
mnCenturyFiscalYear_CFY | CFY | MATH_NUMERIC | OPT | NONE |
A field used to store the century concatenated with the fiscal year. | ||||
szLedgerType1_LT | 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
| ||||
szSubledger_SBL | 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
| ||||
cSubledgerType_SBLT | 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
| ||||
szCostObject1_ABR1 | 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
| ||||
cCostObjectType1_ABT1 | 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
| ||||
szCostObject2_ABR2 | 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
| ||||
cCostObjectType2_ABT2 | 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
| ||||
szCostObject3_ABR3 | 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
| ||||
cCostObjectType3_ABT3 | 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
| ||||
szCostObject4_ABR4 | 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
| ||||
cCostObjectType4_ABT4 | 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
| ||||
mnIdentifierShortItem_ITM | 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
| ||||
szCompany_CO | 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
| ||||
mnBalFWD_APYC | APYC | MATH_NUMERIC | OPT | NONE |
The cumulative prior year-end balance. The system uses this amount as the beginning balance for balance sheet and job cost
| ||||
cAssignmentFlag_ASMF | ASMF | char | OPT | NONE |
This field indicates whether this record in the Cost Analyzer Balance table (F1602) has been affected by an assignment. | ||||
mnWeektoDateNetPostings_AWTD | AWTD | MATH_NUMERIC | OPT | NONE |
The net amount from the week-to-date postings for an account. | ||||
szBusinessUnit_MCU | 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
| ||||
szObjectAccount_OBJ | 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
| ||||
szSubsidiary_SUB | SUB | char | OPT | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
mnOriginalBeginningBudget_BORG | BORG | MATH_NUMERIC | OPT | NONE |
Field that tracks amounts for an annual budget amount by ledger type in the Account Balances file (F0902). | ||||
mnRequestedBudget_BREQ | 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:
| ||||
mnApprovedBudget_BAPR | 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
| ||||
szCurrencyCodeFrom_CRCD | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szCurrencyCodeDenom_CRCX | CRCX | char | OPT | NONE |
A code that indicates the currency in which an amount is denominated. | ||||
mnOriginalPosting1_AN01 | AN01 | MATH_NUMERIC | OPT | NONE |
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnNetBalance1_NB01 | NB01 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
szACTBDescription_DL01 | DL01 | char | OPT | NONE |
A user defined name or remark. | ||||
szLedgerType2_LT | 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
| ||||
mnOriginalPosting2_AN01 | AN01 | MATH_NUMERIC | OPT | NONE |
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company
| ||||
mnNetBalance2_NB01 | NB01 | MATH_NUMERIC | OPT | NONE |
This number represents the net balance for the accounting period. The net balance equals original amount, which is posted to the Cost
| ||||
nCountIndex_INT01 | INT01 | integer | OPT | NONE |
Number of Days in Future to Query for Responses Due. |
None |
None |