EM_BUY_TEMPLATE

#	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_SETID_NONVW
2	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
3	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCT_NB_VW Set Control Field: SETID
4	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. Prompt Table: VAT_ENTITY
5	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: SP_LEDG_A_NONVW
6	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Prompt Table: SP_LGRP_A_NONVW
7	CALENDAR_ID	Character(2)	VARCHAR2(2) NOT NULL	Calendar ID Prompt Table: CAL_DEFN_TBL Set Control Field: SETID
8	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups. Prompt Table: BUS_CAL_HOL_DFN
9	APPL_JRNL_ID_ACCR	Character(10)	VARCHAR2(10) NOT NULL	Accruals Prompt Table: JRNLGEN_APPL_ID
10	APPL_JRNL_ID_CASH	Character(10)	VARCHAR2(10) NOT NULL	Payments Prompt Table: JRNLGEN_APPL_ID
11	APPL_JRNL_ID_CLOSE	Character(10)	VARCHAR2(10) NOT NULL	Closes Prompt Table: JRNLGEN_APPL_ID
12	APPL_JRNL_ID_CSHCL	Character(10)	VARCHAR2(10) NOT NULL	Cash Clearings Prompt Table: JRNLGEN_APPL_ID
13	APPL_JRNL_ID_RVL	Character(10)	VARCHAR2(10) NOT NULL	Revaluations Prompt Table: JRNLGEN_APPL_ID
14	APPL_JRNL_ID_VOID	Character(10)	VARCHAR2(10) NOT NULL	Cancels Prompt Table: JRNLGEN_APPL_ID
15	COMBO_EDIT_TMPL	Character(10)	VARCHAR2(10) NOT NULL	Record Template Prompt Table: AP_COMB_TMPL_VW
16	SALETX_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Prompt Table: BU_STX_LC_CMPVW
17	USETAX_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Prompt Table: BU_UTX_LC_CMPVW
18	FRGHT_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Prompt Table: BU_FRG_LC_CMPVW
19	MISC_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement Prompt Table: BU_MSC_LC_CMPVW
20	VCHR_BLD_DEFN	Character(10)	VARCHAR2(10) NOT NULL	Voucher Build Criteria Prompt Table: VCHR_BLD_CODE
21	ASSTN_ALG_NAME	Character(15)	VARCHAR2(15) NOT NULL	Document Association Prompt Table: AP_ASSTN_ALGHDR
22	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty. Prompt Table: SP_SETID_NONVW
23	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
24	PYMNT_TERMS_CD_PPY	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
25	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling Prompt Table: EM_PYMT_HNDL_VW Set Control Field: SETID
26	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
27	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
28	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Prompt Table: ORIGIN_PROCURE
29	TAX_EXEMPT	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit Default Value: N
30	TAX_EXEMPT_ID	Character(30)	VARCHAR2(30) NOT NULL	Tax Exempt ID
31	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID Prompt Table: SP_SETID_NONVW
32	DST_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Accounting Template Prompt Table: DST_CNTRL_VW
33	VAT_USE_ID	Character(6)	VARCHAR2(6) NOT NULL	VAT Use Type Prompt Table: VAT_USE_TBL
34	EM_VAT_OPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Y/N Table Edit Default Value: N
35	EM_AGREEMENT_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
36	CUR_RT_TYPE_PAID	Character(5)	VARCHAR2(5) NOT NULL	Payment Rate Type Prompt Table: RT_TYPE_TBL
37	VAT_NRCVR_CHRG_CD	Character(10)	VARCHAR2(10) NOT NULL	ProrateVAT Non-Recovery Prompt Table: EM_NRV_LC_VW Set Control Field: SETID
38	EM_NOTIFY_SETID	Character(5)	VARCHAR2(5) NOT NULL	eS - field to store the SETID value for Notifications. Prompt Table: SP_SETID_NONVW
39	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
40	VAT_SVC_PERFRM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Where VAT Services Physically Performed Flag 1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location