| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
EM_VCH_VALID_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Processing
Y/N Table Edit
Default Value: N
|
| 3 |
EM_BI_ACCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Access to Review Invoices
Y/N Table Edit
Default Value: N
|
| 4 |
EM_PAYMNT_ROUTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Paymenting Routing
|
| 5 |
EM_PAYMTG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Payments By eSettlements
Y/N Table Edit
Default Value: N
|
| 6 |
EM_ERP_INTG_XML |
Character(1) |
VARCHAR2(1) NOT NULL |
ERP Integration File
Y/N Table Edit
Default Value: N
|
| 7 |
EM_REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Type
F=Fixed Format
X=XML File
Default Value: X
|
| 8 |
EM_VCH_EXT_ST |
Character(5) |
VARCHAR2(5) NOT NULL |
Voucher Extract Status
|
| 9 |
EM_RPT_ACCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Access
Y/N Table Edit
Default Value: N
|
| 10 |
EM_AUTO_PAY_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Cycle Selection Review
Y/N Table Edit
Default Value: N
|
| 11 |
EM_AUTO_PAYCYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Automated Pay Cycle
A=Automated Pay Cycle
S=Self-Service Pay Cycle
Default Value: A
|
| 12 |
EM_INVOICE_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Approval Required
Y/N Table Edit
Default Value: N
|
| 13 |
DAYS_NOTIFY |
Number(4,0) |
SMALLINT NOT NULL |
Totals Days before notification of expiration, renewal, etc.
|
| 14 |
EM_ERP_FILE_TIMING |
Character(8) |
VARCHAR2(8) NOT NULL |
ERP Integration File timing
|
| 15 |
EM_ERP_FILE_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
ERP Integration File Status
|
| 16 |
EM_AUTO_PAY_TM |
Character(8) |
VARCHAR2(8) NOT NULL |
Automated Pay Cycle Timing
|
| 17 |
EM_EMAIL_INV_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoices to be approved
Y/N Table Edit
Default Value: N
|
| 18 |
EM_EMAIL_PAY_APPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Payments to be approved
Y/N Table Edit
Default Value: N
|
| 19 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Prompt Table:
EM_BUY_TEMPLATE
Set Control Field: DEFAULT_SETID
|
| 20 |
EM_BANNER_MNGT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
No Banner Management
Y/N Table Edit
Default Value: N
|
| 21 |
EM_PAYCYCL_APP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Cycle Approval Required
Y/N Table Edit
Default Value: N
|
| 22 |
EM_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Extract Frequency
B=Bi weekly
D=Daily
M=Monthly
W=Weekly
Y=Yearly
|
| 23 |
EM_PAYCL_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Cycle Frequency
B=Bi Weekly
D=Daily
M=Monthly
W=Weekly
Default Value: W
|
| 24 |
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
|
| 25 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
Prompt Table:
MTCH_CNTRL_VW1
Set Control Field: DEFAULT_SETID
|
| 26 |
EM_REQRD_MATCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit
Default Value: N
|
| 27 |
EM_MATCH_TOL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Matching Tolerance
|
| 28 |
AS_OF_DATE |
Date(10) |
DATE NOT NULL |
As of Date
Default Value: %date
|
| 29 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table:
CURRENCY_CD_TBL
|
| 30 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 31 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table:
RT_TYPE_TBL
|
| 32 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 33 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 34 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 35 |
EM_MATCH_EXCPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Matching Exceptions Buyer
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 36 |
EM_MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Matching Exceptions Seller
Y/N Table Edit
|
| 37 |
DEFAULT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Default SetID
Prompt Table:
SETID_TBL
|
| 38 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_TBL
Set Control Field: BANK_SETID
|
| 39 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
EM_BANK_ACCT_VW
Set Control Field: BANK_SETID
|
| 40 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
Prompt Table:
EM_BANK_MTHD_V2
|
| 41 |
EM_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
Prompt Table:
%EDITTABLE
|
| 42 |
EM_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
%EDITTABLE2
|
| 43 |
EM_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
Prompt Table:
EM_BANK_MTHD_VW
|
| 44 |
EM_IM_ACCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Instant Messenger Access
Y/N Table Edit
Default Value: N
|
| 45 |
EXPIRE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Expiration Days
|
| 46 |
PRO_NUM_LAST_USED |
Number(8,0) |
INTEGER NOT NULL |
Last Voucher Number
Default Value: 0
|
| 47 |
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
|
| 48 |
TRNS_DFLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Count
D=Default
S=Specify
Default Value: D
|
| 49 |
YEARS_NUM |
Number(6,0) |
INTEGER NOT NULL |
Years
|
| 50 |
MONTHS_NUM |
Number(6,0) |
INTEGER NOT NULL |
Months
|
| 51 |
DAYS_NUM |
Number(6,0) |
INTEGER NOT NULL |
Days
|
| 52 |
EM_INV_BACKDT_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
The buyer can establish the number of days an invoice date can be back dated.
|
| 53 |
EM_INV_BACKDT_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Backdate Days message parameter (Warning message or Error message is triggered)
E=Error
W=Warning
Default Value: W
|
| 54 |
EM_USE_AP_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Payables for Approval
Y/N Table Edit
Default Value: N
|