ACPROADJ

UPDATED BY
BR02.3 BR120 BR121 BR122 BR123 BR140
BR151 BR152 BR156 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR300 BR420 BR46.1 BR46.2
BR46.4 BR49.1 BR521 BRIP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
BRJ-HIH-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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-LINE-NBR-MAP
Element: Line Nbr Map
Numeric 6
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-ADJ-LEVEL
Element: Adj Level
Alpha 1

I = Contract
D = Invoice Summarization
P = Posting Activity
A = Posting Activity/Acct Category
T = Transaction Detail
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-REASON-CODE
Element: Reason Code
Alpha 4
This field contains the reason code, which indicates the cause for credit memos.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-CONTRACT
Element: Contract
Alpha 15
Activity Management contract.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-BILL-ADJ-AMT
Element: Intl Amt
Signed 18.2
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-REV-ADJ-AMT
Element: Intl Amt
Signed 18.2
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-ADJUST-UNIT
Element: Units Amount
Signed 15.2
This is the units amount included in the file.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-TRAN-DATE
Element: Tran Date
Numeric 8 (yyyymmdd)
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-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
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-RESOURCE-TYPE
Element: Resource Type
Alpha 1
The type of resource. Valid values include: P - AC Person Q - Equipment E - Employee V - Vendor A - Asset
A = Asset
E = Employee
P = Person
Q = Equipment
V = Vendor
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-RESOURCE-COMP
Element: Resource Comp
Numeric 4
Resource 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.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-RESOURCE-CODE
Element: Resource Code
Alpha 10
The code identifying the resource assigned to the activity or activity group.
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-MATRIX-CAT
Element: Attribute
Alpha 12
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4
BRJ-MX-VALUE
Element: Mx Value 1
Alpha 32
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR46.1
BR46.2 BR46.4


ACPROADJ FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
BRJSET1 HIH-OBJ-ID
LINE-NBR-MAP
ADJ-LEVEL
REASON-CODE
BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR300 BR420
BR46.1 BR46.2
BR46.4 BR49.1
BR521 BRIP.1
BRJSET3 CONTRACT
HIH-OBJ-ID
LINE-NBR-MAP
ADJ-LEVEL
REASON-CODE
KeyChange


ACPROADJ FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Accntract ACCNTRACT Required
BRJ-CONTRACT->CNT-CONTRACT (CNTSET1)
Achistdtl ACHISTDTL Required
BRJ-HIH-OBJ-ID->HDT-OBJ-ID
BRJ-LINE-NBR-MAP->HDT-LINE-NBR
Achisthdr ACHISTHDR Required
BRJ-HIH-OBJ-ID->HIH-OBJ-ID


File created: Thu Jun 09 11:11:00 2016

Home
Contact Us



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