SUBCUST_DATA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.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. Prompt Table: CUST_BI_A2_VW
3	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
4	SUBCUST_QUAL2	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
5	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
6	HI_BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Hi Balance
7	HI_BAL_DT	Date(10)	DATE	Hi Balance Date
8	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.
9	ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
10	ITEM_DT	Date(10)	DATE	Item Date
11	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
12	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.
13	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.
14	PAYMENT_DT	Date(10)	DATE	Payment Date
15	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
16	POSTED_PI	Number(10,0)	DECIMAL(10) NOT NULL	Last Post Process Instance
17	AGED_DT	Date(10)	DATE	Aged Date
18	AGED_PI	Number(10,0)	DECIMAL(10) NOT NULL	Last Aging Process Instance
19	PAYMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
20	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
21	ENTRY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency associated with the monetary amount of a pending item.
22	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.
23	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
24	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
26	AGED_AMT_CR_CHK	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Credit Checked