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.

Field / columnTypeDescription & valuesUpdated by
PDS-PCARD-PROGRAM PK
PCARD_PROGRAM
Alpha 10PD21.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 22PD21.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.2PD21.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 5PD21.1, PD22.1, PD570
PDS-BILL-CATEGORY
BILL_CATEGORY
Alpha 32PD21.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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PDSSET1PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBRPrimaryPD130, PD20.1, PD20.2, PD20.3, PD21.1, PD22.1, PD230, PD570
PDSSET2COMPANY, STATEMENT, TXN-NBR, SEQ-NBR, PCARD-PROGRAM

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PdchrgdtlPDCHRGDTLRequiredPDS-PCARD-PROGRAMPXD-PCARD-PROGRAM (PXDSET1), PDS-STATEMENTPXD-STATEMENT, PDS-COMPANYPXD-COMPANY, PDS-TXN-NBRPXD-TXN-NBR

Programs

Updated by (3)

Referenced by (5)