SII_INV_HDR_TBL

(SQL Table)
Index Back

# 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.
3 VAT_TXN_SOURCE Character(6) VARCHAR2(6) NOT NULL VAT Transaction Source
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 SII_INVOICE_ID Character(60) VARCHAR2(60) NOT NULL SII_INVOICE_ID
6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
7 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.
8 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.
9 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
10 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.
11 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
12 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
13 INVOICE_DT Date(10) DATE Invoice Date
14 RPT_YEAR Character(4) VARCHAR2(4) NOT NULL Reporting Year
15 RPT_PERIOD Character(2) VARCHAR2(2) NOT NULL Reporting Period
16 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
17 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
18 SII_INVOICE_ID_ORG Character(60) VARCHAR2(60) NOT NULL Invoice ID
19 SII_INVOICE_DT_ORG Date(10) DATE Invoice Date
20 VAT_TREATMENT_GRP Character(4) VARCHAR2(4) NOT NULL VAT Treatment Group
21 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
22 SII_TRANS_REGIME Character(2) VARCHAR2(2) NOT NULL Transaction Regime
23 INVOICE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
24 INVOICE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
25 INVOICE_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
26 SII_PURPOSE_SETID Character(5) VARCHAR2(5) NOT NULL Set ID
27 SII_PURPOSE_CD Character(5) VARCHAR2(5) NOT NULL Purpose Code
28 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
29 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
30 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
31 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
32 SII_EXEMPT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
33 SII_EXEMPT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
34 SII_EXEMPT_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
35 SII_TYPE_NON_EXP Character(2) VARCHAR2(2) NOT NULL Transaction Type NON Exempt
36 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
37 COUNTRY_SHIP_FROM Character(3) VARCHAR2(3) NOT NULL Specifies the country from which the invoice contents were shipped (for VAT processing only).
38 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
39 DESCR Character(30) VARCHAR2(30) NOT NULL Description
40 TOT_VAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount
41 TOT_VAT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount
42 TOT_VAT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Total VAT Amount
43 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
44 SII_AMT_NALOC Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
45 SII_AMT_NALOC_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
46 SII_AMT_NALOC_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
47 SII_AMT_NAART Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
48 SII_AMT_NAART_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
49 SII_AMT_NAART_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Invoice Amount
50 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
51 SII_VAT_RC_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
52 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
53 CUR_RT_SOURCE Character(1) VARCHAR2(1) NOT NULL Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
54 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.
55 SII_ACTION_TYPE Character(2) VARCHAR2(2) NOT NULL Action Type
A0=Addition
A1=Modification
56 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. "
57 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
58 SII_RATE_DIV_XEU Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
59 SII_RATE_MULT_XEU Number(16,8) DECIMAL(15,8) NOT NULL Rate Multiplier
60 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
61 ERROR_CODE Character(10) VARCHAR2(10) NOT NULL Error Code
62 LAST_UPDATE_DT Date(10) DATE Last Updated
63 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
64 SII_MACRODATO_FLAG Character(1) VARCHAR2(1) NOT NULL MACRODATO FLAG

Y/N Table Edit

Default Value: N

65 SII_FACTURASIM_FLG Character(1) VARCHAR2(1) NOT NULL FacturaSimp Flag

Y/N Table Edit

Default Value: N

66 SII_REGPREVIO_FLAG Character(1) VARCHAR2(1) NOT NULL RegPrevio Flag

Y/N Table Edit

Default Value: N

67 SII_FACDIS_FLG Character(1) VARCHAR2(1) NOT NULL FacturacionDisp

Y/N Table Edit

Default Value: N