| # |
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 |
WTHD_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Entity
|
| 6 |
WTHD_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Type
|
| 7 |
WTHD_JUR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
|
| 8 |
WTHD_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Class
|
| 9 |
WTHD_RULE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Rule
|
| 10 |
PYMNT_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 11 |
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.
|
| 12 |
DSCNT_DUE_DT |
Date(10) |
DATE |
Discount Due Date
|
| 13 |
SCHEDULED_PAY_DT |
Date(10) |
DATE |
Scheduled to Pay
|
| 14 |
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
|
| 15 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 16 |
ORIG_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Original Process Instance
|
| 17 |
PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle
|
| 18 |
PAY_CYCLE_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Pay Cycle Sequence Number
|
| 19 |
PYMNT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
N=No
Y=Yes
|
| 20 |
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
|
| 21 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 22 |
DECIMAL_POS_TXN |
Number(2,0) |
SMALLINT NOT NULL |
Txn Decimal Positions
|
| 23 |
HOL_PROC_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Holiday Processing Option
A=Due After Holiday
B=Due Before Holiday
N=Not Applicable
|
| 24 |
HOL_PROC_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days before/after Holiday
|
| 25 |
HOL_PROC_OVERFL |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow due date in next month
|
| 26 |
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
|
| 27 |
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. "
|
| 28 |
DECIMAL_POS_BSE |
Number(2,0) |
SMALLINT NOT NULL |
Base Cur Decimal Positions
|
| 29 |
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.
|
| 30 |
BSE_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Base Rate Multiplier for Exchange Rates
|
| 31 |
BSE_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Base Rate Divisor for Exchange Rates
|
| 32 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 33 |
BU_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Category
|
| 34 |
BU_REGIST_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
BU Tax Identification Number
|
| 35 |
VNDR_REGIST_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Supplier Tax ID
|
| 36 |
CONDITION_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Condition %
|
| 37 |
CONDITION_UNTIL |
Date(10) |
DATE |
Condition Valid Until
|
| 38 |
REMIT_WTHD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Remit Withhold to Flag
E=Entity
V=Supplier
|
| 39 |
CALENDAR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar SetID
|
| 40 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 41 |
ADDTL_WTHD_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Additional Withhold Percent
|
| 42 |
BASE_MIN |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Minimum Basis Amount
|
| 43 |
WTHD_MIN |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Minimum Withhold Amount
|
| 44 |
VNDR_JUR_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 45 |
BU_JUR_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 46 |
HOLD_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Payment
B=Hold wthd & regular payment
N=Do Not Hold
W=Hold Withholding only
|
| 47 |
CREATE_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Withholding Payment
|
| 48 |
ENT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Wthd_address_seq_num
|
| 49 |
VJUR_REM_ADDR_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Supplier Jur Remit address
|
| 50 |
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
|
| 51 |
ENTITY_HDR_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 52 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 53 |
DECIMAL_POS_ENT |
Number(2,0) |
SMALLINT NOT NULL |
Entity Decimal Positions
|
| 54 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 55 |
ENT_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
TE Rate Multiplier
|
| 56 |
ENT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
TE Rate Divisor
|
| 57 |
EFT_PYMNT_FMT_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Format
00=Standard SWIFT transfer
10=Urgent SWIFT
15=Euro-Transfer
21=Check, w/ receipt confirmation
22=Check, Urgent
23=Check, urgent w/ receipt
40=Postal Order
CTX=Corp Trade Exchange
PBC=Check, standard
PPD=Prearranged Pay & Deposit
WRT=Wire Transfer
|
| 58 |
LOC_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank SetID
|
| 59 |
LOC_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 60 |
LOC_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Bank Account
|
| 61 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
|
| 62 |
PAY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit Setid
|
| 63 |
PAY_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Supplier
|
| 64 |
PAY_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Supplier Location
|
| 65 |
PAY_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The bank for the disbursing side of a settlement transaction.
|
| 66 |
PAY_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
The bank account for the disbursing side of a settlement transaction.
|
| 67 |
PAY_PYMNT_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Separate Payment
|
| 68 |
PAY_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
|
| 69 |
PAY_PYMNT_HNDG_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment Handling
|
| 70 |
PAY_CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 71 |
GRP_PYMNT_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Group by Payment Date
|
| 72 |
PYMNT_GROUP_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Group Code
|
| 73 |
PAY_CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Payments currency type
|
| 74 |
APPL_VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Wthd Applicable Supplier Setid
|
| 75 |
APPL_VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Wthd Applicable Supplier ID
|
| 76 |
APPL_VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Wthd Applicable Supplier Loc
|
| 77 |
APPL_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Wthd applic Address Seq Num
|
| 78 |
APPL_ON_FIRST_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Applicable to First Payment
|
| 79 |
WTHD_PAN_NUM |
Character(15) |
VARCHAR2(15) NOT NULL |
PAN No.
|
| 80 |
GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Gross Amount
|
| 81 |
WTHD_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount
|
| 82 |
WTHD_BASIS_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount
|
| 83 |
ABS_BASIS_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Absolute value of basis_amt
|
| 84 |
WTHD_RULE_EFFDT |
Date(10) |
DATE |
Effective Date
|
| 85 |
DED_BASIS_AMT |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Deduction Basis Amount
|
| 86 |
PRCNT_WTHHLD |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent Withheld
|
| 87 |
ADDTL_AMT |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
Additional Amount
|
| 88 |
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
|
| 89 |
PP_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Applied Prepaid Gross Amt
|
| 90 |
ORG_WTHD_BASIS_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original withholding amount calculated by the withholding calculation ae.
|
| 91 |
WTHD_CONT_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Reference
|
| 92 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 93 |
WTHD_CUMUL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold Cumulative Flag
|
| 94 |
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.
|
| 95 |
WTHD_SURCHRG_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Withholding SurCharge %
|
| 96 |
ADDL_SRCHRG_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Additional Surcharge %
|
| 97 |
WTHD_CESS_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Field to hold Withholding Cess Percentage
|
| 98 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 99 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|