APAPDHIST

UPDATED BY
AP115 AP180 AP181 AP190 AP198 AP28.1
AP28.2 AP300 AP305 AP45.1 AP136 AP275

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AH2-COMPANY
Element: Company
Numeric 4
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.
AP198
AH2-API-OBJ-ID
Element: Obj Id
Numeric 12
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.
AP198
AH2-VENDOR
Element: Vendor
Alpha 9 (Right Justified)
The vendor's identification code.
AP115 AP198
AH2-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice.
AP115 AP198
AH2-SUFFIX
Element: Suffix
Numeric 3
This is the suffix for the invoice.
AP198
AH2-CANCEL-SEQ
Element: Seq Nbr
Numeric 4
An automatically assigned sequence number.
AP198
AH2-DIST-SEQ-NBR
Element: Dist Seq Nbr
Numeric 6
A unique sequence number.
AP198
AH2-ORIG-DIST-SEQ
Element: Dist Seq Nbr
Numeric 6
A unique sequence number.
AP198
AH2-DIST-TYPE
Element: Dist Type
Alpha 1
The distribution type. "D" = Distribution "I" = Inter-company "G" = Gain/Loss
AP198
AH2-PROC-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP198
AH2-POST-OPTION
Element: Post Option
Alpha 1
General Ledger posting option.
AP198
AH2-INVOICE-TYPE
Element: Invoice Type
Alpha 1
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.
AP198
AH2-REC-STATUS
Element: Rec Status
Numeric 1
The record status.
AP198
AH2-INV-CURRENCY
Element: To Base Curr
Alpha 5
AP198
AH2-TAX-RATE
Element: Chrg Rate
Percent 7.5 (Percent)
Charge rate by month.
AP198
AH2-CURR-RATE
Element: Curr Rate
Signed 14.7
The currency rate.
AP198
AH2-ORIG-BASE-AMT
Element: Intl Amt
Signed 18.2
AP198
AH2-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
AP198
AH2-ORIG-TRAN-AMT
Element: Intl Amt
Signed 18.2
AP198
AH2-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AP198
AH2-TO-BASE-AMT
Element: Intl Amt
Signed 18.2
AP198
AH2-TO-BASE-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AP198
AH2-TAXABLE-AMT
Element: Intl Amt
Signed 18.2
AP198
AH2-UNT-AMOUNT
Element: Intl Amt
Signed 18.2
AP198
AH2-DIST-COMPANY
Element: Company
Numeric 4
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.
AP198
AH2-DIS-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
AP198
AH2-DIS-ACCOUNT
Element: Account
Numeric 6
This 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
Element: Sub Acct
Numeric 4
This 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
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this was created.
AP198
AH2-TAX-SEQ-NBR
Element: Tax Seq Nbr
Numeric 4
AP198
AH2-TAX-INDICATOR
Element: Tax Indicator
Numeric 1

1 = Exempt
2 = Taxable
AP198
AH2-TAX-CODE
Element: Tax Code
Alpha 10
This field contains a code representing specific tax information. This must be valid Tax Code.
AP198
AH2-TAX-TYPE
Element: Tax Type
Alpha 1
The type of tax.
AP198
AH2-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AP198
AH2-DST-REFERENCE
Element: Cross Ref
Alpha 10
A user-defined field that can be used to cross reference expenses to advances or cash payments.
AP198
AH2-ACTIVITY
Element: Activity
Alpha 15
Activities 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
Element: Acct Category
Alpha 5
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
AP198
AH2-BILL-CATEGORY
Element: Bill Category
Alpha 32
AP198
AH2-ACCR-CODE
Element: Accr Code
Alpha 4
A user-defined code representing a general ledger accrual account.
AP198
AH2-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
AP198
AH2-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
AP198
AH2-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
AP198
AH2-PO-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
AP198
AH2-PO-AOC-CODE
Element: Aoc Code
Alpha 2
This field contains the identifier for the add on cost associated with this line item.
AP198
AH2-GLT-OBJ-ID
Element: Obj Id
Numeric 12
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.
AP198
AH2-ATN-OBJ-ID
Element: Obj Id
Numeric 12
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.
AP198
AH2-ASSET-FLAG
Element: Asset Flag
Alpha 1
AP198
AH2-DIST-CODE
Element: Dist Code
Alpha 9
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.
AP198
AH2-TAX-POINT
Element: Tax Point
Alpha 1
AP198
AH2-VAT-REVERSE-FL
Element: All Flag
Alpha 1
AP198
AH2-DST-OBJ-ID
Element: Obj Id
Numeric 12
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.
AP198
AH2-MA-CREATE-FL
Element: Account Flag
Alpha 1
AP198
AH2-TAX-USAGE-CD
Element: Tax Usage Cd
Alpha 10
The tax usage coe for the vendor. This filed is required if the AP Company inidcates that VAT reporting required.
AP198
AH2-TRAN-DIST-FLAG
Element: Final Dst Flag
Alpha 1
AP198
AH2-AC-UPD-STATUS
Element: Ac Upd Status
Numeric 1
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.
AP198
AH2-AC-UPD-DATE
Element: Ac Upd Date
Numeric 8 (yyyymmdd)
Last Ac distribtion record status change date.
AP198
AH2-AC-UPD-TIME
Element: Ac Upd Time
Numeric 6 (hhmmss)
Last AC distribution record change time.
AP198
AH2-DIST-STATUS
Element: Dist Status
Derived
AH2-DIVERSE-CODE
Element: Diverse Code
Alpha 5
Diversity Code for Account Payable Vendors
AP198
AH2-DISTRIB-ADJ
Element: Distrib Adj
Numeric 1
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.
AP198
AH2-PULL-FOR-FR-FL
Element: Pull For Fr Fl
Alpha 1
AH2-STATEMENT
Element: Invoice
Alpha 22
Used to identify the invoice.
AH2-TXN-NBR
Element: Transaction
Alpha 22
AH2-RETAINAGE
Element: Flag Num
Numeric 1

0 = No
1 = Yes
AP198
AH2-PROD-TAX-CAT
Element: Prod Tax Cat
Alpha 15
AP198


APAPDHIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AH2SET1 API-OBJ-ID
DIST-SEQ-NBR
AP115 AP136
AP180 AP181
AP190 AP28.1
AP28.2 AP300
AP305 AP45.1
AH2SET2 COMPANY
STATEMENT
TXN-NBR
API-OBJ-ID
DIST-SEQ-NBR
Subset
Where(PO-NUMBER =Spaces)
AH2SET4 DIST-COMPANY
DIS-ACCT-UNIT
DIS-ACCOUNT
DIS-SUB-ACCT
DISTRIB-DATE
API-OBJ-ID
DIST-SEQ-NBR
KeyChange
AP275
AH2SET5 GLT-OBJ-ID
API-OBJ-ID
DIST-SEQ-NBR
KeyChange, Subset
WhereGLT-OBJ-ID !=Zeroes
AH2SET6 DST-OBJ-ID
KeyChange, Subset
WhereDST-OBJ-ID !=Zeroes
AH2SET9 ATN-OBJ-ID
COMPANY
VENDOR
INVOICE
SUFFIX
CANCEL-SEQ
DIST-SEQ-NBR
KeyChange, Subset
WhereATN-OBJ-ID !=Zeroes


APAPDHIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


APAPDHIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apdistpay APDISTPAY
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


File created: Wed Jun 08 20:47:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.