LMTRANS

UPDATED BY
AP30.4

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LMT-COMPANY
Element: Company
Numeric 4
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
Element: Lease
Alpha 19
LMT-SEQ-NBR
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
LMT-PT-COMPANY
Element: Company
Numeric 4
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
Element: Acct Unit
Alpha 15
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
Element: Account
Numeric 6
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
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
LMT-ACTIVITY
Element: Activity
Alpha 15
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
Element: Acct Category
Alpha 5
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
Element: Intl Amt
Signed 18.2
LMT-BASE-AMT
Element: Intl Amt
Signed 18.2
LMT-TO-BASE-CURR
Element: To Base Curr
Alpha 5
LMT-TO-BASE-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
LMT-TO-BASE-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
LMT-GLT-OBJ-ID
Element: Obj Id
Numeric 12
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
Element: Tran Date
Numeric 8 (yyyymmdd)
LMT-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
0 = Unposted
9 = Posted
LMT-REFERENCE
Element: Reference
Alpha 10 (Lower Case)
The reference number associated with the transaction.
LMT-ALLOC-CD
Element: Exp Alloc Code
Alpha 12
LMT-TYPE
Element: Tran Type
Alpha 3

DFR = Deferred Rent
ACR = Accrued Rent
LMT-PROCESS
Element: Tran Process
Alpha 3
LMT-REVERSE
Element: All Flag
Alpha 1
LMT-PMT-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
LMT-PMT-NBR
Element: Pmt Nbr
Numeric 6
LMT-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP30.4
LMT-CREATION-DATE
Element: Creation Date
Numeric 8 (yyyymmdd)
This is the date that this line was added to the requisition.
LMT-CREATION-TIME
Element: Creation Time
Numeric 6 (hhmmss)
The creation time.
LMT-CREATOR-ID
Element: Operator
Alpha 10
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
STATUS
LEASE
PMT-NBR
SEQ-NBR
AP30.4
LMTSET5 COMPANY
LEASE
PMT-NBR
PMT-VENDOR
CANCEL-SEQ
SEQ-NBR
KeyChange, Subset
WhereTYPE ="ACR"


LMTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:19:33 2016

Home
Contact Us



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