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 |