VCHR_RND2_TAO (SQL Table)	Index Back
AP Accounting Entries

VCHR_RND2_TAO

(SQL Table)

AP Accounting Entries

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

4 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

5 POSTING_PROCESS Character(4) VARCHAR2(4) NOT NULL Posting Process
ACAV=Period End Accruals
ACCR=AP Accrual
CANC=Payment Cancelations
CASH=Cash Clearing
CLOS=Voucher Closure
DFTA=Draft Accrual
PCAD=Card
PPAY=Prepaid Reversals
PREP=Prepaids
PYMN=Payments
RACC=Receipt Accrual
RCVL=Revaluation
REVL=Revaluations
VOID=Void
WTHA=Withholding Accrual

6 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template

7 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments

8 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

9 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

10 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment

11 CF_BAL_LINE_NUM Number(10,0) DECIMAL(10) NOT NULL Chart Field Balancing Line Num

12 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

13 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority

14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

15 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EO_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
4	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
5	POSTING_PROCESS	Character(4)	VARCHAR2(4) NOT NULL	Posting Process ACAV=Period End Accruals ACCR=AP Accrual CANC=Payment Cancelations CASH=Cash Clearing CLOS=Voucher Closure DFTA=Draft Accrual PCAD=Card PPAY=Prepaid Reversals PREP=Prepaids PYMN=Payments RACC=Receipt Accrual RCVL=Revaluation REVL=Revaluations VOID=Void WTHA=Withholding Accrual
6	APPL_JRNL_ID	Character(10)	VARCHAR2(10) NOT NULL	Journal Template
7	PYMNT_CNT	Number(5,0)	INTEGER NOT NULL	Payments
8	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
9	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
10	DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
11	CF_BAL_LINE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Chart Field Balancing Line Num
12	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
13	TAX_AUTHORITY_CD	Character(3)	VARCHAR2(3) NOT NULL	Tax Authority
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.