|
|
MLCOLEDGER FILE
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
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
API2.1 BR44.1 CA10.5 CA110 FB100 FB20.1
FB20.6 FB20.7 FB21.1 GL110 GL120 GL165
GL310 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.2 MA61.1 MAI1.1 RQ10.1
RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500 RQIB.1
RQIF.1 RQIJ.1 SLVW.1 FB11.1 FB111 FB160
FB211 FB296 FB60.1 FB95.1 FB95.2 FB95.3
FB95.4 FB95.5 FB95.6 GL298 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLE-COMPANY Numeric 4
Element: Company 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 Alpha 30 (Lower Case)
Element: Name This is the company name.
MLE-LEDGER Alpha 15
Element: Ledger 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 Numeric 2 GL500
Element: Acct Period This is the current accounting period
for the ledger/company combination. It
is updated by the Ledger Period Closing
(ML199).
MLE-FISCAL-YEAR Numeric 4 GL500
Element: Year This is the current fiscal year for the
ledger/company combination.
MLE-UPDATING Numeric 2
Element: Updating 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 Numeric 4
Element: Year This field contains the last closed
fiscal year.
MLE-ACTIVE-STATUS Alpha 1
Element: Active Status This field contains the status of the
ledger. A ledger must be Active for
transactions to be posted to it.
MLE-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
MLE-CURR-CODE-1 Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
MLE-CURR-CODE-2 Alpha 5
Element: Currency Code 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 AC121 AC123
LEDGER 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 AC121 AC123
COMPANY AC130 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC32.1 AC37.1
AC490 ACVW.1
ATVW.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
...
MLCOLEDGER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
