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