RMA_ORD_VTTX_VW (SQL View)	Index Back
RMA VAT/Tax Fields fr Order RMA VAT/Tax Fields fr Order

RMA_ORD_VTTX_VW

(SQL View)

RMA VAT/Tax Fields fr Order

SELECT S.BUSINESS_UNIT , S.ORDER_NO , S.ORDER_INT_LINE_NO , S.SCHED_LINE_NBR , S.COUNTRY_LOC_BUYER , S.COUNTRY_LOC_SELLER , S.COUNTRY_SHIP_FROM , S.COUNTRY_SHIP_TO , S.COUNTRY_VAT_BILLFR , S.COUNTRY_VAT_BILLTO , S.COUNTRY_VAT_PERFRM , S.COUNTRY_VAT_SUPPLY , S.CUST_PICKUP , S.TAX_CUST_GROUP , S.GROUP_CODE , S.IST_TXN_FLG , S.ORD_ACCEPT_LOC , S.ORD_ORIGIN_LOC , L.PHYSICAL_NATURE , SP.SETID , ' ' , S.PT_SALE_FLG , S.SHIP_FROM_LOC , S.ADDRESS_SEQ_NUM , S.SHIP_TO_CUST_ID , S.SRV_PERFORM_LOC , S.STATE_LOC_BUYER , S.STATE_LOC_SELLER , S.STATE_SHIP_FROM , S.STATE_SHIP_TO , S.STATE_VAT_DEFAULT , S.STATE_VAT_PERFRM , ' ' , S.STORE_LOC , S.TAX_CD , S.TAX_CD_VAT , S.TAX_CUST_ID , S.TAX_DATE , S.TAX_DEPARTMENT , S.TAX_DIVISION , S.TAX_EXEMPT_CERT , S.TAX_EXEMPT_FLG , S.TAX_EXEMPT_RC , S.TAX_GROUP , S.TAX_JOB_NUM , S.TAX_TRANS_SUB_TYPE , S.TAX_TRANS_TYPE , S.TAX_USER_AREA , S.TITLE_PASSAGE , S.VAT_APPLICABILITY , S.VAT_CALC_GROSS_NET , ' ' , S.VAT_DCLRTN_POINT , S.VAT_DST_ACCT_TYPE , S.VAT_EXCPTN_CERTIF , S.VAT_EXCPTN_TYPE , ' ' , ' ' , S.VAT_RECALC_FLG , S.VAT_RGSTRN_BUYER , ' ' , S.VAT_ROUND_RULE , S.VAT_SERVICE_TYPE , S.VAT_SVC_SUPPLY_FLG , S.VAT_TREATMENT , S.VAT_TREATMENT_GRP , S.VAT_TXN_TYPE_CD FROM PS_ORD_LINE L , PS_ORD_SCHEDULE S , PS_BUS_UNIT_TBL_OM B , PS_SET_CNTRL_REC SP WHERE L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.ORDER_NO = S.ORDER_NO AND L.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND L.BUSINESS_UNIT = B.BUSINESS_UNIT AND SP.RECNAME = 'PROD_GROUP_TBL' AND SP.SETCNTRLVALUE = L.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

5 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner

6 COUNTRY_LOC_SELLER Character(3) VARCHAR2(3) NOT NULL Seller's Location Country - May be either the VAT Entity or the Trading Partner

7 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).

8 COUNTRY_SHIP_TO Character(3) VARCHAR2(3) NOT NULL Specifies the country to which the invoice contents were shipped (for VAT processing only).

9 COUNTRY_VAT_BILLFR Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is generated (for VAT processing only).

10 COUNTRY_VAT_BILLTO Character(3) VARCHAR2(3) NOT NULL Specifies the country where an invoice is sent (for VAT processing only).

11 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed

12 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country

13 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes

14 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

15 GROUP_CODE Number(5,0) INTEGER NOT NULL Group With Line

16 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes

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

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

19 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services

20 PROD_GRP_SETID Character(5) VARCHAR2(5) NOT NULL Product Group SetID

21 PROVINCE Character(1) VARCHAR2(1) NOT NULL Province

22 PT_SALE_FLG Character(1) VARCHAR2(1) NOT NULL Point of Sale Flag

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

24 SHIP_TO_ADDR_NUM Number(5,0) INTEGER NOT NULL Ship To Address Sequence Num

25 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

26 SRV_PERFORM_LOC Character(10) VARCHAR2(10) NOT NULL Service Performance Location

27 STATE_LOC_BUYER Character(6) VARCHAR2(6) NOT NULL Buyer's Location State - May be either the VAT Entity or the Trading Partner

28 STATE_LOC_SELLER Character(6) VARCHAR2(6) NOT NULL Seller's Location State - May be either the VAT Entity or the Trading Partner

29 STATE_SHIP_FROM Character(6) VARCHAR2(6) NOT NULL Ship From State

30 STATE_SHIP_TO Character(6) VARCHAR2(6) NOT NULL Ship To State

31 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State

32 STATE_VAT_PERFRM Character(6) VARCHAR2(6) NOT NULL State Where Service Physically Performed

33 STATE_VAT_SUPPLY Character(6) VARCHAR2(6) NOT NULL VAT Place of Supply State

34 STORE_LOC Character(10) VARCHAR2(10) NOT NULL Store Location

35 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

36 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.

37 TAX_CUST_ID Character(15) VARCHAR2(15) NOT NULL Tax Customer ID

38 TAX_DATE Date(10) DATE Tax Date

39 TAX_DEPARTMENT Character(5) VARCHAR2(5) NOT NULL Department used by Tax Vendors

40 TAX_DIVISION Character(5) VARCHAR2(5) NOT NULL Division for Tax Suppliers

41 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate

42 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

43 TAX_EXEMPT_RC Character(2) VARCHAR2(2) NOT NULL Exempt Reason Code
01=Certificat

44 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

45 TAX_JOB_NUM Character(10) VARCHAR2(10) NOT NULL Job Number

46 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

47 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
1=Sale
2=Rental
3=Service
4=Purchase
5=Lease
B=Return

48 TAX_USER_AREA Character(25) VARCHAR2(25) NOT NULL Used for tax calculation by tax vendor.

49 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

50 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated

51 VAT_CALC_GROSS_NET Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net

52 VAT_DCLRTN_DT_SRC Character(1) VARCHAR2(1) NOT NULL Declaration Date Source
A=Delivery Date - Ext Process
D=Delivery Date - Txn Entry
I=Invoice Date
M=Manual Entry
N=Not Applicable

53 VAT_DCLRTN_POINT Character(1) VARCHAR2(1) NOT NULL A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time

54 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.

55 VAT_EXCPTN_CERTIF Character(20) VARCHAR2(20) NOT NULL Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.

56 VAT_EXCPTN_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated

57 VAT_HDR_IND Character(1) VARCHAR2(1) NOT NULL VAT Header Indicator

58 VAT_PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group

59 VAT_RECALC_FLG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.

60 VAT_RGSTRN_BUYER Character(20) VARCHAR2(20) NOT NULL Specifies a customers VAT Registration ID for a particular country.

61 VAT_RGSTRN_SELLER Character(20) VARCHAR2(20) NOT NULL Seller's VAT Registration

62 VAT_ROUND_RULE Character(1) VARCHAR2(1) NOT NULL " Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up

63 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication

64 VAT_SVC_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed

65 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment

66 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group

67 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
4	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
5	COUNTRY_LOC_BUYER	Character(3)	VARCHAR2(3) NOT NULL	Buyer's Location Country - May be either the VAT Entity or the Trading Partner
6	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner
7	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
8	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
9	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
10	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
11	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
12	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
13	CUST_PICKUP	Character(1)	VARCHAR2(1) NOT NULL	Counter sale customer pickup flag N=No Y=Yes
14	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
15	GROUP_CODE	Number(5,0)	INTEGER NOT NULL	Group With Line
16	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes
17	ORD_ACCEPT_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Acceptance
18	ORD_ORIGIN_LOC	Character(10)	VARCHAR2(10) NOT NULL	Order Origin
19	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
20	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
21	PROVINCE	Character(1)	VARCHAR2(1) NOT NULL	Province
22	PT_SALE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Point of Sale Flag
23	SHIP_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Ship From Location
24	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
25	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
26	SRV_PERFORM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Service Performance Location
27	STATE_LOC_BUYER	Character(6)	VARCHAR2(6) NOT NULL	Buyer's Location State - May be either the VAT Entity or the Trading Partner
28	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner
29	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
30	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State
31	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
32	STATE_VAT_PERFRM	Character(6)	VARCHAR2(6) NOT NULL	State Where Service Physically Performed
33	STATE_VAT_SUPPLY	Character(6)	VARCHAR2(6) NOT NULL	VAT Place of Supply State
34	STORE_LOC	Character(10)	VARCHAR2(10) NOT NULL	Store Location
35	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
36	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
37	TAX_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Tax Customer ID
38	TAX_DATE	Date(10)	DATE	Tax Date
39	TAX_DEPARTMENT	Character(5)	VARCHAR2(5) NOT NULL	Department used by Tax Vendors
40	TAX_DIVISION	Character(5)	VARCHAR2(5) NOT NULL	Division for Tax Suppliers
41	TAX_EXEMPT_CERT	Character(30)	VARCHAR2(30) NOT NULL	Exemption Certificate
42	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
43	TAX_EXEMPT_RC	Character(2)	VARCHAR2(2) NOT NULL	Exempt Reason Code 01=Certificat
44	TAX_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Tax Group
45	TAX_JOB_NUM	Character(10)	VARCHAR2(10) NOT NULL	Job Number
46	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
47	TAX_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Transaction Type 1=Sale 2=Rental 3=Service 4=Purchase 5=Lease B=Return
48	TAX_USER_AREA	Character(25)	VARCHAR2(25) NOT NULL	Used for tax calculation by tax vendor.
49	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
50	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible. E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated
51	VAT_CALC_GROSS_NET	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount. G=Calculate at Gross N=Calculate at Net
52	VAT_DCLRTN_DT_SRC	Character(1)	VARCHAR2(1) NOT NULL	Declaration Date Source A=Delivery Date - Ext Process D=Delivery Date - Txn Entry I=Invoice Date M=Manual Entry N=Not Applicable
53	VAT_DCLRTN_POINT	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment. A=At Accounting Date D=At Delivery Time I=At Invoice Time P=At Payment Time
54	VAT_DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
55	VAT_EXCPTN_CERTIF	Character(20)	VARCHAR2(20) NOT NULL	Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
56	VAT_EXCPTN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type. N=None S=Suspended X=Exonerated
57	VAT_HDR_IND	Character(1)	VARCHAR2(1) NOT NULL	VAT Header Indicator
58	VAT_PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
59	VAT_RECALC_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
60	VAT_RGSTRN_BUYER	Character(20)	VARCHAR2(20) NOT NULL	Specifies a customers VAT Registration ID for a particular country.
61	VAT_RGSTRN_SELLER	Character(20)	VARCHAR2(20) NOT NULL	Seller's VAT Registration
62	VAT_ROUND_RULE	Character(1)	VARCHAR2(1) NOT NULL	" Rounding rule to be applied to VAT calculations. Options are 'Natural' D=Round Down N=Natural Round U=Round Up
63	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
64	VAT_SVC_SUPPLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	VAT Services Place of Supply Flag 1=Supplier's Countries 2=Buyer's Countries 3=Where Physically Performed
65	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
66	VAT_TREATMENT_GRP	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Group
67	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.