EXD_SHP_INV_LN

(SQL Table)
Index Back

EXCISE SHIPPING INVOICE LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUEXD_NONVW

2 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.

Prompt Table: EXD_DOC_VW

3 EXD_INVOICE_NO Character(10) VARCHAR2(10) NOT NULL Excise Invoice Number
4 EXD_INVOICE_LN Number(4,0) SMALLINT NOT NULL Excise Invoice Line No
5 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
6 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No
7 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
8 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
9 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
10 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
11 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
12 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
15 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
16 KIT_QTY Number(3,0) SMALLINT NOT NULL Quantity
17 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
18 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price
19 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
20 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base
21 QTY_EXD Signed Number(17,4) DECIMAL(15,4) NOT NULL Excise Quantity
22 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
23 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
24 EXD_UOM Character(3) VARCHAR2(3) NOT NULL Excise Unit Of Measure
25 EXD_TAX_ITEM_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Item Type
C=Capital Goods
F=Finished Goods
R=Raw Material
S=Service
26 EXD_ITM_CATG_CD Character(10) VARCHAR2(10) NOT NULL Excise Item Category Code
27 EXD_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Excise Tax Calculation Code

Prompt Table: EXD_TAX_RATE_VW

28 EXD_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Excise Applicablity Flag. This field is used to indicate the applicability of Excise duty with respect to a vendor, customer, item or product. It will have Yes or No values.
29 EXD_ASSESS_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Assessable Value
30 EXD_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
31 STX_ITM_CATG_CD Character(10) VARCHAR2(10) NOT NULL Sales Item Category Code
32 STX_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Sales Tax Calculation Code

Prompt Table: STX_TAX_RATE_VW

33 STX_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Sales Tax Applicability.
34 STX_TAX_AUTH_RATE Character(8) VARCHAR2(8) NOT NULL Tax Authority Rate (India Sales Tax)
35 STX_TAX_AUTH_RPT Character(8) VARCHAR2(8) NOT NULL Reporting Authority (India Sales Tax)
36 STX_FORM_CD Character(8) VARCHAR2(8) NOT NULL Form Code
37 EXS_TAX_TXN_TYPE Character(4) VARCHAR2(4) NOT NULL Tax Transaction Type. This field will be used in the Tax determination and calculation of taxes.
DEB=Direct Export With Bond
DEWB=Direct Export Without Bond
DIMP=Direct Import
DOM=Domestic
LEB=Local Export With Bond
LEWB=Local Export Without Bond
LIMP=Local Import
38 EXD_USE_AV_FLG Character(1) VARCHAR2(1) NOT NULL Excise Use Av Flag
39 EXS_SERV_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Service Tax Indicator
N=Not Service Tax
Y=Service Tax
40 TOT_EXD_AMT_RPT Number(27,3) DECIMAL(26,3) NOT NULL Total Exc Tax in Rpt Curr
41 TOT_STX_AMT_RPT Number(27,3) DECIMAL(26,3) NOT NULL Total Sales Tax in Rpt Curr
42 TOT_EXS_AMT_RPT Number(27,3) DECIMAL(26,3) NOT NULL Total Exc & Sales Tax Rpt Cur
43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
44 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
45 EXS_CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Excise Currency Reporting
46 EXD_CENVAT_FLG Character(1) VARCHAR2(1) NOT NULL Cenvat Utilization Update Flag
47 EXD_PLA_SR_NO Number(10,0) DECIMAL(10) NOT NULL PLA Serial Number
48 EXD_PLA_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise PLA Amount
49 EXD_RG23AII_SR_NO Number(10,0) DECIMAL(10) NOT NULL RG23 Part II Serial No
50 EXD_RG23AII_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise RG23AII Amount
51 EXD_RG23CII_SR_NO Number(10,0) DECIMAL(10) NOT NULL Register RG23CII Serial No
52 EXD_RG23CII_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise RG23CII Amount
53 EXD_QTY_UPDATED Character(1) VARCHAR2(1) NOT NULL QUANTITY UPDATED
54 EXD_ASSESS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Assessable Amount - Transactio
55 EXD_ASSESS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Assessable Value - Base
56 EXD_ASSESS_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Assessable Value - Reporting