REG_UPDATE_AET

(SQL Table)
 Index Back

State Record, Main

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 SETID Character(5) VARCHAR2(5) NOT NULL SetID
7 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.
8 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
11 EXD_DOC_NBR_SER Character(6) VARCHAR2(6) NOT NULL Excise Document Number Series. Excise Document number series group will be created against each excise transaction type.
12 EXD_INVOICE_SOURCE Character(1) VARCHAR2(1) NOT NULL Excise Invoice Source
1=Shipping Excise Invoice
2=Supplier Excise Invoice
3=Excise Invoice Adjustment
13 EXD_INVOICE_NO_FR Character(18) VARCHAR2(18) NOT NULL Excise Invoice No FR
14 EXD_INVOICE_NO_TR Character(18) VARCHAR2(18) NOT NULL Excise Invoice No TR
15 EXD_ADJ_NO_FR Character(10) VARCHAR2(10) NOT NULL Excise Adjust No From
16 EXD_ADJ_NO_TO Character(10) VARCHAR2(10) NOT NULL Excise Adjust No Through
17 EXD_QTY_REG_UPD Character(1) VARCHAR2(1) NOT NULL Excise Quantity Reg Update
18 EXD_VAL_REG_UPD Character(1) VARCHAR2(1) NOT NULL Value Register Update

Y/N Table Edit

19 EXD_CENVAT_UTL Character(1) VARCHAR2(1) NOT NULL CENVAT Utilization. This field will have two translate values of "fortnightly" and "Online".
F=Fortnightly
O=Online
20 EXD_ACCTG_UPD Character(1) VARCHAR2(1) NOT NULL Excise Accounting Update
21 EXD_DUTY_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL Duty Balance
22 CENVAT_CREDIT_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL CENVAT Credit Total
23 EXD_PLA_SR_NO Number(10,0) DECIMAL(10) NOT NULL PLA Serial Number
24 EXD_PLA_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise PLA Amount
25 EXD_RG23AII_SR_NO Number(10,0) DECIMAL(10) NOT NULL RG23 Part II Serial No
26 EXD_RG23AII_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise RG23AII Amount
27 EXD_RG23CII_SR_NO Number(10,0) DECIMAL(10) NOT NULL Register RG23CII Serial No
28 EXD_RG23CII_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise RG23CII Amount
29 PLA_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL PLA Balance
30 RG23AII_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL RG23AII Balance
31 RG23CII_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL RG23CII Balance
32 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
33 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
34 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
35 EXD_CENVAT_CG_PCT Number(3,0) SMALLINT NOT NULL Cenvat % on Capital Goods
36 EXD_CENVAT_FLG Character(1) VARCHAR2(1) NOT NULL Cenvat Utilization Update Flag
37 EXS_ITM_PROD_ID Character(18) VARCHAR2(18) NOT NULL Item Product ID
38 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
39 EXD_INVOICE_NO Character(10) VARCHAR2(10) NOT NULL Excise Invoice Number
40 AS_OF_DATE Date(10) DATE As of Date
41 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp