| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
VAT_CONTEXT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
VAT Context ID
|
| 3 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 4 |
COUNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
2-Char Country Code
|
| 5 |
VAT_CNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
2-character country code to be displayed along with the VAT Registration ID.
|
| 6 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
Prompt Table:
COUNTRY_VAT_TBL
|
| 7 |
COUNTRY_VAT_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is sent (for VAT processing only).
Prompt Table:
COUNTRY_VAT_TBL
|
| 8 |
COUNTRY_VAT_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Reporting Country
Prompt Table:
%EDT_VAT_4
|
| 9 |
COUNTRY_VAT_SUPPLY |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Place of Supply Country
Prompt Table:
COUNTRY_TBL
|
| 10 |
COUNTRY_VAT_TPRTNR |
Character(3) |
VARCHAR2(3) NOT NULL |
Trading Partner's VAT Registration Country.
**** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
Prompt Table:
COUNTRY_VAT_TBL
|
| 11 |
CURRENCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Reporting Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Error Flag
|
| 13 |
IST_TXN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No
Y=Yes
|
| 14 |
STATE_VAT_DEFAULT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Defaulting State
Prompt Table:
%EDT_VAT_5
|
| 15 |
STATE_VAT_SUPPLY |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Place of Supply State
Prompt Table:
VAT_STAT_SUP_VW
|
| 16 |
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
|
| 17 |
VAT_ADVPAY_DEL_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Payables when Declaration is at Delivery Time
Y/N Table Edit
|
| 18 |
VAT_ADVPAY_DEL_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Receivables when Declaration is at Delivery Time
Y/N Table Edit
|
| 19 |
VAT_ADVPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments
Y/N Table Edit
|
| 20 |
VAT_ADVPAY_INV_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Payables when Declaration is at Invoice Time
Y/N Table Edit
|
| 21 |
VAT_ADVPAY_INV_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Receivables when Declaration is at Invoice Time
Y/N Table Edit
|
| 22 |
VAT_ADVPAY_PMT_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Payables when Declaration is at Payment Time
Y/N Table Edit
|
| 23 |
VAT_ADVPAY_PMT_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Receivables when Declaration is at Payment Time
Y/N Table Edit
|
| 24 |
VAT_ADVPAY_ACT_AP |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Payables when Declaration is at Accounting Date
Y/N Table Edit
|
| 25 |
VAT_ADVPAY_ACT_AR |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT on Advance Payments in Receivables When Declaration is at Accounting Date
Y/N Table Edit
|
| 26 |
VAT_APORT_CNTRL |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Apportionment Control
D=Distribution GL Business Unit
G=Transaction GL Business Unit
T=Transaction Business Unit
|
| 27 |
VAT_APPLICABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Applicable
E=Exempt
O=Outside of Scope of VAT
T=Taxable
|
| 28 |
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
|
| 29 |
VAT_AUTO_CALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatically Calculate VAT
N=No
Y=Yes
|
| 30 |
VAT_CALC_FRGHT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Freight
Y/N Table Edit
|
| 31 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 32 |
VAT_CALC_MISC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Miscellaneous
Y/N Table Edit
|
| 33 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
|
| 34 |
VAT_DCLRTN_DT |
Date(10) |
DATE |
"Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". "
|
| 35 |
VAT_DCLRTN_DT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration Date Source
A=Delivery Date - Ext Process
D=Delivery Date - Txn Entry
I=Invoice Date
M=Manual Entry
N=Not Applicable
|
| 36 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 37 |
VAT_DCLRTN_PT_GDS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 38 |
VAT_DCLRTN_PT_SVC |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 39 |
VAT_DEFAULT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
VAT Default Type
|
| 40 |
VAT_DEFAULT_TYPE_C |
Character(10) |
VARCHAR2(10) NOT NULL |
VAT Default Type - VAT Code
|
| 41 |
VAT_DEFAULT_TYPE_R |
Character(10) |
VARCHAR2(10) NOT NULL |
VAT Default Type-CustVATCode
|
| 42 |
VAT_DEFAULT_TYPE_T |
Character(10) |
VARCHAR2(10) NOT NULL |
VAT Default Type - Txn Type
|
| 43 |
VAT_DFLT_DONE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting
X=Do not default
Y=Defaulting Done
|
| 44 |
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
|
| 45 |
VAT_EXCPTN_CERTIF |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies the VAT exception certificate number. This identifier serves as proof of customer's exemption from VAT.
|
| 46 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
|
| 47 |
VAT_NON_SUSP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Not subject to Suspension
Y/N Table Edit
|
| 48 |
VAT_NRCVR_ALL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Non-Recoverable VAT
Y/N Table Edit
|
| 49 |
VAT_NRCVR_CHRG_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
ProrateVAT Non-Recovery
Prompt Table:
BU_NRV_LC_CMPVW
|
| 50 |
VAT_OVR_RCVRY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Override Recry/Rebate %
B=Override Rebate % Only
N=Do Not Allow Override
R=Override Both Recvry/Rebate %
V=Override Recovery % Only
|
| 51 |
VAT_RCRD_FRGN_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Record Foreign VAT
Y/N Table Edit
|
| 52 |
VAT_RCRD_INPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a business unit will pay the VAT and recover it later from the VAT tax authority. VAT input is usually associated with purchase transactions.
Y/N Table Edit
|
| 53 |
VAT_RCRD_OUTPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) VAT will be collected by the vendor on behalf of the government. VAT output is usually associated with sales transactions.
Y/N Table Edit
|
| 54 |
VAT_RCVRY_PCT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Recovery Percent Source
A=Automatically calculated
M=Manual Entry
|
| 55 |
VAT_RCVRY_RT_ITM |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Item VAT Recovery Rate
|
| 56 |
VAT_REBATE_PCT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Rebate Percent Source
A=Automatically calculated
M=Manual Entry
|
| 57 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
Y/N Table Edit
|
| 58 |
VAT_RGSTRN_BUYER |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies a customers VAT Registration ID for a particular country.
|
| 59 |
VAT_RGSTRN_SELLER |
Character(20) |
VARCHAR2(20) NOT NULL |
Seller's VAT Registration
|
| 60 |
VAT_RGSTRN_TPRTNR |
Character(20) |
VARCHAR2(20) NOT NULL |
Trading Partner's VAT Registration ID
**** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
|
| 61 |
VAT_ROUND_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding for VAT Transactions
D=Default from Higher Level
S=Specify at This Level
|
| 62 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 63 |
VAT_RPT_CNTRY_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reporting Country Source
1=Ship From
2=Ship To
3=VAT Entity
4=Service Performed Country
5=Supplier Location Country
6=Buyer Location Country
7=Buyer VAT Registration Country
|
| 64 |
VAT_RPTG_CURR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amounts in Reporting Currency
Y/N Table Edit
|
| 65 |
VAT_SERVICE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
|
| 66 |
VAT_SUSPENSION_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use VAT Suspension
Y/N Table Edit
|
| 67 |
VAT_SVC_PERFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
|
| 68 |
VAT_SVC_SUPPLY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries
2=Buyer's Countries
3=Where Physically Performed
|
| 69 |
VAT_TOL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the allowable amount difference between the entered VAT amount and the calculated VAT amount. If the VAT amount is outside the specified tolerance, the journal line will not post.
|
| 70 |
VAT_TOL_CUR_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the currency code for a specified VAT tolerance amount (VAT_TOL_AMT).
Prompt Table:
CURRENCY_CD_TBL
|
| 71 |
VAT_TOL_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Override VAT Tolerance Check
Y/N Table Edit
|
| 72 |
VAT_TOL_PCT |
Signed Number(9,2) |
DECIMAL(7,2) NOT NULL |
Specifies the allowable percentage difference between an entered VAT amount and the calculated VAT amount. If the VAT amount is outside the specified tolerance, the journal line will not post.
|
| 73 |
VAT_TREATMENT |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment
Prompt Table:
VAT_TREAT_VW
|
| 74 |
VAT_TREATMENT_EXP |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Treatment for Expenses
DOM=Domestic VAT
FOR=Foreign VAT
NON=No VAT
|
| 75 |
VAT_TREATMENT_PUR |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Treatment Pur
DOM=Domestic VAT
EUA=Intra-EU Acquisition
IMP=Import
OOS=Outside the Scope of VAT
|
| 76 |
VAT_TREATMENT_SAL |
Character(3) |
VARCHAR2(3) NOT NULL |
Describes the VAT Treatment that will be applied to this sales event. VAT treatment determines the accounting and processing that will be performed by the system. VAT treatments correspond to real world events. For example: domestic sale Distance EC Sale Export Sale.
DDS=Domestic VAT - Distance Sale
DOM=Domestic VAT
EUS=Intra-EU Sale
EUT=Intra-EU Sale Simplification
EXP=Export
OOS=Outside the Scope of VAT
|
| 77 |
VAT_TREATMENT_TR |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Treatment for Treasury
DOM=Domestic
FSR=Foreign Service
OOS=Outside of Scope
|
| 78 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
Prompt Table:
VAT_TREAT_GR_VW
|
| 79 |
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
|
| 80 |
VAT_USE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Use Type
Prompt Table:
VAT_USE_TBL
|
| 81 |
VAT_RECEIPT |
Character(1) |
VARCHAR2(1) NOT NULL |
No VAT Receipt
Y/N Table Edit
|
| 82 |
VAT_NRCVR_PRO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prorate Non-Recoverable VAT
Y/N Table Edit
|
| 83 |
VAT_RPTCUR_AMT_LNK |
Character(1) |
VARCHAR2(1) NOT NULL |
Amounts in Reporting Currency
|
| 84 |
VAT_RECLAIM_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Reclaim Percent
|
| 85 |
VAT_RPTCUR_AMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amounts in Reporting Currency
Y/N Table Edit
|
| 86 |
VAT_CUR_RPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Amounts in Reporting Currency
Y/N Table Edit
|
| 87 |
VAT_RVRSE_CHG_GDS |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
Y/N Table Edit
|
| 88 |
VAT_SUBJ_RVRSE_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Domestic Reverse Charge
N=No
Y=Yes
|
| 89 |
TAX_CD_VAT_RVC |
Character(8) |
VARCHAR2(8) NOT NULL |
Reverse Charge VAT Code
Prompt Table:
VAT_HEADER_VW
|
| 90 |
TEST_ATTRIBUTE |
Character(18) |
VARCHAR2(18) NOT NULL |
Represents the treasury deal transaction attribute that is subject to a predefined accounting template
|
| 91 |
PRODUCT_INST |
Character(3) |
VARCHAR2(3) NOT NULL |
Product
AM=Asset Management
AP=Accounts Payable
AR=Accounts Receivable
BI=Billing
EX=Expenses
GL=General Ledger
OM=Order Management
PO=Purchase Order
RE=Real Estate Management
SP=Service Procurement
TR=Treasury
|
| 92 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 93 |
COUNTRY_LOC_BUYER |
Character(3) |
VARCHAR2(3) NOT NULL |
Buyer's Location Country - May be either the VAT Entity or the Trading Partner
Prompt Table:
COUNTRY_TBL
|
| 94 |
COUNTRY_LOC_SELLER |
Character(3) |
VARCHAR2(3) NOT NULL |
Seller's Location Country - May be either the VAT Entity or the Trading Partner
Prompt Table:
COUNTRY_TBL
|
| 95 |
COUNTRY_LOC_TPRTNR |
Character(3) |
VARCHAR2(3) NOT NULL |
Trading Partner Location Country
**** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
Prompt Table:
COUNTRY_TBL
|
| 96 |
COUNTRY_LOC_VATENT |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Entity Location Country - May be either the buyer or the seller
Prompt Table:
COUNTRY_TBL
|
| 97 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 98 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
Prompt Table:
COUNTRY_TBL
|
| 99 |
COUNTRY_SHIP_VATEN |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 100 |
COUNTRY_VAT_PERFRM |
Character(3) |
VARCHAR2(3) NOT NULL |
Country Where Service Physically Performed
Prompt Table:
COUNTRY_TBL
|
| 101 |
COUNTRY_VAT_SHIPTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Ship To VAT Rgstrn Country
Prompt Table:
COUNTRY_VAT_TBL
|
| 102 |
DROP_SHIP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Drop Ship
N=No
Y=Yes
|
| 103 |
PHYSICAL_NATURE |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods
S=Services
|
| 104 |
PHYSICAL_NATURE_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Physical Nature
Y/N Table Edit
|
| 105 |
SHIPTO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Ship To Location
|
| 106 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 107 |
STATE_LOC_BUYER |
Character(6) |
VARCHAR2(6) NOT NULL |
Buyer's Location State - May be either the VAT Entity or the Trading Partner
|
| 108 |
STATE_LOC_SELLER |
Character(6) |
VARCHAR2(6) NOT NULL |
Seller's Location State - May be either the VAT Entity or the Trading Partner
|
| 109 |
STATE_LOC_TPRTNR |
Character(6) |
VARCHAR2(6) NOT NULL |
Trading Partner Location State
**** WARNING **** - This field has label ids of CUSTOMER, VENDOR, BANK. Do NOT delete these label ids. They are used to ensure the correct label is displayed on the common VAT subpages.
Prompt Table:
VAT_STAT_TPR_VW
|
| 110 |
STATE_LOC_VATENT |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Entity Location State - May be either the buyer or the seller
Prompt Table:
VAT_STAT_LOC_VW
|
| 111 |
STATE_SHIP_FROM |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship From State
Prompt Table:
%EDT_VAT_2
|
| 112 |
STATE_SHIP_TO |
Character(6) |
VARCHAR2(6) NOT NULL |
Ship To State
Prompt Table:
%EDT_VAT_1
|
| 113 |
STATE_VAT_PERFRM |
Character(6) |
VARCHAR2(6) NOT NULL |
State Where Service Physically Performed
Prompt Table:
%EDT_VAT_3
|
| 114 |
TRANSACTION_DT |
Date(10) |
DATE |
Transaction date (often used as trade date)
|
| 115 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 116 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 117 |
BANK_COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Bank Country
|
| 118 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 119 |
VAT_DFLT_EFFDT |
Date(10) |
DATE |
VAT Default Effective Date
|
| 120 |
DUE_DT |
Date(10) |
DATE |
Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
|
| 121 |
VAT_ACCOUNT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the relationship of a general ledger account to VAT processing. An account can be non-VAT, VAT or VAT Applicable.
A=VAT Applicable Account
N=Non-VAT Related
V=VAT Account
|
| 122 |
VAT_TOL_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the type of currency exchange rate used to convert the VAT Tolerance amount from its entry currency to the base currency of the business unit.
|
| 123 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 124 |
RECEIPT_DT |
Date(10) |
DATE |
Received Date
|
| 125 |
SHIP_DATE |
Date(10) |
DATE |
Item Shipping Date
|
| 126 |
AM_CREATE_BILL |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Bill
|
| 127 |
DRAFT_SUB_EVENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Defines specific types of activity that can be performed at the Draft Business Event. For example in the process of approving a Draft you can specify that you are paying an item putting an amount on acccount etc.
|
| 128 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 129 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 130 |
ACCOUNT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Account SETID
|
| 131 |
ACCTG_TMPL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
|
| 132 |
ACCTG_TMPL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Accounting Template SetID
|
| 133 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 134 |
ASSET_CLASS |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Class
|
| 135 |
ASSET_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset SetID
|
| 136 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 137 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 138 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
|
| 139 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
|
| 140 |
BILLSRC_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Bill Source SetID
|
| 141 |
BRANCH_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Branch Name
|
| 142 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 143 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 144 |
CATEGORY_CD |
Character(18) |
VARCHAR2(18) NOT NULL |
Category Code
|
| 145 |
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.
Prompt Table:
CUST_ALL_VW
|
| 146 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 147 |
EXPENSE_TYPE |
Character(7) |
VARCHAR2(7) NOT NULL |
Expense Type
|
| 148 |
EXPENSE_TYPE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Expense Type SetID
|
| 149 |
FEE_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that describes a grouping of fee types.
|
| 150 |
GRP_AP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Group ID
|
| 151 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
|
| 152 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
|
| 153 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
|
| 154 |
SOURCE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Source SETID
|
| 155 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
|
| 156 |
ORIGIN_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 157 |
PROD_GRP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group SetID
Prompt Table:
SP_SETID_NONVW
|
| 158 |
PRCS_OPTION_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Processing Option ID
|
| 159 |
PROD_GRP_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Product Group Type
ACCT=Accounting
BO=Backorder/Reservations
CA=Contract
CLMB=Claimback Contract
CTLG=Product Catalogs
FCST=Forecast
FRT=Freight
PRC=Pricing
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources of Supply
TAX=Tax
TRPT=Transportations
VAT=VAT
WEB=WEB Order Entry
|
| 160 |
PROD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product SetID
|
| 161 |
PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
Prompt Table:
PROD_GRP_VAT_VW
|
| 162 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
|
| 163 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 164 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 165 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 166 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 167 |
IDENTIFIER_TBL |
Character(3) |
VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
|
| 168 |
IDENTIFIER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifier SetID
|
| 169 |
IDENTIFIER |
Character(18) |
VARCHAR2(18) NOT NULL |
Identifier
|
| 170 |
VAT_PRODUCT_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Product Group
|
| 171 |
CC_VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Supplier SetID
|
| 172 |
CREDIT_CARD_VENDOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Corporate Card Vendor
|
| 173 |
IDENTIFIER_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifier
Prompt Table:
PROD_GRP_VAT_VW
|
| 174 |
IDEN_GRP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group SetID
Prompt Table:
SP_SETID_NONVW
|
| 175 |
TXN_ROUTE_CD |
Character(20) |
VARCHAR2(20) NOT NULL |
This field holds the Transaction routing Codes used to configure the Billing, SUT and Withholding defaults.
|
| 176 |
TXNRCD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Routing Code Setid
|
| 177 |
VAT_CALC_PB |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Amounts Push Button
|
| 178 |
TAX_CD_VAT_RVC_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Customer VAT Rate
|
| 179 |
VAT_AMT_RVC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Reverse Charge VAT Amount
|
| 180 |
VAT_AMT_RVC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reverse Charge Amount in Base Currency
|
| 181 |
VAT_INV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amount
|
| 182 |
VAT_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Invoice Amt Base Curr
|
| 183 |
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
|
| 184 |
VAT_TRANS_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered Amount
|
| 185 |
VAT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
|
| 186 |
VAT_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. It is expressed in the base currency of the General Ledger business unit associated with the transaction. Refer to the definition for VAT_AMT.
|
| 187 |
VAT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amount in Base Curr
|
| 188 |
VAT_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered Amount
|
| 189 |
VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount
|
| 190 |
VAT_ENTRD_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered VAT Amount Base Cur
|
| 191 |
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.
|
| 192 |
VAT_BASIS_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Basis Amt in Base Curr
|
| 193 |
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.
|
| 194 |
VAT_BASIS_AMT_ENT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Entered Amount
|
| 195 |
VAT_CALC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount
|
| 196 |
VAT_CALC_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Calculated Amount Base Cur
|
| 197 |
VAT_NRCVR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Non Recoverable
|
| 198 |
VAT_NRCVR_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT NonRecoverable Amount
|
| 199 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 200 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 201 |
VAT_REBATE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt
|
| 202 |
VAT_REBATE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Rebate Amt in Base Curr
|
| 203 |
VAT_RECOVERY_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Recovery Percent
|
| 204 |
VAT_REBATE_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
VAT Rebate Percent
|
| 205 |
VAT_RCLM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Reclaim Amount
|
| 206 |
VAT_RCLM_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Base VAT Reclaim Amount
|
| 207 |
TAX_CD_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates at what level PeopleSoft General Ledger determines the VAT Tax Code. The VAT Tax Code (TAX_CD_VAT) can be specified at the Journal Source, Account, or Business Unit level.
D=Default from Higher Level
S=Specify at this Level
|
| 208 |
TAX_CD_VAT_FLGD |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates at what level PeopleSoft General Ledger determines the VAT Tax Code. The VAT Tax Code (TAX_CD_VAT) can be specified at the Journal Source, Account, or Business Unit level.
|
| 209 |
TAX_CD_VAT_PCT |
Signed Number(9,4) |
DECIMAL(7,4) NOT NULL |
Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage.
|
| 210 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 211 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 212 |
VAT_INV_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Amt in Reporting Currency
|
| 213 |
VAT_TRANS_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Transaction Amt Reporting
|
| 214 |
VAT_LN_ENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Line Entered Amount
|
| 215 |
VAT_LN_ENT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Line Entered Amt Base Curr
|
| 216 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 217 |
HDR_COUNTRY_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Purely used to give the VAT Defaulting Edits contexts a way to reference fields in the parent records for validation purposes. This field will not be added to any record.
Specifies the country where an invoice is generated (for VAT processing only).
|
| 218 |
HDR_COUNTRY_BILLTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Purely used to give the VAT Defaulting Edits contexts a way to reference fields in the parent records for validation purposes. This field will not be added to any record.
Specifies the country where an invoice is sent (for VAT processing only).
|
| 219 |
HDR_COUNTRY_SHIPTO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
|
| 220 |
HDR_VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Header VAT Calculation Type
|
| 221 |
HDR_VAT_ENTRD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Header Entered VAT Amount
|
| 222 |
HDR_VAT_TREAT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 223 |
RATE_DIV_VAT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as direct
|
| 224 |
RATE_MULT_VAT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either as di
|
| 225 |
RETURN_CODE |
Signed Number(5,0) |
DECIMAL(4) NOT NULL |
Return Code
|
| 226 |
RULE_SRCH_1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Rule Keyword 1
|
| 227 |
RULE_SRCH_2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Rule Keyword 2
|
| 228 |
RULE_SRCH_3 |
Character(18) |
VARCHAR2(18) NOT NULL |
Rule Keyword 3
|
| 229 |
STORED_AS_NAME_01 |
Character(18) |
VARCHAR2(18) NOT NULL |
This field holds the field name for storing the content of the field name in the Key_Field_Name_01 field.
|
| 230 |
STORED_AS_NAME_02 |
Character(18) |
VARCHAR2(18) NOT NULL |
This field holds the field name for storing the content of the field name in the Key_Field_Name_02 field.
|
| 231 |
STORED_AS_NAME_03 |
Character(18) |
VARCHAR2(18) NOT NULL |
This field holds the field name for storing the content of the field name in the Key_Field_Name_03 field.
|
| 232 |
VAT_CF_ANLSYS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Chartfield Analysis
E=Use Expense Line Chartfields
N=Not Applicable
V=Use VAT Accounting Chartfields
|
| 233 |
VOUCHER_STYLE |
Character(4) |
VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher
TMPL=Template Voucher
|
| 234 |
ERROR_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field with an error.
|
| 235 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 236 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|