MLCOLEDGER

Multi-Book Ledger Co Ledger

The Multi Book Ledger Company Ledger file stores information on the company ledger combination, including the current period and fiscal year.

REFERENCED BY
AC121 AC123 AC130 AC191 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC32.1 AC37.1 AC490
AM180 AP125 AP126 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 API1.1 API2.1 BR44.1
CB222 CA10.5 CA110 FB11.1 FB111 FB160
FB211 FB296 FB60.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL165 GL298 GL299
GL65.1 GL90.6 GL94.1 GL94.2 GL94.3 GL94.4
GL94.5 GL94.6 GL94.7 GL95.1 GL95.2 GL95.3
GL95.4 GL95.5 GL95.6 GL95.7 GL95.8 GL95.9
GL96.1 GL96.2 GL96.3 GL96.4 GL96.5 GL97.1
GL97.2 GL97.3 GL97.4 GL97.5 GL97.6 GL97.7
GL97.8 GL97.9 GL98.1 GL98.2 GL98.3 GL98.4
GL98.5 GL99.1 GL99.2 GL99.3 GL99.4 GL99.5
GL99.6 RW100 DR100 IC141 IC142 IC222
IC83.1 IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA44.1 MA44.2 MA61.1 MAI1.1
ML165 ML65.1 ML65.3 RQ10.1 RQ10.3 RQ11.1
RQ13.2 RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.1
ACVW.1 ATVW.1 FB100 FB20.1 FB20.6 FB20.7
FB21.1 GL310 RW230 RW30.1 RW80.1 GLAV.1
GLCV.1 GLVW.1 ML145 ML167 ML191 ML195
ML196 ML212 ML241 ML245 ML250 ML267
ML270 ML275 ML290 ML291 ML292 ML293
ML300 ML320 ML325 ML327 ML330 ML41.1
ML41.3 ML41.4 ML42.1 ML50.1 ML50.2 ML50.4
ML50.5 ML67.1 ML70.1 ML70.2 ML70.3 ML70.5
ML70.6 ML90.1 ML90.2 ML90.3 ML90.4 ML90.5
ML94.1 ML94.2 ML94.3 ML94.4 ML95.1 ML95.2
ML95.3 ML95.4 ML95.5 ML95.6 ML95.7 ML95.8
ML95.9 ML96.1 ML96.2 ML96.3 ML96.4 ML96.5
ML97.1 ML97.2 ML97.3 ML97.4 ML97.5 ML97.6
ML97.7 ML97.8 ML97.9 ML98.1 ML98.2 ML98.3
ML98.4 ML98.5 ML99.1 ML99.2 ML99.3 ML99.4
ML99.5 ML99.6 MLFC.1 MLIT.1 SLVW.1 AD191
RW270 RW70.1 ML210 SNOA.1 SNRA.1 SNSA.1


UPDATED BY
GL110 GL120 GL500 ML10.1 ML110 ML12.1
ML146 ML170 ML190 ML199 ML240 ML40.1
ML40.2 ML40.3 ML40.7 ML40.8 ML44.1 ML45.1
ML75.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLE-COMPANY
Element: Company
Numeric 4
This is the company to which the ledger is linked to. One company can be associated with multiple ledgers. One ledger can be associated with multiple companies. ML maintains separate records for each unique company/ledger combination.
ML10.1
MLE-NAME
Element: Name
Alpha 30 (Lower Case)
This is the company name.
ML10.1
MLE-LEDGER
Element: Ledger
Alpha 15
This is the ledger. The ledger must be associated with the company on ML10. One company can be associated with multiple ledgers. One ledger can be associated with multiple companies. ML maintains separate records for each unique company/ledger combination.
ML10.1 ML110
MLE-ACCT-PERIOD
Element: Acct Period
Numeric 2
This is the current accounting period for the ledger/company combination. It is updated by the Ledger Period Closing (ML199).
GL500 ML10.1
ML12.1 ML199
MLE-FISCAL-YEAR
Element: Year
Numeric 4
This is the current fiscal year for the ledger/company combination.
GL500 ML10.1
ML12.1 ML199
MLE-UPDATING
Element: Updating
Numeric 2
This is set with a value when an update program is running in GL. The value determines the program that is running. No other updates may take place while this field is not blank.
ML110 ML146
ML170 ML190
ML199 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
ML75.1
MLE-LST-YR-CLOSED
Element: Year
Numeric 4
This field contains the last closed fiscal year.
MLE-ACTIVE-STATUS
Element: Active Status
Alpha 1
This field contains the status of the ledger. A ledger must be Active for transactions to be posted to it.
ML10.1
MLE-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
MLE-CURR-CODE-1
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
MLE-CURR-CODE-2
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).


MLCOLEDGER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLESET1 COMPANY
LEDGER
...
AC121 AC123
AC130 AC191
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC32.1
AC37.1 AC490
ACVW.1 ATVW.1
AM180 AP125
AP126 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
MLESET2 LEDGER
COMPANY
...
AC121 AC123
AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
ATVW.1 AD191
AM180 CA10.5
CA110 FB100
FB11.1 FB111
FB160 FB20.1
FB20.6 FB20.7
FB21.1 FB211
FB296 FB60.1
FB95.1 FB95.2


MLCOLEDGER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Coledger GLSYSTEM Required
MLE-COMPANY->GLS-COMPANY
Glsystem GLSYSTEM Required
MLE-COMPANY->GLS-COMPANY
Mlcalmap MLCALMAP Required
MLE-LEDGER->MCM-LEDGER
MLE-COMPANY->MCM-COMPANY
MLE-FISCAL-YEAR->MCM-FISCAL-YEAR


File created: Thu Jun 09 11:21:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.