ULPOST – This file is used to store the last posting date and time.
- System
- General Ledger Setup (IF)
- Prefix
ULP- Primary key
COMPANY- Fields
- 3
- Updated by
- 12 programs
- Referenced by
- 128 programs
ULPOST is the This file is used to store the last posting date and time. table in Lawson General Ledger Setup (prefix ULP). It is indexed by COMPANY (ULPSET1). It is updated by FB145, GL120, GL167, GL190, GL199, GL320, GL322, GL325 and 4 more and referenced by AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 and 120 more. The table has 3 fields, 1 index and 0 documented relations.
About ULPOST
This file is used to store the last posting date and time.
Fields (3)
Column = COBOL field name without the ULP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ULP-COMPANY PKCOMPANY | Numeric 4 | The company number for the value you are posting. | — |
#ULP-CALC-DATECALC_DATE | Numeric 8 (yyyymmdd) | The date amounts were last calculated. | FB145, GL120, GL167, GL190, GL199, GL320, GL322, GL325 +4 more |
#ULP-CALC-TIMECALC_TIME | Numeric 6 (hhmmss) | — | FB145, GL120, GL167, GL190, GL199, GL320, GL322, GL325 +4 more |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ULPSET1 |
| Primary | AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source) |
Programs
Updated by (12)
- FB145 Budget Batch Journal Control
- GL120 Level Reorganization
- GL167 Balance Interface
- GL190 Journal Posting
- GL199 Period Closing
- GL320 Consolidation File Creation
- GL322 GLHISCOMBL File Rebuild
- GL325 GLAMOUNTS, GLUNITS File Rebuild
- GL327 Report Currency Rebuild
- GL330 Undistributed Retained Earnings Rebuild
- GL45.1 Journal Control
- GL500 Fiscal Year Change
Referenced by (128)
- AC121 Budget Calculation
- AC123 Budget Copy
- AC130 Allocation Calculation
- AC20.1 Life Only Budget
- AC20.2 Annual Budget
- AC20.3 Period Budget
- AC20.4 Activity Budgets by Activity
- AC20.5 Activity Budgets by Account Category
- AC32.1 Allocation Pool
- AC37.1 Allocation Group
- AC490 Activity Reconciliation
- ACVW.1 Build GL Accounting Unit View
- AD191 Cost of Funds
- AM180 Depreciation Calculation and Listing
- ATVW.1 Build Account Category View
- CA10.5 Allocation Calculation
- CA110 Allocation Calculation
- FB100 Budget Calculation - Computes
- FB11.1 Budget Edit Group
- FB111 Budget Edit Group Build
- FB160 Budget Edit Group Interface
- FB20.1 Period Budget, Rate
- FB20.6 Period Budget, Amounts
- FB20.7 Period Budget, Units
- FB21.1 Budget by Period
- FB211 Budget Edit Group Listing
- FB296 Budget Audit
- FB60.1 Budget Edit Group Interface Maintenance
- FB95.1 Budget Analysis
- FB95.2 Account, Period
- FB95.3 Account, Year to Date
- FB95.4 Accounting Unit, Period
- FB95.5 Accounting Unit, Year to Date
- FB95.6 Totals
- GL298 GL Commitment Analysis Report
- GL299 GL and AC History commitment
- GL90.6 Compare Transaction Analysis
- GL94.1 Commitment Analysis
- GL94.2 Account
- GL94.3 Account Totals
- GL94.4 Accounting Unit
- GL94.5 Accounting Unit Totals
- GL94.6 Commitment Account Detail
- GL94.7 Commitment Accounting Unit Detail
- GL95.1 Account Analysis
- GL95.2 Fiscal Year Summary
- GL95.3 Totals
- GL95.4 Chart Query
- GL95.5 Periods versus Year to Date
- GL95.6 Year to Date Current Year versus Last Year
- GL95.7 Periods Current Year versus Last Year
- GL95.8 Year to Date Actual versus Budget
- GL95.9 Periods Actual versus Budget
- GL96.1 Accounting Units
- GL96.2 Year to Date Current Year versus Last Year
- GL96.3 Periods Current Year versus Last Year
- GL96.4 Year to Date Actual versus Budget
- GL96.5 Periods Actual versus Budget
- GL97.1 Accounts
- GL97.2 Year to Date Current Year versus Last Year
- GL97.3 Periods Current Year versus Last Year
- GL97.4 Year to Date Actual versus Budget
- GL97.5 Periods Actual versus Budget
- GL97.6 Year to Date Account Currencies
- GL97.7 Periods Account Currencies
- GL97.8 Fiscal Year Summary
- GL97.9 Totals
- GL98.1 Companies
- GL98.2 Year to Date Current Year versus Last Year
- GL98.3 Periods Current Year versus Last Year
- GL98.4 Year to Date Actual versus Budget
- GL98.5 Periods Actual versus Budget
- GL99.1 Organization Query
- GL99.2 Periods versus Year to Date
- GL99.3 Year to Date Current Year versus Last Year
- GL99.4 Periods Current Year versus Last Year
- GL99.5 Year to Date Actual versus Budget
- GL99.6 Periods Actual versus Budget
- GLAV.1 Build GL Accounting Unit View
- GLCV.1 General Ledger Chart View Build
- GLVW.1 Build GL Accounting Unit View
- ML94.1 Ytd Ml and Gl Actuals
- ML94.2 Period ML and GL Actuals
- ML94.3 YTD ML and GL Actuals
- ML94.4 Period ML and GL Actuals
- ML95.1 Ledger Account Analysis
- ML95.2 Fiscal Year Summary
- ML95.3 Totals
- ML95.4 Ledger Chart Query
- ML95.5 Periods vs. YTD
- ML95.6 YTD Current Year vs. Last Year
- ML95.7 Periods Current Year vs. Last Year
- ML95.8 YTD Actual vs. Budget
- ML95.9 Periods Actual vs. Budget
- ML96.1 Accounting Units
- ML96.2 YTD Current Year vs. Last Year
- ML96.3 Periods Current Year vs. Last Year
- ML96.4 YTD Actual vs. Budget
- ML96.5 Periods Actual vs. Budget
- ML97.1 Accounts
- ML97.2 YTD Current Year vs. Last Year
- ML97.3 Periods Current Year vs. Last Year
- ML97.4 YTD Actual vs. Budget
- ML97.5 Periods Actual vs. Budget
- ML97.6 YTD Account Currencies
- ML97.7 Periods Account Currencies
- ML97.8 Fiscal Year Summary
- ML97.9 Totals
- ML98.1 Companies
- ML98.2 YTD Current Year vs. Last Year
- ML98.3 Periods Current Year vs. Last Year
- ML98.4 YTD Actual vs. Budget
- ML98.5 Periods Actual vs. Budget
- ML99.1 Organization Query
- ML99.2 Periods vs. YTD
- ML99.3 YTD Current Year vs. Last Year
- ML99.4 Periods Current Year vs. Last Year
- ML99.5 YTD Actual vs. Budget
- ML99.6 Periods Actual vs. Budget
- RW100 Report Generation
- RW230 Ratio Listing
- RW270 Total Name Listing
- RW30.1 Ratio Definition
- RW70.1 Total Names
- SLVW.1 Build SL Accounting Unit View
- SNOA.1 RETRIEVE ACTUALS
- SNRA.1 RETRIEVE ACTUALS
- SNSA.1 RETRIEVE ACTUALS