SPF_CINP_AET(SQL Table) |
Index Back |
|---|---|
State Record For PrintInvoiceState Record For Print Invoice App Eng Program |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 3 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 4 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 5 | LINE_NBR_WRK | Number(5,0) | INTEGER NOT NULL | Work Line Number |
| 6 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 7 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPR_DEF_TBL_FS |
| 9 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 11 | 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 |
| 12 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 13 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 14 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 15 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 16 | END_DATE | Date(10) | DATE | End Date |
| 17 | INVOICE_ID_FROM | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 18 | INVOICE_ID_TO | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 19 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 20 | SPF_CURRENCY | Character(1) | VARCHAR2(1) NOT NULL |
Display Currency Selection
B=Base Currency S=Work Order Currency |
| 21 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 22 | SPA_SUP_INV_ID | Character(15) | VARCHAR2(15) NOT NULL | Supplier Invoice ID |
| 23 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 24 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Remit to Location |
| 25 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Remitting Location |
| 26 | NAME1_VNDR | Character(40) | VARCHAR2(40) NOT NULL | Vendor Name |
| 27 | ADDRESS1_VNDR | Character(55) | VARCHAR2(55) NOT NULL | Vendor Address Line 1 |
| 28 | ADDRESS2_VNDR | Character(55) | VARCHAR2(55) NOT NULL | Vendor Address Line 2 |
| 29 | ADDRESS3_VNDR | Character(55) | VARCHAR2(55) NOT NULL | Vendor Address Line 3 |
| 30 | ADDRESS4_VNDR | Character(55) | VARCHAR2(55) NOT NULL | Vendor Address Line 4 |
| 31 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 32 | CITY_VNDR | Character(30) | VARCHAR2(30) NOT NULL | Vendor City |
| 33 | STATE_VNDR | Character(6) | VARCHAR2(6) NOT NULL | Vendor State |
| 34 | POSTAL_VNDR | Character(12) | VARCHAR2(12) NOT NULL | Vendor Postal Code |
| 35 | COUNTRY_VNDR | Character(3) | VARCHAR2(3) NOT NULL | Vendor Country |