DecimalTriggerGetByLTCRCDC

Decimal Trigger Get By LT CRCD CO

Major Business Rule

Object Name: B1100015

Parent DLL: CFIN

Location: Client/Server

Language: C

Functional Description

Purpose
The purpose of this business function is to get the  currency decimals and update the MATH_NUMERIC
structure for all Math Numerics provided.  This is used mainly at the data base trigger level where it
is run automatically when currency processing is on.

Setup Notes and Prerequisites

Special Logic

Technical Specification
Use ledger type to run the JDB API JDB_RetrieveF0025RowUsingLedgerType to retrieve the currency code
from the ledger type record cached.

If the ledger type currency code is not blank, use this currency code to run the JDB API
JDB_RetrieveF0013RowUsingCurrencyCode to retrieve the decimals for the currency from the cache. Run the API's
jdeMathSetDecimals and jdeMathSetCurrCode to set the currency decimals and currency code for each of the
15 DOMESTIC and 15 FOREIGN Math Numeric amounts in the data structure.

If the ledger type currency code is blank, use company to run the JDB API
JDB_RetrieveF0010RowUsingCompanyNumber to retrieve the currency code from the company record cached.  Using the currency code
from the company, run the JDB API JDB_RetrieveF0013RowUsingCurrencyCode to retrieve the decimals for the
currency from the cache.  Run the API's jdeMathSetDecimals and jdeMathSetCurrCode to set the currency
decimals and currency code for each of the 15 DOMESTIC Math Numeric amounts in the data structure.

If the ledger type currency code is blank, use the transaction currency code to run the JDB API
JDB_RetrieveF0013RowUsingCurrencyCode to retrieve the decimals for the currency from the cache.  Run the
API's jdeMathSetDecimals and jdeMathSetCurrCode to set the currency decimals and currency code for each
of the 15 FOREIGN Math Numeric amounts in the data structure.

Data Structure

D1100015 - Decimal Trigger Get By LT CRCD CO

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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 can set up multiple, concurrent accounting ledgers within the general ledger to establish an audit trail for all transactions.
szTransactionCurrencyCode	CRCD	char	NONE	NONE
A code that identifies the currency of a transaction.
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 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.
mnDomesticAmount01	AN01	MATH_NUMERIC	NONE	NONE
A number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants table (F0010). The net amount posted is the total of all debits and credits, beginning with the first day of the period through the last day of the period.
mnDomesticAmount02	AN02	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount03	AN03	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount04	AN04	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount05	AN05	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount06	AN06	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount07	AN07	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount08	AN08	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount09	AN09	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount10	AN10	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount11	AN11	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount12	AN12	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount13	AN13	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount14	AN14	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnDomesticAmount15	AN15	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount01	AN16	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount02	AN17	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount03	AN18	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount04	AN19	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount05	AN20	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount06	AN21	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount07	AN22	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount08	AN23	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount09	AN24	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount10	AN25	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount11	AN26	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount12	AN27	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount13	AN28	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount14	AN29	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.
mnForeignAmount15	AN30	MATH_NUMERIC	NONE	NONE
Number that represents the net amount posted during the accounting period. The system uses the accounting periods from the Company Constants file (F0010). The net amount posted is the total of all debits and credits beginning with the first day of the period through the last day of the period.

Related Functions

None

Related Tables

F0010 Company Constants
F0013 Currency Codes
F0025 Ledger Type Master File