Populating Pending VAT Table Fields

Populate the PS_PENDING_VAT table only if you are bringing in VAT information from a billing system. For each item with VAT information, enter one or two rows for each unique combination of VAT applicability, VAT transaction type code, and tax code to the PS_PENDING_VAT table as needed. Each row should have a different VAT sequence number.

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 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	Required	Use the same value as the BUSINESS_UNIT on PS_ PENDING_ITEM.
4	CUST_ID	Character	Required	Use the same value as the CUST_ID on PS_PENDING_ITEM.
5	ITEM	Character	Required	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	VAT_APPLICABILITY	Character	Optional	Enter the VAT applicability on the VAT line.
9	VAT_TXN_TYPE_CD	Character	Optional	Provide the transaction type code on the VAT line.
10	TAX_CD_VAT	Character	Optional	Provide the VAT code on the VAT item line.
11	VAT_DST_ACCT_TYPE	Character	Optional	If VAT_APPLICABILITY is T (taxable) or S (suspended) and VAT_DCLRTN_POINT is P (payment) (on PENDING_ITEM), then populate VAT_DST_ACCT_TYPE with VAT output intermediate VOI. If PENDING_ITEM.VAT_DCLRTN_POINT is invoice, then populate VAT_DST_ACCT_TYPE with VAT output VO. If VAT_APPLICABILITY is E (exempt) or O (out of scope), then populate VAT_DST_ACCT_TYPE with VONT.
12	VAT_SEQ_NUM	Number	Optional	Enter a sequence number if two VAT lines have the same combination of VAT applicability, VAT transaction type, and tax code.
13	TAX_CD_VAT_PCT	Sign	Optional	Provide the tax percentage corresponding to the VAT code.
14	VAT_DCLRTN_DT	Date	Optional	Provide the invoice date for declaration point of invoice; provide the ship date for declaration point of delivery; leave blank for a declaration point date of payment.
15	VAT_BASIS_AMT	Sign	Optional	Provide the VAT basis amount for the summarized information on this VAT line.
16	VAT_TRANS_AMT	Sign	Required	Provide the VAT basis transaction amount for the summarized information on this VAT line. This amount is the VAT basis (that is, sales) amount before the application of any prompt payment discounts.
17	VAT_TRANS_AMT_BSE	Number	Optional	Provide the VAT basis transaction amount for the summarized information on this VAT line. This amount is the VAT basis (that is, sales) amount in base currency before the application of any available prompt payment discounts.
18	VAT_AMT	Sign	Optional	Provide the VAT amount for the summarized information on this VAT line if the pending item has an invoice declaration point.
19	VAT_AMT_I	Sign	Optional	Provide the VAT amount for the summarized information on this VAT line if the pending item has a payment declaration point.
20	VAT_ERROR_FLAG	Character	Required	Set value to N.
21	ENTRY_CURRENCY	Character	Required	The currency code for the VAT amount. Select from the values that are established on PS_CURRENCY_ CD_TBL.
22	VAT_AMT_BASE	Sign	Optional	Provide VAT amount in business unit base currency.
23	VAT_BASIS_AMT_BASE	Sign	Optional	Provide VAT basis amount in base currency.
24	VAT_AMT_BASE_I	Sign	Optional	Holds intermediate VAT amount when VAT is declared at payment.
25	VAT_TREATMENT	Character	Optional	Determines which default values are applied. The system handles VAT treatment separately for transactions involving goods and services.
26	PHYSICAL_NATURE	Character	Optional	Indicates whether an object is a good or a service.
27	COUNTRY_LOC_BUYER	Character	Optional	Location country of the buyer. This determines VAT defaulting for a VAT service type of Other if it is performed at the ship to location.
28	STATE_LOC_BUYER	Character	Optional	Location state of the buyer. This determines VAT defaulting for a VAT service type of Other if it is performed at the ship to location.
29	COUNTRY_LOC_SELLER	Character	Optional	Location country of the seller. This determines VAT defaulting for a VAT service type of Other if it is performed at the ship from location.
30	STATE_LOC_SELLER	Character	Optional	Location state of the seller. This determines VAT defaulting for a VAT service type of Other if it is performed at the ship from location.
31	VAT_SVC_SUPPLY_FLG	Character	Optional	Indicates the default place of supply for VAT on services. This determines where VAT is liable.
32	VAT_SERVICE_TYPE	Character	Optional	For VAT services treatment, indicates whether the VAT service type is 1 (Freight Transport) or 2 (Other). This value determines whether the VAT treatment appears by default based on the ship to and ship from locations (freight), or the buyer's and sellers location (other).
33	COUNTRY_VAT_PERFRM	Character	Optional	For services, determines the country in which the services is performed.
34	STATE_VAT_PERFRM	Character	Optional	For services, determines the state in which the services is performed.
35	COUNTRY_VAT_SUPPLY	Character	Optiona	For VAT services treatment, indicates the country of the default place of supply.
36	STATE_VAT_SUPPLY	Character	Optional	For VAT services treatment, indicates the country of the default place of supply.
37	STATE_SHIP_FROM	Character	Optional	PeopleSoft Receivables business unit location state. In the case of transactions involving goods or freight service transactions, this is used to determine the VAT treatment.
38	STATE_SHIP_TO	Character	Optional	Ship to customer location country. In the case of transactions involving goods or freight service transactions, this is used to determine the VAT treatment.
39	STATE_VAT_DEFAULT	Character	Optional	Enter the state or province that is used to determine the VAT defaults if the Track VAT by Province field (COUNTRY_VAT_SUBD_FLG) on the COUNTRY_VAT_TBL is set to Y.
40	VAT_DFLT_DONE_FLG	Character	Optional	Leave this field blank. The system populates this field for VAT items that are entered online.
41	VAT_ENTRD_AMT	Sign	Optional	Entered VAT amount in base currency. This amount is calculated from the transaction currency entered VAT amount, based on the exchange rate that is applicable to the transaction.
42	VAT_CALC_AMT	Sign	Optional	Shows the calculated VAT amount in the transaction currency.
43	PROCESS_INSTANCE	Number	Optional	Enter 0. The Receivables Update process updates this value.