EXD_REG_PLA_ABS(SQL Table) |
Index Back |
|---|---|
Abstract Recorg for PLA RegistThis is the Abstract Record of PLA Register in the Register Abstract AE Program. (EXD_REG_ABS) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 2 | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. | |
| 3 | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. | |
| 4 | Date(10) | DATE | Process Scheduler Run Date | |
| 5 | Date(10) | DATE | From Date | |
| 6 | Date(10) | DATE | To Date | |
| 7 | EXD_OPEN_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Opening Balance |
| 8 | EXD_DUTY_CREDIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Opening Balance |
| 9 | EXD_DUTY_DEBIT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Opening Balance |
| 10 | EXD_CLOSE_BALANCE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Opening Balance |
| 11 | EXD_TAX_CMPNT1 | Character(10) | VARCHAR2(10) NOT NULL | AED Component Code |
| 12 | EXD_CODE_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | AED Amount |
| 13 | EXD_TAX_CMPNT2 | Character(10) | VARCHAR2(10) NOT NULL | BED Componet Code |
| 14 | EXD_CODE_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BED Amount |
| 15 | EXD_TAX_CMPNT3 | Character(10) | VARCHAR2(10) NOT NULL | SED Component Code |
| 16 | EXD_CODE_AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SED Amount |
| 17 | EXD_TAX_CMPNT4 | Character(10) | VARCHAR2(10) NOT NULL | CESS Component Code |
| 18 | EXD_CODE_AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise CESS Amount |
| 19 | EXD_TAX_CMPNT5 | Character(10) | VARCHAR2(10) NOT NULL | Addl Component Code |
| 20 | EXD_CODE_AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Additional Duty Amount |
| 21 | EXD_TAX_CMPNT6 | Character(10) | VARCHAR2(10) NOT NULL | Other Component Code |
| 22 | EXD_CODE_AMT6 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Duty Amount |