C360_DS_INQ_SEL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	ORDER_ID	Character(25)	VARCHAR2(25) NOT NULL	Order ID
4	C360_DOC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Document Type CNT=Contract INV=Invoice ITM=Item PMT=Payment RFQ=Quotation RMA=Returned Material SO=Sales Order
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	STATUS_FIELD	Character(30)	VARCHAR2(30) NOT NULL	Payment Status
9	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.
10	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
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_ID	Character(15)	VARCHAR2(15) NOT NULL	Identifies a customer payment. This is usually a check number but may be some other identifying number.
14	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