PROCESS_INSTANCEGPBR_MAN_ROW_TYPECOMPANYESTABIDESTAB_ID_BRAGPBR_CNPJGP_RPT_KEY0=0-Without Centralization
1=1-Establishment Centralizer
2=2-Establishment Centralized
EFFDTDefault Value: %date
ACCOUNTGPBR_MANAD_TMP1(SQL Table) |
Index Back |
|---|---|
Temp Record MANAD- Purpose : Used in MANAD Report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | GPBR_MAN_ROW_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | MANAD Record Type |
| 3 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 4 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 5 | ESTAB_ID_BRA |
Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
| 6 | GPBR_CNPJ |
Character(14) | VARCHAR2(14) NOT NULL | Establlishment CNPJ Number |
| 7 | GP_RPT_KEY |
Character(22) | VARCHAR2(22) NOT NULL | Output Result Key |
| 8 | CENTR_ESTABID_BRA | Character(12) | VARCHAR2(12) NOT NULL | Centralizer Establishment ID |
| 9 | GPBR_MAN_CENTR_IND | Character(1) | VARCHAR2(1) NOT NULL |
MANAD Centralization Indicator
0=0-Without Centralization 1=1-Establishment Centralizer 2=2-Establishment Centralized |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 12 | GPBR_MAN_TEXT | Character(230) | VARCHAR2(230) NOT NULL | MANAD Text |
| 13 | GPBR_MAN_EMP_FORM | Character(1) | VARCHAR2(1) NOT NULL | MANAD Show EmplID + Empl Rcd |
| 14 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 15 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 16 | GL_EXPENSE | Character(35) | VARCHAR2(35) NOT NULL | GL Account #-Expense |
| 17 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 18 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 19 | GPBR_SERVICE_TAKER | Character(3) | VARCHAR2(3) NOT NULL | Service Taker |