AR_WC_INTFC_RS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	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.
3	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.
4	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
5	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
6	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.
7	ENTRY_REASON	Character(5)	VARCHAR2(5) NOT NULL	"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
8	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
9	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
10	ENTRY_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the monetary amount of a pending item transaction such as invoice or credit memo in the base currency of the business unit.
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
13	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
14	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
15	INVOICE_DT	Date(10)	DATE	Invoice Date
16	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
17	INVOICE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
18	INVOICE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Invoice Amount
19	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
20	BILL_SOURCE_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Source
21	CONSOL_HDR	Character(1)	VARCHAR2(1) NOT NULL	Consolidated Hdr? N=No Y=Yes
22	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.
23	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
24	RECEIPT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Receipt Number
25	BUS_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Business Unit Type AR=Accounts Receivable OM=Order Management
26	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion
27	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
28	RECON_ID	Character(15)	VARCHAR2(15) NOT NULL	Reconciliation ID
29	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
30	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
31	CLAIM_ID	Character(15)	VARCHAR2(15) NOT NULL	Claim ID
32	CLAIM_SETTLE_SEQ	Number(5,0)	INTEGER NOT NULL	Claim Settlement Sequence
33	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
34	SETTLEMENT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Vendor Rebate Settlement Method (Payment Method) ACH=Automated Clearing House AV=Adjustment Voucher CHK=Check CM=Credit Memo DD=Direct Debit DR=Draft EFT=Electronic Funds Transfer
35	AMT_CLAIM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Claim Amount
36	LB_BANK_TRANS_ID	Character(20)	VARCHAR2(20) NOT NULL	Bank Transmission ID
37	LOCKBOX_ID	Character(15)	VARCHAR2(15) NOT NULL	Lockbox ID
38	LOCKBOX_BATCH_ID	Character(5)	VARCHAR2(5) NOT NULL	Lockbox Batch Id
39	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
40	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
41	CONTROL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.
42	CONTROL_CNT	Number(6,0)	INTEGER NOT NULL	Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly
43	RECEIVED_DT	Date(10)	DATE	Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
44	LOCKBOX_RUN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Lockbox Run Id
45	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
46	DATA_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Data Source 820=820 ANSI-X12 APP=Accounts Payable Payment BST=Bank Statement CDR=Cash Drawer Receipts CRX=EDIFACT CREEXT LBX=Lockbox ONL=Online XEL=Excel Upload
47	LB_FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	Name of Lockbox File
48	KK_TRAN_ID	Character(10)	VARCHAR2(10) NOT NULL	Commitment Control Foreign Key for Transaction Identification.
49	KK_TRAN_DT	Date(10)	DATE	Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
50	KK_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
51	KK_PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status E=Errors Exist I=Document in process N=Process Unsuccessful P=Provisionally Valid V=No Errors or Warnings W=Only Warnings Exist X=Unrecorded Errors Exist
52	SELECTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selected Flag N=Not Selected Y=Seleted
53	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.
54	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field