IST_ARR6_TAO(SQL Table) |
Index Back |
|---|---|
Intrastat Arrivals 6 Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | UNPOST_SEQ |
Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
| 4 | APPL_JRNL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 5 | PYMNT_CNT |
Number(5,0) | INTEGER NOT NULL | Payments |
| 6 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 7 | DISTRIB_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 8 | DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 9 | CF_BAL_LINE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Chart Field Balancing Line Num |
| 10 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 11 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 12 | COUNTRY_IST_RPTG | Character(3) | VARCHAR2(3) NOT NULL | IST Reporting Country |
| 13 | IST_TXN_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
Intrastat Transaction Source
BILL=Billing Adjustment IREC=RMA Receipt IURC=Interunit Receipt IUSH=Interunit Shipment MANU=Manual Entry RECV=Purchase Receipt RTVR=Receipt Returns RTVS=Shipment Return SHIP=Shipment VCHR=Voucher Adjustment |
| 14 | COUNTRY_VAT_BILLTO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). |
| 15 | 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. |
| 16 | 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. |
| 17 | IST_TXN_DT | Date(10) | DATE | Intrastat Transaction Date |
| 18 | IST_MEMBER_STATE | Character(3) | VARCHAR2(3) NOT NULL | Country of Cons/Dest |
| 19 | NATURE_OF_TXN1 | Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 1 |
| 20 | NATURE_OF_TXN2 | Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 2 |
| 21 | STAT_PROCEDURE | Character(6) | VARCHAR2(6) NOT NULL |
Statistical Procedure
Prompt Table: IST_STATPROC_VW |
| 22 | FISCAL_REGIME | Character(6) | VARCHAR2(6) NOT NULL |
Fiscal Regime
Prompt Table: IST_FSCRGM_VW |
| 23 | IST_INV_AMT_TXN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount - Transaction |
| 24 | IST_INV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount - Base Currency |
| 25 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 26 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 27 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 28 | 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. " |
| 29 | IST_AMOUNT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Amount Source
I=Invoice M=Manual Entry O=Order |