DecimalTriggerGetByLT_CRDC_CRCD

Decimal Trigger Get By LT CRDC CRCD

Major Business Rule

Object Name: B1100014

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 and the ledger type is not 'CA', use the base 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 Math Numeric amounts in the data structure.

If the ledger type currency code is blank and the ledger type is not 'CA', 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.

If the ledger type is 'CA', 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
DOMESTIC and FOREIGN Math Numeric amounts in the data structure.

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.
szBaseCurrencyCode	CRDC	char	NONE	NONE
A code that identifies the domestic (base) currency of the company on a transaction.
szTransactionCurrencyCode	CRCD	char	NONE	NONE
A code that identifies the currency of a transaction.
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.

F0013 Currency Codes
F0025 Ledger Type Master File

DecimalTriggerGetByLT_CRDC_CRCD