PAYMNT_ADV_RPT

#	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	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Default Value: PAYMENT_ITEM.DEPOSIT_BU
5	DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated. Default Value: PAYMENT_ITEM.DEPOSIT_ID
6	PAYMENT_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit. Default Value: PAYMENT_ITEM.PAYMENT_SEQ_NUM
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PAYMENT_ITEM.BUSINESS_UNIT
8	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. Default Value: PAYMENT_ITEM.CUST_ID
9	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. Default Value: PAYMENT_ITEM.ITEM
10	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line Default Value: PAYMENT_ITEM.ITEM_LINE
11	AR_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	A number that is assigned to draft items to ensure uniqueness of key Default Value: PAYMENT_ITEM.AR_SEQ_NUM
12	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 Default Value: PAYMENT_ITEM.ORDER_NO
13	TOTAL_CGST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total CGST Tax Amount
14	TOTAL_SGST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total SGST Tax Amount
15	TOTAL_IGST_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total IGST Tax Amount
16	GST_CESS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GST Cess amount
17	CGST_AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CGST Amount Remaining
18	SGST_AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SGST Adjusted Tax Amount
19	IGST_AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	IGST Adjusted Tax Amount
20	CGST_AMT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	CGST Adjusted Tax Amount
21	SGST_AMT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SGST Adjusted Tax Amount
22	IGST_AMT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	IGST Adjusted Tax Amount
23	ADVANCE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Advance Amount
24	PRINCIPAL_ADV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Principal portion of advance
25	PRINCIPAL_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The notional principal balance of a given deal transaction at commencement.
26	REMAIN_ADV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Advanced Amount Remaining
27	PLACE_OF_SUPPLY	Character(10)	VARCHAR2(10) NOT NULL	Place of Supply
28	GST_RGSTN_NBR	Character(30)	VARCHAR2(30) NOT NULL	GST Registration Number
29	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
30	RPT_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	In process flag Default Value: N
31	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code