SPF_RUNCTL_CSUP(SQL Table) |
Index Back |
|---|---|
Batch Invoices child tableBug# 16623516: Record created to hold multiple suppliers |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: SPF_RUNCTL_CLIN.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: SPF_RUNCTL_CLIN.RUN_CNTL_ID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: SPM_BU_SNW_VW |
| 4 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
SPF_VNDRLOC2_VW
|
| 5 | PROVIDER_CONTACT | Character(15) | VARCHAR2(15) NOT NULL |
PROVIDER CONTACT
Prompt Table: SPA_PRCT_VW |
| 6 | CONTRACTOR | Character(15) | VARCHAR2(15) NOT NULL |
Contractor
Prompt Table: SPA_PROVIDER_VW |
| 7 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: VENDOR_ADDR_VW1 |
| 8 | PYMT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Payment Terms Code
30=Due in 30 days after invoice 45=Due in 45 days after invoice IMM=Due Immediately Prompt Table: PAYTRMS_SPF_VW |
| 9 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 10 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Remitting Location |
| 11 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Remit to Location |