SETIDPrompt Table: EM_SETID_SEC_VW
PRIMARY_VENDORPrompt Table:
EM_VNDR_FAC_VW
Set Control Field: SETID
VENDOR_IDEFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
EM_FACTOR_TBL(SQL Table) |
Index Back |
|---|---|
EBPP : Factoring Table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: EM_SETID_SEC_VW |
| 2 | PRIMARY_VENDOR |
Character(10) | VARCHAR2(10) NOT NULL |
Primary Supplier
Prompt Table:
EM_VNDR_FAC_VW
|
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EM_FACTOR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Activate Factor
Y/N Table Edit Default Value: N |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | EM_FACTOR_NAME | Character(40) | VARCHAR2(40) NOT NULL | Factor Name |
| 8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |