CA_LNK_DTL_VW(SQL View) |
Index Back |
|---|
| SELECT CONTRACT_NUM ,CONTRACT_LINE_NUM ,DESCR ,SHIP_TO_CUST_ID ,ADDR_SEQ_NUM_SHIP ,SHIP_FROM_LOC ,TAX_EXEMPT_FLG ,TAX_EXEMPT_CERT ,TAX_GROUP ,TAX_CD ,TAX_TRANS_TYPE ,TAX_TRANS_SUB_TYPE ,PHYSICAL_NATURE ,BILL_PLAN_ID ,'Y' ,PRODUCT_ID FROM PS_CA_DETAIL DTL1 WHERE 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: BI_SHIP_TO_VW |
| 5 | ADDR_SEQ_NUM_SHIP | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 6 | SHIP_FROM_LOC | Character(10) | VARCHAR2(10) NOT NULL | Ship From Location |
| 7 | TAX_EXEMPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit |
| 8 | TAX_EXEMPT_CERT | Character(30) | VARCHAR2(30) NOT NULL | Exemption Certificate |
| 9 | TAX_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Tax Group
Prompt Table: CA_TAX_GROUP_VW |
| 10 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: CA_TAX_CD_VW |
| 11 | TAX_TRANS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return |
| 12 | 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 |
| 13 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 14 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 15 | LINKS | Character(1) | VARCHAR2(1) NOT NULL |
Links
Y/N Table Edit |
| 16 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |