BI_RMAADJ_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	JOB_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
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	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
6	INTFC_LINE_NUM	Number(8,0)	INTEGER NOT NULL	Interface Line Number
7	TRANS_TYPE_BI_SEQ	Number(3,0)	SMALLINT NOT NULL	Transaction Type Seq 010=Invalid Transaction Type 020=Too many charge lines 030=No charge line for activity 040=Invalid Business Unit 050=Invalid bill-to customer 060=Invalid Billing Address 070=Invalid bill-to contact 080=No Bill Source provided 090=Invalid Bill Source 100=Invalid Bill Type 110=Invalid Bill Cycle 120=Invalid Payment Term 130=Invalid Tax Code 140=Invalid Unit of measure 200=Invalid Standard Note Code 210=No Note Code or Text exists 300=Both Amount & Percentage are 0
8	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
9	BUSINESS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Order Management Business Unit
10	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
11	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number
12	RMA_ID_START	Character(10)	VARCHAR2(10) NOT NULL	From RMA ID
13	RMA_LINE_NBR	Number(5,0)	INTEGER NOT NULL	RMA Line Number
14	RMA_ID_END	Character(10)	VARCHAR2(10) NOT NULL	To RMA ID
15	BILL_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Bill Type Identifier
16	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
17	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
18	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
19	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
20	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
21	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
22	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
23	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
24	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return
25	TAX_TRANS_SUB_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Sub Type 1=Property 2=Freight 3=Service 4=Rental or Lease 5=Expense 6=Misc N=None
26	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
27	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
28	RMA_ADJ_BI_SRC	Character(1)	VARCHAR2(1) NOT NULL	Billing source for RMAs I=INBU N=No RMAs O=OMBU
29	RMA_BILL_BY_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Bill By Identifier
30	AMT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Adjusted
31	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag
32	ORD_ACCEPT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Acceptance
33	ORD_ORIGIN_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Origin
34	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.
35	ACTION_FLG	Character(1)	VARCHAR2(1) NOT NULL	Action Flag A=Action
36	BI_RECCOUNT	Number(10,0)	DECIMAL(10) NOT NULL	BI Rec Count
37	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.
38	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code
39	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
40	REF_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Reference Line Number
41	REF_SCHED_NBR	Number(6,0)	INTEGER NOT NULL	Referenced Schedule Number
42	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
43	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
44	MULTI_CURR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Multi-Currency N=No Y=Yes
45	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
46	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
47	CURTEMPINSTANCE	Number(4,0)	SMALLINT NOT NULL	Temp Table Instance
48	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
49	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
50	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
51	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
52	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
53	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
54	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
55	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
56	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
57	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
58	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
59	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
60	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
61	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
62	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
63	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
64	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
65	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
66	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State
67	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
68	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
69	LINE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Line Type 1 ADV=Advance Billing BAE=Billed Amount in Excess BRT=Billing Retainage DAPP=Cust Deposit Applied DEP=Customer Deposit DISC=Discount Line DREF=Cust Deposit Refunded DRFF=Cust Deposit Refund Fee FRGT=Freight (Surcharge) MISC=Miscellaneous Charge PYCV=Payment with Corporate Voucher RAE=Reclaimed Amount in Excess REV=Revenue Line RSTK=Restock (Surcharge) SUR=Surcharge Line UTL=Utilization Line
70	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
71	TAX_DIVISION	Character(5)	VARCHAR2(5) NOT NULL	Division for Tax Suppliers
72	TAX_DEPARTMENT	Character(5)	VARCHAR2(5) NOT NULL	Department used by Tax Vendors
73	SHIP_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Ship From Location
74	PT_SALE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Point of Sale Flag
75	TAX_DATE	Date(10)	DATE	Tax Date
76	TAX_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Tax Customer ID
77	TAX_USER_AREA	Character(25)	VARCHAR2(25) NOT NULL	Used for tax calculation by tax vendor.
78	TITLE_PASSAGE	Character(1)	VARCHAR2(1) NOT NULL	Title Passage B=Buyer's Destination-Ship To I=Intermediate Consignee S=Seller's Origination-Ship From
79	STORE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Store Location
80	TAX_JOB_NUM	Character(10)	VARCHAR2(10) NOT NULL	Job Number
81	TAX_EXEMPT_RC	Character(2)	VARCHAR2(2) NOT NULL	Exempt Reason Code 01=Certificat
82	TAX_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Tax Group
83	REF_BUS_UNIT_OM	Character(5)	VARCHAR2(5) NOT NULL	Reference Order Management Business Unit
84	USETAX_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Use Tax Basis Amount
85	OM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OM Work Flag
86	ORIG_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Original Quantity
87	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
88	INVOICE_TO_ADJ	Character(22)	VARCHAR2(22) NOT NULL	Invoice To Adjust
89	LINE_SEQ_TO_ADJ	Number(5,0)	INTEGER NOT NULL	Line Sequence To Adjust