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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
2 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
3 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
4 | RUNDATE | Date(10) | DATE | Process Scheduler Run Date |
5 | FROM_DATE | Date(10) | DATE | From Date |
6 | TO_DATE | 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 |