| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
POST_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
POSTING SEQUENCE NUMBER
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 5 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 6 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 7 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 8 |
SETID_AN |
Character(7) |
VARCHAR2(7) NOT NULL |
SET ID
|
| 9 |
SETID_BILL |
Character(7) |
VARCHAR2(7) NOT NULL |
SET ID BILLING
|
| 10 |
BUPRJACT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
BU/Proj/Act Option
A=Business Unit/Project/Activity
B=Business Unit
E=All
P=Business Unit/Project
|
| 11 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 13 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 14 |
BILL_BY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill By Identifier
|
| 15 |
ADDR_SEQ_NUM_BILL |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 16 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
|
| 17 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
|
| 18 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 19 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 20 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 21 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 22 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 23 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 24 |
CONTRACT_DT |
Date(10) |
DATE |
Contract Date
|
| 25 |
CONTRACT_PPD_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Prepaid Add Sequence
|
| 26 |
CA_TXN_ID |
Number(12,0) |
DECIMAL(12) NOT NULL |
Transaction ID
|
| 27 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 28 |
ALL_RDY_CHGS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process all Ready amendments
A=Process all ready amendments
V=Process one contract only
|
| 29 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
|
| 30 |
CHG_DATE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
B=Between two READY dates
F=From a specified date forward
N=No Date Range
T=Through to a specified date
|
| 31 |
CHG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Package Identifier. This is sequenced from 1 to N for each contract.
|
| 32 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 33 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 34 |
DATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
From and To Date Type
A=Accounting Date
J=Journal Date
P=Posted Date
T=Transaction Date
|
| 35 |
EVENT_DT |
Date(10) |
DATE |
The date upon which an accounting event is scheduled to be processed and converted into corresponding accounting
|
| 36 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
|
| 37 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 38 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 39 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 40 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 41 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 42 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 43 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 44 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 45 |
RATE_OPTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Rate Option
ABI=Activity Bill Rate
ACO=Activity Cost Rate
AML=Mark Up/Down Labor
AMN=Mark Up/Down Non-labor
AMT=Quantity Rate
CRB=Custom Bill Rate
CRC=Custom Cost Rate
EBI=Employee Bill Rate
ECO=Employee Cost Rate
FIX=Fixed Amount
JBI=Job Code Bill Rate
JCO=Job Code Cost Rate
MUP=Markup Rate
NON=Bill at Cost
RBI=Project Role Bill Rate
RCO=Project Role Cost Rate
TBI=MM Tools Usage Bill Rate
TCO=MM Tools Usage Cost Rate
WBI=Work Order Labor Bill Rate
WCO=Work Order Labor Cost Rate
|
| 46 |
RATE_AMT |
Number(30,6) |
DECIMAL(29,6) NOT NULL |
Rate Amount for Rates.
|
| 47 |
BILL_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Plan ID
|
| 48 |
BPLAN_LN_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bill Plan Line Number
|
| 49 |
BILL_PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Billing Method
01=As Incurred
02=Installment
03=Recurring
04=Milestone
05=Percent Complete
06=Immediate
07=Value Based
|
| 50 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 51 |
SOLD_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Sold To Customer
|
| 52 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 53 |
BUSINESS_UNIT_CA |
Character(5) |
VARCHAR2(5) NOT NULL |
Contracts Business Unit
|
| 54 |
BILLING_SPECIALIST |
Character(8) |
VARCHAR2(8) NOT NULL |
Billing Specialist
|
| 55 |
DISCOUNT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Discount ID
|
| 56 |
RETAINAGE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Retainage ID
|
| 57 |
RETAINAGE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Reduce by retainage first
|
| 58 |
LAST_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Interface ID
|
| 59 |
REMAINING_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Remaining Amount
|
| 60 |
DISC_SUR_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
|
| 61 |
BILLED_TO_DATE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Billed To Date
|
| 62 |
TRANS_TYPE_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail
|
| 63 |
TRANS_TYPE_BI_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0
|
| 64 |
INTFC_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Interface Line Number
|
| 65 |
LAST_LINE_NUM |
Number(8,0) |
INTEGER NOT NULL |
Last Line Number
|
| 66 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 67 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 68 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 69 |
BOOK_CA_TO_DFR |
Character(1) |
VARCHAR2(1) NOT NULL |
Deferred revenue accounting
|
| 70 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 71 |
PO_REF |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
|
| 72 |
CONTRACT_TYPE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Type
|
| 73 |
CA_RQST_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement
GEN=Generic Application
GOV=Government
INT=Internal
OND=CRM Field Services On Demand
STD=Standard
|
| 74 |
SUBCUST_QUAL1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 75 |
SUBCUST_QUAL2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
|
| 76 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 77 |
DIRECT_INVOICING |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Invoicing
|
| 78 |
BILL_CUR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill Currency
D=Contract Currency
M=Transaction Currency
|
| 79 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 80 |
BILL_CYCLE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
|
| 81 |
BILL_INQUIRY_PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
|
| 82 |
INVOICE_FORM_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Invoice Form
|
| 83 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 84 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 85 |
TAX_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Tax Code
|
| 86 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 87 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
|
| 88 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 89 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 90 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 91 |
SOLD_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sold To Address Sequence Num
|
| 92 |
DISC_SUR_INDICATOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
|
| 93 |
DISCOUNT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Discount Percentage
|
| 94 |
PRE_APPROVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Approval Flag
|
| 95 |
DST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Code
|
| 96 |
DST_ID_DSC |
Character(10) |
VARCHAR2(10) NOT NULL |
Discount Id from BI_DISC_SUR for discounts in CA_DETAIL
|
| 97 |
DST_ID_RET |
Character(10) |
VARCHAR2(10) NOT NULL |
Distribution Id for Retainage found on CA_DETAIL
|
| 98 |
DST_USE |
Character(3) |
VARCHAR2(3) NOT NULL |
Added the following inactive translates for Contracts 8.4:
AP Accounts Payable Liability
AS Fixed Asset
CA Contra Asset
CG Cost of Goods Sold
CL Contra Liability
EX Expense
IN Inventory
WP Work In Progress
|
| 99 |
DST_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Distribution Sequence
|
| 100 |
NET_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
|
| 101 |
ACCT_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Revenue Recognition Plan
|
| 102 |
EVENT_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Event Number
|
| 103 |
RETAINAGE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Retainage Percentage
|
| 104 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 105 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 106 |
RESOURCE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 107 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 108 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 109 |
GROSS_CHANGE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Negotiated Amount
|
| 110 |
TOTAL_REDUCTIONS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Discounts
|
| 111 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 112 |
MIN_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Min Amt Tolerance
|
| 113 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 114 |
INHERIT_BASE_CUR |
Character(1) |
VARCHAR2(1) NOT NULL |
Inherit Base Currency
|
| 115 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 116 |
RECNAME_DOC_SEQ |
Character(15) |
VARCHAR2(15) NOT NULL |
Doc Sequencing Record Name
|
| 117 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 118 |
REV_RECOG_METHOD |
Character(4) |
VARCHAR2(4) NOT NULL |
Revenue Recognition Method
1=As Incurred
2=Apportionment
3=Percent Complete
4=Milestone
5=Billing Manages Revenue
|
| 119 |
FROMPHRASE |
Character(254) |
VARCHAR2(254) NOT NULL |
From Phrase
|
| 120 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 121 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 122 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
|
| 123 |
TAX_TRANS_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None
|
| 124 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 125 |
ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
|
| 126 |
MS_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Milestones
Default Value: N
|
| 127 |
PCT_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Project Progress
Default Value: N
|
| 128 |
DEF_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Contract Liability
Default Value: N
|
| 129 |
GL_STREAM_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Journal Entries
Default Value: N
|
| 130 |
REV_PROC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Revenue Plans
|
| 131 |
BILL_PROC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Bill Plans
|
| 132 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 133 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 134 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 135 |
AP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Rev Rec Plan Status
CAN=Cancelled
DON=Completed
NEW=Pending
PRG=In Progress
RDY=Ready
RIP=Reversal in Progress
RQD=Action Required
RVS=Reversed
|
| 136 |
BP_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Plan Status
CAN=Cancelled
DON=Completed
PND=Pending
PRG=In Progress
RCL=Recycled
RDY=Ready
RIP=Reversal In Progress
RQD=Action Required
RRP=Recycled
RVS=Reversed
|
| 137 |
CHG_PERCENTAGE |
Signed Number(33,5) |
DECIMAL(31,5) NOT NULL |
Change Percentage
|
| 138 |
ACCT_DEF_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Acctg Definition SetID
|
| 139 |
ACCOUNTING_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Exists field is used in the temporary record CA_AP_MS_TA0 to determine if the processed milestone events can use their milestone completion date as their accounting date if they have valid accounting distribution.
|
| 140 |
AMOUNT_1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 141 |
AMOUNT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Work Field
|
| 142 |
CA_FEE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Cost Plus Fee Type
01=None
02=Fixed Fee
03=Award Fee
04=Incentive Fee
05=Other Fee
|
| 143 |
CHG_ORD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Change Order Id.
|
| 144 |
CA_PERCENTAGE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Percentage
|
| 145 |
REVENUE_PROFILE |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Revenue Profile
|