| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 3 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 4 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 5 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 6 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 7 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 8 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 9 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 10 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat
WW=Trailer
|
| 11 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 12 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 13 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 14 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 15 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
|
| 16 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 17 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 18 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 19 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 20 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 21 |
SHIP_FROM_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship From Location
Prompt Table:
LOCATION_TBL
|
| 22 |
ORD_ACCEPT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Acceptance
Prompt Table:
LOCATION_TBL
|
| 23 |
ORD_ORIGIN_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Order Origin
Prompt Table:
LOCATION_TBL
|
| 24 |
STORE_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Store Location
|
| 25 |
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
|
| 26 |
TAX_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tax Group
|
| 27 |
TAX_TRANS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
|
| 28 |
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
|
| 29 |
TAX_EXEMPT_RC |
Character(2) |
VARCHAR2(2) NOT NULL |
Exempt Reason Code
01=Certificat
|
| 30 |
TAX_JOB_NUM |
Character(10) |
VARCHAR2(10) NOT NULL |
Job Number
|
| 31 |
ERROR_DESCR |
Character(20) |
VARCHAR2(20) NOT NULL |
Error Description
|
| 32 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 33 |
CUSTOMER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Customer Group
|
| 34 |
TAX_USER_AREA |
Character(25) |
VARCHAR2(25) NOT NULL |
Used for tax calculation by tax vendor.
|
| 35 |
TAX_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Tax Customer ID
|
| 36 |
TAX_JUR_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax jurisdiction indicator
1=Ship-To Location
2=Ship-From Location
3=Order Acceptance Location
4=Order Origin Location
|
| 37 |
TAX_DATE |
Date(10) |
DATE |
Tax Date
|
| 38 |
GROUP_CODE |
Number(5,0) |
INTEGER NOT NULL |
Group With Line
|
| 39 |
SRV_PERFORM_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Service Performance Location
Prompt Table:
LOCATION_TBL
|
| 40 |
TAX_COMPANY |
Character(5) |
VARCHAR2(5) NOT NULL |
Company for Tax Suppliers
|
| 41 |
TAX_DIVISION |
Character(5) |
VARCHAR2(5) NOT NULL |
Division for Tax Suppliers
|
| 42 |
TAX_DEPARTMENT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department used by Tax Vendors
|
| 43 |
PT_SALE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Point of Sale Flag
Y/N Table Edit
Default Value: N
|
| 44 |
CUST_PICKUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Counter sale customer pickup flag
N=No
Y=Yes
Y/N Table Edit
|
| 45 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD
|
| 46 |
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. "
Default Value: BI_HDR.BASE_CURRENCY
|
| 47 |
USETAX_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 48 |
USETAX_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base Use Tax Amount
|
| 49 |
USETAX_BASIS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Basis Amount
|
| 50 |
USETAX_BASIS_AMT_B |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Use Tax Basis in Base Curr
|
| 51 |
ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Date Time Added
|
| 52 |
LAST_UPDATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 53 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|