SPF_INV_PGC1_VW(SQL View) |
Index Back |
|---|---|
Summary |
| SELECT A.BUSINESS_UNIT , A.INVOICE_ID , ' ' , A.INVOICE_DT , ' ' , A.INVOICE_STATUS , A.SP_SERVICE_METHOD , A.PYMNT_TERMS_CD , ' ' , A.VENDOR_ID , ' ' , A.VNDR_LOC , A.ADDRESS_SEQ_NUM , ' ' , A.REMIT_VENDOR , ' ' , A.REMIT_LOC , A.REMIT_ADDR_SEQ_NUM , ' ' , ' ' FROM PS_SPF_INVOICE_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 3 | BU_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business unit description. |
| 4 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 5 | SP_INVOICE_DT | Character(30) | VARCHAR2(30) NOT NULL | Invoice Date |
| 6 | INVOICE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Invoice Status
0=Submitted to Enterprise 1=Generated 10=Canceled 11=Adjusted 2=Approved 3=Processed 4=Paid 5=Submitted 6=Denied 7=Submitted to Supplier 8=Approved by Supplier 9=Denied by Supplier |
| 7 | SP_SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Type classified as Resource Based or Service Based
D=Deliverable R=Resource |
| 8 | 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. |
| 9 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 10 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 11 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 12 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 13 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: VENDOR_ADDR_VW1 |
| 14 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 15 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 16 | REMIT_TO_NAME | Character(40) | VARCHAR2(40) NOT NULL | Remit To Supplier Name |
| 17 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Remit to Location |
| 18 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Remitting Location |
| 19 | DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 20 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |