| # |
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 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 5 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 6 |
WTHD_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Entity
|
| 7 |
WTHD_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Type
|
| 8 |
WTHD_JUR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
|
| 9 |
WTHD_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Class
|
| 10 |
OVERRIDE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rule Type Parameters
Default Value: N
|
| 11 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 12 |
WTHD_ADDTL_GROSS |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Additional Withheld Gross Amt
|
| 13 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 14 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 15 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 16 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 17 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 18 |
PYMNT_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Selection Status
C=Closed
D=Negative Voucher Sum
E=Externally Paid
F=Federal Sanctions Error
I=In Process - EFT
N=Not Selected for Payment
O=Financial Sanctions Review
P=Paid
R=Requested for Payment
S=Settlement Payment
V=Convert Error
X=Canceled
Y=Prepaid
|
| 19 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 20 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 21 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 22 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
|
| 23 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 24 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 25 |
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
|
| 26 |
PYMNT_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Action
P=Prepayment Applied
R=Record a Payment
S=Schedule Payment
W=Escheated Payment
X=Cancelled
|
| 27 |
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
|
| 28 |
PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
|
| 29 |
PYMNT_HANDLING_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 30 |
PYMNT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
N=No
Y=Yes
|
| 31 |
PYMNT_HOLD_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Hold Reason
ACC=Accounting in Dispute
ACV=Federal Supplier Inactive
ALC=Agency Location Code Required
AMT=Amount in Dispute
CCR=CCR Expired
CRT=Contract Retention
EFT=EFT incomplete or not Prenoted
FNS=Financial Sanctions
GDS=Goods in Dispute
GNV=G-Invoicing Hold
IPC=Inbound IPAC Required
OTH=Other
QTY=Quantity in Dispute
SAM=SAM Expired
WTH=Withholding Hold
|
| 32 |
REMIT_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Setid
|
| 33 |
REMIT_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Bank Code
|
| 34 |
REMIT_BNK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Remit Bank Account
|
| 35 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 36 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 37 |
ORIG_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Original Process Instance
|
| 38 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 39 |
DECIMAL_POS_TXN |
Number(2,0) |
SMALLINT NOT NULL |
Txn Decimal Positions
|
| 40 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
|
| 41 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 42 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
|
| 43 |
PREPAID_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prepaid Status
A=Applied
B=Pending Application
C=Pending Unapply
D=Pending Change
F=Fully Applied
I=Inactive
P=Available Prepayment
R=Restricted
U=Unapplied
X=Cancelled
|
| 44 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 45 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 46 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 47 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 48 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 49 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 50 |
VCHR_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Voucher supplier loc
|
| 51 |
VCHR_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher supplier's address seq
|
| 52 |
WTHD_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount
|
| 53 |
WTHD_RULE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Rule
|
| 54 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
|
| 55 |
BSE_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Base Rate Multiplier for Exchange Rates
|
| 56 |
BSE_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Base Rate Divisor for Exchange Rates
|
| 57 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 58 |
DECIMAL_POS_BSE |
Number(2,0) |
SMALLINT NOT NULL |
Base Cur Decimal Positions
|
| 59 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 60 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 61 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 62 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 63 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 64 |
DECIMAL_POS_ENT |
Number(2,0) |
SMALLINT NOT NULL |
Entity Decimal Positions
|
| 65 |
ENT_VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Supplier Set ID For Entity
|
| 66 |
ENT_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier ID
|
| 67 |
ENT_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location For Entity
|
| 68 |
ENT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Wthd_address_seq_num
|
| 69 |
ENTITY_HDR_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 70 |
APPLY_BALANCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies whether we apply withholding on the invoicing vendor
or the remit_to vendor
I=Invoicing Supplier
R=Remit to Supplier
|
| 71 |
NETAMT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Net Amount
|
| 72 |
FREIGHT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Freight
|
| 73 |
MISC_CHG_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Miscellaneous Charges
|
| 74 |
WHTD_DSCNT_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Discount
|
| 75 |
WTHD_SUT_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Sales/Use Tax
|
| 76 |
WTHD_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply VAT
|
| 77 |
EXCISE_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Excise Tax
|
| 78 |
ENT_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
TE Rate Multiplier
|
| 79 |
ENT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
TE Rate Divisor
|
| 80 |
WTHD_ROUND_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold Rounding Option to be applied to withhold calculations.
D=Round Down
I=TDS Withholding Round
N=Natural Round
R=Nearest Rupee Rounding
U=Round Up
|
| 81 |
PP_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Applied Prepaid Gross Amt
|
| 82 |
WTHD_CONT_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Reference
|
| 83 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 84 |
WTHD_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Withholding
P=Withhold at Payment
V=Withhold at Voucher Posting
|
| 85 |
PAID_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as
|
| 86 |
PAID_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is store
|