SII_ENT_LOC_TBL

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.

3 VAT_TXN_SOURCE Character(6) VARCHAR2(6) NOT NULL VAT Transaction Source

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

5 SII_INVOICE_ID Character(60) VARCHAR2(60) NOT NULL SII_INVOICE_ID

6 INVOICE_DT Date(10) DATE Invoice Date

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

8 CITY Character(30) VARCHAR2(30) NOT NULL City

9 STATE Character(6) VARCHAR2(6) NOT NULL State

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	VAT_ENTITY	Character(20)	VARCHAR2(20) NOT NULL	Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
3	VAT_TXN_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	VAT Transaction Source
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	SII_INVOICE_ID	Character(60)	VARCHAR2(60) NOT NULL	SII_INVOICE_ID
6	INVOICE_DT	Date(10)	DATE	Invoice Date
7	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
8	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
9	STATE	Character(6)	VARCHAR2(6) NOT NULL	State