VNDRAGING_TMP1

(SQL Table)
Index Back

AP Payment Aging Tmp1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
4 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
5 PYMNT_DT Date(10) DATE Payment Date
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 PYMNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Payment Amount
8 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
9 PYMNT_METHOD_ALL Character(3) VARCHAR2(3) NOT NULL Payment Method
ACH=Automated Clearing House
AD=All Draft Payments
ALL=All Payment Methods
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
DD=Direct Debit
DFT=Draft - Supplier Initiated
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Report
10 DFT_STATUS Character(1) VARCHAR2(1) NOT NULL Draft Payment Status
A=Approved
C=Created
D=Due
N=Non-Draft Payment
R=Reconciled
W=Write Off
X=Write Off Posted
11 DET_SUM_SW Character(1) VARCHAR2(1) NOT NULL Detail or Summary
D=Detail
S=Summary
12 AS_OF_DATE Date(10) DATE As of Date
13 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
14 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
15 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency