POCAMDFLTS – No description in the Lawson data dictionary
- System
- Purchase Order (PO)
- Prefix
PDA- Primary key
PROCURE-GROUP,COMPANY,PO-NUMBER,PO-RELEASE,PO-CODE,LINE-NBR,REC-TYP- Fields
- 22
- Updated by
- 2 programs
- Referenced by
- 0 programs
POCAMDFLTS is a Lawson Purchase Order table (prefix PDA); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, REC-TYP (PDASET1). It is updated by PO520 and PO53.9. The table has 22 fields, 1 index and 0 documented relations.
About POCAMDFLTS
No description in the Lawson data dictionary.
Fields (22)
Column = COBOL field name without the PDA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PDA-PROCURE-GROUP PKPROCURE_GROUP | Alpha 4 | Type 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.9 |
PDA-COMPANY PKCOMPANY | 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. | PO520, PO53.9 |
PDA-PO-NUMBER PKPO_NUMBER | Alpha 14 (Right Justified) | This field contains the number representing the purchase order. | PO520, PO53.9 |
PDA-PO-RELEASE PKPO_RELEASE | Numeric 4 | Used to identify a purchase order release (created from a Blanket or Standing order). | PO520, PO53.9 |
PDA-PO-CODE PKPO_CODE | Alpha 4 | This is the purchase order code. | PO520, PO53.9 |
PDA-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | PO520, PO53.9 |
PDA-REC-TYP PKREC_TYP | Numeric 2 | — | PO520, PO53.9 |
PDA-ASSET-DESCASSET_DESC | Alpha 30 (Lower Case) | This field displays the description. | PO520, PO53.9 |
PDA-TAG-NBRTAG_NBR | Alpha 12 | The tag is a user definable identifier assigned to an asset. | PO520, PO53.9 |
PDA-ASSET-GROUPASSET_GROUP | Alpha 10 | — | PO520, PO53.9 |
PDA-AU-GROUPAU_GROUP | Alpha 10 | Accounting unit groups group and identify the accounting units to use when you create journal entries for adding, adjusting, transferring, or disposing of assets. Changes to accounting unit groups are dynamic, affecting all assets using the accounting unit group. Accounting unit group names are user-definable, and accounting unit groups are set up by company. | PO520, PO53.9 |
PDA-COMBINECOMBINE | Alpha 10 | — | PO520, PO53.9 |
PDA-HOLD-AMHOLD_AM | Alpha 1 | —
| PO520, PO53.9 |
PDA-ITEM-NBRITEM_NBR | Alpha 32 | This field contains the item identifier. | PO520, PO53.9 |
PDA-ITEM-DESCITEM_DESC | Alpha 30 (Lower Case) | This field displays the description. | PO520, PO53.9 |
PDA-MODEL-NUMBERMODEL_NUMBER | Alpha 30 | — | PO520, PO53.9 |
PDA-PURCHASE-DATEPURCHASE_DATE | Numeric 8 (yyyymmdd) | The date the asset was purchased. This purchased date can be different from the in-service dates for the depreciation books used. | PO520, PO53.9 |
PDA-INSRV-DATEINSRV_DATE | Numeric 8 (yyyymmdd) | The book in-service date for the asset. NOTE The in-service date can be different for each depreciation book used. | PO520, PO53.9 |
PDA-ITEM-TAX-TRANITEM_TAX_TRAN | Signed 18.2 | — | PO520, PO53.9 |
PDA-LOCATION-NAMELOCATION_NAME | Alpha 15 | A user-defined location name which represents where an asset is physically located. Locations are used to report asset information. | PO520, PO53.9 |
PDA-DIVISIONDIVISION | Alpha 15 | A user-defined division which is used for reporting assets. | PO53.9 |
PDA-ITEM-LOC-DTLITEM_LOC_DTL | Alpha 14 | — | PO520, PO53.9 |
Indexes (1)
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 |
|---|---|---|---|---|
PDASET1 | PROCURE-GROUP, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, REC-TYP | Primary | PO520, PO53.2, PO53.9 |