General Ledger – Lawson GL tables and programs
General Ledger (GL) in Lawson S3 v10 MSP6 has 123 tables, 221 online screens and 141 batch programs.
Tables (123)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| ACDETAIL | ALD | Cost Allocation Detail | ALLOC-CODE, COMPANY, ACCT-UNIT | 5 |
| ACDETAILAU | ALU | CA Alloc Code Detail Audit | ALLOC-CODE, COMPANY, ACCT-UNIT, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| ACHEADER | ALH | Cost Allocation Header | ALLOC-CODE | 4 |
| ACHEADERAU | AHA | CA Alloc Code Definition Audit | ALLOC-CODE, ACTION, DATE, TIME, UNIQUE-I-D | 11 |
| CAALLOCGRP | CAG | Allocation Group | ALLOCATION-GRP | 5 |
| CAALOCGPAU | CGA | Allocation Group Audit | ALLOCATION-GRP, ACTION, DATE, TIME, UNIQUE-I-D | 11 |
| CACODEREL | CDR | Allocation Code Interface | RUN-GROUP, SEQ-NUMBER | 5 |
| CADETAIL | CAD | Allocation Detail | COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR | 44 |
| CADETAILAU | CIT | Allocation Detail Audit | COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR, ACTION, DATE, TIME, UNIQUE-I-D | 14 |
| CAHEADER | CAH | Allocation Header | COMPANY, ALLOC-NAME, ALLOC-TYPE | 46 |
| CAHEADERAU | CHA | Allocation Header Audit | COMPANY, ALLOC-NAME, ALLOC-TYPE, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| CATRANS | CAT | Allocation Transactions | COMPANY, ALLOC-NAME, ALLOC-TYPE, LINE-NBR, SEQ-NUMBER | 29 |
| CMPUTE | CMP | Compute Statements | COMPUTE-NAME | 16 |
| CMPUTEAU | CTA | RW Compute Statement Audit | COMPUTE-NAME, ACTION, DATE, TIME, UNIQUE-I-D | 11 |
| CUAMOUNT | CAM | Currency Amount | FISCAL-YEAR, COMPANY, AMT-TYPE, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, CURRENCY-CODE | 127 |
| CUAMOUNTX | CAX | Currency Amount-Daily | COMPANY, AMT-TYPE, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 20 |
| CUCONTROL | CLC | Currency Control | COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODE | 13 |
| FBADJCODAU | FJA | Budget Adjustment Code Audit | ADJ-CODE, ACTION, DATE, TIME, UNIQUE-I-D | 11 |
| FBADJCODE | FJC | No description in the Lawson data dictionary | ADJ-CODE | 3 |
| FBBATRANS | FBT | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-D | 12 |
| FBBGTRLBOD | YBP | No description in the Lawson data dictionary | RUN-GROUP, SEQ-NUMBER | 8 |
| FBCNTRLAU | FCA | Budget Journal Control Audit | COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, ACTION, DATE, TIME, UNIQUE-I-D | 15 |
| FBCONTROL | FLC | Budget Journal Control | COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP | 26 |
| FBDETAIL | FBD | Budget Detail | COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 116 |
| FBDETAILAU | FDA | Budget Detail Audit | COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, ACTION, DATE, TIME, UNIQUE-I-D | 16 |
| FBDTLBOD | YBQ | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 12 |
| FBDTLHIST | FDH | Budget Detail History | COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, VERSION | 23 |
| FBFNDHDRAU | FFA | Budget Edit Group Audit | COMPANY, FUND-GROUP, ACTION, DATE, TIME, UNIQUE-I-D | 12 |
| FBFUNDAMT | FBB | Budget Fund Balance | COMPANY, FUND-GROUP, FISCAL-YEAR | 9 |
| FBFUNDDTL | FUD | Budget Fund Detail | COMPANY, FUND-GROUP, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 5 |
| FBFUNDHDR | FUH | Budget Fund Header | COMPANY, FUND-GROUP | 10 |
| FBFUNDREL | FFR | Budget Fund Interface | RUN-GROUP, SEQ-NUMBER | 12 |
| FBHEADER | FBH | Budget Header | COMPANY, FISCAL-YEAR, BUDGET-NBR | 20 |
| FBHEADERAU | FHA | Budget Header Audit | COMPANY, FISCAL-YEAR, BUDGET-NBR, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| FBHISTHDR | FHH | Budget History Header | COMPANY, FISCAL-YEAR, BUDGET-NBR, VERSION | 7 |
| FBHSTHDRAU | FHU | Budget Version Audit | COMPANY, FISCAL-YEAR, BUDGET-NBR, VERSION, ACTION, DATE, TIME, UNIQUE-I-D | 14 |
| FBINTBU | FBI | Interbudget Relationship | COMPANY, BUDGET-A, BUDGET-B | 15 |
| FBINTBUAU | FIA | Budget Interbudget Rel Audit | COMPANY, BUDGET-A, BUDGET-B, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| FBSPREAD | FBS | Budgeting Spread Code | COMPANY, FISCAL-YEAR, SPREAD-CODE | 32 |
| FBSPREADAU | FSA | Budget Spread Code Audit | COMPANY, FISCAL-YEAR, SPREAD-CODE, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| FBTRANS | FLT | Budget Transactions | OBJ-ID | 28 |
| FBTRANSAU | FTA | Budget Transactions Audit | COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, LINE-NBR, ACTION, DATE, TIME, UNIQUE-I-D | 16 |
| FBUDGETREL | FBR | Budgeting Relationships | RUN-GROUP, SEQ-NUMBER | 18 |
| FBYETR | FBY | No description in the Lawson data dictionary | FLT-OBJ-ID, GOX-OBJ-ID | 21 |
| GLAMOUNTS | GAM | General Ledger Amounts | COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 78 |
| GLAMOUNTSX | GAX | General Ledger Amounts Daily | COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 14 |
| GLAMTSBOD | YBS | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 11 |
| GLAUDIT | GLA | General Ledger Audit | COMPANY, ACCT-UNIT, PROCESS-DATE, PROCESS-TIME | 13 |
| GLAUTMPCNV | GTC | GL AU Template Interface | RUN-GROUP, COMPANY, TEMPLATE-NAME, ACCT-UNIT, VAR-LEVEL-DISP | 26 |
| GLAUTMPDTL | GAU | GL AU Template Detail | TEMPLATE-NAME, ACCT-UNIT | 13 |
| GLAUTMPHDR | GAH | GL AU Template Header | TEMPLATE-NAME | 3 |
| GLAUTMPMST | GTM | GL Post AU Template | TEMPLATE-NAME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 18 |
| GLAUTMPMXV | GXV | GL AU Attribute Template | TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT | 4 |
| GLAUTMPVLD | GAV | GL AU Attribute Value Template | TEMPLATE-NAME, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM | 5 |
| GLAUTMXVAU | GXA | GL AU Attribute Template Audit | TEMPLATE-NAME, ACCT-UNIT, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| GLBETRANS | GLB | No description in the Lawson data dictionary | TRANS-GROUP, SEQUENCE | 15 |
| GLCBOD | YCM | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE | 13 |
| GLCHARTBOD | YBT | No description in the Lawson data dictionary | CHART-NAME | 7 |
| GLCHDTLBOD | YCJ | No description in the Lawson data dictionary | CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNT | 10 |
| GLCHMAP | GMP | GL Intercompany Chart Map | FROM-COMPANY, TO-COMPANY | 3 |
| GLCHMAPDTL | GMD | GL Interco Chart Map Detail | FROM-COMPANY, TO-COMPANY, FR-ACCT-UNIT, FR-ACCOUNT, FR-SUB-ACCT | 8 |
| GLCHMPDTL | GHD | GL Intraco Chart Map Detail | CO-CHART, STAT-CHART, FR-ACCOUNT, FR-SUB-ACCT | 6 |
| GLCHMPHDR | GHH | GL Intracompany Chart Map | CO-CHART, STAT-CHART | 2 |
| GLCHSUMBOD | YBV | No description in the Lawson data dictionary | CHART-NAME, CHART-SECTION, SEQ-NUMBER | 9 |
| GLCLSAUDIT | GCA | GL Closing Audit | COMPANY, FISCAL-YEAR, ACCT-PERIOD, CLOSE-SEQ | 7 |
| GLCNTRLAU | GCU | Journal Control Audit | COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, ACTION, DATE, TIME, UNIQUE-I-D | 17 |
| GLCOMCNTRL | GCL | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP | 15 |
| GLCOMMIT | GOT | GL Commitments | COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, SYSTEM | 15 |
| GLCOMMITX | GOX | GL commitment Detail | COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, FISCAL-YEAR, PERIOD, SYSTEM, CURRENCY-CODE, GLT-OBJ-ID | 28 |
| GLCOMTRANS | GCT | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, LINE-NBR | 17 |
| GLCONDRILL | GLD | GL Drill Around | GLT-OBJ-ID | 6 |
| GLCONSOL | GCN | General Ledger Consolidation | FISCAL-YEAR, LEVEL-DEPTH, BUDGET-NBR, TRANS-TYPE, COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, CURRENCY-CODE | 80 |
| GLCONTROL | GLC | General Ledger Control | COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE | 70 |
| GLDICT | GLE | No description in the Lawson data dictionary | DB-FILE, FLD-NBR | 4 |
| GLHISCOMBL | GHB | No description in the Lawson data dictionary | COMPANY, YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM, ACTIVITY, ACCT-CATEGORY | 12 |
| GLHISCOMX | GHX | No description in the Lawson data dictionary | PARENT-DOC-ID, PAR-DOC-ID-DTL, UNIQUE-I-D | 46 |
| GLHISTCOM | GHT | No description in the Lawson data dictionary | COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, YEAR, SYSTEM, UNIQUE-I-D | 15 |
| GLMASTREL | GMR | GL Balance Conversion | COMPANY, FISCAL-YEAR, OLD-COMPANY, OLD-ACCT-NBR, TRAN-CURR | 22 |
| GLMSTBOD | YBW | No description in the Lawson data dictionary | COMPANY, ACCOUNT, SUB-ACCOUNT, VAR-LEVELS, ACCT-UNIT | 11 |
| GLNAMESBOD | YBX | No description in the Lawson data dictionary | COMPANY, ACCT-UNIT | 8 |
| GLPERIODMP | GPD | General Ledger Period Map | FROM-COMPANY, TO-COMPANY, FR-FISCAL-YEAR, FR-PERIOD | 7 |
| GLRPTDEF | GLR | General Ledger Report Setup | COMPANY, REPORT-NAME | 15 |
| GLRPTSEL | GRS | GL Report Selection | COMPANY, REPORT-NAME, OR-GROUP, ITEM-NUMBER, SEQUENCE-NBR | 8 |
| GLSEGBLOCK | GSB | General Ledger Segment Block | GLT-OBJ-ID | 2 |
| GLSUBACDTL | GSD | GL Subaccount Detail | SUB-ACCOUNT, SUB-ACCT-TMPLT | 23 |
| GLSUBACHDR | GSA | GL Subaccount Header | SUB-ACCT-TMPLT | 2 |
| GLSYSBOD | YBY | No description in the Lawson data dictionary | COMPANY | 7 |
| GLTRANS | GLT | General Ledger Transactions | COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR | 62 |
| GLTRANSBOD | YBZ | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR | 14 |
| GLTRANSFY | GFY | No description in the Lawson data dictionary | COMPANY, FISCAL-YEAR, ACCT-PERIOD, CONTROL-GROUP, SYSTEM, JE-TYPE, JE-SEQUENCE, LINE-NBR | 56 |
| GLTRANSREL | GTR | GL Transaction Conversion | RUN-GROUP, SEQ-NUMBER | 40 |
| GLTRNRLBOD | YCA | No description in the Lawson data dictionary | RUN-GROUP, SEQ-NUMBER | 8 |
| GLTWHDR | GWH | GL Transaction Writer Header | TW-NAME | 30 |
| GLTWLAYOUT | GWL | GL Transaction Writer Layout | TW-NAME, LINE, COLM-NBR | 14 |
| GLTWSEL | GWS | GL Transaction Writer Select | TW-NAME, OR-GROUP, MATRIX-CAT, SEQ-NUMBER | 6 |
| GLUNITS | GLU | General Ledger Units | COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 75 |
| GLUNITSX | GUX | General Ledger Units-Daily | COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 12 |
| GLZONE | GLZ | General Ledger Zone | COMPANY, ZONE | 4 |
| JBKSEQNBR | JSQ | Journal Book Sequence Number | COMPANY, JRNL-BOOK-NBR, FISCAL-YEAR | 5 |
| RADEFINAU | RAA | Ratio Definitions Audit | RATIO-NAME, ACTION, DATE, TIME, UNIQUE-I-D | 11 |
| RADEFINE | RAD | Ratio Definitions | RATIO-NAME | 8 |
| RATOTALAU | RTA | Ratio Totals Audit | TOTAL-NAME, FISCAL-YEAR, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| RATOTALS | RAT | Ratio Totals | FISCAL-YEAR, TOTAL-NAME, ACCT-UNIT | 80 |
| RJCNTRLAU | RCU | Recurring Journal Ctrl Audit | COMPANY, JE-TYPE, REC-GROUP, ACTION, DATE, TIME, UNIQUE-I-D | 14 |
| RJCONTROL | RJC | Recurring Journal Control | COMPANY, JE-TYPE, REC-GROUP | 47 |
| RJENCUMB | RJE | Recurring Journal Encumbrance | GLT-OBJ-ID | 11 |
| RJTRANS | RJT | Recurring Journal Transactions | COMPANY, REC-GROUP, JE-TYPE, LINE-NBR | 23 |
| RWDICT | RWD | Report Writer Dictionary | DICT-NAME | 12 |
| RWDRILL | RDD | Report Writer Drill Down | REQUEST-NAME, LINE-NBR, COL-POSITION | 30 |
| RWFORMAT | RWF | Report Writer Format | FORMAT, RECORD-TYPE, LINE-NBR | 55 |
| RWFORMATAU | RFA | Report Writer Format Audit | FORMAT, RECORD-TYPE, LINE-NBR, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| RWGRPDET | RGD | Report Writer Group Detail | RECORD-TYPE, HEAD-NAME, RANGE-NUMBER | 11 |
| RWGRPDETAU | RGA | Report Writer Group Detail Adt | HEAD-NAME, RECORD-TYPE, RANGE-NUMBER, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| RWHEADAU | HEA | Report Writer Header Audit | HEAD-TYPE, HEAD-NAME, RECORD-TYPE, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| RWHEADER | RWH | Report Writer Header | HEAD-TYPE, HEAD-NAME, RECORD-TYPE | 9 |
| RWREQSTAU | RRA | Report Writer Request Audit | REQUEST-NAME, ACTION, DATE, TIME, UNIQUE-I-D | 11 |
| RWREQUEST | RWR | Report Writer Request | REQUEST-NAME | 61 |
| RWROWDET | RRD | RW Row File Detail | RECORD-TYPE, HEAD-NAME, LINE-NBR | 41 |
| RWROWDTAU | RDA | Report Writer Row Detail Audit | HEAD-NAME, RECORD-TYPE, LINE-NBR, ACTION, DATE, TIME, UNIQUE-I-D | 13 |
| RWSTYLE | RWS | RW Style | STYLESHEET | 42 |
| RWUSER | RWU | Report Writer User | USER-CLASS, USERNAME | 5 |
| RWUSERAU | RUA | Report Writer User Audit | USER-CLASS, USERNAME, ACTION, DATE, TIME, UNIQUE-I-D | 12 |
| ULTOTALS | ULT | No description in the Lawson data dictionary | FISCAL-YEAR, MATRIX-LIST, TRANS-TYPE, BUDGET-NBR, FR-ACCOUNT, TH-ACCOUNT, FR-SUB-ACCT, TH-SUB-ACCT | 14 |
Online screens (221)
| Screen | Description | Updates | References |
|---|---|---|---|
| CA00.1 | Allocation Group | 9 | 13 |
| CA00.2 | Allocation Groups | 9 | 13 |
| CA05.1 | Allocation Code | 10 | 11 |
| CA05.2 | Define Allocation Code | 9 | 6 |
| CA10.1 | Allocation | 12 | 26 |
| CA10.2 | Define Allocation | 12 | 22 |
| CA10.4 | Line Copy | 13 | 22 |
| CA10.5 | Allocation Calculation | 3 | 22 |
| CA10.6 | Allocation Copy | 10 | 16 |
| CA10.7 | Allocation Detail | 12 | 26 |
| CA10.9 | Allocation Driver | 0 | 1 |
| CA15.1 | Allocation Control | 9 | 12 |
| CA15.2 | Allocation Group Control | 9 | 12 |
| CA60.1 | Allocation Code Interface Maintenance | 2 | 6 |
| CA91.1 | Cost Allocation Definition Audit | 0 | 2 |
| CA91.2 | Cost Allocation Detail Audit | 0 | 2 |
| CA91.3 | CA Allocation Code Definition Audit | 0 | 2 |
| CA91.4 | CA Allocation Code Detail Audit | 0 | 2 |
| CA91.5 | CA Allocation Group Audit | 0 | 2 |
| FB01.1 | Budget User Class | 10 | 9 |
| FB01.2 | Define User Class | 11 | 9 |
| FB10.1 | Spread Code | 11 | 13 |
| FB11.1 | Budget Edit Group | 18 | 38 |
| FB11.2 | Budget Edit Group List | 1 | 6 |
| FB20.1 | Period Budget, Rate | 16 | 34 |
| FB20.2 | Define Budget | 13 | 14 |
| FB20.3 | By Account | 14 | 21 |
| FB20.4 | By Accounting Unit | 14 | 21 |
| FB20.6 | Period Budget, Amounts | 16 | 34 |
| FB20.7 | Period Budget, Units | 16 | 34 |
| FB21.1 | Budget by Period | 16 | 32 |
| FB25.1 | Budget Control | 1 | 5 |
| FB30.1 | Computed By Accounting Unit | 13 | 18 |
| FB31.1 | Computed By Account | 13 | 19 |
| FB35.1 | Interbudget Relationships | 12 | 13 |
| FB40.1 | Budget Journal Entry | 17 | 24 |
| FB40.2 | Define Budget Journal | 18 | 23 |
| FB40.3 | Budget Speed Entry | 17 | 24 |
| FB40.4 | Budget Journal Copy | 13 | 11 |
| FB40.5 | Budget Journal Entry Totals | 0 | 2 |
| FB42.1 | Budget Adjustment Code | 10 | 9 |
| FB45.1 | Budget Journal Control | 29 | 58 |
| FB60.1 | Budget Edit Group Interface Maintenance | 6 | 32 |
| FB65.1 | Budget Interface Maintenance | 2 | 8 |
| FB91.1 | Budget Header Audit | 0 | 2 |
| FB91.2 | Budget Detail Audit | 0 | 2 |
| FB91.3 | Budget Adjustment Code Audit | 0 | 2 |
| FB91.4 | Budget Journal Control Audit | 0 | 2 |
| FB91.5 | Budget Transactions Audit | 0 | 2 |
| FB91.6 | Budget Edit Group Audit | 0 | 2 |
| FB91.7 | Budget Version Audit | 0 | 2 |
| FB91.8 | Budget Interbudget Relationships Audit | 0 | 2 |
| FB91.9 | Budget Spread Code Audit | 0 | 2 |
| FB95.1 | Budget Analysis | 5 | 33 |
| FB95.2 | Account, Period | 5 | 34 |
| FB95.3 | Account, Year to Date | 5 | 34 |
| FB95.4 | Accounting Unit, Period | 5 | 34 |
| FB95.5 | Accounting Unit, Year to Date | 5 | 34 |
| FB95.6 | Totals | 5 | 34 |
| GL04.1 | Reconciliation Code | 1 | 0 |
| GL04.2 | Reconciliation Codes | 1 | 0 |
| GL30.1 | Interzone Relationships | 3 | 6 |
| GL30.2 | Define Zone | 3 | 5 |
| GL34.1 | Intracompany Chart Map Maintenance | 2 | 2 |
| GL35.1 | Chart Map Maintenance | 2 | 1 |
| GL36.1 | Fiscal Year Mapping | 2 | 4 |
| GL40.1 | Journal Entry | 69 | 81 |
| GL40.2 | Define Journal | 70 | 82 |
| GL40.3 | Speed Entry | 68 | 79 |
| GL40.4 | Additional Information | 1 | 5 |
| GL40.5 | Filter | 1 | 6 |
| GL40.6 | Journal Copy | 22 | 18 |
| GL40.7 | Totals | 68 | 79 |
| GL40.8 | Journal Entry | 69 | 81 |
| GL41.1 | Journal Analysis | 1 | 7 |
| GL41.3 | Filter | 1 | 6 |
| GL41.4 | Workflow Journal Entry Update | 9 | 11 |
| GL43.1 | Daily Transaction Analysis | 1 | 9 |
| GL44.1 | Report Currency Entry | 69 | 81 |
| GL45.1 | Journal Control | 71 | 82 |
| GL50.1 | Ledger Report Setup | 2 | 5 |
| GL50.2 | Define Ledger Report | 3 | 4 |
| GL50.4 | Filters | 3 | 13 |
| GL50.5 | Copy | 3 | 4 |
| GL55.1 | Transaction Writer | 4 | 16 |
| GL55.2 | Copy | 3 | 2 |
| GL65.1 | Transaction Interface Maintenance | 3 | 31 |
| GL65.3 | Report Currency Entry | 1 | 4 |
| GL65.4 | Transaction Maintenance | 2 | 8 |
| GL67.1 | Balance Interface Maintenance | 2 | 6 |
| GL70.1 | Recurring Journal | 46 | 63 |
| GL70.2 | Define Recurring Journal | 46 | 63 |
| GL70.3 | Amounts Only | 46 | 63 |
| GL70.5 | Filter | 19 | 35 |
| GL70.6 | Recurring Copy | 45 | 61 |
| GL75.1 | Recurring Journal Control | 29 | 40 |
| GL76.1 | Manual Commitment Entry | 15 | 32 |
| GL76.2 | Manual Commitment Entry Copy | 3 | 4 |
| GL85.1 | Ratio Analysis | 0 | 1 |
| GL90.1 | Transaction Analysis | 1 | 12 |
| GL90.2 | Transaction Totals | 1 | 7 |
| GL90.3 | Filter | 1 | 7 |
| GL90.4 | Reconcile Transactions | 2 | 10 |
| GL90.5 | Nulls | 1 | 7 |
| GL90.6 | Compare Transaction Analysis | 5 | 35 |
| GL90.7 | Transaction Analysis | 1 | 7 |
| GL92.1 | Journal Control Audit | 0 | 3 |
| GL92.3 | Recurring Journal Control Audit | 0 | 2 |
| GL93.1 | Historical Commitment Analysis | 1 | 8 |
| GL93.2 | Historical Commitment Details | 0 | 5 |
| GL93.3 | Selection Criteria | 1 | 5 |
| GL93.4 | Accounts | 0 | 1 |
| GL94.1 | Commitment Analysis | 5 | 32 |
| GL94.2 | Account | 5 | 32 |
| GL94.3 | Account Totals | 5 | 32 |
| GL94.4 | Accounting Unit | 5 | 32 |
| GL94.5 | Accounting Unit Totals | 5 | 32 |
| GL94.6 | Commitment Account Detail | 5 | 32 |
| GL94.7 | Commitment Accounting Unit Detail | 5 | 32 |
| GL95.1 | Account Analysis | 5 | 32 |
| GL95.2 | Fiscal Year Summary | 5 | 32 |
| GL95.3 | Totals | 5 | 32 |
| GL95.4 | Chart Query | 15 | 41 |
| GL95.5 | Periods versus Year to Date | 5 | 32 |
| GL95.6 | Year to Date Current Year versus Last Year | 5 | 32 |
| GL95.7 | Periods Current Year versus Last Year | 5 | 32 |
| GL95.8 | Year to Date Actual versus Budget | 5 | 32 |
| GL95.9 | Periods Actual versus Budget | 5 | 32 |
| GL96.1 | Accounting Units | 5 | 32 |
| GL96.2 | Year to Date Current Year versus Last Year | 5 | 32 |
| GL96.3 | Periods Current Year versus Last Year | 5 | 32 |
| GL96.4 | Year to Date Actual versus Budget | 5 | 32 |
| GL96.5 | Periods Actual versus Budget | 5 | 32 |
| GL97.1 | Accounts | 5 | 32 |
| GL97.2 | Year to Date Current Year versus Last Year | 5 | 32 |
| GL97.3 | Periods Current Year versus Last Year | 5 | 32 |
| GL97.4 | Year to Date Actual versus Budget | 5 | 32 |
| GL97.5 | Periods Actual versus Budget | 5 | 32 |
| GL97.6 | Year to Date Account Currencies | 5 | 32 |
| GL97.7 | Periods Account Currencies | 5 | 32 |
| GL97.8 | Fiscal Year Summary | 5 | 32 |
| GL97.9 | Totals | 5 | 32 |
| GL98.1 | Companies | 5 | 32 |
| GL98.2 | Year to Date Current Year versus Last Year | 5 | 32 |
| GL98.3 | Periods Current Year versus Last Year | 5 | 32 |
| GL98.4 | Year to Date Actual versus Budget | 5 | 32 |
| GL98.5 | Periods Actual versus Budget | 5 | 32 |
| GL99.1 | Organization Query | 15 | 41 |
| GL99.2 | Periods versus Year to Date | 5 | 32 |
| GL99.3 | Year to Date Current Year versus Last Year | 5 | 32 |
| GL99.4 | Periods Current Year versus Last Year | 5 | 32 |
| GL99.5 | Year to Date Actual versus Budget | 5 | 32 |
| GL99.6 | Periods Actual versus Budget | 5 | 32 |
| GLBO.1 | GL BOD Maintenance | 5 | 0 |
| GLBO.2 | GL BOD Inquiry | 0 | 10 |
| GLCC.1 | Print interface for Glp65pd | 0 | 4 |
| GLDT.1 | Calculate posting date from year period | 1 | 2 |
| GLSR.1 | Company Accounting Unit Security Report | 0 | 3 |
| GLSV.1 | Set View | 0 | 5 |
| RW00.1 | Report Writer | 12 | 25 |
| RW00.2 | Level Range | 0 | 2 |
| RW00.4 | Level Override | 0 | 1 |
| RW00.6 | Report Copy | 10 | 10 |
| RW01.1 | Folder | 1 | 6 |
| RW01.2 | Folders | 1 | 6 |
| RW02.1 | Process Group | 1 | 1 |
| RW02.2 | Process Groups | 1 | 1 |
| RW03.1 | User Class | 10 | 9 |
| RW03.2 | Define User Class | 11 | 9 |
| RW04.1 | Stylesheet | 1 | 2 |
| RW04.2 | Stylesheet Copy | 1 | 2 |
| RW10.2 | Account Rows | 12 | 18 |
| RW10.3 | Level Rows | 12 | 18 |
| RW10.4 | Both Rows | 12 | 18 |
| RW10.6 | Additional Information | 1 | 11 |
| RW10.7 | Additional Information | 1 | 11 |
| RW10.8 | Row Copy | 11 | 9 |
| RW11.1 | Define Accounts Row | 11 | 9 |
| RW11.2 | Define Levels Row | 11 | 9 |
| RW11.3 | Define Both Type Row | 11 | 9 |
| RW11.4 | Line Copy | 11 | 9 |
| RW20.1 | Format | 10 | 16 |
| RW20.2 | Define Format | 10 | 16 |
| RW20.5 | Level Override | 1 | 11 |
| RW20.6 | Account Override | 1 | 11 |
| RW20.8 | Format Copy | 10 | 10 |
| RW30.1 | Ratio Definition | 12 | 20 |
| RW40.1 | Level Group | 11 | 10 |
| RW40.2 | Level Preview | 0 | 4 |
| RW40.3 | Account Group | 11 | 9 |
| RW40.4 | Subaccount Group | 11 | 9 |
| RW40.5 | Group Copy | 11 | 9 |
| RW40.6 | Define Level Group | 11 | 9 |
| RW40.7 | Define Account Group | 11 | 9 |
| RW40.8 | Define Subaccount Group | 11 | 9 |
| RW50.1 | Compute Statement | 10 | 13 |
| RW60.1 | Total Range | 12 | 18 |
| RW60.2 | Define Total Range | 11 | 9 |
| RW60.3 | Total Range Copy | 11 | 9 |
| RW60.4 | Level Range | 1 | 11 |
| RW70.1 | Total Names | 12 | 28 |
| RW70.2 | Total Value | 0 | 1 |
| RW80.1 | Drill Around | 2 | 28 |
| RW91.1 | RW Report Definition Audit | 0 | 2 |
| RW91.2 | RW Header Audit | 0 | 2 |
| RW91.3 | RW Row Detail Audit | 0 | 2 |
| RW91.4 | RW Format Audit | 0 | 2 |
| RW91.5 | Ratio Analysis Audit | 0 | 2 |
| RW91.6 | Compute Audit | 0 | 2 |
| RW91.7 | Total Names Audit | 0 | 2 |
| RW91.8 | RW Group Detail Audit | 0 | 2 |
| RW91.9 | RW User Class Audit | 0 | 3 |
| RW92.1 | Detail Account Audit | 0 | 1 |
| RW92.2 | Company Audit | 0 | 1 |
| RW92.3 | Accounting Unit Audit | 0 | 1 |
| RW92.4 | Filter for Detail Account Audit | 0 | 1 |
| RW92.5 | Filter for Company Audit | 0 | 1 |
| RW92.6 | Filter for Account Unit Audit | 0 | 1 |
| RW92.7 | glaudit inq | 0 | 1 |
| RW92.8 | glaudit inq | 0 | 1 |
| RW92.9 | Selection Criteria | 0 | 1 |
Batch programs (141)
| Program | Description | Updates | References |
|---|---|---|---|
| CA110 | Allocation Calculation | 20 | 39 |
| CA160 | Allocation Code Interface | 12 | 12 |
| CA190 | Allocation Interface | 13 | 13 |
| CA195 | Budget Allocation Interface | 18 | 19 |
| CA199 | Allocation Closing | 3 | 8 |
| CA200 | Allocation Group Listing | 1 | 5 |
| CA205 | Allocation Code Listing | 1 | 4 |
| CA210 | Allocation Edit Listing | 4 | 10 |
| CA215 | Allocation Control Listing | 2 | 10 |
| CA240 | Allocation Comparison | 2 | 10 |
| CA260 | Allocation Code Interface Listing | 1 | 1 |
| CA278 | CA Audit Analysis Report | 1 | 7 |
| CA290 | Allocation Ledger | 2 | 11 |
| CA305 | Allocation Audit Analysis Delete | 6 | 0 |
| FB100 | Budget Calculation - Computes | 17 | 33 |
| FB101 | Budget Calculation - Rates | 15 | 26 |
| FB111 | Budget Edit Group Build | 9 | 34 |
| FB120 | Intracompany Mass Budgeting | 15 | 21 |
| FB121 | Intercompany Mass Budgeting | 15 | 18 |
| FB122 | Budget Version | 17 | 18 |
| FB141 | Remote Budget Consolidation | 12 | 26 |
| FB145 | Budget Batch Journal Control | 19 | 27 |
| FB160 | Budget Edit Group Interface | 19 | 37 |
| FB165 | Budget Interface | 16 | 21 |
| FB190 | Budget Double Entry Posting | 18 | 27 |
| FB195 | Translation Calculation | 3 | 17 |
| FB201 | User Class Listing | 1 | 3 |
| FB210 | Spread Code Listing | 2 | 8 |
| FB211 | Budget Edit Group Listing | 9 | 34 |
| FB215 | Budget Annual Amount Report | 2 | 14 |
| FB220 | Budget Listing | 2 | 14 |
| FB225 | Budget Control Report | 2 | 8 |
| FB230 | Computed by Accounting Unit Listing | 2 | 11 |
| FB231 | Computed by Account Listing | 2 | 11 |
| FB235 | Interbudget Relationships | 2 | 10 |
| FB240 | Budget Journal Edit Listing | 2 | 11 |
| FB242 | Budget Adjustment Code Listing | 1 | 1 |
| FB260 | Budget Edit Group Interface Listing | 1 | 1 |
| FB265 | Budget Interface Listing | 2 | 8 |
| FB278 | Flex Budgeting Audit Analysis Report | 1 | 10 |
| FB295 | Budget Analysis Report | 2 | 11 |
| FB296 | Budget Audit | 5 | 34 |
| FB305 | Flex Budgeting Audit Analysis Purge | 10 | 0 |
| FB325 | Budget Actuals Rebuild | 12 | 19 |
| GL100 | Mass Chart Account Change Delete | 13 | 58 |
| GL110 | Company Copy Delete | 94 | 47 |
| GL111 | Backposting Control Mass Upd | 13 | 55 |
| GL120 | Level Reorganization | 50 | 53 |
| GL122 | Mass Account Change Delete | 18 | 78 |
| GL130 | Chart Map Creation | 3 | 3 |
| GL134 | Intracompany Chart Map Creation | 3 | 2 |
| GL135 | Intercompany Chart Map Posting | 15 | 59 |
| GL141 | Consolidation Unload | 2 | 13 |
| GL145 | Journal Entry Hold Release | 10 | 18 |
| GL146 | Batch Journal Control | 69 | 81 |
| GL147 | General Journal Report | 4 | 12 |
| GL148 | Zone Rebalancing | 29 | 59 |
| GL165 | Transaction Interface | 7 | 48 |
| GL167 | Balance Interface | 36 | 63 |
| GL170 | Recurring Journal Interface | 30 | 46 |
| GL179 | Recurring Journal Closing | 3 | 8 |
| GL190 | Journal Posting | 44 | 69 |
| GL191 | Currency Revaluation | 23 | 36 |
| GL192 | Commitment History Update | 3 | 9 |
| GL194 | Update IncomeStatement Beg Bal | 6 | 15 |
| GL195 | Translation Calculation | 15 | 61 |
| GL196 | Report Currency Translation | 25 | 62 |
| GL197 | Period, Year End GL Commitments Processing | 88 | 76 |
| GL199 | Period Closing | 63 | 65 |
| GL204 | Reconciliation Code Listing | 1 | 2 |
| GL215 | Chart Compare | 1 | 3 |
| GL230 | Interzone Relationship Listing | 2 | 12 |
| GL235 | AR Currency Rounding GL Report | 2 | 8 |
| GL238 | Split Distribution Report | 2 | 12 |
| GL240 | Journal Edit Listing | 2 | 18 |
| GL241 | Period Transaction Listing | 2 | 10 |
| GL243 | Daily Transaction Listing | 2 | 12 |
| GL245 | Journal Control Report | 2 | 9 |
| GL247 | Centralization Book Report | 1 | 6 |
| GL250 | Ledger Report Listing | 2 | 9 |
| GL255 | Transaction Writer Listing | 1 | 5 |
| GL256 | Transaction Writer Report | 3 | 29 |
| GL265 | Transaction Interface Listing | 2 | 9 |
| GL267 | Balance Interface Listing | 2 | 8 |
| GL270 | Recurring Journal Edit Listing | 2 | 17 |
| GL275 | Recurring Journal Control Report | 2 | 10 |
| GL276 | Manual Commitment Entry Report | 3 | 9 |
| GL279 | Jrnl Cntrl Audit Analysis Rpt | 1 | 5 |
| GL281 | French Trial Balance | 2 | 13 |
| GL284 | AP Grand Livre Report - Period | 1 | 11 |
| GL285 | AP Grand Livre Report - Date | 1 | 11 |
| GL286 | AR Grand Livre Report - Period | 1 | 11 |
| GL287 | AR Grand Livre Report - Date | 1 | 11 |
| GL288 | GL Grand Livre Report - Period | 1 | 12 |
| GL289 | GL Grand Livre Report - Date | 1 | 8 |
| GL290 | General Ledger Report | 3 | 15 |
| GL291 | Trial Balance | 2 | 17 |
| GL292 | Balance Sheet | 13 | 24 |
| GL293 | Income Statement | 13 | 25 |
| GL294 | Projection by Level | 12 | 25 |
| GL295 | Projection by Account | 2 | 13 |
| GL296 | Transaction Currency Report | 2 | 11 |
| GL297 | Posting Sequence Number Report | 1 | 7 |
| GL298 | GL Commitment Analysis Report | 5 | 33 |
| GL299 | GL and AC History commitment | 9 | 60 |
| GL300 | General Ledger History Delete | 37 | 21 |
| GL306 | Jrnl Cntrl Audit Analysis Dlt | 3 | 0 |
| GL310 | Report Currency Purge | 12 | 6 |
| GL320 | Consolidation File Creation | 4 | 12 |
| GL322 | GLHISCOMBL File Rebuild | 4 | 10 |
| GL325 | GLAMOUNTS, GLUNITS File Rebuild | 5 | 11 |
| GL326 | GLAMOUNTSX, GLUNITSX File Rebuild | 4 | 10 |
| GL327 | Report Currency Rebuild | 6 | 11 |
| GL328 | Daily Report Currency Rebuild | 3 | 10 |
| GL330 | Undistributed Retained Earnings Rebuild | 17 | 58 |
| GL340 | This program has been retired. | 1 | 0 |
| GL500 | Fiscal Year Change | 72 | 49 |
| GL565 | Treasury Management to GL Upload | 2 | 0 |
| GL750 | GL shell program for BOD files | 1 | 10 |
| GL788 | GLDICT Post Install Load Pgm | 2 | 0 |
| JB240 | Journal Book Report | 1 | 6 |
| RW100 | Report Generation | 6 | 33 |
| RW200 | Report Listing | 1 | 6 |
| RW201 | Folder Listing | 1 | 8 |
| RW202 | Process Group Listing | 1 | 2 |
| RW203 | User Class Listing | 1 | 3 |
| RW205 | Data Dictionary Listing | 1 | 2 |
| RW210 | Row Listing | 12 | 12 |
| RW215 | Row Chart Compare | 1 | 8 |
| RW220 | Format Listing | 1 | 6 |
| RW230 | Ratio Listing | 4 | 16 |
| RW240 | Group Listing | 1 | 5 |
| RW250 | Compute Listing | 1 | 3 |
| RW260 | Total Range Listing | 1 | 5 |
| RW270 | Total Name Listing | 3 | 15 |
| RW278 | RW Audit Analysis Report | 1 | 10 |
| RW298 | Usage Report | 1 | 13 |
| RW299 | Detail Report Listing | 1 | 14 |
| RW305 | RW Audit Analysis Delete | 10 | 0 |
| RW590 | Data Dictionary Load | 2 | 1 |
| RW591 | AC Subset Data Dictionary Load | 2 | 1 |
Other tables used by General Ledger programs (157)
ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACACTMXVAL, ACADDLCNTR, ACAMCODE, ACASNROLE, ACASSIGN, ACBILL, ACBILLX, ACBUDHDR, ACCAL, ACCALX, ACCATGRP, ACCATGRPX, ACCATMXVAL, ACCATSUM, ACCATSUMX, ACCNTRACT, ACCOMMIT, ACCOMMITX, ACCONSOL, ACCTRCATGX, ACGRPMXVAL, ACIFACTV, ACMXVAL, ACPRDPERF, ACROLE, ACSTATUS, ACTRANS, ADAMOUNTSX, ADAVGBAL, ADBALANCE, ADCFBAL, ADCOMPANY, ADCONSOL, ADDRDATA, ADMASTER, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU, AMSYSOPTAU, APCOMPANY, APVENMAST, ARAPPLIED, ARCOMP, ARDISTRIB, AROIHDR, AUMXVALDT, AUMXVALUAU, AUMXVALUE, AUMXVLDTAU, CUACCT, CUACCTAU, CUCODES, CUCODESAU, CUCONV, CUCONVAU, CURELAT, CURELATAU, CUSTDESC, CUTABLE, CUTABLEAU, CUTRANSL, CUTRNSLAU, FBFACTOR, GLACCMXVAL, GLACCTREL, GLACCTVLD, GLACMXVLAU, GLADDRESS, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCODES, GLCOMPREL, GLCPYGRP, GLESACCT, GLHOLDCODE, GLINTCO, GLJELOG, GLMASTER, GLMASTERAU, GLMONITOR, GLNAMES, GLNAMESAU, GLSCCAT, GLSRCCODE, GLSYSJE, GLSYSTEM, GLSYSTEMAU, GMAWARD, GMFNDACT, GTMXVALUAU, GTMXVALUE, IFDICT, INSTCTRYCD, JBKACCT, JBKOPCODE, JBKSYSCODE, JBOOKHDR, MACAPDTL, MLAMOUNTS, MLCALMAP, MLCOLEDGER, MLCUAMOUNT, MLCUCNTRL, MLGROUP, MLLEDGER, MLTRANS, MLUNITS, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTMPLDTL, MXTMPLEFDT, MXTMPLHDR, MXTMPLHEDT, MXTPEFDTAU, MXTPHEDTAU, MXVALIDATE, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, MXVIEWDTL, MXVIEWHDR, RJBRIDGE, RJMXVALUAU, RJMXVALUE, RJSCHEDULE, SLMXVALUE, SLRELATHDR, SLTRANDTL, SLTRANS, SLTRANSERR, STRUCTURE, SUBCKPOINT, SYSTEMCODE, TRCODES, ULPOST, WFSETUP