| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPR_DEF_TBL_AP
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
POST_PYMNT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Payment Option
A=Post All Banks
B=Post Bank Account
M=Post Payment Method
P=Post Payment
|
| 7 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 8 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 9 |
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
|
| 10 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 11 |
PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
D=Deposit
DD=Direct Debit
DFT=Draft - Supplier Initiated
DRA=Draft
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
|
| 12 |
PYMNT_ID_REF |
Character(20) |
VARCHAR2(20) NOT NULL |
Payment Reference
|
| 13 |
REQUEST_DT |
Date(10) |
DATE |
Request Date
|
| 14 |
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
|
| 15 |
DST_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
DST Account Type Description
|
| 16 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 17 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 18 |
MOVEMENT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural
R=Reversal
|
| 19 |
MULTIBOOK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multibook entries in Subsystem
|
| 20 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 21 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 22 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 23 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 24 |
PYMNT_CNT_MAX |
Number(5,0) |
INTEGER NOT NULL |
Max payment count
|
| 25 |
TEMP_TBL_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Temporary Table name
|
| 26 |
TEMP_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
Temporary Query Value
|
| 27 |
DECIMALPOS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 28 |
AP_IU_ACCT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
AP InterUnit Options
D=Direct InterUnit Accounting
I=Indirect InterUnit Accounting
|
| 29 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 30 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 31 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 32 |
DOC_SEQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Document Sequencing
|
| 33 |
AP_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payables Transaction Type
A=Voucher Accrual
C=Cash Clearing
D=Drafts Due
F=Drafts Write Off
P=Payment
R=Revaluation
U=Unpost
V=Void Payment
W=Voucher Close
|
| 34 |
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.
|
| 35 |
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.
|
| 36 |
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.
|
| 37 |
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
|
| 38 |
AE_NO_LIST_EDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
no edits
|
| 39 |
PREPAID_APPL_PYMNT |
Number(5,0) |
INTEGER NOT NULL |
Applied Payment Count
|
| 40 |
PYMNT_CNT2 |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 41 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 42 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 43 |
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
|
| 44 |
IU_SYS_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
|
| 45 |
IU_TRAN_CD |
Character(8) |
VARCHAR2(8) NOT NULL |
Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
|
| 46 |
POSTING_METHOD_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Method
D=Detail Offset Method
S=Summary Control
|
| 47 |
FIELDNAME_BU_GL |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit GL Field Name
|
| 48 |
GFEE_RUN_EEG |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox to determine whether to run Entry Event during a batch process.
|
| 49 |
AP_FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 50 |
ORIG_REC_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Original Record Name
|
| 51 |
VNDR_AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Affiliate
|
| 52 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 53 |
PYMNT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payment Number
|
| 54 |
ORIG_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Original Payment Count
|
| 55 |
PYMNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Document Type
E=Express Payment
M=Manual Payment
R=Regular payment
W=Withholding Payment
Z=Zero Payment Check
|
| 56 |
SCHEDULE_TYPE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedulepaymentflag
|
| 57 |
MATCH_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Type for Matching - B- Batch, O - Online
|
| 58 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 59 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 60 |
CANCEL_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine the post status of cancelled payment. If posting has not been run it will be set to W Pending. If the payment action is not V Void, S Stopped, W Escheated Check then the value is N. If the payment has not be posted but has been cancel the value = W. After the cancellation has been posted it the value is P posted.
N=Not Applicable
P=Posted
W=Pending
|
| 61 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 62 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 63 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 64 |
REBATE_TERM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rebate Term Available
|
| 65 |
TOTAL_CNT_SUMM |
Number(8,0) |
INTEGER NOT NULL |
Total Count
|
| 66 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 67 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
|
| 68 |
VAT_SVC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
|
| 69 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 70 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
|
| 71 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
|
| 72 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
|
| 73 |
VAT_RCRD_OUTPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
|
| 74 |
VAT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated
|
| 75 |
CF_BAL_LINE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Chart Field Balancing Line Num
|
| 76 |
AP_CONCAT_INH_CLSE |
Character(50) |
VARCHAR2(50) NOT NULL |
Used to store SQL to form the Concatinated Inheritance Clause.
|
| 77 |
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
|
| 78 |
INSERT_CLAUSE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU <> Dist Line GLBU and No Payment Method setup).
|
| 79 |
INSERT_CLAUSE5 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU <> Dist Line GLBU and No Payment Method setup).
|
| 80 |
INSERT_CLAUSE6 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU <> Dist Line GLBU and No Payment Method setup).
|
| 81 |
INSERT_CLAUSE7 |
Character(254) |
VARCHAR2(254) NOT NULL |
Insert Clause used for Draft Inheritance (where Inh GLBU <> Dist Line GLBU and No Payment Method setup).
|
| 82 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 83 |
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.
|
| 84 |
MONETARY_AMOUNT_02 |
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.
|
| 85 |
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.
|
| 86 |
FOREIGN_AMOUNT2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Foreign Amount 2
|
| 87 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 88 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
|
| 89 |
WHERE_LONG |
Long Character |
CLOB |
Where Clause
|
| 90 |
EXS_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount Base Currency
|
| 91 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 92 |
WHERE_CLAUSE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 93 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 94 |
MONETARY_AMOUNT_01 |
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.
|
| 95 |
VOUCHER_ID_RELATED |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 96 |
PYMNT_CNT_RELATED |
Number(5,0) |
INTEGER NOT NULL |
Payment
|
| 97 |
VAT_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
|
| 98 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 99 |
TOTAL_AMT_WTHD |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount Withheld
|
| 100 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 101 |
MISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc. Amount
|
| 102 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 103 |
SALETX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Sales Tax Amount
|
| 104 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 105 |
VAT_DSCNT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Dscnt Adj
|
| 106 |
VAT_RVRSE_CHG_GDS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
|
| 107 |
BUDG_DT_DFLT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Budget Date
A=Accounting Date Default
P=Predecessor Doc Date Default
|
| 108 |
SELECT_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Select Clause
|
| 109 |
CANCEL_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Action
C=Do Not Reissue/Close Liability
H=Re-Open Voucher(s)/Put on Hold
N=No Cancel Action
P=Processed
R=Re-Open Voucher(s)/Re-Issue
S=Stale Dated Check
W=Escheated
|
| 110 |
CANCEL_DT |
Date(10) |
DATE |
Date Cancelled
|
| 111 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 112 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 113 |
BUSINESS_UNIT_BI |
Character(5) |
VARCHAR2(5) NOT NULL |
Billing Business Unit
|
| 114 |
BI_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Billing Invoice number
|
| 115 |
LOCKBOX_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lockbox ID
|
| 116 |
BI_AP_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
InterUnit AP Level
H=Header is AP Voucher
L=Bill Line is AP Voucher
N=No AP Voucher
|
| 117 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 118 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 119 |
ORG_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
|
| 120 |
ORG_TAX_LOC_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
|
| 121 |
WTHD_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Entity
|
| 122 |
WTHD_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Type
|
| 123 |
WTHD_JUR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
|
| 124 |
WTHD_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Class
|
| 125 |
WTHD_RULE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Rule
|
| 126 |
EXD_NRCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise NonRcvry Amount
|
| 127 |
EXD_NRCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Non Recovery
|
| 128 |
EXD_TOT_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Tax Amount
|
| 129 |
TOT_TAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Tax Amt Base
|
| 130 |
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".
|
| 131 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 132 |
EXS_SERV_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Tax Indicator
N=Not Service Tax
Y=Service Tax
|