ITL_THR_RPT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ITL_RPT_ID	Character(10)	VARCHAR2(10) NOT NULL	Italian Report ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	CONT_REF_NUM	Character(15)	VARCHAR2(15) NOT NULL	Contract Ref Number
4	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
5	INVOICE_DT	Date(10)	DATE	Invoice Date
6	VAT_RGSTRN_ID	Character(20)	VARCHAR2(20) NOT NULL	VAT Registration ID
7	DECLARATION_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Declaration Year
8	RECORD_TYP_TPRTNR	Character(1)	VARCHAR2(1) NOT NULL	Third Party Record Type
9	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
10	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
11	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
12	CUSTOMER_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.
13	TAXPAYER_ID	Character(14)	VARCHAR2(14) NOT NULL	Taxpayer ID
14	VAT_RGSTRN_TPRTNR	Character(20)	VARCHAR2(20) NOT NULL	Trading Partner's VAT Registration ID **** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
15	INV_LINE_NUMBER	Number(31,0)	DECIMAL(31) NOT NULL	Invoice Line Number
16	INV_LINE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Invoice Line Type
17	INV_LINE_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Invoice Line Amount
18	INV_LINE_TAX_CD	Character(8)	VARCHAR2(8) NOT NULL	Invoice Line Tax code
19	INV_LINE_TAX_RATE	Signed Number(9,4)	DECIMAL(7,4) NOT NULL	Invoice Line Tax Rate
20	INV_LINE_TAX_AMT	Signed Number(33,3)	DECIMAL(31,3) NOT NULL	Invoice Line Tax Amt
21	INV_LINE_PYMT_MODE	Character(1)	VARCHAR2(1) NOT NULL	Invoice Line Payment Mode F=Full Amount I=Installment P=Periodic Payment
22	APPL_CRDR_MEMO	Character(8)	VARCHAR2(8) NOT NULL	Applied Credit and Debit Memo
23	RUN_DTTM	DateTime(26)	TIMESTAMP	Run Date and Time