PDCARDCOMP – P-Card Company

System
Purchase Order (PO)
Prefix
PCA
Primary key
PCARD-PROGRAM, REQUEST-NBR, COMPANY
Fields
12
Updated by
3 programs
Referenced by
3 programs

PDCARDCOMP is the P-Card Company table in Lawson Purchase Order (prefix PCA). It is indexed by PCARD-PROGRAM, REQUEST-NBR, COMPANY (PCASET1); alternate indexes: PCASET2, PCASET3 and PCASET4. It is updated by PD10.2, PD10.3 and PD570 and referenced by PD01.1, PD01.2 and POII.1. The table has 12 fields, 4 indexes and 0 documented relations.

About PDCARDCOMP

No description in the Lawson data dictionary.

Fields (12)

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

Field / columnTypeDescription & valuesUpdated by
PCA-PCARD-PROGRAM PK
PCARD_PROGRAM
Alpha 10PD10.3
PCA-REQUEST-NBR PK
REQUEST_NBR
Numeric 16PD10.3
PCA-PCARD-NBR
PCARD_NBR
Alpha 16PD10.2, PD10.3
PCA-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.PD10.3
PCA-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.PD10.3
PCA-DIST-CODE
DIST_CODE
Alpha 9A user-defined code used to automatically create expense distributions or expense distribution "shells" for invoices or to split an invoice distribution into multiple distributions.PD10.3
PCA-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.PD10.3
PCA-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.PD10.3
PCA-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.PD10.3
PCA-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.PD10.3
PCA-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 thruPD10.3
PCA-DEFAULT
DEFAULT
Alpha 1PD10.3

Indexes (4)

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

IndexKeysFlagsConditionUsed in
PCASET1PCARD-PROGRAM, REQUEST-NBR, COMPANYPrimaryPD10.2, PD10.3, PD570, POII.1
PCASET2PCARD-PROGRAM, COMPANY, REQUEST-NBRPD01.1, PD01.2, PD570
PCASET3COMPANY, PCARD-PROGRAM, REQUEST-NBR, PCARD-NBRKeyChange
PCASET4PCARD-PROGRAM, REQUEST-NBRSubsetWhere DEFAULT = "Y"

Programs

Updated by (3)

Referenced by (3)