| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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.
|
| 2 |
VAT_TXN_SOURCE |
Character(6) |
VARCHAR2(6) NOT NULL |
VAT Transaction Source
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
SII_INVOICE_ID |
Character(60) |
VARCHAR2(60) NOT NULL |
SII_INVOICE_ID
|
| 5 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 6 |
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.
|
| 7 |
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.
|
| 8 |
ITEM_LINE |
Number(6,0) |
INTEGER NOT NULL |
Item Line
|
| 9 |
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.
|
| 10 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 11 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
|
| 12 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 13 |
RPT_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Reporting Year
|
| 14 |
RPT_PERIOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reporting Period
|
| 15 |
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
|
| 16 |
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
|
| 17 |
SII_INVOICE_ID_ORG |
Character(60) |
VARCHAR2(60) NOT NULL |
Invoice ID
|
| 18 |
SII_INVOICE_DT_ORG |
Date(10) |
DATE |
Invoice Date
|
| 19 |
VAT_TREATMENT_GRP |
Character(4) |
VARCHAR2(4) NOT NULL |
VAT Treatment Group
|
| 20 |
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
|
| 21 |
SII_TRANS_REGIME |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Regime
|
| 22 |
INVOICE_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 23 |
INVOICE_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 24 |
INVOICE_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 25 |
SII_PURPOSE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Set ID
|
| 26 |
SII_PURPOSE_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Purpose Code
|
| 27 |
CUST_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 28 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 29 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 30 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 31 |
SII_EXEMPT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 32 |
SII_EXEMPT_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 33 |
SII_EXEMPT_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 34 |
SII_TYPE_NON_EXP |
Character(2) |
VARCHAR2(2) NOT NULL |
Transaction Type NON Exempt
|
| 35 |
SII_INTRA_COMM_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Intra-Comm Trans Type
A=A(Transactions in Article 70)
B=B(Transactions in Article 9)
N=Not Applicable
|
| 36 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 37 |
COUNTRY_2CHAR |
Character(2) |
VARCHAR2(2) NOT NULL |
2-Char Country Code
|
| 38 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 39 |
TOT_VAT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 40 |
TOT_VAT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 41 |
TOT_VAT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total VAT Amount
|
| 42 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 43 |
SII_AMT_NALOC |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 44 |
SII_AMT_NALOC_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 45 |
SII_AMT_NALOC_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 46 |
SII_AMT_NAART |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 47 |
SII_AMT_NAART_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 48 |
SII_AMT_NAART_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount
|
| 49 |
VAT_RCVRY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 50 |
SII_VAT_RC_AMT_XEU |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt
|
| 51 |
VAT_RCVRY_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
VAT Recovery Amt in Base Curr
|
| 52 |
CUR_RT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
|
| 53 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 54 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 55 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 56 |
SII_RATE_DIV_XEU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 57 |
SII_RATE_MULT_XEU |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 58 |
SII_INVOICE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
VAT Submission Status
A=Accepted
AE=Accepted with Error
E=Error
G=Generated
M=Manual
R=Ready
RV=Reversed
RX=Rejected
S=Submitted
|
| 59 |
ERROR_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
Error Code
|
| 60 |
LAST_UPDATE_DT |
Date(10) |
DATE |
Last Updated
|
| 61 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|