INSTALLATION_CA

(SQL Table)
Index Back

Contracts

Installation options for Contracts

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DFR_REV_PRORATION Character(1) VARCHAR2(1) NOT NULL Proration Method
1=By Days Within Range
2=Evenly Using All Pds
3=Evenly Using Mid-period Rule
4=Evenly/Partial by Days
5=User Defined Proration Method

Default Value: 1

Prompt Table: CA_PRORATION

2 DFR_ACCTG_DT_CD Character(1) VARCHAR2(1) NOT NULL Future Period Accounting Dates
F=First Day in Accounting Period
L=Last Day in Accounting Period
U=User Defined

Default Value: L

3 BOOK_CA_TO_DFR Character(1) VARCHAR2(1) NOT NULL Deferred revenue accounting

Y/N Table Edit

Default Value: Y

4 ALLOW_METHOD_CHG Character(1) VARCHAR2(1) NOT NULL Revenue Recog. Method Override

Y/N Table Edit

Default Value: Y

5 LAST_CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
6 RETAINAGE_OPT Character(1) VARCHAR2(1) NOT NULL Reduce by retainage first

Y/N Table Edit

Default Value: Y

7 RETAINAGE_OPT2 Character(1) VARCHAR2(1) NOT NULL Apply retainage upon release

Y/N Table Edit

Default Value: N

8 COMBO_EDIT_FLG Character(1) VARCHAR2(1) NOT NULL Edit Combinations

Y/N Table Edit

Default Value: Y

9 STAFF_FLG Character(1) VARCHAR2(1) NOT NULL Pay/Bill Management Installed

Y/N Table Edit

Default Value: N

10 CA_REIMB_AGREE Character(1) VARCHAR2(1) NOT NULL Indicator that the installation of Contracts is for Reimbursabale Agreements

Y/N Table Edit

Default Value: N

11 CA_APPORT_AMT_RSTR Character(1) VARCHAR2(1) NOT NULL Indicator that the installation of Contracts is for Reimbursabale Agreements

Y/N Table Edit

Default Value: N

12 CURR_TRANS_DATE Character(3) VARCHAR2(3) NOT NULL Date Type
ACT=Accounting Date
TRN=Transaction Date

Default Value: ACT

13 RUN_CNTL_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Run Control Seq Nbr
14 CALENDAR_SETID Character(5) VARCHAR2(5) NOT NULL Calendar SetID

Prompt Table: SP_SETID_NONVW

15 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

Prompt Table: CA_CALENDAR
Set Control Field: CALENDAR_SETID

16 CALENDAR_ID_2 Character(2) VARCHAR2(2) NOT NULL Detail Calendar

Prompt Table: CA_CALENDAR
Set Control Field: CALENDAR_SETID

17 LINE_ITEM_FLAG Character(1) VARCHAR2(1) NOT NULL Defer Line Attributes to Batch

Default Value: N

18 ACCT_DEF_SETID Character(5) VARCHAR2(5) NOT NULL Acctg Definition SetID

Prompt Table: SP_SETID_NONVW

19 ACCT_DEF_NAME_FF Character(10) VARCHAR2(10) NOT NULL Acctg Definition Fix Fee

Prompt Table: CA_JRNLGEN_DEFN
Set Control Field: ACCT_DEF_SETID

20 ACCT_DEF_NAME_FS Character(10) VARCHAR2(10) NOT NULL TBP Accounting Definition Entry

Prompt Table: CA_JRNLGEN_DEFN
Set Control Field: ACCT_DEF_SETID

21 ACCT_DEF_NAME_PC Character(10) VARCHAR2(10) NOT NULL Acctg Definition Projects

Prompt Table: CA_JRNLGEN_DEFN
Set Control Field: ACCT_DEF_SETID

22 FS_FLAG Character(1) VARCHAR2(1) NOT NULL CRM Flag
23 SPLIT_LINE Character(1) VARCHAR2(1) NOT NULL Split to Match Limit Exactly

Y/N Table Edit

Default Value: N

24 SEPARATE_BIL_REV Character(1) VARCHAR2(1) NOT NULL Flag used by Governement Contracts to separate Billing and Revenue transactions

Default Value: N

25 ENABLE_SUMM_LIMITS Character(1) VARCHAR2(1) NOT NULL Field to Specify to enable Summary Limits for Government Contracts.
N=No
Y=Yes

Default Value: N

26 PRC_ORD_TMPL_ID Character(25) VARCHAR2(25) NOT NULL Processsing Order Template ID

Prompt Table: PRC_ORD_TMPL_HD

27 SEPARATE_BIL_REV_F Character(1) VARCHAR2(1) NOT NULL Flag used to separate Billing and Revenue for Amount based contract lines.

Y/N Table Edit

Default Value: N

28 HOLD_UNPAID_BI Character(1) VARCHAR2(1) NOT NULL Hold Billing on Unpaid Cost

Y/N Table Edit

Default Value: N

29 HOLD_UNPAID_REV Character(1) VARCHAR2(1) NOT NULL Hold Revenue on Unpaid Cost

Y/N Table Edit

Default Value: N

30 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

31 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

Prompt Table: RT_TYPE_TBL