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. The ACCNTRACT file also defines the Grant Management Multi-Funded Contract. Use GM20 (Multi-funded Contract) to create and maintain Revenue Method = "F" (Multi-funded) contract records. Addition of this new revenue type or Multi-funded contract will allow grant users to define project contracts with multiple funding sources. For Grant Billing, the contract is the intersection of the project and the project funding sources. Multi-Funded Contracts established via GM20 will use GM120 (Grant Expenditure Allocation) and GM121 (Grant Request for Reimbursement) programs to bill.
REFERENCED BY
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
| ||||||||||||
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 |
| |||||||||||||||||||||
Gmcntrfnd | GMCNTRFND |
|
All trademarks and registered trademarks are the property of their
respective owners.