| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EXCEPTIONS_AVP |
Character(1) |
VARCHAR2(1) NOT NULL |
Using STEP
Y/N Table Edit
|
| 3 |
TAX_RC_MATCHING |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason Code Matching
1=Only Exact Reason Code Match
2=Use Default Record
Default Value: 2
|
| 4 |
TAX_CERT_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Certificate Level
1=Individual Certificate Levels
2=State Level Only
Default Value: 2
|
| 5 |
EXCEPTIONS_VERTEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Using TDM
Y/N Table Edit
|
| 6 |
VER_VERTEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Version
I=ISAM
|
| 7 |
SERVER_VERTEX |
Character(20) |
VARCHAR2(20) NOT NULL |
Server Name
|
| 8 |
USER_VERTEX |
Character(10) |
VARCHAR2(10) NOT NULL |
User Name
|
| 9 |
PSWD_VERTEX |
Character(254) |
VARCHAR2(254) NOT NULL |
11/04 - Increased to 44 bytes to allow for encryption. Vertex passwords must be 6-16 characters.
|
| 10 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 12 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 13 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 14 |
INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
|
| 15 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
|
| 16 |
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. "
|
| 17 |
CURRENCY_CD_XEU |
Character(3) |
VARCHAR2(3) NOT NULL |
Euro Currency
|
| 18 |
TAX_VENDOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Provider
A=Taxware
N=None
V=Vertex
|
| 19 |
TAX_COMPANY |
Character(5) |
VARCHAR2(5) NOT NULL |
Company for Tax Suppliers
|
| 20 |
TAX_DIVISION |
Character(5) |
VARCHAR2(5) NOT NULL |
Division for Tax Suppliers
|
| 21 |
TAX_DEPARTMENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department used by Tax Vendors
|
| 22 |
TAX_EXEMPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Exempt Flag
|
| 23 |
TAX_EXEMPT_CERT |
Character(30) |
VARCHAR2(30) NOT NULL |
Exemption Certificate
|
| 24 |
TAX_DATE |
Date(10) |
DATE |
Tax Date
|
| 25 |
SHIP_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Ship To Customer
|
| 26 |
SHIP_TO_ADDR_NUM |
Number(5,0) |
INTEGER NOT NULL |
Ship To Address Sequence Num
|
| 27 |
ORIGINAL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Original Invoice
|
| 28 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 29 |
NET_EXTENDED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Net Extended Amt
|
| 30 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 31 |
ADJ_LINE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Adjustment Line Type
ACR=Adjustment Credit Line
ADJ=Adjustment
ARB=Adjustment Rebill Line
REG=Regular bill line (not adjust)
|
| 32 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 33 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 34 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 35 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 36 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 37 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 38 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 39 |
SHIP_FROM_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship From Location
|
| 40 |
ORD_ACCEPT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Acceptance
|
| 41 |
ORD_ORIGIN_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Origin
|
| 42 |
STORE_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Store Location
|
| 43 |
TAX_JOB_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Job Number
|
| 44 |
TITLE_PASSAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Title Passage
B=Buyer's Destination-Ship To
I=Intermediate Consignee
S=Seller's Origination-Ship From
|
| 45 |
TAX_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Group
|
| 46 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
|
| 47 |
TAX_TRANS_SUB_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Sub Type
1=Property
2=Freight
3=Service
4=Rental or Lease
5=Expense
6=Misc
N=None
|
| 48 |
TAX_EXEMPT_RC |
Character(2) |
VARCHAR2(2) NOT NULL |
Exempt Reason Code
01=Certificat
|
| 49 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
|
| 50 |
TAX_USER_AREA |
Character(25) |
VARCHAR2(25) NOT NULL |
Used for tax calculation by tax vendor.
|
| 51 |
ERROR_STATUS_BI |
Character(4) |
VARCHAR2(4) NOT NULL |
Error Status
|
| 52 |
FINAL_TAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Tax Flag
|
| 53 |
TAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Tax Amount
|
| 54 |
TAX_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Tax Percent
|
| 55 |
INVOICE_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Action
C=Reprint
I=Invoice
P=Pro Forma
|
| 56 |
VENDOR_ERROR |
Signed Number(6,0) |
DECIMAL(5) NOT NULL |
Supplier Error
|
| 57 |
ERROR_DESCR |
Character(20) |
VARCHAR2(20) NOT NULL |
Error Description
|
| 58 |
WRITE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Write Flag
|
| 59 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 60 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 61 |
CONSOL_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Specifies the invoice identifier associated with a consolidated bill.
|
| 62 |
UPD_BILNTAX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
For use with BITAX000 to update BI_LINE_TAX
|
| 63 |
PRIOR_ADJ_INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Adjusted Invoice
|
| 64 |
SQL_TEXT |
Character(254) |
VARCHAR2(254) NOT NULL |
SQL Text
|