PAYMENT_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	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
3	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.
4	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.
5	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.
6	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
7	PAYMENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Status A=Applied B=Bounced C=Complete E=Identified - Express I=Identified J=Directly Journalled R=Unposted Direct Journal U=Unidentified W=Worksheet
8	AR_WOAPPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved Write-Off D=Denied Write-Off I=Initial P=Pending Write-Off Approval Default Value: I
9	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
10	ENTRY_DT	Date(10)	DATE	Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
11	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
12	POST_DT	Date(10)	DATE	The Date a transaction was Posted.
13	SEL_CUST_ID	Character(1)	VARCHAR2(1) NOT NULL	Select items via Customer ID
14	SEL_PO	Character(1)	VARCHAR2(1) NOT NULL	Select items via Postal
15	SEL_REMIT	Character(1)	VARCHAR2(1) NOT NULL	Select items via REMIT TO
16	SEL_CORP_ACCT	Character(1)	VARCHAR2(1) NOT NULL	Select items via CORP ACCT
17	SEL_MICR	Character(1)	VARCHAR2(1) NOT NULL	Select items via MICR ID
18	SEL_OPEN_ITEM	Character(1)	VARCHAR2(1) NOT NULL	Select items via OPEN ITEM
19	SEL_DOCUMENT	Character(1)	VARCHAR2(1) NOT NULL	Select items via DOCUMENT
20	SEL_REF_RANGE	Character(1)	VARCHAR2(1) NOT NULL	Range of References
21	ID_SEQ_CUST	Number(3,0)	SMALLINT NOT NULL	Sequence control for CUST ID
22	ID_SEQ_ITEM	Number(5,0)	INTEGER NOT NULL	Sequence control for ITEM
23	AMT_SEL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount selected
24	AMT_ADJ	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Adjusted
25	AMT_REM	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Remaining
26	DISC_TAKEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discount Taken
27	DISC_EARNED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Discounts Earned
28	DISC_UNEARNED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unearned Discounts
29	WS_COUNT	Number(5,0)	INTEGER NOT NULL	Worksheet Items
30	WS_DTTM	DateTime(26)	TIMESTAMP	Worksheet Created Date/Time
31	WS_SEQ_ITEM	Number(5,0)	INTEGER NOT NULL	Worksheet item sequence number
32	GL_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Distribution Status C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal
33	DST_DT	Date(10)	DATE	Distribution Date
34	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
35	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
36	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.
37	PP_SW	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor
38	DISC_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Discount used switch
39	WO_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Write Off's Used
40	WO_ITEM_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Write Off Item
41	WO_ADJ_USED_SW	Character(1)	VARCHAR2(1) NOT NULL	Write Off Adjustmet from WS
42	WS_UPDATED_SW	Character(1)	VARCHAR2(1) NOT NULL	Worksheet updated switch
43	LOCKBOX_PYMNT_ID	Character(15)	VARCHAR2(15) NOT NULL	Lockbox Payment Id
44	PP_METHOD	Character(15)	VARCHAR2(15) NOT NULL	Payment Predictor Method
45	ALGORITHM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Algorithm Group for Payment Predictor
46	WS_REF_MATCH_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Worksheet Reference Match Type E=Exact Match L=Like Match
47	ALGORITHM	Character(7)	VARCHAR2(7) NOT NULL	Algorithm Identifier
48	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.
49	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.
50	PYMT_RATE_MULT	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.
51	PYMT_RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.
52	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
53	PP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payment Predictor Status A=Applied N=Not Processed P=Processed W=Worksheet Generated
54	PP_RQ	Number(7,0)	INTEGER NOT NULL	Reference Qualifier Count
55	PP_RQ_HIT	Number(7,0)	INTEGER NOT NULL	Reference Qualifier Hits
56	APPLIED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Applied Operator
57	MISC_PAYMENT	Character(1)	VARCHAR2(1) NOT NULL	Journal Directly
58	MISC_DST_BAL	Character(1)	VARCHAR2(1) NOT NULL	Non Customer Dist Balanced C=Journal Complete I=Balanced N=No Distribution O=Out of Balance
59	CREATE_PEND_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Create Pending Items A=Do Not Post L=Batch Standard N=Batch Priority
60	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
61	CASH_CNTRL_USE	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a payment group created by a payment worksheet or by Payment Predictor includes a cash control entry debiting cash.
62	REF_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Reference Level of Detail
63	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
64	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
65	RECONCILE_DT	Date(10)	DATE	The transaction reconciliation date.
66	RECONCILE_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The user ID that performed the reconciliation for a given transaction.
67	RECON_CYCLE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	The bank statement ID.
68	RECON_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Reconciliation Status ALG=Alignment Check AMB=Ambiguous Match AMT=Amounts Not Equal CUR=Currency not Defined DAT=Tran Date <> Value Date DPI=Duplicate Input Transactions DUP=Duplicate Transaction MSC=Miscellaneous Transaction NAM=Payee Names Not Equal NTB=Not Found in Statement NTF=Not Found In System NTP=Not Found in POS Data NUL=Null Transaction ID Ref OVR=Overflow PND=Pending Reconciliation REC=Reconciled RPR=Reprinted Check RR=Requires Review - BSAC STP=Stop Payment TYP=Wrong Transaction Type UNR=Unreconciled VOI=Voided Check
69	RECON_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank A=Automatically Reconciled B=Balance System(s) to BankTran F=Forced to Reconcile M=Manually Reconciled S=Semi Manual U=Unreconciled
70	STTLMNT_DT_ACTUAL	Date(10)	DATE	Date in which a deal transaction is actually settled with a counterparty.
71	STTLMNT_DT_EST	Date(10)	DATE	Date in which a deal transaction is estimated to be settled with a counterparty.
72	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
73	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
74	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
75	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
76	CASH_CNTRL_DONE	Character(1)	VARCHAR2(1) NOT NULL	Cash Control Complete
77	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
78	UNPOST_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reason code for Unposted groups. For informational purposes.
79	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
80	REMIT_FROM_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
81	REMIT_FROM_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Remit From Customer
82	EDI_TRACE_NBR	Number(10,0)	DECIMAL(10) NOT NULL	EDI Trace Number
83	CC_AFFECTED	Character(1)	VARCHAR2(1) NOT NULL	Indicate whether commitment control (revenue estimate) is affected. N=No Y=Yes
84	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
85	KK_AMOUNT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control Amount Type 0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic
86	KK_TRAN_OVER_DTTM	DateTime(26)	TIMESTAMP	Commitment Control source transaction override datetime
87	KK_TRAN_OVER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Commitment Control source transaction override flag N=No Y=Yes
88	KK_TRAN_OVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Commitment Control source transaction override operator
89	BANK_ACCT_RVL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
90	ENTRY_EVENT	Character(10)	VARCHAR2(10) NOT NULL	Entry Event
91	OPRID_APPROVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Approved By
92	RECON_RUN_ID	Character(15)	VARCHAR2(15) NOT NULL	Recon Run ID
93	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CUST_BI_VW Set Control Field: DEPOSIT_BU
94	RECORD_SEQ_NUMBER	Number(10,0)	DECIMAL(10) NOT NULL	An internal work field utilized to enumerate database records in bank statement processing.
95	EO_FROM_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
96	REQ_WO_COMMENTS	Long Character	CLOB	Requestor Write-off Comments