APAPDHIST FILE
REFERENCED BY
AP260 AP275
UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP28.1
AP28.2 AP300 AP305 AP45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AH2-COMPANY Numeric 4 AP198 AP260
Company The company number represents an
established company and is entered on
all function codes.
AH2-API-OBJ-ID Numeric 12 AP198
Api Obj Id
AH2-VENDOR Alpha 9 (Right Justified) AP115 AP198
Vendor ID The vendor's identification code. AP260
AH2-INVOICE Alpha 22 AP115 AP198
Invoice Number Used to identify the invoice. AP260
AH2-SUFFIX Numeric 3 AP198 AP260
Invoice Suffix This is the suffix for the invoice.
AH2-CANCEL-SEQ Numeric 4 AP198 AP260
Cancel Sequence The sequence number assigned upon a
cancellation of a distributed invoice.
The first sequence assigned is 9999.
AH2-DIST-SEQ-NBR Numeric 4 AP198
Distribution A unique sequence number.
Sequence Number
AH2-DIST-TYPE Alpha 1 AP198
Distribution Type The distribution type.
"D" = Distribution
"I" = Inter-company
"G" = Gain/Loss
AH2-PROC-LEVEL Alpha 5 AP198
Process Level The process level represents a
reporting level below company.
AH2-POST-OPTION Alpha 1 AP198
Posting Option General Ledger posting option.
AH2-INVOICE-TYPE Alpha 1 AP198
Invoice Type
AH2-REC-STATUS Numeric 1 AP198
Record Status The record status.
AH2-INV-CURRENCY Alpha 5 AP198
Invoice Currency
AH2-TAX-RATE Percent 7.5 (Percent) AP198
Tax Rate The tax rate defined for the tax code.
AH2-CURR-RATE Signed 13.6 AP198
Currency Rate The currency rate.
AH2-ORIG-BASE-AMT Signed 15.2 AP198
Original Base Amount
AH2-BASE-ND Numeric 1 AP198
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
AH2-ORIG-TRAN-AMT Signed 15.2 AP198
Distribution Amount
AH2-TRAN-ND Numeric 1 AP198
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
AH2-TO-BASE-AMT Signed 15.2 AP198
To Company Base
Amount
AH2-TO-BASE-ND Numeric 1 AP198
To Base Number Of
Decimals
AH2-TAXABLE-AMT Signed 15.2 AP198
Taxable Amount The taxable amount.
AH2-UNT-AMOUNT Signed 15.2 AP198
Unt Amount The total units.
AH2-DIST-COMPANY Numeric 4 AP198
Distribution Company The company number used for posting the
transaction. A valid intercompany
relationship must be defined in the
Lawson General Ledger system.
AH2-DIS-ACCT-UNIT Alpha 15 AP198
Accounting Unit The general ledger distribution
accounting unit. Select a valid
accounting unit if you want the
interface program to create general
ledger transactions for transaction with
a record status of '1' and '2' only. A
transaction will be created to this
account and an offset transaction to the
cash account will occur.
AH2-DIS-ACCOUNT Numeric 6 AP198
Account Number Required if the distribution accounting
unit field is not blank. The general
ledger distribution account.
AH2-DIS-SUB-ACCT Numeric 4 AP198
Subaccount Number The general ledger distribution
subaccount.
AH2-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Distribution Date The date used for posting the
transactions to the general ledger.
AH2-TAX-CODE Alpha 10 AP198
Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
AH2-TAX-TYPE Alpha 1 AP198
Tax Type The type of tax.
AH2-DESCRIPTION Alpha 30 (Lower Case) AP198
Description This field displays the description.
AH2-DST-REFERENCE Alpha 10 AP198
Reference The distribution reference.
AH2-ACTIVITY Alpha 15 AP198
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
AH2-ACCT-CATEGORY Alpha 5 AP198
Account Category Account 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.
AH2-ACCR-CODE Alpha 4 AP198
Accrual Code A user-defined code representing a
general ledger accrual account.
AH2-PO-NUMBER Alpha 14 (Right Justified) AP198
PO Number This field contains the number
representing the purchase order.
AH2-PO-RELEASE Numeric 4 AP198
PO Release Number Used to identify a purchase order
release (created from a Blanket or
Standing order).
AH2-PO-CODE Alpha 4 AP198
Po Code This is the purchase order code.
AH2-PO-LINE-NBR Numeric 6 AP198
PO Line Number The PO line number this record is
associated with.
AH2-PO-AOC-CODE Alpha 2 AP198
Purchase Order Add
On Cost Flg
AH2-GLT-OBJ-ID Numeric 12 AP198
Subsystem GL This is a subsystem GL interface
Interface ID identification number. It is used for
Drill Around purposes.
AH2-ATN-OBJ-ID Numeric 12 AP198
Atn Object ID The system-defined object id
representing the Activity Management
commitment.
AH2-ASSET-FLAG Alpha 1 AP198
Asset Flag
AH2-DIST-CODE Alpha 9 AP198
Distribution Code A user-defined code used to
automatically create expense
distributions or expense distribution
"shells" for invoices or to split an
invoice distribution into multiple
distributions.
AH2-TAX-POINT Alpha 1 AP198
Tax Point
AH2-VAT-REVERSE-FL Alpha 1 AP198
Vat Reverse Fl
AH2-DST-OBJ-ID Numeric 12 AP198
Dst Obj Id
AH2-MA-CREATE-FL Alpha 1 AP198
Ma Create Fl
AH2-TAX-USAGE-CD Alpha 10 AP198
Tax Usage Cd The tax usage coe for the vendor. This
filed is required if the AP Company
inidcates that VAT reporting required.
AH2-TRAN-DIST-FLAG Alpha 1
Tran Dist Flag
AH2-DIST-STATUS Derived
Distribution Status
APAPDHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH2SET1 API-OBJ-ID AP115 AP180
DIST-SEQ-NBR AP181 AP190
AP260 AP28.1
AP28.2 AP300
AP305 AP45.1
AH2SET3 DIST-COMPANY KeyChange
ACTIVITY
ACCT-CATEGORY
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
AH2SET4 DIST-COMPANY KeyChange AP275
DIS-ACCT-UNIT
DIS-ACCOUNT
DIS-SUB-ACCT
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
AH2SET5 GLT-OBJ-ID KeyChange, Subset
API-OBJ-ID Where GLT-OBJ-ID != Zeroes
DIST-SEQ-NBR
AH2SET6 DST-OBJ-ID KeyChange, Subset
Where DST-OBJ-ID != Zeroes
AH2SET9 ATN-OBJ-ID KeyChange, Subset
COMPANY Where ATN-OBJ-ID != Zeroes
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
DIST-SEQ-NBR
APAPDHIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS Not Required
AH2-ATN-OBJ-ID -> ATN-OBJ-ID (ATNSET12)
Apapihist APAPIHIST Required
AH2-COMPANY -> AH1-COMPANY
AH2-VENDOR -> AH1-VENDOR
AH2-INVOICE -> AH1-INVOICE
AH2-SUFFIX -> AH1-SUFFIX
AH2-CANCEL-SEQ -> AH1-CANCEL-SEQ
Apcompany APCOMPANY Required
AH2-COMPANY -> CPY-COMPANY
Apuavhist APUAVHIST Not Required
"D" -> AH5-SEG-TYPE
AH2-API-OBJ-ID -> AH5-API-OBJ-ID
AH2-DIST-SEQ-NBR -> AH5-DIST-SEQ-NBR
Apvenmast APVENMAST Required
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
AH2-VENDOR -> VEN-VENDOR
Asset APAPSHIST Not Required
AH2-API-OBJ-ID -> AH4-API-OBJ-ID
AH2-DIST-SEQ-NBR -> AH4-DIST-SEQ-NBR
Dstusrfld APDFLHIST Not Required
AH2-API-OBJ-ID -> AH7-API-OBJ-ID
AH2-DIST-SEQ-NBR -> AH7-DIST-SEQ-NBR
Glmaster GLMASTER Required
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 Orig GLSYSTEM Required
AH2-COMPANY -> GLS-COMPANY
Glsystem To GLSYSTEM Required
AH2-DIST-COMPANY -> GLS-COMPANY
|
