| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
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 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 5 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 6 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 7 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 8 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 9 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 10 |
PRIMARY_LEDGER |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group.
|
| 11 |
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
|
| 12 |
DST_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
DST Account Type Description
|
| 13 |
REQUEST_DT |
Date(10) |
DATE |
Request Date
|
| 14 |
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.
|
| 15 |
TEMP_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
Temporary Query Value
|
| 16 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 17 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 18 |
TRANSLATE_LEDGERS |
Character(1) |
VARCHAR2(1) NOT NULL |
Translate Summ Ledgers to Dtl
|
| 19 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 20 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 21 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 22 |
AP_CF_INH_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
State Record Clause used to hold the concatenated Charfield Inheritance Setid/Group clause.
|
| 23 |
CF_INHERIT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: CF_INHERIT_TBL.CF_INHERIT_GRP.SearchInit
APCA=Payables Header Level Entries
APEA=Payables Distrib Level Entries
APPE=Payables Period End Accruals
APVN=Payables VAT Non-Recoverable
ARBI=Receivables and Billing
ARRE=Receivables Revaluation
DMAC=Deduction Management Accounts
EXCA=Expenses Control Accounts
EXCR=Expenses Cash Advance Recon
EXPY=Expenses Payroll Offset
EXVN=Expenses VAT Non-Recoverable
GLVI=GL Journal VAT Input Other
GLVN=GL Journal VAT Non-Recoverable
GLVO=GL Journal VAT Output
POCA=Purchasing Control Accounts
POEA=Purchasing Expense Accounts
POVN=Purchasing VAT Non-Recoverable
TDAC=Promotions Mgmt. Accounts
TRVI=Treasury VAT Input Other
TRVN=Treasury VAT Non-Recoverable
TRVO=Treasury VAT Output
|
| 24 |
TEMPTABLENM |
Character(40) |
VARCHAR2(40) NOT NULL |
Temp Table Name
|
| 25 |
INSERT_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Inheritance.
|
| 26 |
INSERT_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Inheritance (where Inh GLBU <> Dist Line GLBU).
|
| 27 |
INSERT_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU = Dist Line GLBU and No Payment Method setup).
|
| 28 |
INSERT_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU <> Dist Line GLBU and No Payment Method setup).
|
| 29 |
INH_WITHIN_BU |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No edit to determine if there is a need to run a second Inheritance Step where INHERIT_WITHIN_BU is chosen and different GLBU's are possible.
Y/N Table Edit
Default Value: N
|
| 30 |
DRAFT_INHERIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Field to determine in this is a Draft Inheritance and if we need to do additional SQL.
|
| 31 |
AP_CONCAT_INH_CLSE |
Character(50) |
VARCHAR2(50) NOT NULL |
Used to store SQL to form the Concatinated Inheritance Clause.
|
| 32 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 33 |
POSTING_METHOD_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Method
D=Detail Offset Method
S=Summary Control
|
| 34 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 35 |
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
|
| 36 |
CF_BAL_LINE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Chart Field Balancing Line Num
|
| 37 |
TAX_AUTHORITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Authority
|
| 38 |
FOREIGN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
|
| 39 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
|
| 40 |
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".
|