ACPROADJ – No description in the Lawson data dictionary

System
AC Billing Revenue (BR)
Prefix
BRJ
Primary key
HIH-OBJ-ID, LINE-NBR-MAP, ADJ-LEVEL, REASON-CODE
Fields
21
Updated by
10 programs
Referenced by
12 programs

ACPROADJ is a Lawson AC Billing Revenue table (prefix BRJ); no description in the lawson data dictionary. It is indexed by HIH-OBJ-ID, LINE-NBR-MAP, ADJ-LEVEL, REASON-CODE (BRJSET1); alternate indexes: BRJSET3. It is related 1:1 to ACCNTRACT, ACHISTDTL and ACHISTHDR. It is updated by BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR300, BR46.1, BR46.2 and 2 more and referenced by BR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 and 4 more. The table has 21 fields, 2 indexes and 3 documented relations.

About ACPROADJ

No description in the Lawson data dictionary.

Fields (21)

Column = COBOL field name without the BRJ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
BRJ-HIH-OBJ-ID PK
HIH_OBJ_ID		Numeric 12This 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 PK
LINE_NBR_MAP		Numeric 6—BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
BRJ-ADJ-LEVEL PK
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 PK
REASON_CODE		Alpha 4This 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
CONTRACT		Alpha 15Activity Management contract.BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
BRJ-BILL-ADJ-AMT
BILL_ADJ_AMT		Signed 18.2—BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
BRJ-REV-ADJ-AMT
REV_ADJ_AMT		Signed 18.2—BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
BRJ-ADJUST-UNIT
ADJUST_UNIT		Signed 15.2This 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
TRAN_DATE		Numeric 8 (yyyymmdd)—BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
BRJ-DESCRIPTION
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
ACTIVITY		Alpha 15Activities 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
ACCT_CATEGORY		Alpha 5Account 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 thruBR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
BRJ-COMPANY
COMPANY		Numeric 4Identifies 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
ACCT_UNIT		Alpha 15The 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
ACCOUNT		Numeric 6This 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
SUB_ACCT		Numeric 4This 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
RESOURCE_TYPE		Alpha 1The 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
RESOURCE_COMP		Numeric 4Resource 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
RESOURCE_CODE		Alpha 10The 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
MATRIX_CAT		Alpha 12—BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4
BRJ-MX-VALUE
MX_VALUE		Alpha 32—BR20.1, BR20.2, BR20.3, BR20.4, BR20.5, BR46.1, BR46.2, BR46.4

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
BRJSET1HIH-OBJ-ID, LINE-NBR-MAP, ADJ-LEVEL, REASON-CODEPrimaryBR02.3, BR120, BR121, BR122, BR123, BR140, BR151, BR152 +14 more
BRJSET3CONTRACT, HIH-OBJ-ID, LINE-NBR-MAP, ADJ-LEVEL, REASON-CODEKeyChange—

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AccntractACCNTRACTRequiredBRJ-CONTRACT → CNT-CONTRACT (CNTSET1)
AchistdtlACHISTDTLRequiredBRJ-HIH-OBJ-ID → HDT-OBJ-ID, BRJ-LINE-NBR-MAP → HDT-LINE-NBR
AchisthdrACHISTHDRRequiredBRJ-HIH-OBJ-ID → HIH-OBJ-ID

Programs

Updated by (10)

Referenced by (12)