SII_PAY_AR_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SII_INVOICE_ID	Character(60)	VARCHAR2(60) NOT NULL	SII_INVOICE_ID
4	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
5	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. Prompt Table: CUST_BI_A2_VW
6	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.
7	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
8	PYMNT_DT	Date(10)	DATE	Payment Date
9	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
10	PAY_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Payment Amt - Base Curr
11	SII_PAY_AMT_XEU	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
12	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
13	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
14	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
15	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
16	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
17	PAYMENT_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
18	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. "
19	PYMT_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.
20	SII_RATE_MULT_XEU	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
21	SII_RATE_DIV_XEU	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
22	INVOICE_DT	Date(10)	DATE	Invoice Date
23	SII_INVOICE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	VAT Submission Status A=Accepted AE=Accepted with Error E=Error G=Generated M=Manual R=Ready RV=Reversed RX=Rejected S=Submitted
24	ERROR_CODE	Character(10)	VARCHAR2(10) NOT NULL	Error Code
25	LAST_UPDATE_DT	Date(10)	DATE	Last Updated
26	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance