|
|
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: Sequence NumbeAn automatically assigned sequence
number.
LMT-PT-COMPANY Numeric 4
Element: Company Type or select the company number you
are allocating to. If you leave this
field blank, the post-from company
defaults.
If you select a post-to company and
accounting unit, leave the Allocation
Code field blank.
LMT-ACCT-UNIT Alpha 15
Element: Accounting UniThe 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: Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
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: Account CategoAccount 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 This is the amount of the transaction in
the company base amount.
LMT-TO-BASE-CURR Alpha 5
To Company Base
Currency
LMT-TO-BASE-ND Numeric 1
Account Currency
Code
LMT-TO-BASE-RATE Signed 14.7
Element: Currency Rate
LMT-GLT-OBJ-ID Numeric 12
Object This is a subsystem GL interface
Identification identification number. It is used for
Drill Around purposes.
LMT-TRAN-DATE Numeric 8 (yyyymmdd)
Element: Transaction 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 This identifies whether this record is
created because of a picking
transaction, or because of a return.
Valid values are:
"IS" = Picking transaction.
"RR" = Return.
~$1 VENDOR
The vendor's identification code.
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 ID
LMT-PMT-NBR Numeric 3
Element: Pmt Nbr
LMT-CANCEL-SEQ Numeric 4 AP30.4
Element: Sequence NumbeThe sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
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 Code
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
|
