UPG_PND_VAT_TAO (SQL Table)	Index Back
Pending Item VAT Amounts

UPG_PND_VAT_TAO

(SQL Table)

Pending Item VAT Amounts

# 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.
Default Value: PENDING_ITEM.GROUP_BU

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.
Default Value: PENDING_ITEM.GROUP_ID

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: PENDING_ITEM.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.
Default Value: PENDING_ITEM.CUST_ID

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.
Default Value: PENDING_ITEM.ITEM

6 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
Default Value: PENDING_ITEM.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.
Default Value: PENDING_ITEM.GROUP_SEQ_NUM

8 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated

9 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table: VAT_TXN_CD

10 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table: VAT_HEADER_VW

11 VAT_DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger.
Prompt Table: VAT_DST_TYPE

12 VAT_BASIS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.

13 VAT_TRANS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount against which the VAT is applicable.

14 VAT_TRANS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the sale or purchase amount in base currency against which the VAT is applicable

15 VAT_BASIS_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. It is specified in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition of VAT_BASIS_AMT.

16 ENTRY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Specifies the currency associated with the monetary amount of a pending item.

#	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. Default Value: PENDING_ITEM.GROUP_BU
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. Default Value: PENDING_ITEM.GROUP_ID
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PENDING_ITEM.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. Default Value: PENDING_ITEM.CUST_ID
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. Default Value: PENDING_ITEM.ITEM
6	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line Default Value: PENDING_ITEM.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. Default Value: PENDING_ITEM.GROUP_SEQ_NUM
8	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible. E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated
9	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. Prompt Table: VAT_TXN_CD
10	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. Prompt Table: VAT_HEADER_VW
11	VAT_DST_ACCT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger. Prompt Table: VAT_DST_TYPE
12	VAT_BASIS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges.
13	VAT_TRANS_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount against which the VAT is applicable.
14	VAT_TRANS_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the sale or purchase amount in base currency against which the VAT is applicable
15	VAT_BASIS_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. It is specified in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition of VAT_BASIS_AMT.
16	ENTRY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Specifies the currency associated with the monetary amount of a pending item.