| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
EM_AGREEMENT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Agreement Id
|
| 3 |
AGREEMENT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Master Agreement Name
|
| 4 |
MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit
Default Value: N
|
| 5 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
Default Value: STANDARD
Prompt Table:
MTCH_CNTRL_VW1
|
| 6 |
EM_STD_VCH_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This will allow vouchers without a PO number to be accepted into the database. This flag will be referenced during Voucher Build.
Y/N Table Edit
Default Value: N
|
| 7 |
EM_EXPOSE_CFS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Expose ChartFields to Supplier
Y/N Table Edit
Default Value: N
|
| 8 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
%EDITTABLE
|
| 9 |
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
|
| 10 |
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
|
| 11 |
EM_INV_VERIFY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used on the Agreement to specify the Invoice types to set for verification/review.
0=No Invoices
1=All Invoices
2=non-PO Invoices
Default Value: 0
|
| 12 |
EM_CPY_ONE_PO_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
If option is selected allows the Buyer/Supplier agreement to restrict a supplier to copy from one and only one PO.
Y/N Table Edit
Default Value: N
|
| 13 |
EM_USE_PTRMS_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines if the default payment terms of the agreement are defaulted from the agreement (default) , from the PO or defaulted from hierarchy
A=Agreement
D=Default from higher level
P=Purchase Order
Default Value: D
|
| 14 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table:
PYMT_TR_EFF_VW
Set Control Field: SETID
|