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.