IST_LOAD_AET(SQL Table) |
Index Back |
|---|---|
IST Txn Loader Run Control AE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 5 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 6 | 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. |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 9 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 10 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
| 11 | IST_FLOW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Flow Type
%=Both A=Arrivals D=Dispatches |
| 12 | RPT_TXN_THRU_DT | Date(10) | DATE | Select Transactions Thru |
| 13 | FREIGHT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 14 | INVITEM_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 15 | SHIPTYPE_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 16 | CUST_SETID | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 17 | LOCATION_SETID | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 18 | NATURE_TXN2_USE | Character(2) | VARCHAR2(2) NOT NULL |
Nature of transaction secon ddigit use
EU=European Union GB=United Kingdom Prompt Table: NATURE_TXN2_USE |
| 19 | NOTC1_DF_SP | Character(1) | VARCHAR2(1) NOT NULL | Sale/Purchase Default |
| 20 | NOTC1_DF_RR | Character(1) | VARCHAR2(1) NOT NULL | Returns/Replacements Default |
| 21 | NOTC2_DF_OSP | Character(1) | VARCHAR2(1) NOT NULL | Sale/Purchase Default |
| 22 | NOTC2_DF_RTN | Character(1) | VARCHAR2(1) NOT NULL | Returns Default |
| 23 | NOTC2_DF_RRT | Character(1) | VARCHAR2(1) NOT NULL | Replace of Return Good Default |
| 24 | NOTC2_DF_RNT | Character(1) | VARCHAR2(1) NOT NULL | Replace Goods not Return Dflt |
| 25 | SPROC_DF_ARR | Character(6) | VARCHAR2(6) NOT NULL | Normal EU Arrival Default |
| 26 | SPROC_DF_SHP | Character(6) | VARCHAR2(6) NOT NULL | Normal EU Shipment Default |
| 27 | SPROC_DF_OAR | Character(6) | VARCHAR2(6) NOT NULL | Other Arrivals Default |
| 28 | SPROC_DF_OSH | Character(6) | VARCHAR2(6) NOT NULL | Other Shipments Default |
| 29 | SPROC_DF_FAD | Character(6) | VARCHAR2(6) NOT NULL | Fin Adj Decrease Default |
| 30 | SPROC_DF_FAI | Character(6) | VARCHAR2(6) NOT NULL | Fin Adj Increase Default |
| 31 | SPROC_DF_TSH | Character(6) | VARCHAR2(6) NOT NULL | Transfer Shipment Default |
| 32 | SPROC_DF_TAR | Character(6) | VARCHAR2(6) NOT NULL | Transfer Arrivals Default |
| 33 | SPROC_DF_TSI | Character(6) | VARCHAR2(6) NOT NULL | Default Statistical Procedure for IntraCompany Transfer Shipments |
| 34 | FRGM_DF_ARR | Character(2) | VARCHAR2(2) NOT NULL | Normal EU Arrival Default |
| 35 | FRGM_DF_SHP | Character(2) | VARCHAR2(2) NOT NULL | Normal EU Shipment Default |
| 36 | FRGM_DF_OAR | Character(2) | VARCHAR2(2) NOT NULL | Other Arrivals Default |
| 37 | FRGM_DF_OSH | Character(2) | VARCHAR2(2) NOT NULL | Other Shipments Default |
| 38 | FRGM_DF_FAD | Character(2) | VARCHAR2(2) NOT NULL | Fin Adj Decrease Default |
| 39 | FRGM_DF_FAI | Character(2) | VARCHAR2(2) NOT NULL | Fin Adj Increase Default |
| 40 | FRGM_DF_TSH | Character(2) | VARCHAR2(2) NOT NULL | Transfer Shipment Default |
| 41 | FRGM_DF_TAR | Character(2) | VARCHAR2(2) NOT NULL | Transfer Arrivals Default |
| 42 | FRGM_DF_TSI | Character(2) | VARCHAR2(2) NOT NULL | Default Fiscal Regime for IntraCompany Transfer Shipments |
| 43 | LAST_IST_DCMNT_ID | Number(8,0) | INTEGER NOT NULL | Last Intrastat Doc ID Assigned |
| 44 | IST_DCMNT_CNT | Number(8,0) | INTEGER NOT NULL | Intrastat Document Count |
| 45 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 46 | IST_LINE_CNT | Number(5,0) | INTEGER NOT NULL | Intrastat Line Count |
| 47 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 48 | SYSTEM_DATE | Date(10) | DATE | System Date |
| 49 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 50 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 51 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 52 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 53 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 54 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 55 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 56 | 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". |
| 57 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 58 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 59 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 60 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 61 | 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 |
| 62 | CF_BAL_LINE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Chart Field Balancing Line Num |
| 63 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 64 | 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. |
| 65 | UOM_IST | Character(3) | VARCHAR2(3) NOT NULL | Intrastat Unit Of Measure |
| 66 | UOM_BILL | Character(3) | VARCHAR2(3) NOT NULL | Bill Unit of Measure |
| 67 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 68 | DEMAND_SOURCE | Character(2) | VARCHAR2(2) NOT NULL |
Demand Source
IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order |
| 69 | 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 |
| 70 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 71 | SCHED_LINE_NO | Number(7,2) | DECIMAL(6,2) NOT NULL | Sched Line NO |
| 72 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 73 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |
| 74 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 75 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 76 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 77 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 78 | RTV_ID | Character(10) | VARCHAR2(10) NOT NULL | Return To Vendor ID |
| 79 | RTV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Return To Vendor Line |
| 80 | RTV_DISTRIB_NUM | Number(5,0) | INTEGER NOT NULL | RTV Distribution Number |
| 81 | SHIPPED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Shipped
B=Both N=No Y=Yes |
| 82 | IST_REGION_ORIGIN | Character(4) | VARCHAR2(4) NOT NULL | Intrastat Region of Origin |
| 83 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 84 | INVOICE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 85 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 86 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 87 | STATE_OTHER | Character(6) | VARCHAR2(6) NOT NULL | State Other |
| 88 | 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. |
| 89 | 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. |
| 90 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 91 | REPLACEMENT_FLG | Character(2) | VARCHAR2(2) NOT NULL |
Replacement Flag
NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods |
| 92 | IST_AMOUNT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Amount Source
I=Invoice M=Manual Entry O=Order |
| 93 | RETURN_SETID | Character(5) | VARCHAR2(5) NOT NULL | RTV (Supplier) SetID |
| 94 | RETURN_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Return to Vendor |
| 95 | IST_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Processing Status |
| 96 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 97 | PORT_AIRPORT | Character(4) | VARCHAR2(4) NOT NULL | Port or Airport |
| 98 | IST_CONCAT_CHAR | Character(6) | VARCHAR2(6) NOT NULL | Concatenation Characters |
| 99 | UOM_RECV | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure |
| 100 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 101 | IST_REGION | Character(4) | VARCHAR2(4) NOT NULL | Region of Origin/Destination |
| 102 | IST_FLOW | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Report Flow
A=Arrivals D=Dispatches |
| 103 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |