NET_PARTICIPANT_IDEFFDTDefault Value: %date
BUSINESS_UNIT_APPrompt Table: SP_BUNAP_NONVW
STL_NET_SETIDVENDOR_IDPrompt Table: NET_VENDOR_VW
NET_PART_VNDR(SQL Table) |
Index Back |
|---|---|
Netting Supplier ParticipantsChild table for external supplier participants. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NET_PARTICIPANT_ID |
Character(12) | VARCHAR2(12) NOT NULL | Netting Participant ID, ID to define which Vendors/Customers//Business Units are available to be netted. |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | BUSINESS_UNIT_AP |
Character(5) | VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table: SP_BUNAP_NONVW |
| 4 | STL_NET_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Netting SetID |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: NET_VENDOR_VW |