EXD_REG_PLA_ABS

(SQL Table)
Index Back

Abstract Recorg for PLA Regist

This 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