VNDRAGING_TMP2

(SQL Table)
Index Back

AP Payment Aging Tmp2

# 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 DAYOFMONTH Number(2,0) SMALLINT NOT NULL Day of Month
6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
7 AMOUNT_OUT1 Signed Number(31,5) DECIMAL(29,5) NOT NULL Output Amount 1
8 AMOUNT_OUT2 Signed Number(31,5) DECIMAL(29,5) NOT NULL Output Amount 2
9 AMOUNT_OUT3 Signed Number(31,5) DECIMAL(29,5) NOT NULL Output Amount 3
10 AMOUNT_OUT4 Signed Number(31,5) DECIMAL(29,5) NOT NULL Output Amount 4
11 AMOUNT_OUT5 Signed Number(31,5) DECIMAL(29,5) NOT NULL Output Amount 5
12 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
13 DET_SUM_SW Character(1) VARCHAR2(1) NOT NULL Detail or Summary
D=Detail
S=Summary
14 AS_OF_DATE Date(10) DATE As of Date
15 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
16 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
17 CURRENCY_PYMNT Character(3) VARCHAR2(3) NOT NULL Payment Currency