RMA_IVC_LINE_VW (SQL View)	Index Back
RMA VAT/Tax Fields fr Inv Line RMA VAT/Tax Fields fr Inv Line

RMA_IVC_LINE_VW

(SQL View)

RMA VAT/Tax Fields fr Inv Line

SELECT L.BUSINESS_UNIT , L.INVOICE , L.LINE_SEQ_NUM , L.COUNTRY_LOC_BUYER , L.COUNTRY_LOC_SELLER , L.COUNTRY_SHIP_FROM , L.COUNTRY_SHIP_TO , L.COUNTRY_VAT_BILLFR , L.COUNTRY_VAT_BILLTO , L.COUNTRY_VAT_PERFRM , L.COUNTRY_VAT_SUPPLY , L.IST_TXN_FLG , L.PHYSICAL_NATURE , L.PROD_GRP_SETID , L.SHIP_TO_ADDR_NUM , L.SHIP_TO_CUST_ID , L.STATE_LOC_BUYER , L.STATE_LOC_SELLER , L.STATE_SHIP_FROM , L.STATE_SHIP_TO , L.STATE_VAT_DEFAULT , L.STATE_VAT_PERFRM , L.STATE_VAT_SUPPLY , L.TAX_CD , L.TAX_CD_VAT , L.TAX_EXEMPT_CERT , L.TAX_EXEMPT_FLG , L.VAT_APPLICABILITY , L.VAT_DST_ACCT_TYPE , L.VAT_PRODUCT_GROUP , L.VAT_SERVICE_TYPE , L.VAT_SVC_SUPPLY_FLG , L.VAT_TREATMENT , H.VAT_TREATMENT_GRP , L.VAT_TXN_TYPE_CD FROM PS_BI_HDR H , PS_BI_LINE L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.INVOICE = L.INVOICE

# 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 COUNTRY_LOC_BUYER Character(3) VARCHAR2(3) NOT NULL Buyer's Location Country - May be either the VAT Entity or the Trading Partner

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

25 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.

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

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

28 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

29 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.

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

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

32 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

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

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

35 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	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
3	LINE_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Sequence
4	COUNTRY_LOC_BUYER	Character(3)	VARCHAR2(3) NOT NULL	Buyer's Location Country - May be either the VAT Entity or the Trading Partner
5	COUNTRY_LOC_SELLER	Character(3)	VARCHAR2(3) NOT NULL	Seller's Location Country - May be either the VAT Entity or the Trading Partner
6	COUNTRY_SHIP_FROM	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country from which the invoice contents were shipped (for VAT processing only).
7	COUNTRY_SHIP_TO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country to which the invoice contents were shipped (for VAT processing only).
8	COUNTRY_VAT_BILLFR	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is generated (for VAT processing only).
9	COUNTRY_VAT_BILLTO	Character(3)	VARCHAR2(3) NOT NULL	Specifies the country where an invoice is sent (for VAT processing only).
10	COUNTRY_VAT_PERFRM	Character(3)	VARCHAR2(3) NOT NULL	Country Where Service Physically Performed
11	COUNTRY_VAT_SUPPLY	Character(3)	VARCHAR2(3) NOT NULL	VAT Place of Supply Country
12	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes
13	PHYSICAL_NATURE	Character(1)	VARCHAR2(1) NOT NULL	Physical Nature G=Goods S=Services
14	PROD_GRP_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product Group SetID
15	SHIP_TO_ADDR_NUM	Number(5,0)	INTEGER NOT NULL	Ship To Address Sequence Num
16	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
17	STATE_LOC_BUYER	Character(6)	VARCHAR2(6) NOT NULL	Buyer's Location State - May be either the VAT Entity or the Trading Partner
18	STATE_LOC_SELLER	Character(6)	VARCHAR2(6) NOT NULL	Seller's Location State - May be either the VAT Entity or the Trading Partner
19	STATE_SHIP_FROM	Character(6)	VARCHAR2(6) NOT NULL	Ship From State
20	STATE_SHIP_TO	Character(6)	VARCHAR2(6) NOT NULL	Ship To State
21	STATE_VAT_DEFAULT	Character(6)	VARCHAR2(6) NOT NULL	VAT Defaulting State
22	STATE_VAT_PERFRM	Character(6)	VARCHAR2(6) NOT NULL	State Where Service Physically Performed
23	STATE_VAT_SUPPLY	Character(6)	VARCHAR2(6) NOT NULL	VAT Place of Supply State
24	TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Code
25	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.
26	TAX_EXEMPT_CERT	Character(30)	VARCHAR2(30) NOT NULL	Exemption Certificate
27	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
28	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
29	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.
30	VAT_PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Product Group
31	VAT_SERVICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Service Type 1=Freight Transport 2=Other 3=Electronics/Communication
32	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
33	VAT_TREATMENT	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment
34	VAT_TREATMENT_GRP	Character(4)	VARCHAR2(4) NOT NULL	VAT Treatment Group
35	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.