VCHR_SBI_TMP2

(SQL Table)
Index Back

SBI Temp Work Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
5 SBI_NUM Character(40) VARCHAR2(40) NOT NULL SBI_num
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
8 SBI_DOC_OPT Character(1) VARCHAR2(1) NOT NULL SelfBillingNumber
G=Group Vouchers (Auto-Num)
I=Individual Voucher (Auto-Num)
P=Individual Vchr-Invoice Number
9 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
10 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.
11 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration
12 VOUCHER_TYPE Character(1) VARCHAR2(1) NOT NULL Voucher Type
A=Adjustment Voucher
B=Batch Edit Voucher
C=Recurring Voucher
E=ERS Voucher
J=Journal Voucher
N=Reversal Voucher
P=Prepaid Voucher
R=Regular Voucher
T=Third Party Voucher
V=Registered Voucher
X=Template Voucher
13 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
14 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
15 ERS_INV_SEQ Number(5,0) INTEGER NOT NULL ERS Invoice Sequence