ACTEMPCNT – Activity Contract Template

System: AC Billing Revenue (BR)
Prefix: BRA
Primary key: TEMPLATE
Fields: 38
Updated by: 1 program
Referenced by: 4 programs

ACTEMPCNT is the Activity Contract Template table in Lawson AC Billing Revenue (prefix BRA). It is indexed by TEMPLATE (BRASET1). It is updated by BR47.1 and referenced by AC56.1, AC560, BR10.1 and BR247. The table has 38 fields, 1 index and 0 documented relations.

About ACTEMPCNT

No description in the Lawson data dictionary.

Fields (38)

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

Field / column	Type	Description & values	Updated by
`BRA-TEMPLATE` PK TEMPLATE	Alpha 15	The name of the template the detail records are associated to.	BR47.1
`BRA-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	BR47.1
`BRA-REVENUE-MTHD` REVENUE_MTHD	Alpha 1	— `P` Percent Complete `C` Completed Contract `A` Full Accrual `M` Milestone `T` Cost Plus Full Accrual `9` User Defined `1` Product `2` Maintenance `3` Prod and Maint	BR47.1
`BRA-GROUP` GROUP	Alpha 15	—	BR47.1
`BRA-COMBINE-CONT` COMBINE_CONT	Alpha 1	— `P` Posting/segment `C` Contract/Non-Segment `1` Posting/Acct Cat/Segment `2` Contract/Acct Cat/Non-Segment	BR47.1
`BRA-PCT-CMPLT-MTHD` PCT_CMPLT_MTHD	Alpha 1	— `A` Method A - Percent Complete `B` Method B - Gross Margin	BR47.1
`BRA-BUDGET-TYPE` BUDGET_TYPE	Alpha 1	— `A` Amount `U` Units	BR47.1
`BRA-UNBL-AR-GL-CD` UNBL_AR_GL_CD	Alpha 4	—	BR47.1
`BRA-UNBL-ACCT-CAT` UNBL_ACCT_CAT	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	BR47.1
`BRA-ADV-BILL-GL-CD` ADV_BILL_GL_CD	Alpha 4	—	BR47.1
`BRA-ADV-BL-ACT-CAT` ADV_BL_ACT_CAT	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	BR47.1
`BRA-PS-THRU-GL-CD` PS_THRU_GL_CD	Alpha 4	—	BR47.1
`BRA-PS-THRU-CAT` PS_THRU_CAT	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	BR47.1
`BRA-AUTO-JRL-CD` AUTO_JRL_CD	Alpha 4	—	BR47.1
`BRA-REVENUE-FLAG` REVENUE_FLAG	Alpha 1	This flag identifies whether an activity/account category is eligible for revenue recognition. `I` Include `E` Exclude	BR47.1
`BRA-BILLING-FLAG` BILLING_FLAG	Alpha 1	— `I` Include `E` Exclude	BR47.1
`BRA-DFLT-ACCT-CAT` DFLT_ACCT_CAT	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	BR47.1
`BRA-DFLT-COMPANY` DFLT_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.	BR47.1
`BRA-DFLT-ACCT-UNIT` DFLT_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.	BR47.1
`BRA-RETAIN-GL-CD` RETAIN_GL_CD	Alpha 4	—	BR47.1
`BRA-RETAIN-CAT` RETAIN_CAT	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	BR47.1
`BRA-REAL-METHOD-FL` REAL_METHOD_FL	Alpha 1	— `1` Prorate `2` No Prorate Use Defaults `3` No Prorate Activity	BR47.1
`BRA-REAL-AU-FL` REAL_AU_FL	Alpha 1	— `A` Activity Company Acct Unit `T` Trans Company Acct Unit	BR47.1
`BRA-FORCE-DETAIL` FORCE_DETAIL	Alpha 1	This field determines whether this individual transaction can be summarized along with other like transactions. `Y` Yes `N` No	BR47.1
`BRA-RET-ACCOUNT` RET_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.	BR47.1
`BRA-RET-SUB-ACCT` RET_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.	BR47.1
`BRA-REVENUE-GL-CD` REVENUE_GL_CD	Alpha 4	—	BR47.1
`BRA-REV-ACCT-CAT` REV_ACCT_CAT	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	BR47.1
`BRA-REV-ACCT` REV_ACCT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	BR47.1
`BRA-REV-SUB-ACCT` REV_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.	BR47.1
`BRA-LOSS-GL-CD` LOSS_GL_CD	Alpha 4	—	BR47.1
`BRA-LOSS-ACCT-CAT` LOSS_ACCT_CAT	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	BR47.1
`BRA-RSRV-LSS-GL-CD` RSRV_LSS_GL_CD	Alpha 4	—	BR47.1
`BRA-ADJ-ACCT-CAT` ADJ_ACCT_CAT	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	BR47.1
`BRA-ADJ-ACCOUNT` ADJ_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.	BR47.1
`BRA-ADJ-SUB-ACCT` ADJ_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.	BR47.1
`BRA-BILL-PAID-AP` BILL_PAID_AP	Alpha 1	— `Y` Yes `N` No	BR47.1
`BRA-EX-CEILINGS` EX_CEILINGS	Alpha 1	— `Y` Yes `N` No	BR47.1

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`BRASET1`	`TEMPLATE`	Primary		AC56.1, AC560, BR10.1, BR247, BR47.1

ACTEMPCNT – Activity Contract Template

About ACTEMPCNT

Fields (38)

Indexes (1)

Programs

Updated by (1)

Referenced by (4)