PENDING_TAX_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GROUP_BU	Character(5)	VARCHAR2(5) NOT NULL	Represents the high level grouping of multiple general ledger business units.
2	GROUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
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	GROUP_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
8	TAX_RATE_SEQ	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence
9	EXS_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Rate Code
10	EXS_TAX_RATE_SEQ	Number(3,0)	SMALLINT NOT NULL	Tax Rate Sequence
11	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
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
28	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
29	ENTRY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency associated with the monetary amount of a pending item.
30	RPT_PROCESS	Character(1)	VARCHAR2(1) NOT NULL	In process flag Default Value: N