APOP_VENDOR_LVW(SQL View) |
Index Back |
---|---|
Supplier Header Related Lang |
SELECT A.SETID , A.VENDOR_ID , A.AP_PERIOD_NAME , A.AP_ACTION_SUPPLIER , VL.LANGUAGE_CD , VL.VENDOR_NAME_SHORT , VL.VNDR_NAME_SHRT_USR FROM %Table(APOP_VENDOR_MV) A , %Table(VENDOR_LANG) VL WHERE VL.SETID = A.SETID AND VL.VENDOR_ID = A.VENDOR_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SETID_TBL |
2 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
3 | AP_PERIOD_NAME | Character(35) | VARCHAR2(35) NOT NULL | Period Name |
4 | AP_ACTION_SUPPLIER | Character(1) | VARCHAR2(1) NOT NULL |
Action Supplier
A=Added U=Updated |
5 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
6 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
7 | VNDR_NAME_SHRT_USR | Character(10) | VARCHAR2(10) NOT NULL | Short Vendor Name |