TPR_TYPE_CDB=Customer/Supplier
C=Customer
S=Supplier
A=Active
I=Inactive
Default Value: A
BI_TPR_TYPE_VW(SQL View) |
Index Back |
|---|---|
Customer Type View |
| SELECT TPR_TYPE_CD ,DESCR50 ,SHORT_DESCR ,USAGE_TYPE_GST ,STATUS FROM PS_GST_TPR_TYPE WHERE USAGE_TYPE_GST IN('C','B') AND STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TPR_TYPE_CD |
Character(30) | VARCHAR2(30) NOT NULL | Trading Partner type |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | SHORT_DESCR | Character(15) | VARCHAR2(15) NOT NULL | This field is used to represent the short description for various objects |
| 4 | USAGE_TYPE_GST | Character(1) | VARCHAR2(1) NOT NULL |
Usage Type
B=Customer/Supplier C=Customer S=Supplier |
| 5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |