BO_IDTAX_EXEMPT_CERTY/N Table Edit
Default Value: N
B=Blanket
O=Other
S=Single Purchase
RO_BO_TAX_EX_VW(SQL View) |
Index Back |
|---|---|
Customer Tax Exempt DetailBusiness Object Tax Exempt Detail |
| SELECT BO_ID , TAX_EXEMPT_CERT , TAX_EXEMPT_FLAG , EXEMPT_CATEGORY , ISSUED_DT , EXPIRATION_DT , DESCR , DESCR254 FROM PS_BO_EXEMPT_DTL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_BO_EXEMPT_DTL B WHERE A.BO_ID = B.BO_ID AND A.SETID = B.SETID AND A.CUST_ID = B.CUST_ID AND A.TAX_EXEMPT_CERT = B.TAX_EXEMPT_CERT AND B.EFFDT <= %CurrentDateIn AND B.EXPIRATION_DT > %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | TAX_EXEMPT_CERT |
Character(30) | VARCHAR2(30) NOT NULL | Exemption Certificate |
| 3 | TAX_EXEMPT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Exemption License
Y/N Table Edit Default Value: N |
| 4 | EXEMPT_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exempt Category
B=Blanket O=Other S=Single Purchase |
| 5 | ISSUED_DT | Date(10) | DATE | Issued Date |
| 6 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |