IST_DISP9_TAO(SQL Table) |
Index Back |
|---|---|
Intrastat Dispatch 9 Temp |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 4 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 5 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 6 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 7 | DEMAND_LINE_NO |
Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 8 | IST_INV_TXN_TMP | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | IST Txn Invoice Amt - Temp |
| 9 | IST_INV_BSE_TMP | Signed Number(30,5) | DECIMAL(28,5) NOT NULL | IST Bse Invoice Amt - Temp |
| 10 | IST_INV_AMT_TXN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount - Transaction |
| 11 | IST_INV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount - Base Currency |
| 12 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 13 | 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. " |
| 14 | 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. |
| 15 | 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. |
| 16 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 17 | IST_AMOUNT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Amount Source
I=Invoice M=Manual Entry O=Order |
| 18 | REPLACEMENT_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods |
| 19 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 20 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 21 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 22 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 23 | QTY_SHIP_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Ship Base |