LM_VENDOR_IDA=Active
I=Inactive
CORE=Core
EDUC=Education
FNSV=Financial Services
GOVT=Government
HLTH=Health Care
RETL=Retail
TRAN=Transportation
UTIL=Utilities
LM_VENDOR_A_VW(SQL View) |
Index Back |
|---|---|
Vendor View |
| SELECT LM_VENDOR_ID , LM_VENDOR_STATUS , LM_VENDOR_DESCR , LM_ALT_VENDOR_DESC , LM_INDUSTRY FROM PS_LM_VENDOR WHERE LM_VENDOR_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_VENDOR_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Vendor ID |
| 2 | LM_VENDOR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Status
A=Active I=Inactive |
| 3 | LM_VENDOR_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Description |
| 4 | LM_ALT_VENDOR_DESC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Vendor Description |
| 5 | LM_INDUSTRY | Character(4) | VARCHAR2(4) NOT NULL |
Industry
CORE=Core EDUC=Education FNSV=Financial Services GOVT=Government HLTH=Health Care RETL=Retail TRAN=Transportation UTIL=Utilities |