SCR_LOC_SCRL_VW(SQL View) |
Index Back |
|---|---|
SCR Location view |
| SELECT S.SETID , S.VENDOR_ID , L.VNDR_LOC , L.EFFDT ,L.EFFDT , V.DEFAULT_LOC , L.PRIMARY_VENDOR , L.PRIM_ADDR_SEQ_NUM , L.REMIT_SETID , L.REMIT_VENDOR , L.REMIT_LOC , L.REMIT_ADDR_SEQ_NUM , L.PYMNT_TERMS_CD , L.VNDR_LOC %Concat ' - ' %Concat S.DESCR , S.DESCR , S.CCR_ADDR_TYPE ,' ' ,'N' FROM PS_VNDR_LOC_SCROL S , PS_VENDOR_LOC L , PS_VENDOR V WHERE L.SETID = S.SETID AND L.VENDOR_ID = S.VENDOR_ID AND L.VNDR_LOC = S.VNDR_LOC AND S.SETID = V.SETID AND S.VENDOR_ID = V.VENDOR_ID AND L.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VENDOR_LOC B WHERE L.SETID = B.SETID AND L.VENDOR_ID = B.VENDOR_ID AND L.VNDR_LOC = B.VNDR_LOC AND B.EFFDT <= %CurrentDateIn ) AND L.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 4 | SCR_EFFDT | Date(10) | DATE | Approved Changes Take Effect |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | DEFAULT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Default Location |
| 7 | PRIMARY_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Primary Supplier
Prompt Table: VNDR_RETURN_VW |
| 8 | PRIM_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Invoicing Location
Prompt Table: VNDR_INVADDR_VW |
| 9 | REMIT_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table: SETID_TBL |
| 10 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table: VNDR_RETURN_VW |
| 11 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Remit to Location
Prompt Table: VNDR_REM_LO2_VW |
| 12 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Remitting Location
Prompt Table: VNDR_REMADDR_VW |
| 13 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: PYMT_TRMS_VW |
| 14 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 16 | CCR_ADDR_TYPE | Character(3) | VARCHAR2(3) NOT NULL | SAM Address Type |
| 17 | COMMENTS | Long Character | CLOB | Comment |
| 18 | SCR_REMOVE | Character(1) | VARCHAR2(1) NOT NULL | Remove Contact |