BI_RPT_RQ_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
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.
6 BI_TRANS_TYPE Character(4) VARCHAR2(4) NOT NULL Created this field for Transmission Type for E-Invoicing Feature.
CUST=Bill-To Customer
INV=Invoice

Default Value: INV

7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
8 DATE_FROM Date(10) DATE Date From
9 DATE_TO Date(10) DATE Date To
10 FS_MAP_ID Character(30) VARCHAR2(30) NOT NULL Map ID
11 BI_PROGRESSIVE_ID Character(5) VARCHAR2(5) NOT NULL Progressive ID
12 BI_DRV_FLD Character(22) VARCHAR2(22) NOT NULL Invoice

Prompt Table: %EDITTABLE

13 VAT_RGSTRN_ID Character(20) VARCHAR2(20) NOT NULL VAT Registration ID
14 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
15 FILEPATH Character(30) VARCHAR2(30) NOT NULL File Information
16 FS_MAP_RET Number(4,0) SMALLINT NOT NULL Result
17 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter