| # |
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 |
AE_PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
App Engine Pay Cycle
|
| 89 |
AE_PAY_CYCLE_SEQ |
Number(6,0) |
INTEGER NOT NULL |
App Engine Pay Cycle Seq Num
|
| 90 |
AE_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 91 |
AE_VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 92 |
AE_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 93 |
ABS_ACCUM_BASIS |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Accumulated Basis Amount
|
| 94 |
ABS_PYMNT_GROSS |
Number(16,2) |
DECIMAL(15,2) NOT NULL |
Abs value of pymnt_gross_amt
|
| 95 |
ABS_SUM_AMT |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Absolute value of sum amt
|
| 96 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 97 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 98 |
ACCUM_BASIS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This accumulated basis field will be stored in the currency of the withholding entity.
|
| 99 |
ACCUM_BASIS_ENT |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
This accumulated basis field will be stored in the currency of the withholding entity.
|
| 100 |
ACCUM_WTHD |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will store the accumulated withholdings in the currency of
the withholding entity.
|
| 101 |
CALC_UPD_WTHD_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calc upd wthd (ent cur)
|
| 102 |
CALC_WTHD_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calc Withholding in Base cur.
|
| 103 |
CALC_WTHD_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calc wthd (ent cur)
|
| 104 |
CALC_WTHD_TXN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Calc wthd (txn cur)
|
| 105 |
CREDIT_NOTE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Note Flag
|
| 106 |
LOG_WTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Log Withholding to period tbl
|
| 107 |
ORIG_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original Pymnt_gross_amt
|
| 108 |
ORIG_GROSS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original Gross amt bse
|
| 109 |
ORIG_HOLD_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Originating XREF hold reason
|
| 110 |
ORIG_PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Orig xref pay cycle
|
| 111 |
ORIG_PAY_CYCLE_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Orig. xref pay cycle seq num
|
| 112 |
ORIG_PYMNT_HOLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Originating XREF PYMNT_HOLD
|
| 113 |
ORIG_SELCT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Orig xref select status to upd
|
| 114 |
PAYMENT_DT |
Date(10) |
DATE |
Payment Date
|
| 115 |
PREV_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Previous Business Unit
|
| 116 |
PREV_VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Previous Voucher ID
|
| 117 |
PREV_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Previous Payment Count
|
| 118 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
|
| 119 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 120 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 121 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
|
| 122 |
XREF_ERROR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag for Xref
|
| 123 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 124 |
NEW_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
New Pymnt_cnt for Wthd
|
| 125 |
WTHD_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Wthd Payment Count
|
| 126 |
WTHD_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount Base
|
| 127 |
WTHD_DECL_DATE |
Date(10) |
DATE |
withholding declaration date
|
| 128 |
WTHD_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Wthd payment process instance
|
| 129 |
WTHD_PAY_CYCLE |
Character(6) |
VARCHAR2(6) NOT NULL |
Pay Cycle for wthd xref
|
| 130 |
WTHD_PAY_CYCLE_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Wthd xref pay cycle seq num
|
| 131 |
XREF_TOT_WTHD_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Xref total basis in base cur.
|
| 132 |
XREF_TOT_WTHD_TXN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Xref Total basis in txn cur.
|
| 133 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
|
| 134 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 135 |
VENDOR_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Category
|
| 136 |
SEL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
sel_flg
|
| 137 |
AE_NO_LIST_EDITS |
Character(1) |
VARCHAR2(1) NOT NULL |
no edits
|
| 138 |
COLLECT_AGENT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Collection Agent Flag
N=Is NOT Collection Agent
Y=Is Collection Agent
|
| 139 |
WTHD_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold if missing
N=Don't withholding
Y=Withholdeable
|
| 140 |
WTHD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Withholding Applicable Flag
B=Global and 1099
G=Global
T=1099
|
| 141 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 142 |
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
|
| 143 |
PYMNT_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay
D=Discounted Amount
F=Full Amount
|
| 144 |
ORG_WTHD_BASIS_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Original withholding amount calculated by the withholding calculation ae.
|
| 145 |
EXPRESS_PYMNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Express Payment ?
|
| 146 |
WTHD_CONT_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
Contract Reference
|
| 147 |
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.
|
| 148 |
WTHD_CUMUL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Withhold Cumulative Flag
|
| 149 |
WTHD_SURCHRG_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Withholding SurCharge %
|
| 150 |
ADDL_SRCHRG_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Additional Surcharge %
|
| 151 |
WTHD_CESS_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Field to hold Withholding Cess Percentage
|
| 152 |
WTHD_SURCHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withhold Surcharge Amount
|
| 153 |
ADDL_SRCHRG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional Surcharge Amount
|
| 154 |
WTHD_CESS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field to hold the amount value for Wihtholding Cess amount
|
| 155 |
FROM_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
From Voucher Post
|
| 156 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 157 |
DATE_TO |
Date(10) |
DATE |
Date To
|
| 158 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 159 |
PYMT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Terms Code
30=Due in 30 days after invoice
45=Due in 45 days after invoice
IMM=Due Immediately
|
| 160 |
TOTAL_AMT_WTHD |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount Withheld
|
| 161 |
TOTAL_AMT_WTHD_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount Withheld BASE
|
| 162 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 163 |
TOTAL_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount Base
|
| 164 |
TOTAL_AMT_DIFF |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount Difference
|
| 165 |
TOTAL_AMT_DIFF_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount Difference
|
| 166 |
INSTALLMENT_PCT |
Number(12,8) |
DECIMAL(11,8) NOT NULL |
Installment Percent
|
| 167 |
PYMNT_CNT2 |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 168 |
CURRENCY_PYMNT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Currency
|
| 169 |
BASE_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 170 |
PAID_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Paid Amount
|
| 171 |
PAID_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Paid Amount
|
| 172 |
PYMNT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is stored
|
| 173 |
PYMNT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determining whether a currency exchange rate is store
|
| 174 |
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
|
| 175 |
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
|
| 176 |
PREPAID_APPLIED_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Applied Business Unit
|
| 177 |
PREPAID_APPL_VCHR |
Character(8) |
VARCHAR2(8) NOT NULL |
Applied Voucher ID
|
| 178 |
PREPAID_APPL_PYMNT |
Number(5,0) |
INTEGER NOT NULL |
Applied Payment Count
|
| 179 |
BANK_SETID_PRIOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Prior Bank Setid
|
| 180 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 181 |
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
|
| 182 |
ORIG_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Original Payment Count
|
| 183 |
FROM_MANPYMNT |
Character(1) |
VARCHAR2(1) NOT NULL |
From Manual Payment
|
| 184 |
WS_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Worksheet ID
|
| 185 |
PAY_FROM_DT |
Date(10) |
DATE |
Pay From Date
|
| 186 |
PAY_THRU_DT |
Date(10) |
DATE |
Pay Through Date
|
| 187 |
NEXT_PAY_THRU_DT |
Date(10) |
DATE |
Next Pay Through Date
|
| 188 |
NEXT_PYMNT_DT |
Date(10) |
DATE |
Next Payment Date
|
| 189 |
EXEMPT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Research Exempt
|
| 190 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 191 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 192 |
WTHD_PREPAY_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Signifies if Withholding applies to the prepayment
N=Not Applicable
V=Postpone to regular voucher
|
| 193 |
ACCUM_SURCHRG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Accumulated Surcharge
|
| 194 |
ACCUM_ADDSRCHRG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Accumulated Add'l Surcharge
|
| 195 |
ACCUM_WTHDCESSAMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Accumulated Additional Class
|
| 196 |
CALC_WTHD_ENT_HSC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
HSC Calculation
|
| 197 |
ACCUM_WTHD1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will store the accumulated withholdings in the currency of
the withholding entity.
|
| 198 |
AMT_DIFF |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount1
|
| 199 |
WTHD_ROUND_OPT2 |
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
U=Round Up
|
| 200 |
PREV_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 201 |
PREV_RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 202 |
ACCUM_WTHD2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This field will store the accumulated withholdings in the currency of
the withholding entity.
|
| 203 |
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
|
| 204 |
AMT_DIFF1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field used for Calculation
|
| 205 |
PPAY_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit Prepayment
|
| 206 |
PPAY_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 207 |
PPAY_PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payment Count
|
| 208 |
PPAY_VCHR_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 209 |
PPAY_WTHD_CLASS |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Class
|
| 210 |
PPAY_WTHD_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Entity
|
| 211 |
PPAY_WTHD_JUR_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Jurisdiction
|
| 212 |
PPAY_WTHD_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Withholding Type
|
| 213 |
AMT_DIFF2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field Used for Calculation
|
| 214 |
AMT_DIFF3 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field Used for Calculations
|
| 215 |
PYMNT_CNT3 |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 216 |
WTH_SRCHRG_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withhold Surcharge Amount
|
| 217 |
ADD_SRCHRG_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Additional Surcharge Amount
|
| 218 |
WTHD_CESS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field to hold the amount value for Wihtholding Cess amount
|
| 219 |
FLAT_RATE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Field to hold the percentage for a Flat Rate while calculating TDS for India
|
| 220 |
RATE_FORCE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Field to hold the Value of the Percentage when the Rate in Force is
applied.
|
| 221 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 222 |
CALC_WTHD_TXN1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
WTHD Base
|
| 223 |
CALC_WTHD_TXN2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
WTHD Base
|
| 224 |
BUSINESS_UNIT_OLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Old Business Unit
|
| 225 |
VOUCHER_ID_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Related Voucher
|
| 226 |
PYMNT_CNT_REF |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 227 |
FREIGHT_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 228 |
DSCNT_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 229 |
TAX_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 230 |
VAT_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount
|
| 231 |
MISC_CHG_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Misc Charge Amt
|
| 232 |
EXS_TAX_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 233 |
MERCHANDISE_AMT_S |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
|
| 234 |
DSCNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Amount
|
| 235 |
EXS_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Sales Tax Amount
|
| 236 |
FREIGHT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Freight Amount
|
| 237 |
MISC_CHG_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
11/5/98 ebn CN#CM800-2.0: Added for Landed Cost Enhancement
|
| 238 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 239 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 240 |
NETAMT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Net Amount
|
| 241 |
FREIGHT_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Freight
|
| 242 |
MISC_CHG_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Miscellaneous Charges
|
| 243 |
WTHD_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply VAT
|
| 244 |
WHTD_DSCNT_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Discount
|
| 245 |
WTHD_SUT_APPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Sales/Use Tax
|
| 246 |
EXCISE_APPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply Excise Tax
|
| 247 |
WTH_BASIS_AMT_CUMM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount
|
| 248 |
WTHD_AMT_CUMM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Amount
|
| 249 |
PMT_GROSS_AMT_XREF |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 250 |
PPAY_AMT_PRORATE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Payment Amount
|
| 251 |
ADDITIONAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount
|
| 252 |
ADDITIONAL_AMT1 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount
|
| 253 |
PP_GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Applied Prepaid Gross Amt
|
| 254 |
CUMM_THRESHOLD |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Withholding Basis Amount
|
| 255 |
FROM_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
From Basis Amount
|
| 256 |
ACCUM_BASIS_PYMNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
This accumulated basis field will be stored in the currency of the withholding entity.
|
| 257 |
ACCUM_BASIS_ENT_PY |
Signed Number(19,2) |
DECIMAL(17,2) NOT NULL |
This accumulated basis field will be stored in the currency of the withholding entity.
|
| 258 |
ADD_SRCHRG_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field to hold the amount value for Additional Surcharge amount (Entity Currency)
|
| 259 |
WTH_SRCHRG_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field to hold the amount value for Wihtholding Cess amount (Entity Currency)
|
| 260 |
WTHD_CESS_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field to hold the amount value for Wihtholding Surcharge amount (Entity Currency)
|
| 261 |
AMT1_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Expenses
|
| 262 |
AMT2_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Encumbrances
|
| 263 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 264 |
EXD_TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Excise Tax Amount
|
| 265 |
DELAY_DAYS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Delay Days Flag
D=Default from BU
N=Do Not Employ
S=Specify
|
| 266 |
PYMNT_DELAY_DAYS |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Payment Delay Days
|
| 267 |
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
|
| 268 |
OVERRIDE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Rule Type Parameters
Default Value: N
|