SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
BILL_TO_CUST_IDPrompt Table: CUSTOMER
TAX_EXEMPT_CERTBI_CUST_EXMPTVW(SQL View) |
Index Back |
|---|---|
BI - Customer Tax Exempt ViewBI - Customer Tax Exempt View |
| SELECT A.SETID , A.CUST_ID , A.TAX_EXEMPT_CERT FROM PS_CUST_EXEMPT A , PS_CUST_EXEMPT_DTL B WHERE A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND A.TAX_EXEMPT_CERT = B.TAX_EXEMPT_CERT AND %EffdtCheck(CUST_EXEMPT_DTL, B, %currentdatein) AND B.EFF_STATUS = 'A' AND B.EXPIRATION_DT >= %CurrentDateIn AND B.TAX_EXEMPT_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUSTOMER |
| 3 | TAX_EXEMPT_CERT |
Character(30) | VARCHAR2(30) NOT NULL | Exemption Certificate |