BI_BBY_DFT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	SQLTABLENAME	Character(18)	VARCHAR2(18) NOT NULL	SQL Table Name
4	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
5	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
7	TMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Field for holding temp data
8	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
9	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
10	BILL_BY_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill By Identifier
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
13	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
14	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
15	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
16	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
17	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
18	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
19	BILLING_AUTHORITY	Character(8)	VARCHAR2(8) NOT NULL	Billing Authority
20	BILLING_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Billing Specialist
21	BILL_CYCLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Billing Cycle Identifier
22	BILL_INQUIRY_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Bill Inquiry Phone
23	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
24	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
25	CR_ANALYST	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
26	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
27	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
28	INVOICE_FORM_ID	Character(10)	VARCHAR2(10) NOT NULL	Invoice Form
29	PAYMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft. 10/28/2003 edw 655070000 - Removed LTC and CSH xlats. ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report
30	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.
31	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
32	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code
33	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
34	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
35	CONSOL_SETID	Character(5)	VARCHAR2(5) NOT NULL	Consolidation Customer SetID
36	CONSOL_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Consolidation Customer ID
37	CONSOL_KEY	Character(22)	VARCHAR2(22) NOT NULL	Invoice Consolidation Key
38	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
39	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.