LMDISTRIB – Invoice Distributitions
- System
- LM (LM)
- Prefix
DIS- Primary key
COMPANY,PMT-VENDOR,LEASE,PMT-NBR,CANCEL-SEQ,DIST-SEQ-NBR- Fields
- 45
- Updated by
- 1 program
- Referenced by
- 0 programs
LMDISTRIB is the Invoice Distributitions table in Lawson LM (prefix DIS). It is indexed by COMPANY, PMT-VENDOR, LEASE, PMT-NBR, CANCEL-SEQ, DIST-SEQ-NBR (DISSET1); alternate indexes: DISSET2. It is related 1:1 to ACACCTCAT, ACACTIVITY, APCOMPANY, LMINVOICE and GLSYSTEM and 1:M to LMDSTRIBAU and LMINTEREST. It is updated by AP30.4. The table has 45 fields, 2 indexes and 7 documented relations.
About LMDISTRIB
No description in the Lawson data dictionary.
Fields (45)
Column = COBOL field name without the DIS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
DIS-COMPANY PKCOMPANY | Numeric 4 | This field contains the Accounts Payable company associated with the invoice. | — |
DIS-LEASE PKLEASE | Alpha 19 | This field contains the lease number. | — |
DIS-PMT-VENDOR PKPMT_VENDOR | Alpha 9 (Right Justified) | This field contains the vendor who receives the payment. | — |
DIS-PMT-NBR PKPMT_NBR | Numeric 6 | This is the unique number assigned to the payment. Together with the lease number, it forms the invoice number. | — |
DIS-DIST-SEQ-NBR PKDIST_SEQ_NBR | Numeric 6 | This field contains a unique sequence number assigned to the distribution record. | — |
DIS-INVOICEINVOICE | Alpha 22 | This field contains the unique invoice number associated with the lease. It consists of the lease number with the payment number as a suffix. | — |
DIS-SUFFIXSUFFIX | Numeric 3 | This field contains the invoice suffix used to make a recurring invoice instance unique. | — |
DIS-CANCEL-SEQ PKCANCEL_SEQ | Numeric 4 | An automatically assigned sequence number. | AP30.4 |
DIS-EXEC-CODEEXEC_CODE | Alpha 6 | This represents the executory code associated with the payment. | — |
DIS-PT-COMPANYPT_COMPANY | Numeric 4 | This field contains the company where the debt (capital lease) or expense (operating lease) distribution is posted. | — |
DIS-ACCT-UNITACCT_UNIT | Alpha 15 | This field contains the accounting unit where the debt (capital lease) or expense (operating lease) distribution is posted. | — |
DIS-ACCOUNTACCOUNT | Numeric 6 | This field contains the account where the debt (capital lease) or expense (operating lease) distribution is posted. | — |
DIS-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | This field contains the subaccount where the debt (capital lease) or expense (operating lease) distribution is posted. | — |
DIS-ACTIVITYACTIVITY | Alpha 15 | This field contains the activity where the debt (capital lease) or expense (operating lease) distributions are tracked. | — |
DIS-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | This field contains the account category for the activity where debt (capital lease) or expense (operating lease) distributions are tracked. | — |
DIS-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | — |
DIS-SEGMENT-BLOCKSEGMENT_BLOCK | Alpha 103 | This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information. | — |
DIS-ORIG-TRAN-AMTORIG_TRAN_AMT | Signed 18.2 | This field contains the amount of the invoice distribution in the currency of the invoice (which is also the lease currency). | — |
DIS-PCT-TRAN-AMTPCT_TRAN_AMT | Signed 18.2 | — | — |
DIS-PRINCIPAL-AMTPRINCIPAL_AMT | Signed 18.2 | This is the principal portion of the payment in lease currency. | — |
DIS-INTEREST-AMTINTEREST_AMT | Signed 18.2 | This is the interest portion of the payment in lease currency. | — |
DIS-ORIG-BASE-AMTORIG_BASE_AMT | Signed 18.2 | This the total payment amount in company base currency. | — |
DIS-PCT-BASE-AMTPCT_BASE_AMT | Signed 18.2 | — | — |
DIS-BASE-PRINC-AMTBASE_PRINC_AMT | Signed 18.2 | This is the principal payment amount in company base currency. | — |
DIS-BASE-INT-AMTBASE_INT_AMT | Signed 18.2 | This is the interest payment amount in company base currency. | — |
DIS-TO-BASE-CURRTO_BASE_CURR | Alpha 5 | This field contains the base currency of the debt company. | — |
DIS-TO-BASE-NDTO_BASE_ND | Numeric 1 | This field indicates the number of decimal positions defined for the debt company currency conversions. | — |
DIS-TO-BASE-RATETO_BASE_RATE | Signed 14.7 | This is the debt company currency exchange rate. | — |
DIS-TO-BASE-AMTTO_BASE_AMT | Signed 18.2 | This is the payment amount in debt company currency. | — |
DIS-GLT-PRN-OBJ-IDGLT_PRN_OBJ_ID | Numeric 12 | This is the object ID used to drill around hrough principal transactions.. | — |
DIS-INT-CALC-FLINT_CALC_FL | Alpha 1 | This flag indicates whether interest should be calculated. If the lease is a capital lease, the interest calculation flag is set to Yes. | — |
DIS-INT-CALC-DATEINT_CALC_DATE | Numeric 8 (yyyymmdd) | This field contains the date when interest was calculated. | — |
DIS-INT-CANCEL-FLINT_CANCEL_FL | Alpha 1 | This flag indicates whether the interest calculations have been canceled. Values are: If a lease payment invoice is canceled in AP and interest calculations have already been performed for the payment, the next time LM180 is run, the interest calculation is reversed and this flag is set to Yes.
| — |
DIS-STATUSSTATUS | Numeric 1 | This field indicates whether the lease is posted. Valid values are:
| — |
DIS-INV-FISCAL-YRINV_FISCAL_YR | Derived | This field contains the lease invoice fiscal year. | — |
DIS-INV-PERIODINV_PERIOD | Derived | This field contains the lease invoice period. | — |
DIS-ALLOC-CDALLOC_CD | Alpha 12 | — | — |
DIS-TAX-POINTTAX_POINT | Alpha 1 | — | — |
DIS-TAX-INDICATORTAX_INDICATOR | Numeric 1 | — | — |
DIS-TAX-USAGE-CDTAX_USAGE_CD | Alpha 10 | The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required. | — |
DIS-TAX-TYPETAX_TYPE | Alpha 1 | The type of tax. | — |
DIS-TAX-CODETAX_CODE | Alpha 10 | This field contains a code representing specific tax information. This must be valid Tax Code. | — |
DIS-TAX-RATETAX_RATE | Percent 7.5 (Percent) | Charge rate by month. | — |
DIS-TRAN-TAXABLETRAN_TAXABLE | Signed 18.2 | — | — |
DIS-TAX-LANDED-FLTAX_LANDED_FL | Alpha 1 | — | — |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
DISSET1 | COMPANY, PMT-VENDOR, LEASE, PMT-NBR, CANCEL-SEQ, DIST-SEQ-NBR | Primary | AP30.4 | |
DISSET2 | COMPANY, LEASE, PMT-VENDOR, PMT-NBR, PT-COMPANY, ACCT-UNIT, DIST-SEQ-NBR | KeyChange, Subset | Where CANCEL-SEQ = Zeroes | — |
Relations
One to one (5) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Not Required | DIS-ACCT-CATEGORY → AAX-ACCT-CATEGORY (AAXSET1) | |
| Acactivity | ACACTIVITY | Not Required | DIS-ACTIVITY → ACV-ACTIVITY | |
| Apcompany | APCOMPANY | Not Required | DIS-COMPANY → CPY-COMPANY | |
| Lminvoice | LMINVOICE | Not Required | DIS-COMPANY → INV-COMPANY, DIS-LEASE → INV-LEASE, DIS-PMT-NBR → INV-PMT-NBR, DIS-PMT-VENDOR → INV-PMT-VENDOR, DIS-CANCEL-SEQ → INV-CANCEL-SEQ | |
| Pt Company | GLSYSTEM | Not Required | DIS-PT-COMPANY → GLS-COMPANY |
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Lmdstribau | LMDSTRIBAU | DIS-COMPANY → LDU-COMPANY, DIS-PMT-VENDOR → LDU-PMT-VENDOR, DIS-LEASE → LDU-LEASE, DIS-PMT-NBR → LDU-PMT-NBR, DIS-CANCEL-SEQ → LDU-CANCEL-SEQ, DIS-DIST-SEQ-NBR → LDU-DIST-SEQ-NBR, LDU-ACTION, LDU-DATE, LDU-TIME, LDU-UNIQUE-I-D | ||
| Lminterest | LMINTEREST | DIS-COMPANY → LEI-COMPANY, DIS-PMT-VENDOR → LEI-PMT-VENDOR, DIS-LEASE → LEI-LEASE, DIS-PMT-NBR → LEI-PMT-NBR, DIS-CANCEL-SEQ → LEI-CANCEL-SEQ, DIS-DIST-SEQ-NBR → LEI-DIST-SEQ-NBR, LEI-INT-SEQ-NBR |
Programs
Updated by (1)
- AP30.4 Invoice Cancel