| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_CA_NONVW
|
| 2 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 3 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table:
SP_BUCABI_NONVW
|
| 4 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 5 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 6 |
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
|
| 7 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE_EF_VW
Set Control Field: BUSINESS_UNIT_BI
|
| 8 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC_EF_VW
Set Control Field: BUSINESS_UNIT_BI
|
| 9 |
SHIP_FROM_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship From Location
Prompt Table:
LOCATION_TBL
Set Control Field: BUSINESS_UNIT_BI
|
| 10 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
Prompt Table:
DST_CODE_UAR_VW
|
| 11 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 12 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 13 |
OPR_DEF_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Operator Default Flag
Y/N Table Edit
Default Value: N
|
| 14 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
Prompt Table:
CA_TYPE_TBL
|
| 15 |
TAX_PPD_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Prepaid Tax Timing
INT=Tax on Initial Bill
UTL=Tax on Utilization
|
| 16 |
CONTRACT_ADMIN |
Character(40) |
VARCHAR2(40) NOT NULL |
Contract Administrator defined on CABU.
Prompt Table:
MEMBER_VW
|
| 17 |
CONTR_LEGAL_ENTITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Legal Entity
Prompt Table:
CA_LEGAL_ENTITY
|
| 18 |
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
|
| 19 |
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
|
| 20 |
DFR_REV_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Liability Override
Y/N Table Edit
Default Value: Y
|
| 21 |
ALLOW_METHOD_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Recog. Method Override
Y/N Table Edit
Default Value: Y
|
| 22 |
CA_NOTES_DEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if Contract Internal Notes can be deleted
Y/N Table Edit
Default Value: Y
|
| 23 |
CA_NOTES_UPD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if Contract Internal Notes can be deleted
Y/N Table Edit
Default Value: Y
|
| 24 |
DST_RULE_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Dist Rule Code
Prompt Table:
DST_RULE_OM
|
| 25 |
BUSINESS_UNIT_OM |
Character(5) |
VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table:
SP_BUCAOM_NONVW
|
| 26 |
COMBO_EDIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Combinations
|
| 27 |
CA_PGP_LIQ_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Liquidation rate
|
| 28 |
CA_PGP_RATE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Progress Payment Rate
|
| 29 |
REVIEW_TIMING |
Number(3,0) |
SMALLINT NOT NULL |
Review Timing
|
| 30 |
REVIEW_TIMING_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Timing Option
C=Control
D=Default
Default Value: D
|
| 31 |
BP_DTL_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Detail Template ID
Prompt Table:
CA_BP_DTL_TMPL
Set Control Field: SETID
|
| 32 |
CHG_BIL_RETRO_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Billing Retroactively
Y/N Table Edit
Default Value: Y
|
| 33 |
CHG_REV_RETRO_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Change Revenue Retroactively
Y/N Table Edit
Default Value: Y
|
| 34 |
CA_BP_TMPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Template
Prompt Table:
CA_PPDBPTMPL_VW
|
| 35 |
USE_FOR_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use for All Lines in Contract
Y/N Table Edit
Default Value: N
|
| 36 |
DST_ID_DFR |
Character(10) |
VARCHAR2(10) NOT NULL |
Deferred Distribution Code
Prompt Table:
DST_CODE_DFR_VW
|
| 37 |
BP_DTL_TMPL_TMP |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Plan Detail Template ID
Prompt Table:
CA_BP_DTL_TMPL
|
| 38 |
PVN_GEN_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract
C=Contract Number
CL=Contract Number/Contract Line
CP=Contract Number/Project
|
| 39 |
CONS_TPL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Contracts Console Template ID
Default Value: CONTRACTS
Prompt Table:
CA_CONS_CABU_VW
|
| 40 |
SEPARATE_BIL_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag used by Governement Contracts to separate Billing and Revenue transactions
Y/N Table Edit
Default Value: INSTALLATION_CA.SEPARATE_BIL_REV
|
| 41 |
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: INSTALLATION_CA.SEPARATE_BIL_REV_F
|
| 42 |
CONTRACT_ROLE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Role
Prompt Table:
CA_CONTR_ROLE
|
| 43 |
REVENUE_PROFILE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Revenue Profile
Prompt Table:
CA_REV_PROFILE
|
| 44 |
SHARE_BUNDLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Share Bundling Attributes
Y/N Table Edit
Default Value: N
|
| 45 |
USE_PC_CFS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Project ChartFields
Y/N Table Edit
Default Value: Y
|
| 46 |
REV_CONVERG_COMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Revenue Convergence Completed
Y/N Table Edit
Default Value: N
|
| 47 |
AUTO_RVW_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Review for Revenue
Y/N Table Edit
Default Value: Y
|
| 48 |
OVRD_AUTO_RVW_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow to Override Review Required for Revenue option at contract level
Y/N Table Edit
Default Value: N
|