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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AH2-COMPANY SET2 SET9
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 SET9
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP115, AP198
#AH2-INVOICE SET9
INVOICE		Alpha 22Used to identify the invoice.AP115, AP198
#AH2-SUFFIX SET9
SUFFIX		Numeric 3This is the suffix for the invoice.AP198
#AH2-CANCEL-SEQ SET9
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 SET4
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 SET4
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 SET4
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 SET4
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 SET4
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 SET5
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 SET9
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 SET6
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 SET2
STATEMENT		Alpha 22Used to identify the invoice.—
#AH2-TXN-NBR SET2
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 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
AH2SET1
  1. API-OBJ-ID
  2. DIST-SEQ-NBR
PrimaryAP115, AP136, AP180, AP181, AP190, AP232, AP28.1, AP28.2 +3 more
AH2SET2
  1. COMPANY
  2. STATEMENT
  3. TXN-NBR
  4. API-OBJ-ID
  5. DIST-SEQ-NBR
SubsetWhere (PO-NUMBER = Spaces)—
AH2SET4
  1. DIST-COMPANY
  2. DIS-ACCT-UNIT
  3. DIS-ACCOUNT
  4. DIS-SUB-ACCT
  5. DISTRIB-DATE
  6. API-OBJ-ID
  7. DIST-SEQ-NBR
KeyChangeAP275
AH2SET5
  1. GLT-OBJ-ID
  2. API-OBJ-ID
  3. DIST-SEQ-NBR
KeyChange, SubsetWhere GLT-OBJ-ID != Zeroes—
AH2SET6
  1. DST-OBJ-ID
KeyChange, SubsetWhere DST-OBJ-ID != Zeroes—
AH2SET9
  1. ATN-OBJ-ID
  2. COMPANY
  3. VENDOR
  4. INVOICE
  5. SUFFIX
  6. CANCEL-SEQ
  7. DIST-SEQ-NBR
KeyChange, SubsetWhere ATN-OBJ-ID != Zeroes—

Relations

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

One to one (10) — lookups and parents

RelationTableRulesConditionField map
ActransACTRANSNot Required
AH2-ATN-OBJ-ID→ATN-OBJ-ID (ATNSET12)
ApapihistAPAPIHISTRequired
AH2-COMPANY→AH1-COMPANY
AH2-VENDOR→AH1-VENDOR
AH2-INVOICE→AH1-INVOICE
AH2-SUFFIX→AH1-SUFFIX
AH2-CANCEL-SEQ→AH1-CANCEL-SEQ
ApcompanyAPCOMPANYRequired
AH2-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
ApvenmastAPVENMASTRequired
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
AH2-VENDOR→VEN-VENDOR
AssetAPAPSHISTNot Required
AH2-API-OBJ-ID→AH4-API-OBJ-ID
AH2-DIST-SEQ-NBR→AH4-DIST-SEQ-NBR
DstusrfldAPDFLHISTNot Required
AH2-API-OBJ-ID→AH7-API-OBJ-ID
AH2-DIST-SEQ-NBR→AH7-DIST-SEQ-NBR
GlmasterGLMASTERRequired
AH2-DIST-COMPANY→GLM-COMPANY
AH2-DIS-ACCT-UNIT→GLM-ACCT-UNIT
AH2-DIS-ACCOUNT→GLM-ACCOUNT
AH2-DIS-SUB-ACCT→GLM-SUB-ACCOUNT
Glsystem OrigGLSYSTEMRequired
AH2-COMPANY→GLS-COMPANY
Glsystem ToGLSYSTEMRequired
AH2-DIST-COMPANY→GLS-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
ApdistpayAPDISTPAY
AH2-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)