| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
EM_BU_VNAGRT_VW
|
| 2 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Default Value: NEXT
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 5 |
GROSS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Gross Invoice Amount
|
| 6 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 7 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: VENDOR.SETID
|
| 8 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Default Value: VENDOR_SHRT_VW.VENDOR_ID
Prompt Table:
EM_VNLNM_USR_VW
|
| 9 |
VENDOR_NAME_SHORT |
Character(14) |
VARCHAR2(14) NOT NULL |
Short Vendor Name
|
| 10 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 11 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
EM_VNDR_LOC_VW
|
| 12 |
VCHR_SRC |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Source
|
| 13 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
|
| 14 |
VCHR_BLD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Build Status
B=Build Voucher
D=Delete Voucher
E=Pre-Edit Error
H=Tolerance Hold
I=Initiated
N=Not processed
S=Voucher Staged
T=Stage Voucher
|
| 15 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 16 |
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.
|
| 17 |
DESCR50_MIXED |
Character(50) |
VARCHAR2(50) NOT NULL |
Description 50 characters, mixed case
|
| 18 |
DESCR_LONG |
Character(254) |
VARCHAR2(254) NOT NULL |
Long Description
|
| 19 |
DESCR254 |
Character(254) |
VARCHAR2(254) NOT NULL |
Description of length 254
|
| 20 |
DESCR254_MIXED |
Character(254) |
VARCHAR2(254) NOT NULL |
Description
|
| 21 |
EM_ADDRESS_DESC |
Long Character |
CLOB |
Address Description
|
| 22 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 23 |
EM_CUSTOMER_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
This field is used to store the internal number the seller uses for the buyer. It is used by the EAI.
|
| 24 |
EM_SUPPLIER_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for the buyer to indicate his internal code for the seller.
|
| 25 |
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
|
| 26 |
TAX_EXEMPT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Tax Exempt ID
|
| 27 |
VAT_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Registration ID
|
| 28 |
ENTERED_DT |
Date(10) |
DATE |
Entered on
|
| 29 |
MERCHANDISE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Merchandise Amt
F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
|
| 30 |
BENEFICIARY_BANK |
Character(30) |
VARCHAR2(30) NOT NULL |
The bank/counterparty associated with a given beneficiary.
|
| 31 |
BENEF_BRANCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Beneficiary Branch field
|
| 32 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 33 |
DESCR3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 34 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 35 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 36 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 37 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 38 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
|
| 39 |
VAT_RGSTRN_SELLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Seller's VAT Registration
|