CA_DETAIL_NL_VW

(SQL View)
 Index Back

SELECT DTL.CONTRACT_NUM ,DTL.CONTRACT_LINE_NUM ,DTL.BILL_PLAN_ID ,DTL.BPLAN_LN_NBR ,DTL.PRODUCT_ID ,DTL.DESCR ,DTL.GROSS_AMT ,DTL.CURRENCY_CD ,DTL.REV_RECOG_METHOD ,DTL.SHIP_TO_CUST_ID ,DTL.ADDR_SEQ_NUM_SHIP ,DTL.SHIP_FROM_LOC ,DTL.TAX_CD ,DTL.TAX_EXEMPT_FLG ,DTL.TAX_EXEMPT_CERT ,DTL.TAX_GROUP ,DTL.TAX_TRANS_TYPE ,DTL.TAX_TRANS_SUB_TYPE ,DTL.PHYSICAL_NATURE ,DTL.QTY ,DTL.UNIT_OF_MEASURE FROM PS_CA_DETAIL DTL WHERE DTL.BPLAN_LN_NBR = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

Prompt Table: CA_CONTR_HDR

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
3 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
4 BPLAN_LN_NBR Number(3,0) SMALLINT NOT NULL Bill Plan Line Number
5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: BUS_UNIT_TBL_CA

9 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
10 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: BI_SHIP_TO_VW

11 ADDR_SEQ_NUM_SHIP Number(5,0) INTEGER NOT NULL Address Sequence Number
12 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location
13 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

Prompt Table: CA_TAX_CD_VW

14 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

Y/N Table Edit

Default Value: N

15 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
16 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

Prompt Table: CA_TAX_GROUP_VW

17 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
18 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
19 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
20 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage