EXD_AC2_BAL_ABS(SQL Table) |
Index Back |
|---|---|
Balance Register for AC2This is the Balance Record of AC2 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 | EXD_BALANCE_DATE |
Date(10) | DATE | Balance Date |
| 5 | EXD_REGISTER_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Excise Register Code. This code is unique to the Excise Tax Location and it is issued by the Excise authority
DSA=Daily Stock Account ICGH=CENVAT Register - CG Onhold ICGQ=Qty Register - Capital Goods ICGV=CENVAT Register -Capital Goods IRMQ=Qty Register - Raw Material IRMV=CENVAT Register - Raw Material PLA=Personal Ledger Account |
| 6 | EXD_TAX_CMPNT1 | Character(10) | VARCHAR2(10) NOT NULL | AED Component Code |
| 7 | EXD_OPEN_BALANCE1 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 8 | EXD_DUTY_DEBIT1 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 9 | EXD_DUTY_CREDIT1 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 10 | EXD_CLOSE_BALANCE1 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 11 | EXD_TAX_CMPNT2 | Character(10) | VARCHAR2(10) NOT NULL | BED Componet Code |
| 12 | EXD_OPEN_BALANCE2 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 13 | EXD_DUTY_DEBIT2 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 14 | EXD_DUTY_CREDIT2 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 15 | EXD_CLOSE_BALANCE2 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 16 | EXD_TAX_CMPNT3 | Character(10) | VARCHAR2(10) NOT NULL | SED Component Code |
| 17 | EXD_OPEN_BALANCE3 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 18 | EXD_DUTY_DEBIT3 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 19 | EXD_DUTY_CREDIT3 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 20 | EXD_CLOSE_BALANCE3 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 21 | EXD_TAX_CMPNT4 | Character(10) | VARCHAR2(10) NOT NULL | CESS Component Code |
| 22 | EXD_OPEN_BALANCE4 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 23 | EXD_DUTY_DEBIT4 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 24 | EXD_DUTY_CREDIT4 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 25 | EXD_CLOSE_BALANCE4 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 26 | EXD_TAX_CMPNT5 | Character(10) | VARCHAR2(10) NOT NULL | Addl Component Code |
| 27 | EXD_OPEN_BALANCE5 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 28 | EXD_DUTY_DEBIT5 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 29 | EXD_DUTY_CREDIT5 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 30 | EXD_CLOSE_BALANCE5 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 31 | EXD_TAX_CMPNT6 | Character(10) | VARCHAR2(10) NOT NULL | Other Component Code |
| 32 | EXD_OPEN_BALANCE6 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 33 | EXD_DUTY_DEBIT6 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 34 | EXD_DUTY_CREDIT6 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 35 | EXD_CLOSE_BALANCE6 | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 36 | EXD_DAY_OPEN_BAL | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 37 | EXD_DAY_DUTY_DR | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 38 | EXD_DAY_DUTY_CR | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |
| 39 | EXD_DAY_CLOSE_BAL | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Opening Balance |