BUOPTAP_TEO3

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	ACCOUNTING_DT_IND	Character(1)	VARCHAR2(1) NOT NULL	Accounting Date Indicator C=Use Current Date D=Business Unit Default P=Use Payment Date S=Use Specific Date Default Value: C
6	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
8	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: RT_TYPE_TBL
9	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 Default Value: CHK
10	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
11	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
12	DSCNT_ALWAYS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Always take discount Y/N Table Edit Default Value: Y
13	DSCNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Discount Delay Days
14	PYMNT_DELAY_DAYS	Signed Number(5,0)	DECIMAL(4) NOT NULL	Payment Delay Days
15	PYMNT_HANDLING_CD	Character(2)	VARCHAR2(2) NOT NULL	Payment Handling Prompt Table: PYMNT_HNDL_TBL
16	DUP_INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Duplicate Invoice Severity K=Reject R=Recycle W=Warning Default Value: K
17	DUP_INV_NUM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Invoice Number N=No Y=Yes Y/N Table Edit Default Value: Y
18	DUP_INV_DT	Character(1)	VARCHAR2(1) NOT NULL	Invoice Date N=No Y=Yes Y/N Table Edit Default Value: Y
19	DUP_INV_VENDOR_NUM	Character(1)	VARCHAR2(1) NOT NULL	Vendor ID N=No Y=Yes Y/N Table Edit Default Value: Y
20	DUP_INV_GROSS_AMT	Character(1)	VARCHAR2(1) NOT NULL	Gross Amount N=No Y=Yes Y/N Table Edit Default Value: Y
21	DUP_INV_BUS_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Business Unit N=No Y=Yes Y/N Table Edit Default Value: Y
22	DUP_INV_COMB_CODE	Number(3,0)	SMALLINT NOT NULL	Dupl Invoice Combination Code
23	GRP_AP_POST_OPT	Character(1)	VARCHAR2(1) NOT NULL	Post Option 1=Post Vouchers as Group 2=Post Vouchers Individually Default Value: 2
24	VCHR_BALANCE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Voucher Balance Option D=Default from Higher Level K=Reject Unbalanced Vouchers R=Recycle Unbalanced Vouchers Default Value: K
25	CHART_EDIT_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Chartfield Edit Option D=Default from Higher Level K=Reject w/ edit error N=No Edits R=Recycle S=Use suspense account W=Warning Default Value: K
26	COMBO_EDIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Edit Combinations Y/N Table Edit Default Value: N
27	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: BANK_CD_VW
28	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: BANK_ACCT_VW11
29	VCHR_APPRVL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Voucher Approval Flag D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework Default Value: P
30	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: BUSPROCNAME_VW
31	APPR_RULE_SET	Character(30)	VARCHAR2(30) NOT NULL	Approval Rule Set Prompt Table: APPR_RULE_HDR
32	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN). Prompt Table: ROLE_USRLST_VW
33	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: SHIPTO_TBL
34	SUT_BASE_ID	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Tax Destination Prompt Table: SHIPTO_TBL
35	SALETX_TOL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Tolerance Flag D=Default from Higher Level S=Specify at this Level Default Value: S
36	SALETX_TOL_PCT	Number(6,2)	DECIMAL(5,2) NOT NULL	Sales Tax Tolerance Percent
37	SALETX_TOL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Tolerance Amount
38	SALETX_TOL_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Sales Tax Tolerance Curr Code Prompt Table: CURRENCY_CD_TBL
39	SALETX_TOL_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Sales Tax Tolerance Rate Type Prompt Table: CUR_RT_TYPE_TBL
40	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. Prompt Table: DOC_TYPE_TBL
41	RECEIPT_AWARE	Character(1)	VARCHAR2(1) NOT NULL	Receipt Awareness Level H=Find receipts by quantity L=Use receipts on voucher only M=Sum all receipts for PO Default Value: M
42	PROCESS_PPV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Purchase Price Variance Y/N Table Edit Default Value: N
43	PROCESS_ERV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Exchange Rate Variance Y/N Table Edit Default Value: N
44	HOL_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Holiday Processing Option A=Due After Holiday B=Due Before Holiday N=Not Applicable Default Value: N
45	HOL_PROC_DAYS	Number(3,0)	SMALLINT NOT NULL	Days before/after Holiday
46	HOL_PROC_OVERFL	Character(1)	VARCHAR2(1) NOT NULL	Allow due date in next month Y/N Table Edit Default Value: N
47	RECALC_SUT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Recalculate Sales/Use Tax Y/N Table Edit Default Value: N
48	TAX_ADJ_DIFF_OPT	Character(1)	VARCHAR2(1) NOT NULL	SUT Difference Opt A=Accrue Difference N=Not Applicable S=Short Pay Default Value: N
49	TAX_ADJ_LIMIT_OPT	Character(1)	VARCHAR2(1) NOT NULL	Adjustment Limit Option B=Both Over/Under N=Not Applicable O=Over U=Under Default Value: N
50	VCHR_TAX_ADJ_DFT	Character(1)	VARCHAR2(1) NOT NULL	Sales and Use Tax Adjustments A=Automatic D=Default N=None S=Stage to Pending File Default Value: D
51	DFT_SIGHT_CD	Character(5)	VARCHAR2(5) NOT NULL	Draft Sight Code Prompt Table: APD_SIGHTCD_TBL
52	DFT_APPROVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Draft Issue Approval Required Y/N Table Edit Default Value: Y
53	DATE_CALC_BASIS	Character(1)	VARCHAR2(1) NOT NULL	Date Calculation Basis A=Agricultural Commodities D=Dairy M=Meat O=Poultry P=Prompt Pay Basis 7 Days Q=Prompt Pay Basis 14 Days
54	PAY_SCHEDULE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Pay Schedule Type MAN=Manual OTH=Other Non Transportation TRN=Transportation
55	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_VW4
56	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
57	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
58	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
59	PREPAID_AUTO_APPLY	Character(1)	VARCHAR2(1) NOT NULL	Automatically Apply Prepayment