UPG_LC_AET

(SQL Table)
Index Back

Upgrade AET Table for ERP Glob

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 UPG_RELEASE Character(4) VARCHAR2(4) NOT NULL Upgrade Application Release
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
3 PUBLIC_SECTOR Character(1) VARCHAR2(1) NOT NULL Public Sector
4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
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 TXN_LINE_NUM Number(5,0) INTEGER NOT NULL Transaction Line Number
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 PV_FIELD_OVERRIDES Character(254) VARCHAR2(254) NOT NULL Override Fields
9 COUNTRY_VAT_RPTG Character(3) VARCHAR2(3) NOT NULL VAT Reporting Country
10 VAT_DCMNT_ID Number(8,0) INTEGER NOT NULL VAT Document ID
11 VAT_DCMNT_ID_NEW Number(8,0) INTEGER NOT NULL New VAT Document ID
12 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".
13 LAST_VAT_DCMNT_ID Number(8,0) INTEGER NOT NULL Last VAT Document ID Assigned
14 TMP_FLD Character(1) VARCHAR2(1) NOT NULL Field for holding temp data