| # |
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 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 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 |
COUNTRY_IST_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
IST Reporting Country
|
| 8 |
IST_FLOW_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Flow Type
%=Both
A=Arrivals
D=Dispatches
|
| 9 |
IST_REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Type
D=Supplementary Declaration
O=Other
|
| 10 |
RPT_DT |
Date(10) |
DATE |
Report Date
|
| 11 |
RPT_FROM_DATE |
Date(10) |
DATE |
Report From Date
|
| 12 |
RPT_THRU_DT |
Date(10) |
DATE |
Report Thru Date
|
| 13 |
RPT_TXN_FRM_DT |
Date(10) |
DATE |
Select Transactions From
|
| 14 |
RPT_TXN_THRU_DT |
Date(10) |
DATE |
Select Transactions Thru
|
| 15 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 16 |
IST_FLOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Report Flow
A=Arrivals
D=Dispatches
|
| 17 |
IST_VATREG_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Registration ID Required
Y/N Table Edit
Default Value: N
|
| 18 |
IST_VATREG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Registration Display
N=No Prefix
P=With Prefix
|
| 19 |
IST_VATREG_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Vat Registration Country Type
2=2 Char
3=3 Char
N=3 Numeric
|
| 20 |
IST_VATREG_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Registration ID Source
L=Local Tax ID
V=VAT Registration ID
|
| 21 |
IST_DESCR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Goods Description Required
Y/N Table Edit
Default Value: N
|
| 22 |
IST_CNTRY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Country Dest/Cons Required
Default Value: N
|
| 23 |
IST_CNTRY_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Country of Cons/Dest Type
2=2 Char
3=3 Char
N=3 Numeric
|
| 24 |
IST_REGION_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Region Requiredxxxxxxxxxxxxxxx
Y/N Table Edit
Default Value: N
|
| 25 |
IST_DLVYTRM1_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 1 Required
Y/N Table Edit
Default Value: N
|
| 26 |
IST_DLVYTRM2_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 2 Required
Y/N Table Edit
Default Value: N
|
| 27 |
IST_NOTC1_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
NOTC 1st Digit Required
Y/N Table Edit
Default Value: N
|
| 28 |
IST_NOTC2_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
NOTC 2nd Digit Required
Y/N Table Edit
Default Value: N
|
| 29 |
IST_TMODE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Mode Of Transport Required
Y/N Table Edit
Default Value: N
|
| 30 |
IST_PORT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Port/Airport Requiredxxxxxxxxx
Y/N Table Edit
Default Value: N
|
| 31 |
IST_COMMCODE_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
EU Commodity Code Required
Y/N Table Edit
Default Value: N
|
| 32 |
IST_ORIGIN_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Country of Origin Required
Y/N Table Edit
Default Value: N
|
| 33 |
IST_ORIGIN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Country of Origin Type
2=2 Character
3=3 Character
N=3 Numeric
|
| 34 |
IST_STATPROC_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical Procedure Required
Y/N Table Edit
Default Value: N
|
| 35 |
IST_FISCREG_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Fiscal Regime Required flag
Y/N Table Edit
Default Value: N
|
| 36 |
IST_NETMASS_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Mass Required
Y/N Table Edit
Default Value: N
|
| 37 |
IST_NETMASS_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Net Mass Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
|
| 38 |
IST_SUNIT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplementary Units Required
Y/N Table Edit
Default Value: N
|
| 39 |
IST_SUNIT_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Suppl Unit Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
|
| 40 |
IST_INVAMT_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Amount Required
Y/N Table Edit
Default Value: N
|
| 41 |
IST_INVAMT_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Invoice Amount Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
|
| 42 |
IST_STATVAL_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Statistical Value Required
Y/N Table Edit
Default Value: N
|
| 43 |
IST_STATVAL_ROUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Stat Value Rounding Method
N=Normal Rounding
T=Truncate Decimal Places
U=Round Up to Next Integer
|
| 44 |
IST_STATVAL_FACTOR |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Statistical Value Factor
Default Value: 1
|
| 45 |
IST_TPRTNR_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partner Reg Required
Y/N Table Edit
Default Value: N
|
| 46 |
IST_TPRTNR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partner Display
N=No Prefix
P=With Prefix
|
| 47 |
IST_TPRTNR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trading Partner Country Type
2=2 Char
3=3 Char
N=3 Numeric
|
| 48 |
IST_EXCPN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Exception Type
F=Fiscal Regime
N=Nature of Txn 2nd Digit
S=Statistical Procedure
|
| 49 |
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
|
| 50 |
IST_FINADJ_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Financial Adjustments
Y/N Table Edit
Default Value: N
|
| 51 |
IST_FINADJ_NOTC1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Financial Adjustment Notice
Y/N Table Edit
Default Value: N
|
| 52 |
IST_FINADJ_NOTC2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Intrastat Financial Adjustment Notice
Y/N Table Edit
Default Value: N
|
| 53 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 54 |
IST_CRNCY_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Reporting Currency
|
| 55 |
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. "
|
| 56 |
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.
|
| 57 |
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.
|
| 58 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 59 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 60 |
IST_CNT |
Number(6,0) |
INTEGER NOT NULL |
Intrastat Transaction Count
|
| 61 |
IST_ERR_CNT |
Number(8,0) |
INTEGER NOT NULL |
Intrastat Error Count
|
| 62 |
IST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Processing Status
|
| 63 |
IST_EXCPN_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Intrastat Exception Code
|
| 64 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 65 |
WHERE_CLAUSE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 66 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
|
| 67 |
FIELDNAME1 |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name 1
|
| 68 |
FIELDNAME2 |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname 2
|
| 69 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 70 |
UOM_IST |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Unit Of Measure
|
| 71 |
UOM_SUPPLMNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Supplementary Unit Of Measure
|
| 72 |
CONVERSION_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Conversion Rate
|
| 73 |
COUNTRY_IST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Country Type
2=2 Character
3=3 Character
N=3 Numeric
|
| 74 |
COUNTRY_IST_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Country Prefix From
|
| 75 |
COUNTRY_IST_RGSTRN |
Character(3) |
VARCHAR2(3) NOT NULL |
Intrastat Country Prefix
|
| 76 |
IST_RGSTRN_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Intrastat Registration Id
|
| 77 |
IST_PORT_KEY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Port/Airport Key Required
Y/N Table Edit
Default Value: N
|
| 78 |
IST_DLVY1_KEY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delivery Terms 1 Key Required
Y/N Table Edit
Default Value: N
|
| 79 |
IST_TMODE_KEY_REQD |
Character(1) |
VARCHAR2(1) NOT NULL |
Mode Of Transport Key Required
Y/N Table Edit
Default Value: N
|
| 80 |
IST_WHERE_CLAUSE1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Where Clause
|
| 81 |
IST_WHERE_CLAUSE2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Where Clause
|
| 82 |
IST_WHERE_CLAUSE3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Where Clause
|