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. |
|
||
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. |
|
||
AH2-VENDOR Element: Vendor | Alpha 9 (Right Justified) The vendor's identification code. |
|
||
AH2-INVOICE Element: Invoice | Alpha 22 Used to identify the invoice. |
|
||
AH2-SUFFIX Element: Suffix | Numeric 3 This is the suffix for the invoice. |
|
||
AH2-CANCEL-SEQ Element: Seq Nbr | Numeric 4 An automatically assigned sequence number. |
|
||
AH2-DIST-SEQ-NBR Element: Dist Seq Nbr | Numeric 6 A unique sequence number. |
|
||
AH2-ORIG-DIST-SEQ Element: Dist Seq Nbr | Numeric 6 A unique sequence number. |
|
||
AH2-DIST-TYPE Element: Dist Type | Alpha 1 The distribution type. "D" = Distribution "I" = Inter-company "G" = Gain/Loss |
|
||
AH2-PROC-LEVEL Element: Process Level | Alpha 5 This field contains the process level, which is the reporting hierarchy below company. |
|
||
AH2-POST-OPTION Element: Post Option | Alpha 1 General Ledger posting option. |
|
||
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. |
|
||
AH2-REC-STATUS Element: Rec Status | Numeric 1 The record status. |
|
||
AH2-INV-CURRENCY Element: To Base Curr | Alpha 5 |
|
||
AH2-TAX-RATE Element: Chrg Rate | Percent 7.5 (Percent) Charge rate by month. |
|
||
AH2-CURR-RATE Element: Curr Rate | Signed 14.7 The currency rate. |
|
||
AH2-ORIG-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||
AH2-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||
AH2-ORIG-TRAN-AMT Element: Intl Amt | Signed 18.2 |
|
||
AH2-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
AH2-TO-BASE-AMT Element: Intl Amt | Signed 18.2 |
|
||
AH2-TO-BASE-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
AH2-TAXABLE-AMT Element: Intl Amt | Signed 18.2 |
|
||
AH2-UNT-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
AH2-DISTRIB-DATE Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||
AH2-TAX-SEQ-NBR Element: Tax Seq Nbr | Numeric 4 |
|
||
AH2-TAX-INDICATOR Element: Tax Indicator | Numeric 1 1 = Exempt 2 = Taxable |
|
||
AH2-TAX-CODE Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||
AH2-TAX-TYPE Element: Tax Type | Alpha 1 The type of tax. |
|
||
AH2-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
AH2-BILL-CATEGORY Element: Bill Category | Alpha 32 |
|
||
AH2-ACCR-CODE Element: Accr Code | Alpha 4 A user-defined code representing a general ledger accrual account. |
|
||
AH2-PO-NUMBER Element: Po Number | Alpha 14 (Right Justified) This field contains the number representing the purchase order. |
|
||
AH2-PO-RELEASE Element: Po Release | Numeric 4 Used to identify a purchase order release (created from a Blanket or Standing order). |
|
||
AH2-PO-CODE Element: Po Code | Alpha 4 This is the purchase order code. |
|
||
AH2-PO-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||
AH2-PO-AOC-CODE Element: Aoc Code | Alpha 2 This field contains the identifier for the add on cost associated with this line item. |
|
||
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. |
|
||
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. |
|
||
AH2-ASSET-FLAG Element: Asset Flag | Alpha 1 |
|
||
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. |
|
||
AH2-TAX-POINT Element: Tax Point | Alpha 1 |
|
||
AH2-VAT-REVERSE-FL Element: All Flag | Alpha 1 |
|
||
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. |
|
||
AH2-MA-CREATE-FL Element: Account Flag | Alpha 1 |
|
||
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. |
|
||
AH2-TRAN-DIST-FLAG Element: Final Dst Flag | Alpha 1 |
|
||
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. |
|
||
AH2-AC-UPD-DATE Element: Ac Upd Date | Numeric 8 (yyyymmdd) Last Ac distribtion record status change date. |
|
||
AH2-AC-UPD-TIME Element: Ac Upd Time | Numeric 6 (hhmmss) Last AC distribution record change time. |
|
||
AH2-DIST-STATUS Element: Dist Status | Derived |
|
||
AH2-DIVERSE-CODE Element: Diverse Code | Alpha 5 Diversity Code for Account Payable Vendors |
|
||
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. |
|
||
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 |
|
||
AH2-PROD-TAX-CAT Element: Prod Tax Cat | Alpha 15 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AH2SET1 |
API-OBJ-ID DIST-SEQ-NBR |
|
| ||||||||||||||||
AH2SET2 |
COMPANY STATEMENT TXN-NBR API-OBJ-ID DIST-SEQ-NBR |
|
|||||||||||||||||
AH2SET4 |
DIST-COMPANY DIS-ACCT-UNIT DIS-ACCOUNT DIS-SUB-ACCT DISTRIB-DATE API-OBJ-ID DIST-SEQ-NBR |
|
| ||||||||||||||||
AH2SET5 |
GLT-OBJ-ID API-OBJ-ID DIST-SEQ-NBR |
|
|||||||||||||||||
AH2SET6 |
DST-OBJ-ID |
|
|||||||||||||||||
AH2SET9 |
ATN-OBJ-ID COMPANY VENDOR INVOICE SUFFIX CANCEL-SEQ DIST-SEQ-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Actrans | ACTRANS |
Not Required
| |||||||||||||||
Apapihist | APAPIHIST |
Required
| |||||||||||||||
Apcompany | APCOMPANY |
Required
| |||||||||||||||
Apuavhist | APUAVHIST |
Not Required
| |||||||||||||||
Apvenmast | APVENMAST |
Required
| |||||||||||||||
Asset | APAPSHIST |
Not Required
| |||||||||||||||
Dstusrfld | APDFLHIST |
Not Required
| |||||||||||||||
Glmaster | GLMASTER |
Required
| |||||||||||||||
Glsystem Orig | GLSYSTEM |
Required
| |||||||||||||||
Glsystem To | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apdistpay | APDISTPAY |
|
All trademarks and registered trademarks are the property of their
respective owners.