APAPDHIST – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
AH2
Primary key
API-OBJ-ID, DIST-SEQ-NBR
Fields
65
Updated by
10 programs
Referenced by
3 programs

APAPDHIST is a Lawson Accounts Payable table (prefix AH2); no description in the lawson data dictionary. It is indexed by API-OBJ-ID, DIST-SEQ-NBR (AH2SET1); alternate indexes: AH2SET2, AH2SET4, AH2SET5, AH2SET6 and AH2SET9. It is related 1:1 to ACTRANS, APAPIHIST, APCOMPANY, APUAVHIST, APVENMAST, APAPSHIST, APDFLHIST, GLMASTER and 1 more and 1:M to APDISTPAY. It is updated by AP115, AP180, AP181, AP190, AP198, AP28.1, AP28.2, AP300 and 2 more and referenced by AP136, AP232 and AP275. The table has 65 fields, 6 indexes and 11 documented relations.

About APAPDHIST

No description in the Lawson data dictionary.

Fields (65)

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

Field / columnTypeDescription & valuesUpdated by
AH2-COMPANY
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.AP198
AH2-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
AH2-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP115, AP198
AH2-INVOICE
INVOICE		Alpha 22Used to identify the invoice.AP115, AP198
AH2-SUFFIX
SUFFIX		Numeric 3This is the suffix for the invoice.AP198
AH2-CANCEL-SEQ
CANCEL_SEQ		Numeric 4An automatically assigned sequence number.AP198
AH2-DIST-SEQ-NBR PK
DIST_SEQ_NBR		Numeric 6A unique sequence number.AP198
AH2-ORIG-DIST-SEQ
ORIG_DIST_SEQ		Numeric 6A unique sequence number.AP198
AH2-DIST-TYPE
DIST_TYPE		Alpha 1The distribution type. "D" = Distribution "I" = Inter-company "G" = Gain/LossAP198
AH2-PROC-LEVEL
PROC_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP198
AH2-POST-OPTION
POST_OPTION		Alpha 1General Ledger posting option.AP198
AH2-INVOICE-TYPE
INVOICE_TYPE		Alpha 1THis field will be filled in from the Invoice based on PO number. This is a carrier for the field. The PORECEIVE file will have to be updated with this field.AP198
AH2-REC-STATUS
REC_STATUS		Numeric 1The record status.AP198
AH2-INV-CURRENCY
INV_CURRENCY		Alpha 5—AP198
AH2-TAX-RATE
TAX_RATE		Percent 7.5 (Percent)Charge rate by month.AP198
AH2-CURR-RATE
CURR_RATE		Signed 14.7The currency rate.AP198
AH2-ORIG-BASE-AMT
ORIG_BASE_AMT		Signed 18.2—AP198
AH2-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.AP198
AH2-ORIG-TRAN-AMT
ORIG_TRAN_AMT		Signed 18.2—AP198
AH2-TRAN-ND
TRAN_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AP198
AH2-TO-BASE-AMT
TO_BASE_AMT		Signed 18.2—AP198
AH2-TO-BASE-ND
TO_BASE_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.AP198
AH2-TAXABLE-AMT
TAXABLE_AMT		Signed 18.2—AP198
AH2-UNT-AMOUNT
UNT_AMOUNT		Signed 18.2—AP198
AH2-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.AP198
AH2-DIS-ACCT-UNIT
DIS_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
AH2-DIS-ACCOUNT
DIS_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP198
AH2-DIS-SUB-ACCT
DIS_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.AP198
AH2-DISTRIB-DATE
DISTRIB_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP198
AH2-TAX-SEQ-NBR
TAX_SEQ_NBR		Numeric 4—AP198
AH2-TAX-INDICATOR
TAX_INDICATOR		Numeric 1—
  • 1 Exempt
  • 2 Taxable
AP198
AH2-TAX-CODE
TAX_CODE		Alpha 10This field contains a code representing specific tax information. This must be valid Tax Code.AP198
AH2-TAX-TYPE
TAX_TYPE		Alpha 1The type of tax.AP198
AH2-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.AP198
AH2-DST-REFERENCE
DST_REFERENCE		Alpha 10A user-defined field that can be used to cross reference expenses to advances or cash payments.AP198
AH2-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.AP198
AH2-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 thruAP198
AH2-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—AP198
AH2-ACCR-CODE
ACCR_CODE		Alpha 4A user-defined code representing a general ledger accrual account.AP198
AH2-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP198
AH2-PO-RELEASE
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP198
AH2-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.AP198
AH2-PO-LINE-NBR
PO_LINE_NBR		Numeric 6This field contains the line number.AP198
AH2-PO-AOC-CODE
PO_AOC_CODE		Alpha 2This field contains the identifier for the add on cost associated with this line item.AP198
AH2-GLT-OBJ-ID
GLT_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
AH2-ATN-OBJ-ID
ATN_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
AH2-ASSET-FLAG
ASSET_FLAG		Alpha 1—AP198
AH2-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.AP198
AH2-TAX-POINT
TAX_POINT		Alpha 1—AP198
AH2-VAT-REVERSE-FL
VAT_REVERSE_FL		Alpha 1—AP198
AH2-DST-OBJ-ID
DST_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
AH2-MA-CREATE-FL
MA_CREATE_FL		Alpha 1—AP198
AH2-TAX-USAGE-CD
TAX_USAGE_CD		Alpha 10The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.AP198
AH2-TRAN-DIST-FLAG
TRAN_DIST_FLAG		Alpha 1—AP198
AH2-AC-UPD-STATUS
AC_UPD_STATUS		Numeric 1AC provides status that the activity reflects "cash basis" billing. Status change will reflect AP invoice for distibution has been paid and message of payment has been sent to AC.
  • 0 No payment information impact
  • 1 Requires payment information
  • 2 AP invoice paid. AC updated.
AP198
AH2-AC-UPD-DATE
AC_UPD_DATE		Numeric 8 (yyyymmdd)Last Ac distribtion record status change date.AP198
AH2-AC-UPD-TIME
AC_UPD_TIME		Numeric 6 (hhmmss)Last AC distribution record change time.AP198
AH2-DIST-STATUS
DIST_STATUS		Derived——
AH2-DIVERSE-CODE
DIVERSE_CODE		Alpha 5Diversity Code for Account Payable VendorsAP198
AH2-DISTRIB-ADJ
DISTRIB_ADJ		Numeric 1Identifies distribution as one that was created from AP30.2 Distribution Adjustments. If created in AP30.2 form value equal to '1'. Used to determine source code to send to GLTRANS and ACTRANS.AP198
AH2-PULL-FOR-FR-FL
PULL_FOR_FR_FL		Alpha 1——
AH2-STATEMENT
STATEMENT		Alpha 22Used to identify the invoice.—
AH2-TXN-NBR
TXN_NBR		Alpha 22——
AH2-RETAINAGE
RETAINAGE		Numeric 1—
  • 0 No
  • 1 Yes
AP198
AH2-PROD-TAX-CAT
PROD_TAX_CAT		Alpha 15—AP198

Indexes (6)

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

IndexKeysFlagsConditionUsed in
AH2SET1API-OBJ-ID, DIST-SEQ-NBRPrimaryAP115, AP136, AP180, AP181, AP190, AP232, AP28.1, AP28.2 +3 more
AH2SET2COMPANY, STATEMENT, TXN-NBR, API-OBJ-ID, DIST-SEQ-NBRSubsetWhere (PO-NUMBER = Spaces)—
AH2SET4DIST-COMPANY, DIS-ACCT-UNIT, DIS-ACCOUNT, DIS-SUB-ACCT, DISTRIB-DATE, API-OBJ-ID, DIST-SEQ-NBRKeyChangeAP275
AH2SET5GLT-OBJ-ID, API-OBJ-ID, DIST-SEQ-NBRKeyChange, SubsetWhere GLT-OBJ-ID != Zeroes—
AH2SET6DST-OBJ-IDKeyChange, SubsetWhere DST-OBJ-ID != Zeroes—
AH2SET9ATN-OBJ-ID, COMPANY, VENDOR, INVOICE, SUFFIX, CANCEL-SEQ, DIST-SEQ-NBRKeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
ActransACTRANSNot RequiredAH2-ATN-OBJ-ID → ATN-OBJ-ID (ATNSET12)
ApapihistAPAPIHISTRequiredAH2-COMPANY → AH1-COMPANY, AH2-VENDOR → AH1-VENDOR, AH2-INVOICE → AH1-INVOICE, AH2-SUFFIX → AH1-SUFFIX, AH2-CANCEL-SEQ → AH1-CANCEL-SEQ
ApcompanyAPCOMPANYRequiredAH2-COMPANY → CPY-COMPANY
ApuavhistAPUAVHISTNot Required"D" → AH5-SEG-TYPE, AH2-API-OBJ-ID → AH5-API-OBJ-ID, AH2-DIST-SEQ-NBR → AH5-DIST-SEQ-NBR
ApvenmastAPVENMASTRequiredCPY-VENDOR-GROUP → VEN-VENDOR-GROUP, AH2-VENDOR → VEN-VENDOR
AssetAPAPSHISTNot RequiredAH2-API-OBJ-ID → AH4-API-OBJ-ID, AH2-DIST-SEQ-NBR → AH4-DIST-SEQ-NBR
DstusrfldAPDFLHISTNot RequiredAH2-API-OBJ-ID → AH7-API-OBJ-ID, AH2-DIST-SEQ-NBR → AH7-DIST-SEQ-NBR
GlmasterGLMASTERRequiredAH2-DIST-COMPANY → GLM-COMPANY, AH2-DIS-ACCT-UNIT → GLM-ACCT-UNIT, AH2-DIS-ACCOUNT → GLM-ACCOUNT, AH2-DIS-SUB-ACCT → GLM-SUB-ACCOUNT
Glsystem OrigGLSYSTEMRequiredAH2-COMPANY → GLS-COMPANY
Glsystem ToGLSYSTEMRequiredAH2-DIST-COMPANY → GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
ApdistpayAPDISTPAYAH2-COMPANY → DTY-COMPANY, AH2-VENDOR → DTY-VENDOR, AH2-INVOICE → DTY-INVOICE, AH2-SUFFIX → DTY-SUFFIX, AH2-DIST-SEQ-NBR → DTY-DIST-SEQ-NBR, → DTY-LINE-NBR, → DTY-MAD-SEQ-NBR, → DTY-PMT-SEQ-NBR

Programs

Updated by (10)

Referenced by (3)