Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
Item Overview:
To use PeopleSoft Payables to pay third parties the deductions withheld from employee paychecks, a
unique vendor ID and profile must be established for each deduction recipient. Vendor profiles are
created in the Payables system and stores the vendor ID, name, payment terms and methods, processing
defaults, and other information needed to manage the vendor relationship. Payables use PeopleSoft's
Application Messaging technology to publish, or send, vendor information to PeopleSoft Payroll. Then
vendors can be displayed on the Payroll system's Vendor Information pages and locate the information
that will be used to link vendors to deduction records.
Menu Path:
Home / Define Business Rules / Define AP Interface / Setup / Vendor Control
Home / Define Business Rules / Define AP Interface / Setup / Vendor Information
Home / Define Business Rules / Define AP Interface / Setup / Vendor Bank Account
AP_VENDOR_CNTRL
VENDOR
VENDOR_ADDR
VENDOR_ADDR_PHN
VENDOR_LOC
VENDOR_PAY
VNDR_CNTCT_SCR
VENDOR_CNTCT
VENDOR_LANG
VNDR_CNTCT_PHN
VENDOR_POLICY
VNDR_PLCY_CNTCT
VNDR_BANK_ACCT
PY_VNDR_MAPPING
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 1 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 2 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 3 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
Record Information:
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 4 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
PS RECORD NAME RECORD NAME DESCRIPTION
AP_VENDOR_CNTRL Controls for a set of Controls for a set of Vendors. Sets up the
Vendors controls for HRMS Vendors. Determines if auto
numbering will be used and defines the last
vendor ID assigned.
VENDOR HRMS Vendor HRMS Vendor
VENDOR_ADDR Vendor Address This record mirrors the AP Vendor Address
table.
VENDOR_ADDR_PHN Vendor Address Phone Vendor Address Phone record. Stores Phone
record related info.
VENDOR_LOC Vendor Location Provided location information for each Vendor.
VENDOR_PAY Vendor Payment Details Vendor Payment Details - Bank information, etc.
VNDR_CNTCT_SCR Vendor Contact Scroll Vendor Contact Scroll
VENDOR_CNTCT Vendor Contact Detail Provided detail information about each Vendor
Contact.
VENDOR_LANG Vendor related language Vendor related language table
table
VNDR_CNTCT_PHN Vendor Contact Telephone This record stores the vendor contact telephone
Nbrs numbers.
VENDOR_POLICY Vendor Policy Detail Vendor Policy Details. Replaces the old
Provider Policy record.
VNDR_PLCY_CNTCT Vendor Policy Contact Vendor Policy Contact Details
Details
VNDR_BANK_ACCT Vendor Bank Accounts Vendor Bank Accounts
PY_VNDR_MAPPING AP/PY Mapping Record AP/PY Mapping Record
Approach:
This work unit will not be configured by the HRMS team since the State of Connecticut Financials team
will create Vendor profiles to store the vendor ID, name, payment terms and methods, processing
defaults, and other information needed to manage the vendor relationship. The State of Connecticut will
use PeopleSoft's Application Messaging technology to publish, or send, vendor information from
Payables to PeopleSoft Payroll and link the vendors to the deduction records in Payroll. The Application
Messages used to synchronize the data are VENDOR_FULLSYNC, and VENDOR_SYNC. Below is a
screen shot of what an Application message looks like in Application Designer.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 5 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
Information Source:
Data Entry Method:
_____ On-Line Pages
_____ Excel Spreadsheet
Fields on Record:
PS RECORD NAME/
PS FIELD NAME FIELD NAME DESCRIPTION
AP_VENDOR_CNTRL
SETID SetID Prompt: SETID_TBL
Select the SetID
Required
VENDOR_NUM_OPTIO Use Auto-Numbering Y/N Edit
N PeopleSoft Payables has the option of using an
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 6 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
auto numbering feature to assign IDs to new
vendors.
Required
VNDR_ID_PREFIX HRMS Vendor ID Prefix Enter the If HRMS Vendor ID Prefix only if the
auto-numbering check box is selected enter a
prefix that is used identify HRMS vendors.
VNDR_ID_LAST_ASSG Last Vendor ID Assigned
N
PRENOTE_WAIT_DAYS Prenote Wait Days (U.S.) Enter the Prenote Wait Days (U.S.). The
PoepleSoft default value is 10
WTHD_SW Display Withholding Flag Y/N Edit
Required
VAT_SW Display VAT Flag Y/N Edit
Required
COUNTRY Country Prompt: COUNTRY_TBL
Select the Country of the vendor.
VENDOR
SETID SetID This field will be defaulted from the SETID
value on the AP_VENDOR_CNTRL record.
Required
VENDOR_ID Vendor ID Enter the Vendor only if auto numbering option
is not selected. Otherwise this field will be
defaulted from the value on the
AP_VENDOR_CNTRL record.
VENDOR_NAME_SHOR Short Vendor Name Enter the Short Vendor Name.
T
VNDR_NAME_SHRT_U Short Vendor Name This field will default to the concatenation of the
SR VENDOR_NAME_SHORT and
VNDR_NAME_SEQ_NUM field values.
Required.
VNDR_NAME_SEQ_NU Sequence Number Enter the Sequence Number
M
NAME1 Name 1 Enter the payee name as it should appear on the
check.
Required.
NAME2 Name 2 Enter the second payee name as it should appear
on the check if applicable.
VENDOR_STATUS Vendor Status Enter the Vendor Status. Translate values are:
„A‟ Approved, „E‟ Unapproved, „I‟ Inactive, and
„X‟ To Archive. The PeopleSoft default for this
field is „A‟ and should be accepted as the default
for Core-CT.
Required.
VENDOR_CLASS Classification Enter the Vendor Classification. Translate
values are: „A‟ Attorney, „E‟ Employee, „H‟
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 7 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
HRMS related, and „R‟ Outside Party. The
PeopleSoft default for this field is „H‟.
Required.
VENDOR_PERSISITEN Persistence Enter the Vendor Persistence. Translate values
CE are: „O‟ One Time, „P‟ Permanent, and „R‟
Regular. . The PeopleSoft default for this field
is „R‟ and should be accepted as the default for
Core-CT.
Required.
REMIT_ADDR_SEQ_NU Remitting Location Enter the Remitting Location.
M
PRIM_ADDR_SEQ_NU Invoicing Location Enter the Invoicing Location.
M
ADDR_SEQ_NUM_ORD Ordering Location Enter the Ordering Location.
R
REMIT_SETID Remit SetID This field will be defaulted from the SETID
value on this record.
REMIT_VENDOR Remit Vendor Enter Remit Vendor if applicable.
CORPORATE_SETID SetID This field will be defaulted from the SETID
value on this record.
CORPORATE_VENDOR Corporate Vendor Enter Corporate Vendor if applicable.
CUST_SETID Customer SetID Prompt: SETID_TBL
The default for this field will be defaulted from
the SETID value on this record.
CUST_ID Customer ID Enter Customer ID
ENTERED_BY Entered By Enter Entered By, which will default the operator
ID who last updated the recorded.
AR_NUM Our Customer Number Enter Our Customer Number with the AR
(Accounts Receivable) number.
OLD_VENDOR_ID Old Vendor ID Enter Old Vendor ID if applicable.
WTHD_SW Display Withholding Flag Y/N Edit
Select if there is withholding for the vendor. The
PeopleSoft default for this value is „N‟.
Required.
VAT_SW Display VAT Flag Y/N Edit
Select if there is VAT for the vendor. The
PeopleSoft default for this value is „N‟.
Required.
VNDR_STATUS_PO Open for Ordering Y/N Edit
Select if the vendor is open for ordering. The
PeopleSoft default for this value is „N‟.
REMIT_LOC Remit to Location Enter Remit to Location if applicable.
DEFAULT_LOC Default Location Enter Default Location if applicable.
NAME1_AC Name 1 Alternate Char Set Enter Alternative Name 1 for vendor if
applicable.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 8 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
NAME2_AC Name 2 Alternate Char Set Enter Alternative Name 2 for vendor if
applicable.
PRIMARY_VENDOR Invoice Vendor Enter Invoice Vendor if applicable.
LAST_ACTIVITY_DT Last Activity Date Enter Last Activity Date. PeopleSoft defaults
this value to the current system date.
WITHHOLD_LOC Withholding Location Enter the Withholding Location if applicable.
IN_PROCESS_FLG In Process Enter if the In Process flag is applicable. The
PeopleSoft default for this value is „N‟.
PROCESS_INSTANCE Process Instance Enter the Process Instance if applicable.
HUB_ZONE HUB Zone Y/N Edit
Enter the HUB Zone.
EEO_CERTIF_DT EEO Certification Date Enter the EEO Certification Date is applicable.
HRMS_CLASS Classification Prompt: %RECNAME_EDIT
Enter the HRMS Classification. This field
identifies the HRMS classification used to create
views to see the appropriate vendors on the
appropriate tables.
It is also used to identify tax and non-tax
deductions when the system extracts deductions
to create AP vouchers. Translate values are: „D‟
General Deduction, „G‟ Garnishment Payee, „H‟
National Health Service Provider, „I‟ Industrial
Insurance Board Provider, „P‟ General Provider,
and „T‟ Tax Collector. For benefit providers,
select P for General Provider. The PeopleSoft
default for this value is „P‟.
Required.
VENDOR_ADDR
SETID SetID This field will be defaulted from the SETID
value on the VENDOR record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR record.
Required
ADDRESS_SEQ_NUM Address Sequence Enter the Address Sequence Number. The
Number PeopleSoft default is „1‟ and should be set for the
CoreCT default value.
EFFDT Effective Date Enter the Effective Date. The PeopleSoft default
is the current system date.
EFF_STATUS Status as of Effective Date Enter the Status of the Effective Date. The valid
values are „A‟ Active, and „I” Inactive. The
PeopleSoft default is “A‟ and should be used for
CoreCT.
NAME1 Name 1 Enter the payee name as it should appear on the
check.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 9 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
Required.
NAME2 Name 2 Enter the second payee name as it should appear
on the check if applicable.
EMAILID Email ID Enter the Email ID of the payee if applicable.
ADDRESS_SBR
COUNTRY Country Prompt: COUNTRY_TBL
Select „USA‟ as the default for Core-CT.
ADDRESS1 Address Line 1 Enter the Vendor Address line 1
ADDRESS2 Address Line 2 Enter the Vendor Address line 2 if applicable
ADDRESS3 Address Line 3 Enter the Vendor Address line 3 if applicable
ADDRESS4 Address Line 4 Enter the Vendor Address line 4 if applicable
CITY City Enter the City of the Vendor
NUM12 Number 1 Enter the number for the Vendor location.
Valid for Spanish Addresses only
NUM2 Number 2 Enter an additional number for the Vendor
location if applicable. Valid for Spanish
Addresses only
HOUSE_TYPE House Type Enter the house type for the Vendor. Translate
Values: „AB‟(House Boat), „WW‟ (Trailer)
ADDR_FIELD1 Address Field 1 Enter the address Field 1 type for the Vendor.
Translate Values: „AL‟(Village),
„AP‟(Apartment), „AV‟(Avenue), „BL‟(Housing
Block), „BO‟(District), „CH‟(Villa), „CL‟(Street),
„CM‟(Way), „CO‟(Housing Estate), „CR‟(Road),
„CS‟(Farmhouse), „CT‟(Hill), „ED‟ (Building),
„GL‟(Roundabout), „GR‟(Group), „LG‟(Place),
„MC‟(Market), „MN‟(Municipality),
„MZ‟(Block), „PB‟(Town), „PG‟(Industrial
Zone), „PJ‟(Passage), „PQ‟(Park), „PR‟(Annex),
„PS‟(Promenade), „PZ‟(Square),
„RB‟(Boulevard), „RD‟(Beltway), „TR‟(Alley),
„UR‟(Neighborhood), „ZZ‟(Unknown)
This shouldn‟t be used for the Vendor
ADDR_FIELD2 Address Field 2 This shouldn‟t be used for the Vendor
ADDR_FIELD3 Address Field 3 This shouldn‟t be used for the Vendor
COUNTY County Enter the County of the Vendor if applicable
STATE State Prompt: %EDIT_STATE
Select the State of the Vendor.
POSTAL Postal Code Enter the Postal Code for the Vendor.
GEO_CODE Tax Vendor Geographical Enter the Geographic Code for the Vendor.
Code
IN_CITY_LIMIT In City Limit Y/N Edit.
Select the In City Limit indicator.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 10 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
VENDOR_ADDR_PHN
SETID SetID This field will be defaulted from the SETID
value on the VENDOR_ADDR record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR_ADDR
record.
Required
ADDRESS_SEQ_NUM Address Sequence This field will be defaulted from the
Number ADDRESS_SEQ_NUM value on the
VENDOR_ADDR record.
Required
EFFDT Effective Date This field will be defaulted from the EFFDT
value on the VENDOR_ADDR record.
Required
PHONE_TYPE Phone Type Enter the phone type for the Vendor. Translate
values are: „BUSN‟ Business, „CAMP‟ Campus,
„CELL” Cellular, „DORM‟ Dormitory, „FAX‟
FAX, „HOME‟ Home, „MAIN‟ Main, „OTR‟
Other, „PGR1‟ Pager 1, „PGR2‟ Pager 2, and
„TELX‟ Telex.
Required.
COUNTRY_CODE Prefix Enter the Vendor Telephone Number prefix.
PHONE Telephone Enter the Vendor Telephone Number.
EXTENSION Phone Extension Enter the Vendor Telephone Number Extension.
VENDOR_LOC
SETID SetID This field will be defaulted from the SETID
value on the VENDOR record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR record.
Required
VNDR_LOC Vendor Location Enter an identifier for the Vendor location
information. If more than one location is set up
for the vendor, the previous page and next page
links on the Vendor Location bar can be used to
display information.
Required.
EFFDT Effective Date Enter the Effective Date. The PeopleSoft default
is the current system date.
Required.
EFF_STATUS Status as of Effective Date Enter the Status of the Effective Date. The valid
values are „A‟ Active, and „I” Inactive. The
PeopleSoft default is “A‟ and should be used for
CoreCT.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 11 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
CURRENCY_CD Currency Code Enter the Currency Code.
CUR_RT_TYPE Exchange Rate Type Enter the Exchange Rate Type.
FREIGHT_TERMS Freight Terms Code Enter the Freight Terms Code.
SHIP_TYPE_ID Ship Via Code Enter the Ship Via Code.
DISP_METHOD Dispatch Method Enter the Dispatch Method. Translate values:
„EDI‟ Electronic Data Interchange., „EML‟ E-
mail Dispatch, „FAX‟ Fax Transmission, „PHN‟
Phone Dispatch, and „PRN‟ Print.
PYMENT_TERMS_CD Payment Terms Id Enter the Payment Terms Id.
MATCH_CNTRL_ID Match Rules Enter the Match Rules.
MATCH_OPT Requires Matching Edit Y/N
Enter Requires Matching. PeopleSoft default is
„N‟
Required.
ERS_ACTION ERS Action Enter ERS Action. Valid translate values are:
„N‟ None, „O‟ Override Rules, and „V‟ Create
Voucher. The PeopleSoft default is „N‟.
ERS_FLAG Allow Eval Rcpt Edit Y/N
Settlement Enter Allow Eval Rcpt Settlement. PeopleSoft
default is „N‟.
VCHR_APPRVL_FLG Voucher Approval Flag Enter Voucher Approval Flag. Valid translate
values are: „D‟ Default from Higher Level, „P‟
Pre-Approved, and „S‟ Specify at this Level.
PeopleSoft default is „D‟.
Required.
BUSPROCNAME Business Process Name Prompt: BUSPROCNAME_VW
Select the Business Process Name
APPR_RULE_SET Approval Rule Set Prompt: APPR_RULE_HDR
Select the Approval Rule Set
VAT_DCLRTN_POINT Declaration Point Enter the Declaration Point. Valid translate
values are: „D‟ Delivery, „I‟ At Invoice Time,
and „P‟ At Payment Time.
VAT_CALC_TYPE Calculation Type Enter the Calculation Type. Valid Translate
values are: „E‟ Exclusive, „I‟ Inclusive, and „N‟
Not Applicable.
VAT_TXN_TYPE_CD VAT Transaction Type Enter the VAT Transaction Type.
VAT_TOL_FLG VAT Tolerance Check Enter the VAT Tolerance Check Indicator. Valid
Indicator translate values are: „D‟ Default from Higher
Level, and „S‟ Specify at this Level. The
PeopleSoft Default is „D‟.
Required.
VAT_TOL_PCT VAT Tolerance Enter the VAT Tolerance Percentage.
Percentage
VAT_TOL_AMT VAT Tolerance Amount Enter the VAT Tolerance Amount
VAT_TOL_CUR_CD Currency Enter the Currency
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 12 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
VAT_TOL_RT_TYPE Rate Type Enter Rate Type
VAT_USE_ID VAT Use Type Enter the VAT Use Type
BUYER_ID Buyer Name Enter the Buyer Name
REMIT_SETID Remit SetID Prompt: SETID_TBL
Select the Remit SetID
Required.
REMIT_VENDOR Remit Vendor Prompt: VENDOR
Select the Remit Vendor. This is the information
about the vendor to whom payments will be sent.
Required.
REMIT_LOC Remit to Location Prompt: VNDR_REMLOC_VW
Select the Remit to Location.
REMIT_ADDR_SEQ_NU Remitting Location Prompt: VNDR_REMADDR_VW
M Select the Remitting Location. The PeopleSoft
Default is „1‟ and should be accepted for the
State of Connecticut.
Required.
ADDR_SEQ_NUM_ORD Ordering Location Prompt: VNDR_ADDR
R Select the Ordering Location. The PeopleSoft
Default is „1‟ and should be accepted for the
State of Connecticut.
Required.
PRICE_SETID Price From Vendor SetID Enter the Price From Vendor SetID.
PRICE_VENDOR Price Vendor ID Prompt: VENDOR
Select the Price Vendor ID.
PRICE_LOC Price from Location Prompt: VENDOR_LOC
Select the Price from Location.
RETURN_VENDOR Return to Vendor Prompt: VENDOR
Select the Return to Vendor.
RET_ADDR_SEQ_NUM Return to Address Prompt: VENDOR_ADDR
Select the Return to Address. The PeopleSoft
Default is „1‟ and should be accepted for the
State of Connecticut.
DST_CNTRL_ID Accounting Template Enter the Accounting Template.
PREFERRED_LANGUA Preferred Language Enter the Preferred Language. Valid translate
GE values are: Valid Translate vales are „E‟ English,
or „F‟ French.
RFQ_DISP_MTHD RFQ Dispatch Method Enter the RFQ Dispatch Method. Valid translate
values are: „EDI‟ Electronic Data Interchange.,
„EML‟ E-mail Dispatch, „FAX‟ Fax
Transmission, „PHN‟ Phone Dispatch, and
„PRN‟ Print.
PRIMARY_VENDOR Invoice Vendor Prompt: VENDOR
Select the Invoice Vendor.
PRIM_ADDR_SEQ_NU Invoicing Location Prompt: VENDOR_ADDR
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 13 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
M Select the Invoicing Location
SHIPTO_ID Ship to Location Enter the Ship to Location.
SUT_BASE_ID Sales/Use Tax Destination Enter the Sales/Use Tax Destination.
SALETX_TOL_AMT Sales Tax Tolerance Enter the Sales Tax Tolerance Amount.
Amount
SALETX_TOL_CUR_CD Sales Tax Tolerance Curr Enter the Sales Tax Tolerance Curr Code.
Code
SALETX_TOL_PCT Sales Tax Tolerance Enter the Sales Tax Tolerance Percent.
Percent
SALETX_TOL_RT_TYP Sales Tax Tolerance Rate Enter the Sales Tax Tolerance Rate Type.
E Type
SALETX_CD_ERS Sales Tax Code ERS Enter the Sales Tax Code ERS.
SALES_USE_TX_FLG Sales/Use Tax Code Enter the Sales/Use Tax Code. The valid
translate values are: „N‟ Non Taxable, „S‟ Sales
Tax, and „U‟
Use Tax. The PeopleSoft default is „N‟.
Required.
AUTO_ASN_FLG Advanced Shipment Edit Y/N
Notification Enter the Advanced Shipment Notification. The
PeopleSoft default is „N‟ and should be used for
the State of Connecticut.
SALETX_TOL_FLG Sales Tax Tolerance Flag Enter the Sales Tax Tolerance Flag. Valid
translate values are: „D‟ Default from Higher
Level, or „S‟ Specify at this Level. PeopleSoft
default is „D‟
Required.
SHIP_LOC_FLG Ship To/End Location Enter the Ship To/End Location Flag. Valid
Flag translate values are: „D‟ Default from Higher
Level, or „S‟ Specify at this Level. PeopleSoft
default is „D‟.
Required.
WTHD_CD Withholding Code Enter the Withholding Code
DOC_TYPE Document Type Enter the Document Type
DOC_TYPE_FLG Document Type Flag Enter the Document Type Flag. . Valid translate
values are: „D‟ Default, or „S‟ Specify.
PeopleSoft default is „D‟.
Required.
RTV_DISPATCH_METH RTV Dispatch Method Enter the RTV Dispatch Method. Translate
values: „EDI‟ Electronic Data Interchange.,
„EML‟ Electronic Mail, „FAX‟ Fax
Transmission, and „PRN‟ Print. The PeopleSoft
Default is „PRN‟.
Required.
RTV_NOTIFY_METH RTV Notification Method Enter the RTV Notification Method. Translate
values: „EML‟ Electronic Mail, or „PHN‟ Phone
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 14 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
Dispatch. The PeopleSoft Default is „PHN.
Required.
RTV_DEBIT_OPT RTV Debit Option Enter the RTV Debit Option. „D‟ Default or „N‟
No. The PeopleSoft Default is „D‟.
Required.
VNDR_SBI_FLAG Allow SBI Edit Y/N
Enter Allow SBI. The PeopleSoft default is „N‟.
Required.
SBI_APPROVAL_FLG SBI Approval Flag Enter the SBI Approval Flag. The valid translate
values are: „A‟ Approved or „U‟ Unapproved.
The PeopleSoft default is „A‟ which should be
accepted for the State of Connecticut.
Required.
ACCOUNT Account Enter the Account.
ALTACCT Alternate Account Enter the Alternate Account.
OPERATING_UNIT Operating Unit Enter the Operating Unit.
DEPTID Department Enter the Department.
PRODUCT Product Enter the Product.
PROJECT_ID Project/Grant Enter the Project/Grant.
AFFILIATE Affiliate Enter the Affiliate
CONSIGNED_FLAG Consigned Flag Edit Y/N
Enter the Consigned Flag. The PeopleSoft
default is „N‟.
Required
VCHR_CONSIGN_OPT Consigned Voucher Enter the Consigned Voucher Option. Valid
Option translate values are: „A‟ Automatic Creation, „M‟
Manual Creation, and „S‟ Stage Pending
Voucher.
ERS_INV_DT_OPT ERS Invoice Date Option Enter the ERS Invoice Date Option. Valid
translate values are „F‟ Freight Terms or „R‟
Receipt Date.
BANK_ACCT_SEQ_NB Bank Account Seq Enter the Bank Account Seq Number.
R Number
ACCT_TEMPL_FLG Accounting Template Enter the Accounting Template. Valid translate
values are: „D‟ Default from Higher Level, and
„S‟ Specify at this Level. The PeopleSoft
Default is „D‟.
Required
PAY_TRM_BSE_DT_DF Payment terms Basis Date Enter the Payment terms Basis Date. Valid
T translate values are: „A‟ Accounting Date, „B‟
Default, „C‟ Constructive Doc Receipt Date, „D‟
Default Higher Level, „I‟ Invoice Date, „R‟
Receipt Date, „S‟; Ship Date, and „U‟ User
Specific Date. The PeopleSoft Default is „B‟.
Required
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 15 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
RECV_ONLY_MTCH_F Recipient Only Match Edit Y/N
LG Enter the Recipient Only Match. The PeopleSoft
default is „N‟.
Required
VCHR_MTCH_ADJ_DF Match Adjustments Enter the Match Adjustments. The valid
LT translate values are: „A‟ Automatic, „D‟ Default
Higher, „N‟ None and „S‟ Stage to Pending File.
The PeopleSoft default is „D‟.
Required
ERS_INV_DT_DFLT ERS Invoice Date Enter the ERS Invoice Date. The valid translate
values are: „D‟ Default Higher, „F‟ Freight
Terms, and „R‟ Receipt Date. The PeopleSoft
default is „D‟.
Required
ERS_TAX_TYPE_DFLT ERS Tax Type Enter the ERS Tax Type. The valid translate
values are „B‟ Buyer‟s Sales Tax, „D‟ Default
Higher, „N‟ None, „U‟ Use Tax, and „V‟ Value
added Tax. The PeopleSoft default is „D‟.
Required
ERS_TAX_CD_OPT ERS Sale Tax Code Enter the ERS Sale Tax Code Override. The
Override Valid translate values are: „D‟ Default from Ship
To, or „S‟ Specify. The PeopleSoft default is „D‟.
Required
LAST_SBI_NUM Last SBI Number Used Enter the Last SBI Number Used.
SBI_DOC_DFLT SBI Document Option Enter the SBI Document Option. The valid
translate values are: „D‟ Default from Higher,
„G‟ Group Vouchers, „I‟ Individual Voucher, and
„P‟ Invoice Number. The PeopleSoft default is
„D‟.
Required
VCHR_TAX_ADJ_DFT Sales and Use Tax Enter the Sales and Use Tax Adjustment. .The
Adjustment valid translate values are: „A‟ Automatic, „D‟
Default Higher, „N‟ None and „S‟ Stage to
Pending File. The PeopleSoft default is „D‟.
Required
RTV_VCHR_ADJ_DFLT RTV Adjustment Option Enter the RTV Adjustment Option. The valid
translate values are: „A‟ Automatic, „D‟ Default
Higher, „N‟ None and „S‟ Stage to Pending File.
The PeopleSoft default is „D‟.
Required
VAT_SUPSENSION_FL Use VAT Suspension Edit Y/N
G Enter the Use VAT Suspension. The PeopleSoft
default is „N‟.
Required
VAT_ROUND_RULE VAT Rounding Rule Enter the VAT Rounding Rule. The valid
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 16 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
translate values are: „D‟ Round Down, „N‟
Natural Round, and „U‟ Round Up. The
PeopleSoft Default is „N.
COMMENTS_2000 Comments Text Enter Comments.
VENDOR_PAY
SETID SetID This field will be defaulted from the SETID
value on the VENDOR_LOC record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR_LOC
record.
Required
VNDR_LOC Vendor Location This field will be defaulted from the
VNDR_LOC value on the VENDOR_LOC
record.
Required
EFFDT Effective Date This field will be defaulted from the EFFDT
value on the VENDOR_LOC record.
Required
SEQ_NUM Sequence This field will be defaulted from the SEQ_NUM
value on the VENDOR_LOC record.
Required
EFF_STATUS Status as of Effective Date This field will be defaulted from the
EFF_STATUS value on the VENDOR_LOC
record.
Required
CURRENCY_CD Currency Code This field will be defaulted from the
CURRENCY_CD value on the VENDOR_LOC
record.
Required
CUR_RT_TYPE Exchange Rate Type This field will be defaulted from the
CUR_RT_TYPE value on the VENDOR_LOC
record.
Required
PYMNT_METHOD Payment Method Enter the Payment Method. Valid translate
values are:
„ACH‟ Automatic Clearing House., „BEF‟ Draft
- Customer EFT, „BOO‟ Customer Initiated
Draft, „CHK‟ System Check, „DD‟ Direct Debut,
„DFT‟ Vendor Initiated Draft, „EFT‟ Electronic
Funds Transfer, „GE‟ Giro – EFT, „GM‟ Giro –
Manual, „LC‟ Letter of Credit, „MAN‟ Manual
Check, „TRW‟ Treasury Wire Flat File and
„WIR‟ Wire Report.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 17 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
PYMNT_HOLD Hold Payments Edit Y/N
Enter the Hold Payments. If this check box is
selected, PeopleSoft Payables automatically
places payments for this vendor on hold. The
PeopleSoft default value is „N‟.
Required
PYMNT_GROUP_CD Pay Group Code Enter the Pay Group Code.
PYMNT_SEPARATE Separate Payment Edit Y/N
Enter the Separate Payment. If this check box is
selected, PeopleSoft Payables creates a separate
payment for each voucher, even if the system
processes multiple vouchers for the vendor in the
same pay cycle. The PeopleSoft default is „Y‟.
PYMNT_HANDLING_C Payment Handling Enter the Payment Handling. The Valid translate
D values are: „HD‟ High Dollar Payment, „IN‟
Internal Distribution, „PO‟ Rout to Purchasing,
and „RE‟ Regular Payments.
DSCNT_ALWAYS_FLG Always take Discount Edit Y/N
Enter the Always take Discount. The PeopleSoft
Default is „N‟.
Required
DELAY_DAYS_FLG Delay Days Flag Enter the Delay Days Flag. The valid translate
values are: „D‟ Default from BU, „N‟ Do Not
employ, and „S‟ Specify. The PeopleSoft default
is „D‟.
Required
DSCNT_DELAY_DAYS Discount Delay Days Enter the Discount Delay Days.
PYMNT_DELAY_DAYS Payment Delays Days Enter the Payment Delays Days.
BANK_CD Bank ID Enter the Bank ID which is the code for the bank
from which payments for this vendor are made.
BANK_ACCT_KEY Bank Account Enter the Bank Account.
CURRENCY_PYMNT Payment Currency Enter the Payment Currency.
CUR_RT_TYPE_PYMNT Payment Currency Rate Enter the Payment Currency Rate Type.
Type
EFT_PYMNT_FMT_CD Payment Format Enter the Payment Format. The valid translate
values are: „00‟ Standard SWIFT Transfer, „10‟
Urgent SWIFT, „15‟ Euro-Transfer, „21‟ Check,
w/ receipt confirmation, „22‟ Check, Urgent,
„23‟ Check, urgent with receipt, „40‟ Postal
Order, „CTX‟ Corp Trade Exchange, „PBC‟
Check, standard, „PPD‟ Prearranged Pay &
Deposit, and „WRT‟ Wire Transfer.
EFT_RTNG_FLG Complex Routing Enter the Complex Routing. The valid translate
values are: „D‟ Use DFI ID, „N‟ None, and „R‟
Use Complex Routing. The PeopleSoft default is
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 18 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
„D‟.
EFT_RTING_STATUS Routing Status Enter the Routing Status. The valid translate
values are: „C‟ Complete, and „I‟ Incomplete.
The PeopleSoft default value is „I‟.
EFT_TRANS_HANDLIN Transaction Handling Enter the Transaction Handling. The valid
G translate values are: „D‟ Payment Only, „P‟
Prenotification, and „X‟ Payment and Advice.
The PeopleSoft default is „X‟
PRENOTE_DATE Prenotification Date Enter the Prenotification Date.
PRENOTE_REQD Prenotification Reqd Edit Y/N
Enter the Prenotification Reqd. The PeopleSoft
default is „N‟
PRENOTE_STATUS Prenotification Status Enter the Prenotification Status. The valid
translate values are: „C‟ Completed, „N‟ Not
Submitted, „P‟ Pending, „R‟ Rejected, and „S‟
Submitted.
EFT_DOM_COSTS_CD Domestic Costs Enter the Domestic Costs. The valid translate
values are: „1‟ Payer‟s Domestic Account, „2‟
Payer‟s Forgiven Account, „3‟ Payee‟s Account,
and „4‟ Trans Exp to Pyr, other to Pye.
EFT_CORR_COSTS_CD Correspondents Costs Enter the Correspondents Costs. The valid
translate values are: „1‟ Payer‟s Domestic
Account, „2‟ Payer‟s Forgiven Account, „3‟
Payee‟s Account, and „4‟ Trans Exp to Pyr, other
to Pye.
EFT_CROSSED_CHECK Crossed Check Edit Y/N
Enter the Crossed Check. The PeopleSoft default
value if „N‟
EFT_CHECK_FWRD_C Check Forwarding Enter the Check Forwarding. The valid translate
D values are: „1‟ Payer‟s Bank, „2‟ Payer, „3‟
Payee, and „4‟ Payee‟s Bank.
EFT_CHECK_DRAW_C Bank Check Drawn On Enter the Bank Check Drawn On. The valid
D translate values are: „1‟ Payer‟s Bank, or „2‟
Payee‟s Bank.
EFT_PAY_INST_CD1 Payment Instruction 1 Enter the Payment Instruction 1
EFT_PAY_INST_CD2 Payment Instruction 2 Enter the Payment Instruction 2
EFT_PAY_INST_CD3 Payment Instruction 3 Enter the Payment Instruction 3
EFT_PAY_INST_CD4 Payment Instruction 4 Enter the Payment Instruction 4
EFT_PAY_INST_REF1 Payment Instruction Ref 1 Enter the Payment Instruction Ref 1
EFT_PAY_INST_REF2 Payment Instruction Ref 2 Enter the Payment Instruction Ref 2
FACTORING_FLG Factoring Edit Y/N
Enter Factoring. The PeopleSoft default value if
„N‟
HOL_PROC_OPT Holiday Processing Option Enter the Holiday Processing Option. The
PeopleSoft default value if „N‟
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 19 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
HOL_PROC_DAYS Days before/after Holiday Enter the Days before/after Holiday
HOL_PROC_OVERFL Pay Permit in Next Month Enter the Pay Permit in Next Month. The
PeopleSoft default value if „N‟
MIN_DFT_AMT Minimum Draft Amount Enter the Minimum Draft Amount.
MIN_DFT_AMT_OPT Minimum Draft Amount Enter the Minimum Draft Amount Option. The
Option valid translate values are: „A‟ Alternative
Payment Method, or „N, Do Not Issue Draft. The
PeopleSoft default value is „N‟
Required.
PYMNT_METHOD_ALT Payment Method Edit Y/N
Enter the Payment Method. The valid translate
values are: „ACH‟ Automatic Clearing House,
„CHK‟ System Check, „DD‟ Direct Debut, „EFT‟
Electronic Funds Transfer, „GE‟ Giro – EFT,
„GM‟ Giro – Manual, „LC‟ Letter of Credit, and
„MAN‟ Manual Check.
GRP_PYMENT_DT Group by Payment Date Edit Y/N
Enter the Group by Payment Date. The
PeopleSoft Default is „N‟.
Required.
BCH_TRANCOST_CD Transfer Cost Code Enter the Transfer Cost Code.
BCH_CALC_SRC Bank Charge source Enter the Bank Charge source.
BCH_CURRENCY_CD Currency CD Enter the Currency CD.
SMT_SPLIT_ID Payment Split ID Enter the Payment Split ID.
SMT_SPLIT_FLG Payment Split Enter the Payment Split.
VNDR_CNTCT_SCR
SETID SetID This field will be defaulted from the SETID
value on the VENDOR record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR record.
Required
CNTCT_SEQ_NUM Contact Sequence Number Enter the Contact Sequence Number. The
PeopleSoft Default is „1‟ and should be accepted
as the default for the State of Connecticut.
Required.
DESCR Description Enter a description for the Vendor Contact.
VENDOR_CNTCT
SETID SetID This field will be defaulted from the SETID
value on the VENDOR_CNTC_SCR record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the
VENDOR_CNTC_SCR record.
Required
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 20 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
CNTCT_SEQ_NUM Contact Sequence Number Enter the Contact Sequence Number. The
PeopleSoft Default is „1‟ and should be accepted
as the default for the State of Connecticut.
Required
EFFDT Effective Date Enter the Effective Date. The PeopleSoft default
is the current system date.
ADDRSS_SEQ_NUM Address Sequence Prompt: VENDOR_ADDR_VW
Number Select the Address Sequence Number.
EFF_STATUS Status as of Effective Date Enter the Status of the Effective Date. The valid
values are „A‟ Active, and „I” Inactive. The
PeopleSoft default is “A‟ and should be used for
CoreCT.
CONTACT_NAME Contact Name Enter the Vendor‟s Contact Name.
CONTACT_TYPE Contact Type Enter the Vendor‟s Contact Type. Valid
translates are: „B‟ Billing Contact, „C‟ Claims,
„E‟ EDI Contact, „G‟ General, „I‟ Internal
Corporate Contact, „M‟ Executive Management,
„O‟ Policy, „P‟ Account Payable, „R‟ Broker, „S‟
Sales Contact, „U‟ Customer Service, „V‟
Service Contact, and „W‟ Warehousing/Shipping
Contact.
CONTACT_TITLE Contact Title Enter the Vendor‟s Contact Title
PREFERRED_LANGUA Preferred Language Enter the Vendor‟s Preferred Language. Valid
GE translate values are:
URL URL Enter the Vendor‟s URL
DESCR Description Enter a description of the Vendor‟s Contact
EMAILID Email ID Enter the Vendor‟s Contact Email ID
VENDOR_LANG
SETID SetID This field will be defaulted from the SETID
value on the VENDOR_CNTCT record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR_CNTCT
record.
Required
LANGUAGE_CD Language Code Enter the Vendor Language Code. Valid
Translate vales are „E‟ English, or „F‟ French.
NAME1 Name 1 Defaulted from the NAME1 field in VENDOR
record.
NAME2 Name 2 Defaulted from the NAME2 field in VENDOR
record.
VNDR_NAME_SHRT_U Short Vendor Name Defaulted from the VNDR_NAME_SHRT_USR
SR field in VENDOR record.
NAME1_AC Name 1 Alternate Char Set Defaulted from the NAME1_AC field in
VENDOR record.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 21 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
NAME2_AC Name 2 Alternate Char Set Defaulted from the NAME2_AC field in
VENDOR record.
VNDR_CNTCT_PHN
SETID SetID This field will be defaulted from the SETID
value on the VENDOR_CNTCT record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR_CNTCT
record.
Required
CNTCT_SEQ_NUM Contact Sequence Number This field will be defaulted from the
CNTCT_SEQ_NUM value on the
VENDOR_CNTCT record.
Required
EFFDT Effective Date This field will be defaulted from the EFFDT
value on the VENDOR_CNTCT record.
Required
PHONE_TYPE Phone Type Enter the phone type for the Vendor. Translate
values are: „BUSN‟ Business, „CAMP‟ Campus,
„CELL” Cellular, „DORM‟ Dormitory, „FAX‟
FAX, „HOME‟ Home, „MAIN‟ Main, „OTR‟
Other, „PGR1‟ Pager 1, „PGR2‟ Pager 2, and
„TELX‟ Telex.
Required.
COUNTRY_CODE Prefix Enter the Vendor Contact Telephone Number
prefix.
PHONE Telephone Enter the Vendor Contact Telephone Number.
EXTENSION Phone Extension Enter the Vendor Contact Telephone Number
Extension.
VENDOR_POLICY
SETID SetID This field will be defaulted from the SETID
value on the VENDOR record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR record.
Required
GROUP_NBR Group Number Enter the Vendor Policy Group Number
Required.
POLICY_NBR Policy Number Enter the Vendor Policy Number
POLICY_BEGIN_DATE Policy Begin Date Enter the Policy Begin Date
POLICY_END_DATE Policy End Date Enter the Policy End Date
POLICY_URL_ID General Policy URL Id Prompt: PSURLDEFN
Select the vendor's website address that provides
general policy information.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 22 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
VENDOR_URL_ID Authorized Providers URL Prompt: PSURLDEFN
Select the vendor's website address that contains
a list of authorized participating providers.
VNDR_PLCY_CNTCT
SETID SetID This field will be defaulted from the SETID
value on the VENDOR_POLICY record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR_POLICY
record.
Required
GROUP_NBR Group Number This field will be defaulted from the
GROUP_NBR value on the VENDOR_POLICY
record.
Required
CNTCT_SEQ_NUM Contact Sequence Number Prompt: VENDOR_CNTCT_VW
Select a contact from the list of contacts that
were entered on the Provider/Vendor Table -
Contacts page. After the contact is selected, the
Contact Name automatically appears.
VNDR_BANK_ACCT
SETID SetID This field will be defaulted from the SETID
value on the VENDOR_LOC record.
Required
VNDR_LOC Vendor ID This field will be defaulted from the
VNDR_LOC value on the VENDOR_LOC
record.
Required
VNDR_LOC Vendor Location This field will be defaulted from the
VNDR_LOC value on the VENDOR_LOC
record.
Required
EFFDT Effective Date This field will be defaulted from the EFFDT
value on the VENDOR_LOC record.
Required
BANK_ACCT_SEQ_NB Bank Account Seq Num This field will be defaulted from the
R BANK_ACCT_SEQ_NBR value on the
VENDOR_LOC record.
Required
DESCR Description Enter a Description for the Vendor Bank account
DEFAULT_IND Default Election Edit Y/N
Enter the Default Election. The PeopleSoft
Default is „N‟.
BANK_ACCT_SBR
BANK_ID_QUAL Bank ID Qual Enter the Bank ID Qual which is the country-
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 23 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
specific numeric value by which the
bank/counterparty is identified. This value
controls how the bank/counterparty pages edit
and display bank information.
BNK_ID_NBR External Bank ID Enter the Bank ID for the bank.
BRANCH_ID Branch ID The branch ID for the bank, if appropriate.
BANK_ACCT_TYPE Bank Account Type Enter the Bank Account Type examples include
Bond, Checking Account, and Life Insurance.
BANK_ACCOUNT_NU Bank Account # The vendor's bank account number.
M
CHECK_DIGIT Check Digit The check digit used by the bank.
DFI_ID_QUAL DFI Qualifier Enter the DFI Qualifier. If Automatic Clearing
House (ACH), Wire, or EFT payments are made
to the vendor location, this field should display
the appropriate DFI Qualifier: The value
determines the format for the DFI ID field. Valid
options are:
Transit Number: The DFI ID is exactly 9 digits,
plus check digit calculation.
Swift ID: The DFI ID is 8 or 11 characters;
positions 5 and 6 must be a valid 2-character
country code.
CHIPS ID: The DFI ID is 3 or 4 digits.
Canadian Bank Branch/Institute and Mutually
Defined: No validation for DFI ID.
DFI_ID_NUM DFI ID The bank's DFI ID. The format is determined by
the value displayed in the DFI Qualifier field.
BENEFICIARY_BANK Beneficiary Bank Enter the Beneficiary Bank.
BENEFICIARY_BNK_A Beneficiary Bank Alt Char Enter the Beneficiary Bank Alt Char Set.
C Set
BENEF_BRANCH Beneficiary Branch Enter the Beneficiary Branch.
BENEF_BRANCH_AC Branch Alternate Char Enter the Branch Alternate Char.
ADDRESS_SBR
COUNTRY Country Prompt: COUNTRY_TBL
Select „USA‟ as the default for Core-CT.
ADDRESS1 Address Line 1 Enter the Bank Address line 1
ADDRESS2 Address Line 2 Enter the Bank Address line 2 if applicable
ADDRESS3 Address Line 3 Enter the Bank Address line 3 if applicable
ADDRESS4 Address Line 4 Enter the Bank Address line 4 if applicable
CITY City Enter the City of the Bank
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 24 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
NUM12 Number 1 Enter the number for the Bank location. Valid for
Spanish Addresses only
NUM2 Number 2 Enter an additional number for the Bank location
if applicable. Valid for Spanish Addresses only
HOUSE_TYPE House Type Enter the house type for the Bank. Translate
Values: „AB‟(House Boat), „WW‟ (Trailer)
This shouldn‟t be used for the bank
ADDR_FIELD1 Address Field 1 Enter the address Field 1 type for the Bank.
Translate Values: „AL‟(Village),
„AP‟(Apartment), „AV‟(Avenue), „BL‟(Housing
Block), „BO‟(District), „CH‟(Villa), „CL‟(Street),
„CM‟(Way), „CO‟(Housing Estate), „CR‟(Road),
„CS‟(Farmhouse), „CT‟(Hill), „ED‟ (Building),
„GL‟(Roundabout), „GR‟(Group), „LG‟(Place),
„MC‟(Market), „MN‟(Municipality),
„MZ‟(Block), „PB‟(Town), „PG‟(Industrial
Zone), „PJ‟(Passage), „PQ‟(Park), „PR‟(Annex),
„PS‟(Promenade), „PZ‟(Square),
„RB‟(Boulevard), „RD‟(Beltway), „TR‟(Alley),
„UR‟(Neighborhood), „ZZ‟(Unknown)
This shouldn‟t be used for the bank
ADDR_FIELD2 Address Field 2 This shouldn‟t be used for the bank
ADDR_FIELD3 Address Field 3 This shouldn‟t be used for the bank
COUNTY County Enter the County of the Bank if applicable
STATE State Prompt: %EDIT_STATE
Select the State of the Bank.
POSTAL Postal Code Enter the Postal Code for the Bank.
GEO_CODE Tax Vendor Geographical Enter the Geographic Code for the Bank.
Code
IN_CITY_LIMIT In City Limit Y/N Edit.
Select the In City Limit indicator.
BUS_PHONE_SBR
COUNTRY_CODE Country Code Enter the Vendor Bank‟s Telephone Country
Code.
PHONE Telephone Enter the Vendor Bank‟s Telephone Number.
EXTENSION Phone Extension Enter the Vendor Bank‟s Telephone Number
Extension.
FAX Fax Number Enter the Vendor Bank‟s Fax Number.
PY_VNDR_MAPPING
SETID SetID This field will be defaulted from the SETID
value on the VENDOR record.
Required
VENDOR_ID Vendor ID This field will be defaulted from the
VENDOR_ID value on the VENDOR record.
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 25 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
Required
NAME1 Name 1 This field will be defaulted from the NAME1
value on the VENDOR record.
Required
SETID_AP Accounts Payable SetID Enter the Accounts Payable SetID
AP_VNDR_ID AP Vendor ID Prompt: VNDR_MAPPING_VW
Select the AP Vendor ID.
Dependencies and Timing:
Testing Considerations:
Assumptions:
The Financials Team will populate all fields and records in the Vendor work unit therefore the
Vendor work unit will not need to be configured for HRMS.
The State of Connecticut will use Application Messaging to send Vendor Information to
PeopleSoft Payroll from Payables.
The Application Messages used to synchronize the data in the Vendor work unit are
VENDOR_FULLSYNC, and VENDOR_SYNC.
Financials will go live prior to HRMS.
Revisions
Date:
Comments:
Name:
Changes Needed:
Reasons:
Input Provided By:
Name Title, Department
Jacquie Langworthy Configuration Team (Accenture)
Mark Bissoni Configuration Team
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 26 of 27
Jiasoj
Jdfljsdoi
sl Configuration Approach
State of Connecticut Vendor
Core-CT Project
SIGNOFFS
Configuration Team
_________________________ _________________________
_________________________ _________________________
Configuration Team Leads
_________________________ _________________________
Ryan Oakes Ron Kuehner
Module Team Leads
_________________________ _________________________
Team Leads
_________________________ _________________________
Rajeev Sharma Anne North
_________________________
Sue Martin
D:\Docstoc\Working\pdf\7d35ea6f-2d6e-4ee2-9d26-994d28de943f.doc
10/24/2011 3:22 PM Page 27 of 27