AR_ITM_ACTXDT_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	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.
5	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
6	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
7	ITEM_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Item Sequence Number
8	TAX_RATE_SEQ	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence
9	EXS_TAX_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Tax Type C=Custom Duty E=Excise Duty G=Goods and Services Tax S=Sales Tax / VAT
10	EXS_TAX_RATE_SEQ	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence
11	EXS_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Rate Code
12	EXS_TAX_CMPNT_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Component Code
13	EXS_TAX_DEP_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Dependency Code
14	EXS_CALC_SCHEME	Character(1)	VARCHAR2(1) NOT NULL	Calculation Scheme A=Amount P=Percentage Q=Quantity
15	EXS_TAX_RATE_PCT	Number(8,4)	DECIMAL(7,4) NOT NULL	Tax Rate Percentage
16	EXS_TAXRT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
17	EXS_TAXRT_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
18	EXS_TAXRT_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tax Rate Amount
19	EXS_TAX_RATE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Excise Unit Of Measure
20	EXS_CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Excise Currency Reporting
21	EXS_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount
22	EXS_TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount Base Currency
23	EXS_TAX_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Amount Reporting Currency
24	EXS_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount
25	EXS_BASIS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount Base Currency
26	EXS_BASIS_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Sales Tax Basis Amount Reporting Currency
27	EXS_CURRENCY_TRC	Character(3)	VARCHAR2(3) NOT NULL	Curreny Tax Rate