BUSINESS_UNITPrompt Table: SP_BU_FS_NONVW
DISTRIB_SET_IDDefault Value: NEXT
Prompt Table: DST_S_AN_VW
DOC_TYPE_OMB=Claimback Contract
C=Contract
O=Sales Order
R=Return Material Authorization
DST_S_AN_SRCH(SQL View) |
Index Back |
|---|---|
Dist Set AutoNum Add Srch |
| SELECT a.business_unit , a.distrib_set_id , a.doc_type_om FROM PS_DST_SET_OM a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 2 | DISTRIB_SET_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Distribution Set ID
Default Value: NEXT Prompt Table: DST_S_AN_VW |
| 3 | DOC_TYPE_OM |
Character(1) | VARCHAR2(1) NOT NULL |
Document Type
B=Claimback Contract C=Contract O=Sales Order R=Return Material Authorization |