| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETVC_NONVW
|
| 2 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 3 |
EM_VCHR_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Processing
0=Specify Buyers
1=All Buyers
Y/N Table Edit
Default Value: N
|
| 4 |
EM_CASH_COL_NOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Collections Access
Y/N Table Edit
Default Value: N
|
| 5 |
EM_RPT_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Access Allowed
Y/N Table Edit
Default Value: N
|
| 6 |
EM_NOT_VCHR_PD |
Character(1) |
VARCHAR2(1) NOT NULL |
Voucher Paid Notification
Y/N Table Edit
Default Value: N
|
| 7 |
EM_BANNER_MNGT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
No Banner Management
Y/N Table Edit
Default Value: N
|
| 8 |
EM_SELL_INFO1_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Information Flag 1
Y/N Table Edit
Default Value: N
|
| 9 |
EM_SELL_INFO2_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Information Flag 2
Y/N Table Edit
Default Value: N
|
| 10 |
EM_ERP_INTG_XML |
Character(1) |
VARCHAR2(1) NOT NULL |
ERP Integration File
Y/N Table Edit
Default Value: N
|
| 11 |
EM_REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Type
F=Fixed Format
X=XML File
Default Value: X
|
| 12 |
EM_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Extract Frequency
B=Bi weekly
D=Daily
M=Monthly
W=Weekly
Y=Yearly
|
| 13 |
EM_VCHR_EXT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Invoice Extract Status
AP=Approved
MA=Matched and Approved
MP=Matched and Pending Approval
PA=Pending Approval
PD=Paid
X=Any Status Change
|
| 14 |
EM_IM_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Instant Messenger Access
Y/N Table Edit
Default Value: N
|
| 15 |
EXPIRE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Expiration Days
|
| 16 |
TRANSACTION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Component Issue/Receipt Flag
1=Issue Material from Stock
2=Return Material to Stock
Y/N Table Edit
|
| 17 |
YEARS_NUM |
Number(6,0) |
INTEGER NOT NULL |
Years
|
| 18 |
MONTHS_NUM |
Number(6,0) |
INTEGER NOT NULL |
Months
|
| 19 |
DAYS_NUM |
Number(6,0) |
INTEGER NOT NULL |
Days
|
| 20 |
TRNS_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Count
D=Default
S=Specify
Default Value: D
|