EOTP_PARTNERIDPrompt Table: EOTP_PARTNER
EOTP_PARTNRTYPB=Bidder
C=Customer
V=Supplier
EOTP_SEQNUMEOTP_FIELDNAMEEOTP_PARTNRKEYS(SQL Table) |
Index Back |
|---|---|
Partner TypePartner Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOTP_PARTNERID |
Number(15,0) | DECIMAL(15) NOT NULL |
Partner ID
Prompt Table: EOTP_PARTNER |
| 2 | EOTP_PARTNRTYP |
Character(1) | VARCHAR2(1) NOT NULL |
Partner Type
B=Bidder C=Customer V=Supplier |
| 3 | EOTP_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 4 | EOTP_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Fieldname |
| 5 | EOTP_FIELDVALUE | Long Character | CLOB | Field Value |