BSUNTBL_BI_TEO1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
4	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
5	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. "
6	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
7	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
8	IVC_NUM_ID	Character(8)	VARCHAR2(8) NOT NULL	Invoice Number ID
9	BI_PNLSERIES_ID	Character(8)	VARCHAR2(8) NOT NULL	Page Series ID
10	GL_LVL	Character(1)	VARCHAR2(1) NOT NULL	GL Level A=AR Creates GL Acct Entries B=BI Creates GL Acct Entries N=No GL Accounting Entries
11	AR_LVL	Character(1)	VARCHAR2(1) NOT NULL	AR Level H=Header is AR Open Item L=Bill Line is AR Open Item N=No AR Open Items
12	AR_DST_OPT	Character(1)	VARCHAR2(1) NOT NULL	AR Distribution Option H=Use Header for Distribution L=Use Line for Distribution
13	ENTRY_TYPE_DB	Character(5)	VARCHAR2(5) NOT NULL	Debit Entry Type
14	ENTRY_REASON_DB	Character(5)	VARCHAR2(5) NOT NULL	Debit Entry Reason
15	ENTRY_TYPE_CR	Character(5)	VARCHAR2(5) NOT NULL	Credit Entry Type
16	ENTRY_REASON_CR	Character(5)	VARCHAR2(5) NOT NULL	Credit Entry Reason
17	ENABLE_DFR_REV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enable Deferred Revenues
18	DFR_ACCTG_DT_CD	Character(1)	VARCHAR2(1) NOT NULL	Future Period Accounting Dates F=First Day in Accounting Period L=Last Day in Accounting Period U=User Defined
19	DFR_REV_PRORATION	Character(1)	VARCHAR2(1) NOT NULL	Proration Method 1=By Days Within Range 2=Evenly Using All Pds 3=Evenly Using Mid-period Rule 4=Evenly/Partial by Days 5=User Defined Proration Method
20	DFR_MID_PERIOD_DAY	Number(2,0)	SMALLINT NOT NULL	Mid-Period # of Days
21	ENABLE_ACCRUED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enable Contract Asset Accrual
22	APPL_JRNL_ID_RVRSL	Character(10)	VARCHAR2(10) NOT NULL	Accrued Journal Template
23	DST_ID_UAR	Character(10)	VARCHAR2(10) NOT NULL	Contract Asset Distribution
24	ACCRUE_UNBILLED	Character(1)	VARCHAR2(1) NOT NULL	Accrue Bills of This Level
25	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
26	GROUP_ID_SEQ_NUM	Number(15,0)	DECIMAL(15) NOT NULL	Group ID
27	TAX_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Tax Provider A=Taxware N=None V=Vertex
28	TAX_COMPANY	Character(5)	VARCHAR2(5) NOT NULL	Company for Tax Suppliers
29	TAX_DIVISION	Character(5)	VARCHAR2(5) NOT NULL	Division for Tax Suppliers
30	TAX_DEPARTMENT	Character(5)	VARCHAR2(5) NOT NULL	Department used by Tax Vendors
31	ORD_ACCEPT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Acceptance
32	ORD_ORIGIN_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Origin
33	DST_ID_SUT	Character(10)	VARCHAR2(10) NOT NULL	Sales/Use Distribution Code
34	DST_ID_GST	Character(10)	VARCHAR2(10) NOT NULL	GST Distribution Code
35	ORIGIN_AP	Character(3)	VARCHAR2(3) NOT NULL	AP Origin ID
36	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.
37	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
38	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
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
41	AG_CONTRACT	Character(1)	VARCHAR2(1) NOT NULL	Acceptgiro Contract - inital implementation wil only include type A/S, future enhancements may include additional Acceptgiro types. 0=None 1=A/S Contract Default Value: 0
42	BU_FSS_FLG	Character(1)	VARCHAR2(1) NOT NULL	02/15/06 EGS: Created
43	ATT_IVC_IMG_OPT	Character(1)	VARCHAR2(1) NOT NULL	Attach Invoice Image Option 0=Do not Attach Invoice Image 1=Attach Invoice Image 9=Not Defined at this level
44	BILL_TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Bill entry template ID
45	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
46	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
47	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
48	BI_APPROVAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Enable Invoice Approvals
49	ONLY_APPR_CREDITS	Character(1)	VARCHAR2(1) NOT NULL	Only Submit Credits
50	ACCRUE_USE_TAX	Character(1)	VARCHAR2(1) NOT NULL	Accrue Use Tax Y/N Table Edit Default Value: N
51	DST_ID_USETAX	Character(10)	VARCHAR2(10) NOT NULL	Use Tax Distribution Code Prompt Table: DST_CODE_TBL
52	DST_ID_UT_OFFSET	Character(10)	VARCHAR2(10) NOT NULL	Use Tax Offset Distribution Co Prompt Table: DST_CODE_TBL
53	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
54	BI_AP_LVL	Character(1)	VARCHAR2(1) NOT NULL	InterUnit AP Level H=Header is AP Voucher L=Bill Line is AP Voucher N=No AP Voucher
55	SCM_CCI_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Credit Card Group Prompt Table: SCM_CC_GROUP_VW
56	CC_TYPE_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Select Credit Card Type Y/N Table Edit
57	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code