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
ACVW.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 API2.1
CA10.5 CA110 FB100 FB20.1 FB20.6 FB20.7
FB21.1 GL165 GL65.1 RW100 RW230 RW30.1
RW80.1 GLAV.1 GLCV.1 GLVW.1 IFAC.1 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MAI1.1 SLVW.1 FB11.1 FB111
FB160 FB211 FB296 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL298 GL299
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
RW270 RW70.1 SNOA.1 SNRA.1 SNSA.1


UPDATED BY
GL500 GL110 GL120 GL310

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.
MLE-NAME
Element: Name		Alpha 30 (Lower Case)
This is the company name.
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.
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
MLE-FISCAL-YEAR
Element: Year		Numeric 4
This is the current fiscal year for the ledger/company combination.
GL500
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.
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.
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
...
ACVW.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 API2.1
CA10.5 CA110
FB100 FB20.1
FB20.6 FB20.7
FB21.1 GL110
GL120 GL165
GL310 GL500
MLESET2 LEDGER
COMPANY
...
ACVW.1 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 FB95.3
FB95.4 FB95.5
FB95.6 GL298
GL299 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6


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: Wed Jun 08 20:50:15 2016

Home
Contact Us



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