CA_HDR_DTL_VW

(SQL View)
 Index Back

Header and Line View


SELECT HDR.CONTRACT_NUM , CD.CONTRACT_LINE_NUM , HDR.BUSINESS_UNIT , HDR.SOLD_TO_CUST_ID , CD.PRODUCT_ID , CD.DESCR , CD.PRODUCT_GROUP , HDR.CONTRACT_TYPE , HDR.CA_RQST_SRC , HDR.CA_STATUS , CD.CA_LINE_STATUS , CD.ADHOC_OFFERING , CD.TAX_GROUP , CD.TAX_TRANS_TYPE , CD.TAX_TRANS_SUB_TYPE , CD.PHYSICAL_NATURE , CD.THIRD_PARTY_FLG , CD.UNIT_OF_MEASURE , CD.RENEWABLE , CD.PRICING_STRUCTURE , CD.PERCENTAGE , CD.APPLIES_TO , CD.REV_RECOG_METHOD , CD.GROSS_AMT , CD.CURRENCY_CD , CD.RENEWAL_ACTION , CD.CA_FEE_TYPE FROM PS_CA_CONTR_HDR HDR , PS_CA_DETAIL CD WHERE HDR.CONTRACT_NUM = CD.CONTRACT_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 SOLD_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Sold To Customer
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group
8 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
9 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
10 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status
11 CA_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Obligation status
A=Active
C=Cancelled
P=Pending
R=Renewed
12 ADHOC_OFFERING Character(1) VARCHAR2(1) NOT NULL Ad hoc Product
C=Converted from Ad Hoc
D=Non-unique Ad Hoc Line
N=Product
Y=Ad Hoc Product
13 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group
14 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
15 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
16 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
17 THIRD_PARTY_FLG Character(1) VARCHAR2(1) NOT NULL Third Party Flag
18 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
19 RENEWABLE Character(1) VARCHAR2(1) NOT NULL Renewable
20 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
AMT=Amount
PCT=Percent
RATE=Rate
RCR=Recurring
21 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
22 APPLIES_TO Character(4) VARCHAR2(4) NOT NULL PSIRS-KK
HDR=% of Total Contract Amount
LINE=% of Contract Lines
23 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
24 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
26 RENEWAL_ACTION Character(4) VARCHAR2(4) NOT NULL Renewal Action
AUTO=Automatic
MANL=Manual
27 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