| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 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.
Prompt Table:
VAT_ENTITY
|
| 2 |
COUNTRY_IST_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
IST Reporting Country
Prompt Table:
IST_COUNTRY_TBL
|
| 3 |
IST_DCMNT_ID |
Number(8,0) |
INTEGER NOT NULL |
Intrastat Document ID
Default Value: 0
|
| 4 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1
|
| 5 |
IST_FLOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Report Flow
A=Arrivals
D=Dispatches
|
| 6 |
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
Default Value: MANU
|
| 7 |
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.
Prompt Table:
%EDITTABLE
|
| 8 |
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.
|
| 9 |
IST_TXN_DT |
Date(10) |
DATE |
Intrastat Transaction Date
Default Value: %date
|
| 10 |
COMMODITY_CD_EU |
Character(10) |
VARCHAR2(10) NOT NULL |
EU Commodity Code
Prompt Table:
COMMOD_CODE_EU
|
| 11 |
ITM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Item SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 12 |
INV_ITEM_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Item ID
Prompt Table:
VAT_INV_ITEM_VW
|
| 13 |
IST_ERR_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Transaction in Error
Y/N Table Edit
|
| 14 |
IST_MEMBER_STATE |
Character(3) |
VARCHAR2(3) NOT NULL |
Country of Cons/Dest
Prompt Table:
EU_MEMBER_VW
|
| 15 |
IST_REGION |
Character(4) |
VARCHAR2(4) NOT NULL |
Region of Origin/Destination
Prompt Table:
STATE_TBL_IST_V
|
| 16 |
IST_DELIVERY_TRM1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Delivery Terms 1
CFR=Cost and Freight
CIF=Cost, Insurance, Freight
CIP=Carriage and Insurance Paid To
CPT=Carriage Paid To
DAF=Delivered at Frontier
DDP=Delivered Duty Paid
DDU=Delivered Duty Unpaid
DEQ=Delivered Ex-Quay
DES=Delivered Ex-Ship
EXW=Ex-Works
FAS=Free Alongside Ship
FCA=Franco Carrier
FOB=Free on Board
XXX=Other Delivery Terms
|
| 17 |
IST_DELIVERY_TRM2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 2
1=Place in Reporting Country
2=Place in Other EU Country
3=Place in Other Non-EU Country
|
| 18 |
NATURE_OF_TXN1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Transaction 1
Prompt Table:
NATURE_TXN1_VW
|
| 19 |
NATURE_OF_TXN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Nature of Transaction 2
Prompt Table:
NATURE_TXN2_VW
|
| 20 |
COUNTRY_IST_ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Country of Origin
Prompt Table:
COUNTRY_TBL
|
| 21 |
IST_TRANSPORT_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Mode of Transport for Intrastat Reporting
1=Transport by Sea
2=Transport by Rail
3=Transport by Road
4=Transport by Air
5=Consignments by Post
7=Fixed Transport Installations
8=Transport by Inland Waterway
9=Own Propulsion
|
| 22 |
PORT_AIRPORT |
Character(4) |
VARCHAR2(4) NOT NULL |
Port or Airport
Prompt Table:
PORT_AIRPRT_VW
|
| 23 |
STAT_PROCEDURE |
Character(6) |
VARCHAR2(6) NOT NULL |
Statistical Procedure
Prompt Table:
IST_STATPROC_VW
|
| 24 |
FISCAL_REGIME |
Character(6) |
VARCHAR2(6) NOT NULL |
Fiscal Regime
Prompt Table:
IST_FSCRGM_VW
|
| 25 |
QTY_IST_SUOM |
Number(16,4) |
DECIMAL(15,4) NOT NULL |
Intrastat Quantity
|
| 26 |
UOM_IST |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Unit Of Measure
Prompt Table:
UNITS_TBL
|
| 27 |
IST_WEIGHT |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Intrastat Weight
|
| 28 |
NET_MASS |
Number(6,0) |
INTEGER NOT NULL |
Net Mass in KG
|
| 29 |
SUPPLMNTRY_UNITS |
Number(6,0) |
INTEGER NOT NULL |
Supplementary Units
|
| 30 |
UOM_SUPPLMNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Supplementary Unit Of Measure
Prompt Table:
UNITS_TBL
|
| 31 |
IST_INV_AMT_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount - Reporting
|
| 32 |
IST_INV_AMT_TXN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount - Transaction
|
| 33 |
IST_INV_AMT_BSE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Invoice Amount - Base Currency
|
| 34 |
IST_STAT_VAL_RPTG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Statistical Value - Reporting
|
| 35 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 36 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 37 |
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.
|
| 38 |
CUST_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
|
| 39 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 40 |
IST_CRNCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Reporting Currency
|
| 41 |
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. "
Prompt Table:
CURRENCY_CD_TBL
|
| 42 |
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.
|
| 43 |
CUR_EFFDT |
Date(10) |
DATE |
Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
|
| 44 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
Default Value: 1
|
| 45 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1
|
| 46 |
EXCHNG_RT_SRC |
Character(3) |
VARCHAR2(3) NOT NULL |
Exchange Rate Source
BSE=Base Currency
TBL=Exchange Rate Table
TXN=Transaction Currency
|
| 47 |
IST_AMOUNT_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Amount Source
I=Invoice
M=Manual Entry
O=Order
Default Value: M
|
| 48 |
IN_PROCESS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
In process flag
Default Value: N
|
| 49 |
SYSTEM_DATE |
Date(10) |
DATE |
System Date
Default Value: %date
|
| 50 |
IST_INVAMT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Amount Calculated By
M=Manually
S=System
Default Value: S
|
| 51 |
IST_STATVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Stat Value Calculated By
M=Manually
S=System
Default Value: S
|
| 52 |
IST_SUNIT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Supp Unit Calculated By
M=Manually
S=System
Default Value: S
|
| 53 |
IST_NETMASS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Mass Calculated By
M=Manually
S=System
Default Value: S
|
| 54 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 55 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 56 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|