|
|
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 The company number represents an
established company and is entered on
all function codes.
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 Number
AH2-DIST-SEQ-NBR Numeric 4 AP198
Element: Number of Items
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
AH2-POST-OPTION Alpha 1 AP198
Element: Posting OptionGeneral Ledger posting option.
AH2-INVOICE-TYPE Alpha 1 AP198
Element: Invoice Type
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 13.6 AP198
Element: Currency Rate The currency rate.
AH2-ORIG-BASE-AMT Signed 15.2 AP198
Element: Adj Amt
AH2-BASE-ND Numeric 1 AP198
Account Currency
Code
AH2-ORIG-TRAN-AMT Signed 15.2 AP198
Element: Adj Amt
AH2-TRAN-ND Numeric 1 AP198
Account Currency
Code
AH2-TO-BASE-AMT Signed 15.2 AP198
Element: Adj Amt
AH2-TO-BASE-ND Numeric 1 AP198
Account Currency
Code
AH2-TAXABLE-AMT Signed 15.2 AP198
Element: Adj Amt
AH2-UNT-AMOUNT Signed 15.2 AP198
Element: Adj Amt
AH2-DIST-COMPANY Numeric 4 AP198
Element: Company
AH2-DIS-ACCT-UNIT Alpha 15 AP198
Element: Accounting Unit
AH2-DIS-ACCOUNT Numeric 6 AP198
Element: Account
AH2-DIS-SUB-ACCT Numeric 4 AP198
Element: Subaccount
AH2-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Element: Date
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
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.
AH2-ACCR-CODE Alpha 4 AP198
Accounts Receivable
Code
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
AH2-PO-AOC-CODE Alpha 2 AP198
Element: Add On Cost Code
AH2-GLT-OBJ-ID Numeric 12 AP198
Object
Identification
AH2-ATN-OBJ-ID Numeric 12 AP198
Object
Identification
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-DIST-STATUS Derived
Element: 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
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
|
