|
|
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
Element: Company Identifies 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.
AH2-API-OBJ-ID Numeric 12 AP198
Object
Identification
AH2-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor ID The vendor's identification code.
AH2-INVOICE Alpha 22 AP115 AP198
Element: Invoice NumberUsed to identify the invoice.
AH2-SUFFIX Numeric 3 AP198
Element: Invoice SuffixThis is the suffix for the invoice.
AH2-CANCEL-SEQ Numeric 4 AP198
Element: Sequence NumbeThe 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-ORIG-DIST-SEQ Numeric 4 AP198
Element: Orig Dist Seq
AH2-DIST-TYPE Alpha 1 AP198
Element: Distribution TThe distribution type.
"D" = Distribution
"I" = Inter-company
"G" = Gain/Loss
AH2-PROC-LEVEL Alpha 5 AP198
Element: Process Level The process level represents a
reporting level below company.
AH2-POST-OPTION Alpha 1 AP198
Element: Posting OptionGeneral Ledger posting option.
AH2-INVOICE-TYPE Alpha 1 AP198
Element: Invoice Type THis 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.
AH2-REC-STATUS Numeric 1 AP198
Element: Record Status The record status.
AH2-INV-CURRENCY Alpha 5 AP198
To Company Base
Currency
AH2-TAX-RATE Percent 7.5 (Percent) AP198
Element: Chrg Rate The tax rate defined for the tax code.
AH2-CURR-RATE Signed 14.7 AP198
Element: Currency Rate The currency rate.
AH2-ORIG-BASE-AMT Signed 18.2 AP198
Element: Intl Amt
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 18.2 AP198
Element: Intl Amt
AH2-TRAN-ND Numeric 1 AP198
Account Currency The number of decimal positions defined
Code for the transaction currency.
AH2-TO-BASE-AMT Signed 18.2 AP198
Element: Intl Amt
AH2-TO-BASE-ND Numeric 1 AP198
Account Currency
Code
AH2-TAXABLE-AMT Signed 18.2 AP198
Element: Intl Amt This is the taxable amount.
AH2-UNT-AMOUNT Signed 18.2 AP198
Element: Intl Amt The total units.
AH2-DIST-COMPANY Numeric 4 AP198
Element: 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
Element: Accounting UniThe 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
Element: Account Required if the distribution accounting
unit field is not blank. The general
ledger distribution account.
AH2-DIS-SUB-ACCT Numeric 4 AP198
Element: Subaccount The general ledger distribution
subaccount.
AH2-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Element: Date The date used for posting the
transactions to the general ledger.
AH2-TAX-SEQ-NBR Numeric 4 AP198
Element: Tax Seq Nbr
AH2-TAX-INDICATOR Numeric 1 AP198
Element: Tax Indicator 1 = Exempt
2 = Taxable
AH2-TAX-CODE Alpha 10 AP198
Element: Tax Code This field contains a code representing
specific tax information. This must be
valid Tax Code.
AH2-TAX-TYPE Alpha 1 AP198
Element: Tax Type The type of tax.
AH2-DESCRIPTION Alpha 30 (Lower Case) AP198
Element: Description This field displays the description.
AH2-DST-REFERENCE Alpha 10 AP198
Element: Cross Ref The distribution reference.
AH2-ACTIVITY Alpha 15 AP198
Element: 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
Element: Account CategoAccount 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 thru
AH2-BILL-CATEGORY Alpha 32 AP198
Element: Bill Category
AH2-ACCR-CODE Alpha 4 AP198
Element: Accrual Code A user-defined code representing a
general ledger accrual account.
AH2-PO-NUMBER Alpha 14 (Right Justified) AP198
Element: PO Number This field contains the number
representing the purchase order.
AH2-PO-RELEASE Numeric 4 AP198
Element: PO Release NumUsed to identify a purchase order
release (created from a Blanket or
Standing order).
AH2-PO-CODE Alpha 4 AP198
Element: Po Code This is the purchase order code.
AH2-PO-LINE-NBR Numeric 6 AP198
Element: Line Number The PO line number this record is
associated with.
AH2-PO-AOC-CODE Alpha 2 AP198
Element: Add On Cost Code
AH2-GLT-OBJ-ID Numeric 12 AP198
Object This is a subsystem GL interface
Identification identification number. It is used for
Drill Around purposes.
AH2-ATN-OBJ-ID Numeric 12 AP198
Object The system-defined object id
Identification representing the Activity Management
commitment.
AH2-ASSET-FLAG Alpha 1 AP198
Element: Asset Flag
AH2-DIST-CODE Alpha 9 AP198
Element: Distribution CA 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
Element: Tax Point
AH2-VAT-REVERSE-FL Alpha 1 AP198
Element: All Flag
AH2-DST-OBJ-ID Numeric 12 AP198
Object
Identification
AH2-MA-CREATE-FL Alpha 1 AP198
Element: Account Flag
AH2-TAX-USAGE-CD Alpha 10 AP198
Element: 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
Element: Final Dst Flag
AH2-AC-UPD-STATUS Numeric 1 AP198
Element: Ac Upd Status AC 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.
AH2-AC-UPD-DATE Numeric 8 (yyyymmdd) AP198
Element: Ac Upd Date Last Ac distribtion record status change
date.
AH2-AC-UPD-TIME Numeric 6 (hhmmss) AP198
Element: Ac Upd Time Last AC distribution record change time.
AH2-DIST-STATUS Derived
Element: Distribution Status
AH2-DIVERSE-CODE Alpha 5 AP198
Element: Diverse Code Diversity Code for Account Payable
Vendors
AH2-DISTRIB-ADJ Numeric 1
Element: Distrib Adj Identifies 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.
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
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
|
