SCR_INV_ORG_VW(SQL View) |
Index Back |
|---|---|
RFC Procurement DefaultsRFC Procurement Defaults |
| SELECT A.SETID ,A.VENDOR_ID ,A.EFFDT ,A.EFF_STATUS ,A.DUP_INVOICE_IND ,A.DUP_INVOICE_ACTION ,A.DUP_INV_NUM_FLG , A.DUP_INV_VENDOR_NUM ,A.DUP_INV_GROSS_AMT ,A.DUP_INV_DT ,A.DUP_INV_BUS_UNIT ,A.DUP_INV_COMB_CODE FROM PS_VENDOR_INVOICE A , PS_VENDOR V WHERE A.SETID = V.SETID AND A.VENDOR_ID = V.VENDOR_ID AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_VENDOR_INVOICE B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DUP_INVOICE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Indicator
D=Default from Higher Level S=Specify at this Level |
| 6 | DUP_INVOICE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Severity
K=Reject R=Recycle W=Warning |
| 7 | DUP_INV_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Number
N=No Y=Yes Y/N Table Edit |
| 8 | DUP_INV_VENDOR_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Vendor ID
N=No Y=Yes Y/N Table Edit |
| 9 | DUP_INV_GROSS_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Gross Amount
N=No Y=Yes Y/N Table Edit |
| 10 | DUP_INV_DT | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Date
N=No Y=Yes Y/N Table Edit |
| 11 | DUP_INV_BUS_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit
N=No Y=Yes Y/N Table Edit |
| 12 | DUP_INV_COMB_CODE | Number(3,0) | SMALLINT NOT NULL | Dupl Invoice Combination Code |