BI_XLN_TAX_VW

(SQL View)
 Index Back

Bill Line Tax Info for XML


SELECT C.SETID , C.CUST_ID , A.BUSINESS_UNIT , A.INVOICE , A.LINE_SEQ_NUM , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.ADDR_FIELD3 , A.CITY , A.IN_CITY_LIMIT , A.COUNTY , A.STATE , A.GEO_CODE , A.POSTAL , A.COUNTRY , A.SHIP_FROM_LOC , A.ORD_ACCEPT_LOC , A.ORD_ORIGIN_LOC , A.STORE_LOC , A.TITLE_PASSAGE , A.TAX_GROUP , A.TAX_TRANS_TYPE , A.TAX_TRANS_SUB_TYPE , A.TAX_EXEMPT_RC , A.TAX_JOB_NUM , A.ERROR_DESCR , A.PROCESS_INSTANCE , A.CUSTOMER_GROUP , A.TAX_USER_AREA , A.ADD_DTTM , A.AUDIT_ACTN , A.IN_PROCESS_FLG , A.LAST_UPDATE_DTTM , A.LAST_MAINT_OPRID FROM PS_BI_XLN_TAX_TAO A , PS_BI_XLINE_TAO B , PS_BI_XHDR_TAO C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE AND A.LINE_SEQ_NUM = B.LINE_SEQ_NUM AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.INVOICE = C.INVOICE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
5 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
10 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
11 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
12 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
13 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
14 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
15 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
16 CITY Character(30) VARCHAR2(30) NOT NULL City
17 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

Default Value: N

18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
19 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

20 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
21 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Default Value: INSTALLATION.COUNTRY

Prompt Table: COUNTRY_TBL

23 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location

Prompt Table: LOCATION_TBL

24 ORD_ACCEPT_LOC Character(10) VARCHAR2(10) NOT NULL Order Acceptance

Default Value: BUS_UNIT_TBL_BI.ORD_ACCEPT_LOC

Prompt Table: LOCATION_TBL

25 ORD_ORIGIN_LOC Character(10) VARCHAR2(10) NOT NULL Order Origin

Default Value: BUS_UNIT_TBL_BI.ORD_ORIGIN_LOC

Prompt Table: LOCATION_TBL

26 STORE_LOC Character(10) VARCHAR2(10) NOT NULL Store Location
27 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
28 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group
29 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return
30 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
31 TAX_EXEMPT_RC Character(2) VARCHAR2(2) NOT NULL Exempt Reason Code
01=Certificat
32 TAX_JOB_NUM Character(10) VARCHAR2(10) NOT NULL Job Number
33 ERROR_DESCR Character(20) VARCHAR2(20) NOT NULL Error Description
34 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
35 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

Prompt Table: CUST_BI_GRP_VW

36 TAX_USER_AREA Character(25) VARCHAR2(25) NOT NULL Used for tax calculation by tax vendor.
37 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
38 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
39 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
40 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.
41 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID