DD_ITEM_TEO2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DD_BU	Character(5)	VARCHAR2(5) NOT NULL	Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.
3	DD_ID	Character(15)	VARCHAR2(15) NOT NULL	Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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.
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	ASOF_DT	Date(10)	DATE	As of Date
9	ITEM_SELECTED	Character(1)	VARCHAR2(1) NOT NULL	Item selected switch
10	DD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process. A=Accepted C=Complete E=Rejected N=No Action P=Pending R=Remitted Z=All
11	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.
12	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""."
13	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
14	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
15	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency
16	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
17	ENTRY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency associated with the monetary amount of a pending item.
18	DD_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency in which a direct debit is created. This field is maintained by the Direct Debit generation process.
19	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
20	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
21	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
22	PO_LINE	Number(3,0)	SMALLINT NOT NULL	Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
23	DOCUMENT	Character(30)	VARCHAR2(30) NOT NULL	Specifies a document used as a reference number for a Receivables item. Document ID is used by the Receivables Update program and the Maintenance Worksheet to "match" related invoices debit memos and credit memos.
24	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
25	DELETE_ME	Character(1)	VARCHAR2(1) NOT NULL	Delete Record
26	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.
27	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.
28	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
29	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
30	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
31	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
32	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.
33	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
34	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
35	VAT_RECALC_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
36	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
37	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
38	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
39	DST_ID_AR	Character(10)	VARCHAR2(10) NOT NULL	Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.
40	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
41	ITM_MULTIPLIER	Signed Number(2,0)	DECIMAL(1) NOT NULL	Posting Item Multiplier
42	MRL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Revenue Distribution B=In Balance E=In Error N=Not Applied S=System Generated
43	MRL_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	TAX amount for MRL calculation
44	BUSINESS_UNIT_CA	Character(5)	VARCHAR2(5) NOT NULL	Contracts Business Unit
45	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
46	SP_ID	Number(11,0)	DECIMAL(11) NOT NULL	Service Purchase ID
47	AR_TRAN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tax Status N=Not Applicable O=Post-Tax R=Pre-Tax Default Value: N
48	ITEM_MSG_CD	Character(3)	VARCHAR2(3) NOT NULL	Item Message Code CNL=Cancel Item CRT=Create Open Item GBA=Goal Balance Attained RFD=Refund Item
49	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
50	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code