PDMERCHANT – Merchant
- System
- Purchase Order (PO)
- Prefix
PDM- Primary key
PCARD-PROGRAM,MERCHANT- Fields
- 29
- Updated by
- 2 programs
- Referenced by
- 9 programs
PDMERCHANT is the Merchant table in Lawson Purchase Order (prefix PDM). It is indexed by PCARD-PROGRAM, MERCHANT (PDMSET1). It is updated by PD04.1 and PD570 and referenced by AP145, AP146, AP245, AP246, PD05.1, PD06.1, PD204, PD21.1 and 1 more. The table has 29 fields, 1 index and 0 documented relations.
About PDMERCHANT
No description in the Lawson data dictionary.
Fields (29)
Column = COBOL field name without the PDM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PDM-PCARD-PROGRAM PKPCARD_PROGRAM | Alpha 10 | — | PD04.1, PD570 |
#PDM-MERCHANT PKMERCHANT | Alpha 32 | — | PD04.1, PD570 |
#PDM-PREFIXPREFIX | Alpha 6 | The telephone number country code. | PD04.1 |
#PDM-PHONEPHONE | Alpha 15 | Phone number. | PD04.1 |
#PDM-EXTENSIONEXTENSION | Alpha 5 | This field contains the telephone extension number. | PD04.1 |
#PDM-TAX-IDTAX_ID | Alpha 20 | — | PD04.1 |
#PDM-INCOME-CODEINCOME_CODE | Alpha 4 | A user-defined code that represents a type of income withholding. Used to track reportable income for reporting or withholding. | PD04.1 |
#PDM-LEGAL-NAMELEGAL_NAME | Alpha 80 (Lower Case) | Institution's legal name used on the GM269 and GM272 reports. | PD04.1, PD570 |
#PDM-SNAMESNAME | Alpha 30 | The requester can enter the recommended vendor's name for the requested items. | PD04.1, PD570 |
#PDM-VNAMEVNAME | Alpha 30 | The requester can enter the recommended vendor's name for the requested items. | — |
#PDM-VENDOR-CONTCTVENDOR_CONTCT | Alpha 30 | The requester can enter the recommended vendor's name for the requested items. | PD04.1 |
#PDM-VEN-CLASSVEN_CLASS | Alpha 3 | A user-defined code representing a subset of vendors within a vendor group. | — |
#PDM-FAX-PREFIXFAX_PREFIX | Alpha 6 | The telephone number country code. | PD04.1 |
#PDM-FAX-NUMFAX_NUM | Alpha 15 | Phone number. | PD04.1 |
#PDM-FAX-EXTFAX_EXT | Alpha 5 | This field contains the telephone extension number. | PD04.1 |
#PDM-ADDR1ADDR1 | Alpha 30 (Lower Case) | This field contains the first line of address information. | PD04.1 |
#PDM-ADDR2ADDR2 | Alpha 30 (Lower Case) | This field contains the first line of address information. | PD04.1 |
#PDM-ADDR3ADDR3 | Alpha 30 (Lower Case) | This field contains the first line of address information. | PD04.1 |
#PDM-ADDR4ADDR4 | Alpha 30 (Lower Case) | This field contains the first line of address information. | PD04.1 |
#PDM-CITY-ADDR5CITY_ADDR5 | Alpha 18 (Lower Case) | This field contains the city of the address. | PD04.1 |
#PDM-STATE-PROVSTATE_PROV | Alpha 2 | The state or province. | PD04.1 |
#PDM-POSTAL-CODEPOSTAL_CODE | Alpha 10 (Lower Case) | This field contains the postal code. | PD04.1 |
#PDM-COUNTYCOUNTY | Alpha 25 (Lower Case) | The county for the company address. | PD04.1 |
#PDM-COUNTRYCOUNTRY | Alpha 30 (Lower Case) | This field contains the country of the address, or it can be used for additional information such as an attention name. | PD04.1 |
#PDM-SEC-WTH-EXEMPTSEC_WTH_EXEMPT | Alpha 1 | —
| — |
#PDM-SEC-WTH-CODE1SEC_WTH_CODE1 | Alpha 10 | — | — |
#PDM-SEC-WTH-CODE2SEC_WTH_CODE2 | Alpha 10 | — | — |
#PDM-SEC-WTH-CODE3SEC_WTH_CODE3 | Alpha 10 | — | — |
#PDM-FOR-ECON-CODEFOR_ECON_CODE | Alpha 10 | — | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PDMSET1 |
| Primary | AP145, AP146, AP245, AP246, PD04.1, PD05.1, PD06.1, PD204 +3 more |