NET_AUTOSEL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	NUM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	AUTO_NUM_INSTAL. To enable a value in the Auto NUmber by Installation you need to add the value to the Record SearchInit Peoplecode in record AUTO_NUM_INSTAL
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	SQLROWS	Number(5,0)	INTEGER NOT NULL	SQL Rows
6	STOP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Stop Search Here
7	NET_CONTRACT_ID	Character(10)	VARCHAR2(10) NOT NULL	Contract ID : To identify unique contract.
8	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
9	NET_PARTICIPANT_ID	Character(12)	VARCHAR2(12) NOT NULL	Netting Participant ID, ID to define which Vendors/Customers//Business Units are available to be netted.
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	NETTING_SEQ_NO	Number(10,0)	DECIMAL(10) NOT NULL	Netting Sequence Number
12	STL_NETSCHED_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID for Settlement Instructions used on other objects that don't contain setid as part of their key.
13	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID
14	PRE_APPROVAL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Pre Approval Flag Y/N Table Edit Default Value: N
15	NET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Indicates the status of a given Netting Run: Open Approve Cancel Close A=Approved C=Closed O=Open X=Cancelled
16	DUE_DT_START	Date(10)	DATE	Start Due Date
17	DUE_DT_END	Date(10)	DATE	End Due Date
18	ORDER_BY_AP	Character(50)	VARCHAR2(50) NOT NULL	Order By AP
19	ORDER_BY_AR	Character(50)	VARCHAR2(50) NOT NULL	Order By AR
20	RULE_AP	Character(254)	VARCHAR2(254) NOT NULL	Rule AP
21	RULE_AR	Character(254)	VARCHAR2(254) NOT NULL	Rule AR
22	TOTAL_AP_TXNS	Number(5,0)	INTEGER NOT NULL	Total Payable Transactions
23	TOTAL_PAY_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	An internal work field in the settlements module that contains a summary of all outbound transact
24	TOTAL_PAY_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Payment Amount - Base
25	PAY_DISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bi-Lateral Netting - Payable Discount Available Amount
26	TOTAL_AR_TXNS	Number(5,0)	INTEGER NOT NULL	Total Receivable Transactions
27	TOTAL_RCV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	An internal work field in the settlements module that contains a summary of all inbound transacti
28	TOTAL_REC_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Receivable Amount - Base
29	RCV_DISC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Bi-Lateral Netting - Receivable Discount Available Amount
30	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
31	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
32	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
33	PYMNT_GROSS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Gross Payment Amount
34	GROSS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Gross Amount
35	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.
36	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.
37	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
38	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
39	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency
40	NET_TXN_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Transaction Status B=Balance D=DeSelect - Full DB=DeSelect Split - Balance DF=DeSelect - Full DN=DeSelect Split - Net N=Net NA=Not Applicable S=Split - Net / Balance
41	NET_PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Netting Payment Amount
42	NET_BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Netted Amount
43	NET_BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Netting Balance Amount Base
44	BAL_PYMNT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance Payment Amount
45	BAL_BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance Amount
46	BAL_BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance Amount Base
47	AE_DO_WHEN	Character(1)	VARCHAR2(1) NOT NULL	When
48	AE_ROW_COUNT	Number(4,0)	SMALLINT NOT NULL	in Scroll
49	REM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Remaining Amount
50	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
51	NETTING_BU	Character(5)	VARCHAR2(5) NOT NULL	Holds GL Business Unit
52	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
53	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. "
54	BEG_SEQ	Character(3)	VARCHAR2(3) NOT NULL	Beginning Sequence
55	MAX_LENGTH	Number(2,0)	SMALLINT NOT NULL	Maximum Length of Auto Number
56	LAST_AUTO_NBR	Number(18,0)	DECIMAL(18) NOT NULL	Last Auto-Assigned Number
57	NET_REF_LAST_USED	Number(12,0)	DECIMAL(12) NOT NULL	Last Netting Reference
58	NET_REF_ID	Character(12)	VARCHAR2(12) NOT NULL	A reference identifier associated with a cash transaction subject to netting with a given bank/count
59	NET_APPLY_DSCNT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether to apply AP/AR discount amounts to the netted transactions. Default Value: N
60	SQL_TEXT_AP	Character(254)	VARCHAR2(254) NOT NULL	Payable SQL
61	SQL_TEXT_AR	Character(254)	VARCHAR2(254) NOT NULL	Receivable SQL
62	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text
63	COUNTER_NAME	Character(30)	VARCHAR2(30) NOT NULL	Counter Name