ACCNTRACT

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
ACVW.1 AP178 EX542 MX123 MX500 SN02.1
SNAC.1


UPDATED BY
AC10.1 AC10.5 AC200 AC210 ACAC.1 AP125
AP126 AP131 AP170 AP193 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP211
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP520 API1.1 API2.1 CB10.1 CB15.1
CB15.2 CB150 CB191 CB20.1 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 CB55.1 CB554
EE11.1 EE135 EE20.3 EE35.1 EE35.2 EE520
GL146 GL165 GL170 GL197 GL299 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL70.1 GL70.2 GL70.3 GL70.5 GL70.6 GL75.1
EX545 IFEB.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MAI1.1 PO136 PO190 PO300 PO520 POCP.1
POI3.1 POIG.1 POII.1 POIJ.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
AC10.1
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


ACCNTRACT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CNTSET1 CONTRACT
...
AC10.1 AC10.5
AC200 AC210
ACAC.1 ACVW.1
AP125 AP126
AP131 AP170
AP178 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP211
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
CNTSET2 ACTIVITY
CONTRACT
KeyChange
...
AC10.1 AC10.5
AC200 AC210
ACAC.1 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP211
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP520
API1.1 API2.1
CB10.1 CB15.1
CNTSET3 COMPANY
CUSTOMER
AC-CUSTOMER-ID
CONTRACT
KeyChange
CNTSET4 LETTER-CREDIT
CONTRACT
ACTIVITY
KeyChange
AC200 AC210
AP211 GL299
CNTSET5 COMPANY
CUSTOMER
CONTRACT
KeyChange


ACCNTRACT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
CNT-ACTIVITY->ACV-ACTIVITY (ACVSET1)
Acaddlcntr ACADDLCNTR Not Required
ACV-ACTIVITY-GRP->ADN-ACTIVITY-GRP
CNT-CONTRACT->ADN-CONTRACT
Accustomer ACCUSTOMER Required
CNT-COMPANY->CMR-COMPANY
CNT-CUSTOMER->CMR-CUSTOMER
CNT-AC-CUSTOMER-ID->CMR-AC-CUSTOMER-ID
Acmilestn ACMILESTN Not Required
Valid When CNT-REVENUE-MTHD ="M"
CNT-ACTIVITY->MLS-ACTIVITY
"R"->MLS-MILESTONE-CAT
Arcomp ARCOMP Required
CNT-COMPANY->ACO-COMPANY
Arcustomer ARCUSTOMER Required
CNT-COMPANY->ACM-COMPANY
CNT-CUSTOMER->ACM-CUSTOMER


ACCNTRACT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acceiling ACCEILING
CNT-ACTIVITY->CEH-ACTIVITY
  CEH-ACCT-CATEGORY
  CEH-SUM-ACCT-CAT
  CEH-CTR-CAT-GRP
  CEH-MATRIX-CAT
Acchgordx Tot ACCHGORDX
CNT-CONTRACT->CHX-ACTIVITY-GRP
CNT-ACTIVITY->CHX-ACTIVITY
Zeroes->CHX-BUDGET-NBR
  CHX-CHG-ORDER-NBR
  CHX-ACCT-CATEGORY
  CHX-FISCAL-YEAR
  CHX-PERIOD
Accntracct ACCNTRACCT
CNT-CONTRACT->CNA-CONTRACT
  CNA-ACCT-CATEGORY
Accntractx ACCNTRACTX
CNT-CONTRACT->CNX-CONTRACT
  CNX-ACTIVITY
Acctrcatg ACCTRCATG
CNT-CONTRACT->BCG-CONTRACT
  BCG-CTR-CAT-GRP
Acctrcatgx ACCTRCATGX
CNT-CONTRACT->BCX-CONTRACT
  BCX-ACCT-CATEGORY
Achistdtl ACHISTDTL
CNT-CONTRACT->HDT-CONTRACT
  HDT-OBJ-ID
  HDT-LINE-NBR
Achisthdr ACHISTHDR
CNT-CONTRACT->HIH-CONTRACT
  HIH-COMPANY
  HIH-CUSTOMER
  HIH-AC-CUSTOMER-ID
  HIH-INVOICE
  HIH-OBJ-ID
Aracpivot ARACPIVOT
CNT-CONTRACT->CCP-CONTRACT
  CCP-DUE-DATE
  CCP-TRANS-TYPE
  CCP-BATCH-NBR
  CCP-TRANSACTION
  CCP-PAYMENT-SEQ
  CCP-COMPANY
Gmcntrfnd GMCNTRFND
CNT-CONTRACT->GCF-CONTRACT
  GCF-GRANT


File created: Wed Jun 08 20:48:19 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.