DecimalTriggerGetByLT_CRCX

Decimal Trigger Get By LT CRCX

Major Business Rule

Object Name: B1100009

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
Note that when 'Post by Currency' is not turned on, that is currencies are summarized in the CA
ledger, the account's company currency decimals is used.  This is the currency that is in the denominated
currency field (CRCX) in the Account Balance file.  In all other circumstances, the appropriate
currency will be in the denominated currency field.

Technical Specification
First determine if this is a units ledger type.  If it is a units ledger type, go to the Data
Dictionary for data item 'U' to retrieve the display decimals.  Use this value as the decimals for each of
the 45 Math Numeric amounts.  Currency code does not apply to these Math Numeric amounts.

If this is not a units ledger type, use the denominated 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 45 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.
szDenominatedCurrencyCode	CRCX	char	NONE	NONE

mnAmount01	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.
mnAmount02	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.
mnAmount03	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.
mnAmount04	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.
mnAmount05	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.
mnAmount06	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.
mnAmount07	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.
mnAmount08	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.
mnAmount09	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.
mnAmount10	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.
mnAmount11	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.
mnAmount12	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.
mnAmount13	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.
mnAmount14	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.
mnAmount15	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.
mnAmount16	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.
mnAmount17	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.
mnAmount18	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.
mnAmount19	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.
mnAmount20	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.
mnAmount21	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.
mnAmount22	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.
mnAmount23	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.
mnAmount24	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.
mnAmount25	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.
mnAmount26	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.
mnAmount27	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.
mnAmount28	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.
mnAmount29	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.
mnAmount30	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.
mnAmount31	AN31	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.
mnAmount32	AN32	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.
mnAmount33	AN33	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.
mnAmount34	AN34	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.
mnAmount35	AN35	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.
mnAmount36	AN36	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.
mnAmount37	AN37	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.
mnAmount38	AN38	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.
mnAmount39	AN39	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.
mnAmount40	AN40	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.
mnAmount41	AN41	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.
mnAmount42	AN42	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.
mnAmount43	AN43	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.
mnAmount44	AN44	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.
mnAmount45	AN45	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_CRCX