INSTALLATION_CA(SQL Table) |
Index Back |
---|---|
ContractsInstallation 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
|
16 | CALENDAR_ID_2 | Character(2) | VARCHAR2(2) NOT NULL |
Detail Calendar
Prompt Table:
CA_CALENDAR
|
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
|
20 | ACCT_DEF_NAME_FS | Character(10) | VARCHAR2(10) NOT NULL |
TBP Accounting Definition Entry
Prompt Table:
CA_JRNLGEN_DEFN
|
21 | ACCT_DEF_NAME_PC | Character(10) | VARCHAR2(10) NOT NULL |
Acctg Definition Projects
Prompt Table:
CA_JRNLGEN_DEFN
|
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 |