Activity Contract
The ACCNTRACT file defines the activity contract. Contract data is entered and maintained via BR10 (Contract Parameters). Contract activities are defined via AC10 (Activity) by entering a "C" in the level type field. Only one activity in a branch can be defined as a contract activity. Contract information defines the revenue method, contract amount, contract currency, customer, and billed/unbilled accounts / account categories for billing and revenue.
REFERENCED BY
AC10.1 | AC120 | AC300 | BR10.1 | BR10.2 | BR10.9 |
BR12.2 | BR120 | BR122 | BR130 | BR131 | BR140 |
BR20.1 | BR20.2 | BR20.3 | BR20.4 | BR20.5 | BR22.1 |
BR300 | BR46.1 | BR46.2 | BR46.4 | BR521 | BR530 |
BR580 | BRIP.1 | BR11.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CNT-CONTRACT Element: Contract | Alpha 15 Activity Management contract. |
|
||||||||||||||||||
CNT-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. |
|
||||||||||||||||||
CNT-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||||||||||||||||||
CNT-REVENUE-MTHD Element: Revenue Mthd | Alpha 1 A = Accrual P = Percent Complete C = Completed Contract 9 = User Defined M = Milestone T = Cost Plus 1 = Product 2 = Maintenance 3 = Prod and Maint F = Multi Funded Contract |
|
||||||||||||||||||
CNT-CONTRCT-AMT-ND Element: Contrct Amt Nd | Numeric 1 |
|
||||||||||||||||||
CNT-CONTRACT-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||
CNT-FIXED-EXCHANGE Element: Fixed Exchange | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||
CNT-MULT-DIV Element: Mult Div | Alpha 1 M = Multiply D = Divide |
|
||||||||||||||||||
CNT-EXCHANGE-RATE Element: Acct Rate | Signed 14.7 |
|
||||||||||||||||||
CNT-CUST-PO-NBR Element: Cust Po Nbr | Alpha 22 |
|
||||||||||||||||||
CNT-GROUP Element: Group | Alpha 15 |
|
||||||||||||||||||
CNT-COMBINE-CONT Element: Combine Cont | Alpha 1 C = Contract/Non-Segment P = Posting/Segment 1 = Posting/Acct Cat/Segment 2 = Contract/Acct Cat/Non-Segment |
|
||||||||||||||||||
CNT-PCT-CMPLT-MTHD Element: Pct Cmplt Mthd | Alpha 1 A = Alternative A (% Complete) B = Alternative B (Gross Margin) |
|
||||||||||||||||||
CNT-BUDGET-TYPE Element: Budget Type | Alpha 1 A = Amount U = Units |
|
||||||||||||||||||
CNT-TOTAL-BILLED Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-TOT-UNT-BILLED Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-TOT-REV-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-TOT-REV-UNIT Element: Tot Rev Unit | Signed 15.2 |
|
||||||||||||||||||
CNT-CUSTOMER Element: Customer | Alpha 9 (Right Justified) This field contains the number that represents a customer. |
|
||||||||||||||||||
CNT-AC-CUSTOMER-ID Element: Ac Customer Id | Alpha 5 |
|
||||||||||||||||||
CNT-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. |
|
||||||||||||||||||
CNT-UNBL-AR-GL-CD Element: Unbl Ar Gl Cd | Alpha 4 |
|
||||||||||||||||||
CNT-UNBL-ACCT-CAT 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 |
|
||||||||||||||||||
CNT-ADV-BILL-GL-CD Element: Adv Bill Gl Cd | Alpha 4 |
|
||||||||||||||||||
CNT-ADV-BL-ACT-CAT 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 |
|
||||||||||||||||||
CNT-PS-THRU-GL-CD Element: Ps Thru Gl Cd | Alpha 4 |
|
||||||||||||||||||
CNT-PS-THRU-CAT 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 |
|
||||||||||||||||||
CNT-TOLERANCE-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-AUTO-JRL-CD Element: Auto Jrl Cd | Alpha 4 |
|
||||||||||||||||||
CNT-JOURNAL-CODE Element: Journal Code | Alpha 4 |
|
||||||||||||||||||
CNT-REVENUE-FLAG Element: Revenue Flag | Alpha 1 This flag identifies whether an activity/account category is eligible for revenue recognition. I = Include E = Exclude |
|
||||||||||||||||||
CNT-BILLING-FLAG Element: Billing Flag | Alpha 1 I = Include E = Exclude |
|
||||||||||||||||||
CNT-APPLY-TOL-AMT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-APPLY-TOL-UNIT Element: Apply Tol Unit | Signed 15.2 |
|
||||||||||||||||||
CNT-DFLT-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. |
|
||||||||||||||||||
CNT-DFLT-ACCT-CAT 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 |
|
||||||||||||||||||
CNT-DFLT-COMPANY Element: Dflt Company | Numeric 4 |
|
||||||||||||||||||
CNT-DFLT-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. |
|
||||||||||||||||||
CNT-DFLT-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. |
|
||||||||||||||||||
CNT-DFLT-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. |
|
||||||||||||||||||
CNT-RETAIN-GL-CD Element: Retain Gl Cd | Alpha 4 |
|
||||||||||||||||||
CNT-RETAIN-CAT Element: Retain Cat | Alpha 5 |
|
||||||||||||||||||
CNT-REAL-METHOD-FL Element: Real Method Fl | Alpha 1 1 = Prorate 2 = No Prorate; Use Defaults 3 = No Prorate; Use Activity |
|
||||||||||||||||||
CNT-REAL-AU-FL Element: Real Au Fl | Alpha 1 A = Activity Company Acct Unit T = Trans Company Acct Unit |
|
||||||||||||||||||
CNT-FORCE-DETAIL Element: Force Detail | Alpha 1 This field determines whether this individual transaction can be summarized along with other like transactions. Y = Yes N = No |
|
||||||||||||||||||
CNT-RET-ACCOUNT Element: Ret Account | Numeric 6 |
|
||||||||||||||||||
CNT-RET-SUB-ACCT Element: Ret Sub Acct | Numeric 4 |
|
||||||||||||||||||
CNT-BILL-PAID-AP Element: Bill Paid Ap | Alpha 1 This is the "Exclude Unpaid AP" flag maintained in the contract parameters (BR10). The values are: Y = Yes N = No |
|
||||||||||||||||||
CNT-LETTER-CREDIT Element: Letter Credit | Alpha 20 |
|
||||||||||||||||||
CNT-DOCUMENT-NBR Element: Document Numbr | Alpha 20 |
|
||||||||||||||||||
CNT-EX-CEILINGS Element: Ex Ceilings | Alpha 1 Y = Yes N = No |
|
||||||||||||||||||
CNT-PURGE-FL Element: Purge Fl | Alpha 1 |
|
||||||||||||||||||
CNT-MT-RENEW-DATE Element: Mt Renew Date | Derived |
|
||||||||||||||||||
CNT-BILLING-METHOD Element: Billing Method | Numeric 1 |
|
||||||||||||||||||
CNT-FUND-AMOUNT Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-EXPENDITURES Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-RECEIVABLE Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-RECEIPTS Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-REMAINING Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-AMT-TO-CLAIM Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||
CNT-LST-ALLOC-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||
CNT-STATUS Element: Status | Numeric 1 0 = Unapproved 1 = Approved |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CNTSET1 |
CONTRACT |
|
|||||||||||||||||||||||||||||||||||||
CNTSET2 |
ACTIVITY CONTRACT |
|
| ||||||||||||||||||||||||||||||||||||
CNTSET3 |
COMPANY CUSTOMER AC-CUSTOMER-ID CONTRACT |
|
| ||||||||||||||||||||||||||||||||||||
CNTSET4 |
LETTER-CREDIT CONTRACT ACTIVITY |
|
| ||||||||||||||||||||||||||||||||||||
CNTSET5 |
COMPANY CUSTOMER CONTRACT |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acactivity | ACACTIVITY |
Required
| ||||||||||||
Acaddlcntr | ACADDLCNTR |
Not Required
| ||||||||||||
Accntbod | ACCNTBOD |
Not Required, Delete Cascades
| ||||||||||||
Accntrpcd | ACCNTRPCD |
Not Required
| ||||||||||||
Accustdtl | ACCUSTDTL |
Required
| ||||||||||||
Accustomer | ACCUSTOMER |
Required
| ||||||||||||
Acfeedtl | ACFEEDTL |
Required
| ||||||||||||
Acmilestn | ACMILESTN |
Not Required
| ||||||||||||
Acprodhdr | ACPRODHDR |
Not Required
| ||||||||||||
Arcomp | ARCOMP |
Required
| ||||||||||||
Arcustomer | ARCUSTOMER |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acceiling | ACCEILING |
| |||||||||||||||||||||
Acchgordx Tot | ACCHGORDX |
| |||||||||||||||||||||
Acclgtrans | ACCLGTRANS |
| |||||||||||||||||||||
Accntmod | ACCNTMOD |
| |||||||||||||||||||||
Accntracct | ACCNTRACCT |
| |||||||||||||||||||||
Accntractx | ACCNTRACTX |
| |||||||||||||||||||||
Accntrcat | ACCNTRCAT |
| |||||||||||||||||||||
Accontacts | ACCONTACTS |
| |||||||||||||||||||||
Acctrcatg | ACCTRCATG |
| |||||||||||||||||||||
Acctrcatgx | ACCTRCATGX |
| |||||||||||||||||||||
Acfeebal | ACFEEBAL |
| |||||||||||||||||||||
Achistclg | ACHISTCLG |
| |||||||||||||||||||||
Achistcnsl | ACHISTCNSL |
| |||||||||||||||||||||
Achistdtl | ACHISTDTL |
| |||||||||||||||||||||
Achisthdr | ACHISTHDR |
| |||||||||||||||||||||
Acmnthdr | ACMNTHDR |
| |||||||||||||||||||||
Acmntsch | ACMNTSCH |
| |||||||||||||||||||||
Acpmhsthdr | ACPMHSTHDR |
| |||||||||||||||||||||
Acproadj | ACPROADJ |
| |||||||||||||||||||||
Acprodinv | ACPRODINV |
| |||||||||||||||||||||
Acretain | ACRETAIN |
| |||||||||||||||||||||
Acretng | ACRETNG |
| |||||||||||||||||||||
Aracpivot | ARACPIVOT |
| |||||||||||||||||||||
Arpayment | ARPAYMENT |
| |||||||||||||||||||||
Gmcntrfnd | GMCNTRFND |
|
All trademarks and registered trademarks are the property of their
respective owners.