APAPSHIST – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
AH4
Primary key
API-OBJ-ID, DIST-SEQ-NBR
Fields
26
Updated by
9 programs
Referenced by
0 programs

APAPSHIST is a Lawson Accounts Payable table (prefix AH4); no description in the lawson data dictionary. It is indexed by API-OBJ-ID, DIST-SEQ-NBR (AH4SET1). It is updated by AP180, AP181, AP190, AP198, AP28.1, AP28.2, AP300, AP305 and 1 more. The table has 26 fields, 1 index and 0 documented relations.

About APAPSHIST

No description in the Lawson data dictionary.

Fields (26)

Column = COBOL field name without the AH4- 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
#AH4-API-OBJ-ID PK
API_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP198
#AH4-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number.AP198
#AH4-ASSET-DESC
ASSET_DESC		Alpha 30 (Lower Case)This field displays the description.AP198
#AH4-TAG-NBR
TAG_NBR		Alpha 12The tag is a user definable identifier assigned to an asset.AP198
#AH4-ITEM-NBR
ITEM_NBR		Alpha 32This field contains the item identifier.AP198
#AH4-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.AP198
#AH4-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.AP198
#AH4-MODEL-NUMBER
MODEL_NUMBER		Alpha 30—AP198
#AH4-SERIAL-NUMBER
SERIAL_NUMBER		Alpha 30This optional field is used for the serial number of the asset.AP198
#AH4-HOLD-AM
HOLD_AM		Alpha 1—AP198
#AH4-COMBINE
COMBINE		Alpha 10—AP198
#AH4-ITEM-DESC
ITEM_DESC		Alpha 30This field contains the description for stock and non-stock items.AP198
#AH4-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.AP198
#AH4-ITEM-TAX-TRAN
ITEM_TAX_TRAN		Signed 18.2—AP198
#AH4-ITEM-TAX-BASE
ITEM_TAX_BASE		Signed 18.2—AP198
#AH4-ASSET-GROUP
ASSET_GROUP		Alpha 10—AP198
#AH4-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.AP198
#AH4-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.AP198
#AH4-ASSET
ASSET		Numeric 10The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide.AP198
#AH4-LOCATION-NAME
LOCATION_NAME		Alpha 15A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.AP198
#AH4-DIVISION
DIVISION		Alpha 15A user-defined division which is used for reporting assets.AP198
#AH4-AU-GROUP
AU_GROUP		Alpha 10Accounting 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.AP198
#AH4-BAR-CODE
BAR_CODE		Alpha 30——
#AH4-ITEM-LOC-DTL
ITEM_LOC_DTL		Alpha 14——
#AH4-AP-DISTRIB-FL
AP_DISTRIB_FL		Alpha 1——
#AH4-LAND-COST-FL
LAND_COST_FL		Alpha 1——

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.

IndexKeysFlagsConditionUsed in
AH4SET1
  1. API-OBJ-ID
  2. DIST-SEQ-NBR
PrimaryAP180, AP181, AP190, AP28.1, AP28.2, AP300, AP305, AP45.1

Programs

Updated by (9)