POCMMDIST – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
CMS
Primary key
PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, LINE-SEQ
Fields
22
Updated by
5 programs
Referenced by
0 programs

POCMMDIST is a Lawson Purchase Order table (prefix CMS); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, LINE-SEQ (CMSSET1). It is updated by PO520, PO53.1, PO53.2, PO53.3 and PO53.4. The table has 22 fields, 1 index and 0 documented relations.

About POCMMDIST

No description in the Lawson data dictionary.

Fields (22)

Column = COBOL field name without the CMS- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
CMS-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together.PO520, PO53.2, PO53.3, PO53.4
CMS-COMPANY PK
COMPANY		Numeric 4Identifies 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.PO520, PO53.2, PO53.3, PO53.4
CMS-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.PO520, PO53.2, PO53.3, PO53.4
CMS-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).PO520, PO53.2, PO53.3, PO53.4
CMS-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.PO520, PO53.2, PO53.3, PO53.4
CMS-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.PO520, PO53.2, PO53.3, PO53.4
CMS-LINE-SEQ PK
LINE_SEQ		Numeric 3This field contains the record sequence number.PO520, PO53.2, PO53.3, PO53.4
CMS-AOC-CODE PK
AOC_CODE		Alpha 2This field contains the identifier for the add on cost associated with this line item.PO520, PO53.2, PO53.3, PO53.4
CMS-REC-TYP
REC_TYP		Numeric 2—
  • 14 MMDIST record
PO520, PO53.2, PO53.3, PO53.4
CMS-ACCT-UNIT
ACCT_UNIT		Alpha 15The 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.PO520, PO53.2, PO53.3, PO53.4
CMS-ACCOUNT
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.PO520, PO53.2, PO53.3, PO53.4
CMS-SUB-ACCT
SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.PO520, PO53.2, PO53.3, PO53.4
CMS-DIST-COMPANY
DIST_COMPANY		Numeric 4Identifies 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.PO520, PO53.2, PO53.3, PO53.4
CMS-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.PO520, PO53.2, PO53.3, PO53.4
CMS-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 thruPO520, PO53.2, PO53.3, PO53.4
CMS-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—PO520, PO53.2, PO53.3, PO53.4
CMS-ASSET-TEMPLATE
ASSET_TEMPLATE		Alpha 10A user-defined asset template identifies general asset creation parameters that you can use to quickly add assets with minimal keying. Using a template lets you default many data items associated with a new asset. You can use an asset template to process quick asset additions in AM20.1 (Quick Addition) and to create assets and asset books from Accounts Payable and Activity Management interface information. Asset templates are required if you define new assets as a result of transactions interfaced from the Lawson Purchase Order or Accounts Payable systems.PO520, PO53.2, PO53.3, PO53.4
CMS-ASSET
ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.PO520, PO53.2, PO53.3, PO53.4
CMS-DIST-PERCENT
DIST_PERCENT		Signed 6.3—PO520, PO53.2, PO53.3, PO53.4
CMS-DIST-QTY
DIST_QTY		Signed 13.4This field contains the desired quantity.PO520, PO53.2, PO53.3, PO53.4
CMS-RUN-GROUP
RUN_GROUP		Alpha 15—PO520, PO53.2, PO53.3, PO53.4
CMS-DIST-AMOUNT
DIST_AMOUNT		Signed 18.2—PO520, PO53.2, PO53.3, PO53.4

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CMSSET1PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, AOC-CODE, LINE-SEQPrimaryPO520, PO53.1, PO53.2, PO53.3, PO53.4

Programs

Updated by (5)