PDCHRGDIST – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PDS
Primary key
PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBR
Fields
32
Updated by
3 programs
Referenced by
5 programs

PDCHRGDIST is a Lawson Purchase Order table (prefix PDS); no description in the lawson data dictionary. It is indexed by PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBR (PDSSET1); alternate indexes: PDSSET2. It is related 1:1 to PDCHRGDTL. It is updated by PD21.1, PD22.1 and PD570 and referenced by PD130, PD20.1, PD20.2, PD20.3 and PD230. The table has 32 fields, 2 indexes and 1 documented relation.

About PDCHRGDIST

No description in the Lawson data dictionary.

Fields (32)

Column = COBOL field name without the PDS- 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 / columnTypeDescription & valuesUpdated by
#PDS-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD21.1, PD22.1, PD570
#PDS-STATEMENT PK
STATEMENT		Alpha 22Used to identify the invoice.PD21.1, PD22.1, PD570
#PDS-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.PD21.1, PD22.1, PD570
#PDS-TXN-NBR PK
TXN_NBR		Alpha 22—PD21.1, PD22.1, PD570
#PDS-DIST-TYPE
DIST_TYPE		Alpha 1The distribution type. "D" = Distribution "I" = Inter-company "G" = Gain/Loss
  • G Goods
  • T Tax
PD21.1, PD22.1, PD570
#PDS-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.PD21.1, PD22.1, PD570
#PDS-DIST-AMOUNT
DIST_AMOUNT		Signed 18.2—PD21.1, PD22.1, PD570
#PDS-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.PD21.1, PD22.1, PD570
#PDS-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.PD21.1, PD22.1, PD570
#PDS-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.PD21.1, PD22.1, PD570
#PDS-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.PD21.1, PD22.1, PD570
#PDS-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.PD21.1, PD22.1, PD570
#PDS-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5—PD21.1, PD22.1, PD570
#PDS-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—PD21.1, PD22.1, PD570
#PDS-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.PD21.1, PD22.1
#PDS-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103This 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.PD21.1, PD22.1, PD570
#PDS-ASSET-FLAG
ASSET_FLAG		Alpha 1——
#PDS-ASSET-DESC
ASSET_DESC		Alpha 30 (Lower Case)This field displays the description.—
#PDS-TAG-NBR
TAG_NBR		Alpha 12The tag is a user definable identifier assigned to an asset.—
#PDS-ITEM-NBR
ITEM_NBR		Alpha 32This field contains the item identifier.—
#PDS-ITEM-DESC
ITEM_DESC		Alpha 30This field contains the description for stock and non-stock items.—
#PDS-ITEM-QUANTITY
ITEM_QUANTITY		Numeric 8The number of units that make up the asset item. Each unit of an item is exactly the same as every other unit of the item.—
#PDS-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.—
#PDS-INSRV-DATE
INSRV_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.—
#PDS-PURCHASE-DATE
PURCHASE_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.—
#PDS-MODEL-NUMBER
MODEL_NUMBER		Alpha 30——
#PDS-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30This optional field is used for the serial number of the asset.—
#PDS-HOLD-AM
HOLD_AM		Alpha 1——
#PDS-ASSET
ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.—
#PDS-ASSET-GROUP
ASSET_GROUP		Alpha 10——
#PDS-COMBINE
COMBINE		Alpha 10——
#PDS-BAR-CODE
BAR_CODE		Alpha 30——

Indexes (2)

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.

IndexKeysFlagsConditionUsed in
PDSSET1
  1. PCARD-PROGRAM
  2. STATEMENT
  3. COMPANY
  4. TXN-NBR
  5. SEQ-NBR
PrimaryPD130, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1, PD230, PD570
PDSSET2
  1. COMPANY
  2. STATEMENT
  3. TXN-NBR
  4. SEQ-NBR
  5. PCARD-PROGRAM
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PDCHRGDTLPDCHRGDIST

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PdchrgdtlPDCHRGDTLRequired
PDS-PCARD-PROGRAM→PXD-PCARD-PROGRAM (PXDSET1)
PDS-STATEMENT→PXD-STATEMENT
PDS-COMPANY→PXD-COMPANY
PDS-TXN-NBR→PXD-TXN-NBR

Programs

Updated by (3)

Referenced by (5)