AR_1099C_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
7	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
8	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
9	CREDITOR_ID1	Character(40)	VARCHAR2(40) NOT NULL	Field's label for SEPA Direct Debit Form
10	TIN	Character(20)	VARCHAR2(20) NOT NULL	Taxpayer Identification Number
11	TIN1	Character(20)	VARCHAR2(20) NOT NULL	Taxpayer Identification Number
12	CONTROL_ID	Character(25)	VARCHAR2(25) NOT NULL	Control ID
13	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
14	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
15	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
16	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
17	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
18	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
19	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
20	CALENDAR_YEAR	Number(4,0)	SMALLINT NOT NULL	Calendar Year
21	FROM_DT	Date(10)	DATE	From Date
22	TO_DT	Date(10)	DATE	To Date
23	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
24	ASOF_DT	Date(10)	DATE	As of Date
25	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
26	ENTRY_USE_ID	Character(5)	VARCHAR2(5) NOT NULL	Specifies the System Function or type of processing associated with an entry type.
27	ENTRY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of a pending item transaction such as invoice or credit memo.
28	LAST_RUN_DTM	DateTime(26)	TIMESTAMP	Last Run On
29	WHERE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Where Option B=Both N=None P=Process Instance V=By Value
30	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
31	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
32	MARKET_VALUE	Number(27,3)	DECIMAL(26,3) NOT NULL	Market Value
33	BUSINESS_UNIT_AR	Character(5)	VARCHAR2(5) NOT NULL	AR Business Unit
34	CUST_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
35	INTEREST_EXPENSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest Expense
36	INTEREST_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Interest Amount