|
|
APAPDHIST FILE
REFERENCED BY
AP136 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
Element: Obj Id This 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.
AH2-VENDOR Alpha 9 (Right Justified) AP115 AP198
Element: Vendor The vendor's identification code.
AH2-INVOICE Alpha 22 AP115 AP198
Element: Invoice Used to identify the invoice.
AH2-SUFFIX Numeric 3 AP198
Element: Suffix This is the suffix for the invoice.
AH2-CANCEL-SEQ Numeric 4 AP198
Element: Seq Nbr An automatically assigned sequence
number.
AH2-DIST-SEQ-NBR Numeric 6 AP198
Element: Dist Seq Nbr A unique sequence number.
AH2-ORIG-DIST-SEQ Numeric 6 AP198
Element: Dist Seq Nbr A unique sequence number.
AH2-DIST-TYPE Alpha 1 AP198
Element: Dist Type The distribution type.
"D" = Distribution
"I" = Inter-company
"G" = Gain/Loss
AH2-PROC-LEVEL Alpha 5 AP198
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
AH2-POST-OPTION Alpha 1 AP198
Element: Post Option General 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: Rec Status The record status.
AH2-INV-CURRENCY Alpha 5 AP198
Element: To Base Curr
AH2-TAX-RATE Percent 7.5 (Percent) AP198
Element: Chrg Rate Charge rate by month.
AH2-CURR-RATE Signed 14.7 AP198
Element: Curr Rate The currency rate.
AH2-ORIG-BASE-AMT Signed 18.2 AP198
Element: Intl Amt
AH2-BASE-ND Numeric 1 AP198
Element: Base Nd The number of decimal positions defined
for the company base currency.
AH2-ORIG-TRAN-AMT Signed 18.2 AP198
Element: Intl Amt
AH2-TRAN-ND Numeric 1 AP198
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
AH2-TO-BASE-AMT Signed 18.2 AP198
Element: Intl Amt
AH2-TO-BASE-ND Numeric 1 AP198
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
AH2-TAXABLE-AMT Signed 18.2 AP198
Element: Intl Amt
AH2-UNT-AMOUNT Signed 18.2 AP198
Element: Intl Amt
AH2-DIST-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-DIS-ACCT-UNIT Alpha 15 AP198
Element: Acct Unit The 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.
AH2-DIS-ACCOUNT Numeric 6 AP198
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AH2-DIS-SUB-ACCT Numeric 4 AP198
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AH2-DISTRIB-DATE Numeric 8 (yyyymmdd) AP198
Element: Date This field displays the system date
when this was created.
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 A user-defined field that can be used
to cross reference expenses to advances
or cash payments.
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: Acct 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.
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: Accr 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 Used 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 Nbr This field contains the line number.
AH2-PO-AOC-CODE Alpha 2 AP198
Element: Aoc Code This field contains the identifier for
the add on cost associated with this
line item.
AH2-GLT-OBJ-ID Numeric 12 AP198
Element: Obj Id This 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.
AH2-ATN-OBJ-ID Numeric 12 AP198
Element: Obj Id This 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.
AH2-ASSET-FLAG Alpha 1 AP198
Element: Asset Flag
AH2-DIST-CODE Alpha 9 AP198
Element: Dist 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
Element: Tax Point
AH2-VAT-REVERSE-FL Alpha 1 AP198
Element: All Flag
AH2-DST-OBJ-ID Numeric 12 AP198
Element: Obj Id This 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.
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 AP198
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: Dist Status
AH2-DIVERSE-CODE Alpha 5 AP198
Element: Diverse Code Diversity Code for Account Payable
Vendors
AH2-DISTRIB-ADJ Numeric 1 AP198
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.
AH2-PULL-FOR-FR-FL Alpha 1
Element: Pull For Fr Fl
AH2-STATEMENT Alpha 22
Element: Invoice Used to identify the invoice.
AH2-TXN-NBR Alpha 22
Element: Transaction
APAPDHIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH2SET1 API-OBJ-ID AP115 AP136
DIST-SEQ-NBR AP180 AP181
AP190 AP28.1
AP28.2 AP300
AP305 AP45.1
AH2SET2 COMPANY Subset
STATEMENT Where (PO-NUMBER = Spaces )
TXN-NBR
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
|
