| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
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.
Prompt Table:
VAT_ENTITY
|
| 3 |
COUNTRY_VAT_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Reporting Country
|
| 4 |
INVOICE |
Character(22) |
VARCHAR2(22) NOT NULL |
Invoice
|
| 5 |
LINE_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Sequence
|
| 6 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
Prompt Table:
CUST_BI_A2_VW
|
| 7 |
BI_PROGRESSIVE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Progressive ID
|
| 8 |
VAT_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
VAT Registration ID
|
| 9 |
COUNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
2-Char Country Code
|
| 10 |
ENTITY_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Entity Name
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 12 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 13 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 14 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 15 |
BI_CNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
2-Char Country Code
|
| 16 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 17 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 18 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 19 |
INVOICE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
Default Value: REG
|
| 20 |
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.
|
| 21 |
BILL_TYPE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table:
BI_TYPE
|
| 22 |
BILL_SOURCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table:
BI_SRC
|
| 23 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 24 |
QTY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Quantity
|
| 25 |
UNIT_AMT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Unit Price
|
| 26 |
BI_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD
|
| 27 |
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.
|
| 28 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 29 |
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.
|
| 30 |
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
|
| 31 |
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.
|
| 32 |
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
|
| 33 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 34 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
|
| 35 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 36 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 37 |
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.
|
| 38 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
|
| 39 |
BI_CODIC_DESC |
Character(15) |
VARCHAR2(15) NOT NULL |
CodiceDestinatario
|
| 40 |
FISCAL_REGIME |
Character(6) |
VARCHAR2(6) NOT NULL |
Fiscal Regime
|
| 41 |
DESCRIPTION |
Character(35) |
VARCHAR2(35) NOT NULL |
DESCRIPTION
|
| 42 |
BI_REF_NUM |
Character(4) |
VARCHAR2(4) NOT NULL |
Reference Number
|
| 43 |
BI_NUM_ITEM |
Character(20) |
VARCHAR2(20) NOT NULL |
NumItem
|
| 44 |
BI_TIPO_DOC |
Character(4) |
VARCHAR2(4) NOT NULL |
TipoDocumento
|
| 45 |
BI_NUM_LINE |
Character(1) |
VARCHAR2(1) NOT NULL |
NumeroLinea
|
| 46 |
BI_TIPO_CESP |
Character(4) |
VARCHAR2(4) NOT NULL |
TipoCessionePrestazione
|
| 47 |
BI_NATURA |
Character(4) |
VARCHAR2(4) NOT NULL |
Natura
|
| 48 |
BI_MOD_PMT |
Character(4) |
VARCHAR2(4) NOT NULL |
Payment Mode
|
| 49 |
BI_RPT_INV_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Invoice Status
A=Accepted
DP=Deadline Passed
FD=Failed Delivery
G=Generated
R=Rejected
RC=Received
RF=Refused
T=Transmitted
U=Undeliverable
|
| 50 |
ENTRY_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
|
| 51 |
ENTRY_REASON |
Character(5) |
VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
|
| 52 |
BI_PREZ_TOTAL |
Signed Number(26,3) |
DECIMAL(24,3) NOT NULL |
Total Amount
|