(IND) Populating Pending Tax Table Fields for India

Populate the PS_PENDING_TAX and PS_PENDING_TAX_DTL tables only if you are bringing in taxes for India information from a billing system.

PS_PENDING_TAX Table

The following table specifies a field type for each field. Use the field type to determine how to populate system-maintained fields and optional fields that you want to leave blank. Supply a space for character fields, a null value for date fields, and a zero for numeric fields.

Note:

Use Application Designer to review the characteristics for each field in more detail.

Column	Field Name	Field Type	Option/Condition /Required	Field Description
1	GROUP_BU	Character	Required	Use the same value as the GROUP_BU on PS_GROUP_ CONTROL.
2	GROUP_ID	Character	Required	Use the same value as the GROUP_ID on PS_GROUP_ CONTROL.
3	BUSINESS_UNIT	Character	Optional	Use the same value as the BUSINESS_UNIT on PS_ PENDING_ITEM.
4	CUST_ID	Character	Optional	Use the same value as the CUST_ID on PS_PENDING_ITEM.
5	ITEM	Character	Optional	Use the same value as the ITEM on PS_PENDING_ITEM.
6	ITEM_LINE	Number	Optional	Use the same value as the ITEM_LINE on PS_PENDING_ITEM.
7	GROUP_SEQ_NUM	Number	Optional	Use the same value as the GROUP_SEQ_NUM on PS_PENDING_ITEM.
8	TAX_RATE_SEQ	Number	Optional	Indicates the order in which tax component codes in the tax rate code are calculated. This line number is system generated.
9	EXD_APPL_FLG	Character	Optional	Enter Y to indicate that the business unit is excise-duty applicable. Otherwise, leave it blank.
10	STX_APPL_FLG	Character	Optional	Enter Y to indicate that the business unit is sales tax applicable. Otherwise, leave it blank.
11	EXS_TAX_TXN_TYPE	Character	Optional	Tax transaction type for the transaction. Values are: DEB: Direct export with bond. DEWB: Direct export without bond. DIMP: Direct import. DOM: Domestic. LEB: Local export with bond. LEWB: Local export without bond. LIMP: Local import.
12	STX_TAX_AUTH_RPT	Character	Optional	Enter a sales tax reporting authority. Select from the values that you establish on the PS_STX_TAX_AUTH table.
13	STATE_SHIP_TO	Character	Optional	The state where the items that are billed on this line are shipped.
14	STATE_SHIP_FROM	Character	Optional	The state from which the items that are billed on this line are shipped.
15	EXS_TXN_LINE_AMT	Sign	Optional	The total amount of transactions for the line. Each line has its own transaction total. The system uses this amount to calculate the taxes.
16	EXD_TAX_CATG_CD	Character	Optional	Enter an excise tax category code for the item. Select from the values that you establish on the PS_EXS_TAX_CATG table.
17	STX_TAX_CATG_CD	Character	Optional	Enter an sales tax category code for the item. Select from the values that you establish on the PS_EXS_TAX_CATG table.
18	EXD_TAX_AMT	Sign	Optional	The total amount of excise duty tax for the line. Each line has its own excise duty tax amount. The sum of all the excise duty amounts should equal the control excise duty amount. The control excise duty amount is the amount at field PENDING_ITEM.TOT_EXD_AMT.
19	EXD_TAX_RATE_CD	Character	Optional	Enter the tax rate code that is used to calculate the excise duty for each line. Select from the values that you establish on the PS_EXS_TAX_RATE table.
20	EXD_TAX_AMT_BSE	Sign	Optional	Excise duty in the business unit base currency.
21	EXD_TAX_AMT_RPT	Sign	Optional	The excise duty tax amount in the reporting currency.
22	STX_TAX_AMT	Sign	Optional	The total amount of sales tax for the line. Each line has its own sales tax amount. The sum of all the sales tax amounts should equal the control sales tax amount. The control sales tax amount is the amount at field PENDING_ITEM.TOT_STX_AMT.
23	STX_TAX_RATE_CD	Character	Optional	Enter the tax rate code that is used to calculate the sales tax for each line. Select from the values that you establish in the PS_EXS_TAX_RATE table.
24	STX_TAX_AMT_BSE	Sign	Optional	Sales tax amount in the business unit base currency.
25	STX_TAX_AMT_RPT	Sign	Optional	Sales tax amount in reporting currency.
26	EXS_CURRENCY_RPTG	Character	Optional	Enter the excise reporting currency. Select the CURRENCY_CD for the tax location that you define on the PS_ORG_TAX_LOC table.
27	STX_FORM_CD	Character	Optional	Sales tax form codes are assigned to tax rate codes. The form code helps determine the applicable forms for the transaction for form tracking purposes. Select from the values that you establish on the PS_STX_FORM_CODE table.
28	BU_APPL_FLG	Character	Optional	Business unit applicable flag. Set this field to Y, if excise duty or sales tax are applicable to the business unit.
29	EXS_DTL_LINK	Character	Optional	Leave blank.
30	SUM_TOT_EXD_AMT	Sign	Optional	Summary total of the total excise duty tax amounts.
31	SUM_TOT_EXD_BSE	Sign	Optional	Summary total of excise duty tax amounts in base currency.
32	SUM_TOT_STX_AMT	Sign	Optional	Summary total of the total sales tax amounts.
33	SUM_TOT_STX_BSE	Sign	Optional	Summary total of sales tax amounts in base currency.
34	SUM_TOT_TAX_AMT	Sign	Optional	Summary total of excise duty and sales tax amounts.
35	RATE_DIV_RPT	Number	Optional	Used to convert the base currency into the tax location reporting currency.
36	RATE_MULT_RPT	Sign	Optional	Used to convert the base currency into the tax location reporting currency.
37	RT_TYPE	Character	Optional	Rate type used to calculate the exchange rate between the default reporting currency code and the override currency code.
38	EXD_TAX_RATE_SRC	Character	Optional	Source transaction for the excise tax rate. Enter 1 (system-defined) or 2 (manually entered).
39	STX_TAX_RATE_SRC	Character	Optional	Source transaction for the sales tax rate. Enter 1 (system-defined) or 2 (manually entered).
40	ORG_SETID	Character	Optional	SetID for an organization.
41	ORG_CODE	Character	Optional	Organization code for a tax location. Select from the values that are established on the PS_ORG_RGSTN_DTL table.
42	ORG_TAX_LOC_CD	Character	Optional	Organization that is associated with a tax location code. Select from the values that are established on the PS_ORG_TAX LOC table.
43	EXS_TXC_LN_STATUS	Character	Optional	Excise tax calculation line status.
44	EXD_UOM	Character	Optional	Excise unit of measure for the assessable value.
45	RATE_MULT_EXS	Sign	Optional	Currency rate multiplier that is used to convert the base currency into the tax location reporting currency. Enter 1.
46	RATE_DIV_EXS	Number	Optional	Currency rate divisor that is used to convert the base currency into the tax location reporting currency. Enter 1.
47	COUNTRY_SHIP_FROM	Character	Optional	Country from which items are shipped.
48	COUNTRY_SHIP_TO	Character	Optional	Ship to country for the line item.
49	RATE_MULT	Sign	Optional	Used to convert the transaction currency into base currency.
50	RATE_DIV	Number	Optional	Used to convert the transaction currency into base currency.
51	ENTRY_CURRENCY	Character	Optional	The currency code for the tax amount. Select from the values that are established on PS_CURRENCY_ CD_TBL.

PS_PENDING_TAX_DTL

The following table specifies a field type for each field. Use the file type to determine how to populate system-maintained field and optional fields that you want to leave blank. Supply a space for character fields, a null value for date fields, and a zero for numeric fields.

Note:

Use Application Designer to review the characteristics of each field in more detail.

Column	Field Name	Field Type	Option/Condition/Required	Field Description
1	GROUP_BU	Character	Required	Use the same value as the GROUP_BU on PS_GROUP_ CONTROL.
2	GROUP_ID	Character	Required	Use the same value as the GROUP_ID on PS_GROUP_ CONTROL.
3	BUSINESS_UNIT	Character	Optional	Use the same value as the BUSINESS_UNIT on PS_ PENDING_ITEM.
4	CUST_ID	Character	Optional	Use the same value as the CUST_ID on PS_PENDING_ITEM.
5	ITEM	Character	Optional	Use the same value as the ITEM on PS_PENDING_ITEM.
6	ITEM_LINE	Number	Optional	Use the same value as the ITEM_LINE on PS_PENDING_ITEM.
7	GROUP_SEQ_NUM	Number	Optional	Use the same value as the GROUP_SEQ_NUM on PS_PENDING_ITEM.
8	TAX_RATE_SEQ	Number	Optional	The sequence number for the tax rate. This entry is manual for most excise adjustment types.
9	EXS_TAX_RATE_CD	Character	Optional	If this line is related to excise duty, enter the same excise duty that is entered in the PENDING_TAX.EXD_TAX_RATE_CD field. If this line is related to sales tax, enter the same sales tax that is entered in the PENDING_TAX.STX_TAX_RATE_CD field. The field EXS_TAX_TYPE is the field that indicates if the line is an excise duty line or a sales tax line. Enter the tax rate code that is used to calculate the excise duty for each line. Select from the values that you establish on the PS_EXS_TAX_RATE table. Leave blank if excise duty and sales tax should not be calculated for the line.
10	EXS_TAX_RATE_SEQ	Number	Optional	Indicates the order that tax component codes in the tax rate code are calculated.
11	EXS_TAX_TYPE	Character	Optional	Enter the type of tax to calculate in the line. Enter E for excise duty and S for sales tax.
12	EXS_TAX_CMPNT_CD	Character	Optional	Enter the tax component code. Select from the values that you establish on the PS_EXS_TAX_CMPNT table.
13	EXS_TAX_DEP_CD	Character	Optional	Enter the tax dependency code that indicates the basis for calculating the tax, as well as the precedence of taxes of the same tax type that must be included. Select from the values that you establish on the PS_EXS_TAX_DPNDNCY table.
14	EXS_CALC_SCHEME	Character	Optional	Indicates how the taxes are calculated. Enter P (percentage), Q (quantity), or A (amount). In PeopleSoft Receivables, only the percentage lines are calculated, but the others should be populated to be consistent with the tax rate code.
15	EXS_TAX_RATE_PCT	Number	Optional	Enter the percent of taxation that is associated with the corresponding tax rate code if the EXS_CALC_SCHEME is P.
16	EXS_TAXRT_AMT	Sign	Optional	Leave blank.
17	EXS_TAXRT_AMT_BSE	Sign	Optional	Leave blank.
18	EXS_TAXRT_AMT_RPT	Sign	Optional	Leave blank.
19	EXS_TAX_RATE_UOM	Character	Optional	Leave blank.
20	EXS_CURRENCY_RPTG	Character	Optional	Enter the code for the reporting currency.
21	EXS_TAX_AMT	Sign	Optional	The total amount of excise tax for the line. The sum of all the excise tax amounts should equal the control excise tax amount.
22	EXS_TAX_AMT_BSE	Sign	Optional	Excise tax amount in the base currency.
23	EXS_TAX_AMT_RPT	Sign	Optional	The total amount of excise tax for each line expressed in the reporting currency.
24	EXS_BASIS_AMT	Sign	Optional	Base amount against which taxes are calculated.
25	EXS_BASIS_AMT_BSE	Sign	Optional	The base amount that the system uses when calculating excise or sales taxes. This amount is the excise basis amount in the base currency.
26	EXS_BASIS_AMT_RPT	Sign	Optional	The base amount that the system uses when calculating excise taxes expressed in the reporting currency.
27	EXS_CURRENCY_TRC	Character	Optional	Leave this field blank.
28	CURRENCY_CD	Character	Optional	Use the value in the CURRENCY_CD field currency code on the PS_PENDING_ITEM table if it's available. Otherwise, use the ENTRY_CURRENCY on the PS_PENDING_ITEM table.
29	ENTRY_CURRENCY	Character	Optional	The currency code for the tax amount. Use the same value as the ENTRY_CURRENCY on the PS_PENDING_ITEM table.