| # |
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 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 5 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 6 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 7 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 8 |
COUNTER1 |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Counter 1
|
| 9 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 10 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 11 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 12 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 13 |
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
|
| 14 |
COMPLETED_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Completed
N=Not Completed
Y=Complete
|
| 15 |
SQLROWS |
Number(5,0) |
INTEGER NOT NULL |
SQL Rows
|
| 16 |
COUNTER2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 2
|
| 17 |
COUNTER3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 3
|
| 18 |
COUNTER4 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 4
|
| 19 |
COUNTER5 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Counter 5
|
| 20 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 21 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|