UPG_LC_AET(SQL Table) |
Index Back |
---|---|
Upgrade AET Table for ERP Glob |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |