| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 5 |
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
|
| 6 |
COUNTRY_VAT_RPTG |
Character(3) |
VARCHAR2(3) NOT NULL |
VAT Reporting Country
Prompt Table:
VAT_ENT_RGSTRN
|
| 7 |
VAT_RPT_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Report ID
Prompt Table:
VAT_RPT_ID_HDR
|
| 8 |
RPT_DT |
Date(10) |
DATE NOT NULL |
Report Date
|
| 9 |
RPT_THRU_DT |
Date(10) |
DATE NOT NULL |
Report Thru Date
|
| 10 |
VAT_RPT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Report Type
C=Reverse Charge Sales List
O=Other Report
R=VAT Return
S=EC Sales List
Default Value: R
|
| 11 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table:
CUR_RT_TYPE_TBL
|
| 12 |
RPT_FROM_DATE |
Date(10) |
DATE NOT NULL |
Report From Date
|
| 13 |
RPT_TXN_FRM_DT |
Date(10) |
DATE |
Select Transactions From
|
| 14 |
RPT_TXN_THRU_DT |
Date(10) |
DATE |
Select Transactions Thru
|
| 15 |
VAT_REPORT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reconciliation Report Type
A=Account Balance Reconciliation
B=Taxable Basis Reconciliation
T=VAT Transaction Reconciliation
V=Account/VAT Account Recon
Z=Zero VAT Justification
Default Value: B
|
| 16 |
VAT_EXTRACT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT Reconciliation Extract Type.
G=General Ledger Journals
I=Input VAT Transactions
L=Billing Transactions
M=Asset Mgmt Transactions
O=Output VAT Transactions
P=AP, GL, Expenses, Treasury
R=Receivables Transactions
Default Value: I
|
| 17 |
DET_SUM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Detail or Summary
D=Detail
S=Summary
Default Value: S
|
| 18 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_VATBU_NONVW
Set Control Field: VAT_ENTITY
|
| 19 |
PRT_EXCPTN_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Exceptions Only
Y/N Table Edit
Default Value: Y
|
| 20 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 21 |
ACCOUNT_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
From Account
Prompt Table:
%EDITTABLE
|
| 22 |
ACCOUNT_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
To Account
Prompt Table:
%EDITTABLE
|
| 23 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 24 |
VAT_TOLERANCE_AMT |
Signed Number(13,3) |
DECIMAL(11,3) NOT NULL |
VAT Tolerance Amount
|
| 25 |
ALT_SORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternative Sort Criteria
Y/N Table Edit
|
| 26 |
PRINT_PROTOCOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Print Summary Totals
Y/N Table Edit
Default Value: N
|
| 27 |
ALTACCT_VIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Alternate Account
Y/N Table Edit
Default Value: N
|
| 28 |
FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table:
STAT_RPT_LBL_VW
|
| 29 |
RPT_PERIOD |
Character(2) |
VARCHAR2(2) NOT NULL |
Reporting Period
|
| 30 |
RPT_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Reporting Year
|
| 31 |
EXTRACT_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Extract File
Y/N Table Edit
|