|
|
LMTRANS FILE
UPDATED BY
AP30.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LMT-COMPANY Numeric 4
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
LMT-LEASE Alpha 19
Element: Lease
LMT-SEQ-NBR Numeric 4
Element: Seq Nbr An automatically assigned sequence
number.
LMT-PT-COMPANY Numeric 4
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
LMT-ACCT-UNIT Alpha 15
Element: Acct Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
LMT-ACCOUNT Numeric 6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
LMT-SUB-ACCOUNT Numeric 4
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
LMT-ACTIVITY Alpha 15
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
LMT-ACCT-CATEGORY Alpha 5
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
LMT-TRAN-AMT Signed 18.2
Element: Intl Amt
LMT-BASE-AMT Signed 18.2
Element: Intl Amt
LMT-TO-BASE-CURR Alpha 5
Element: To Base Curr
LMT-TO-BASE-ND Numeric 1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
LMT-TO-BASE-RATE Signed 14.7
Element: Curr Rate The currency rate.
LMT-GLT-OBJ-ID Numeric 12
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
LMT-TRAN-DATE Numeric 8 (yyyymmdd)
Element: Tran Date
LMT-STATUS Numeric 1
Element: Status This field displays the status of the
transaction.
0 = Unposted
9 = Posted
LMT-REFERENCE Alpha 10 (Lower Case)
Element: Reference The reference number associated with
the transaction.
LMT-ALLOC-CD Alpha 12
Element: Exp Alloc Code
LMT-TYPE Alpha 3
Element: Tran Type DFR = Deferred Rent
ACR = Accrued Rent
LMT-PROCESS Alpha 3
Element: Tran Process
LMT-REVERSE Alpha 1
Element: All Flag
LMT-PMT-VENDOR Alpha 9 (Right Justified)
Element: Vendor The vendor's identification code.
LMT-PMT-NBR Numeric 6
Element: Pmt Nbr
LMT-CANCEL-SEQ Numeric 4 AP30.4
Element: Seq Nbr An automatically assigned sequence
number.
LMT-CREATION-DATE Numeric 8 (yyyymmdd)
Element: Creation Date This is the date that this line was
added to the requisition.
LMT-CREATION-TIME Numeric 6 (hhmmss)
Element: Creation Time The creation time.
LMT-CREATOR-ID Alpha 10
Element: Operator This field is used to store the login
id of the person who entered the record.
LMTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LMTSET1 COMPANY
LEASE
SEQ-NBR
LMTSET2 COMPANY
LEASE
TYPE
PROCESS
STATUS
SEQ-NBR
LMTSET3 COMPANY
LEASE
SEQ-NBR*
LMTSET4 COMPANY AP30.4
STATUS
LEASE
PMT-NBR
SEQ-NBR
LMTSET5 COMPANY KeyChange, Subset
LEASE Where TYPE = "ACR"
PMT-NBR
PMT-VENDOR
CANCEL-SEQ
SEQ-NBR
LMTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Gltrans GLTRANS Required
LMT-GLT-OBJ-ID -> GLT-OBJ-ID (GLTSET7)
Lminvoice LMINVOICE Required
LMT-COMPANY -> INV-COMPANY
LMT-LEASE -> INV-LEASE
LMT-PMT-NBR -> INV-PMT-NBR
LMT-PMT-VENDOR -> INV-PMT-VENDOR
LMT-CANCEL-SEQ -> INV-CANCEL-SEQ
Lmlease LMLEASE Required
LMT-COMPANY -> LSE-COMPANY
LMT-LEASE -> LSE-LEASE
|
