INTFC_CA2_STG (SQL Table)	Index Back
BI Interfc ext table - TBP TBP transaction staging table for BiIling Interface extension table

INTFC_CA2_STG

(SQL Table)

BI Interfc ext table - TBP

TBP transaction staging table for BiIling Interface extension table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 TXN_SEQ_NUM Number(10,0) DECIMAL(10) NOT NULL Transaction Sequence number for TBP transactions

3 TRANS_TYPE_BI Character(4) VARCHAR2(4) NOT NULL Transaction Type
AE=Accounting Entry
AHDR=Adjustment Header
DDS=Deferred Discount/Surcharge
DS=Discount/Surcharge
EXSD=Indian Excise/Sales Tax Detail
LINE=Chargeable Line
NOTE=Note/Comment
TAX=Sales/Use Tax Detail

4 TRANS_TYPE_BI_SEQ Number(3,0) SMALLINT NOT NULL Transaction Type Seq
010=Invalid Transaction Type
020=Too many charge lines
030=No charge line for activity
040=Invalid Business Unit
050=Invalid bill-to customer
060=Invalid Billing Address
070=Invalid bill-to contact
080=No Bill Source provided
090=Invalid Bill Source
100=Invalid Bill Type
110=Invalid Bill Cycle
120=Invalid Payment Term
130=Invalid Tax Code
140=Invalid Unit of measure
200=Invalid Standard Note Code
210=No Note Code or Text exists
300=Both Amount & Percentage are 0

5 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

6 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

7 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

8 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

9 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

10 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

11 CITY Character(30) VARCHAR2(30) NOT NULL City

12 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

13 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

14 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

15 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

16 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

17 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

18 COUNTY Character(30) VARCHAR2(30) NOT NULL County

19 STATE Character(6) VARCHAR2(6) NOT NULL State

20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

21 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

22 EXD_INVOICE_NO Character(10) VARCHAR2(10) NOT NULL Excise Invoice Number

23 EXD_INVOICE_LINE Number(5,0) INTEGER NOT NULL Excise Invoice Line Number

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

25 STX_APPL_FLG Character(1) VARCHAR2(1) NOT NULL Sales Tax Applicability.

26 STX_TAX_AUTH_CD Character(8) VARCHAR2(8) NOT NULL Tax Authority Code
Prompt Table: STX_TAX_AUTH

27 EXD_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Excise Tax Calculation Code
Prompt Table: EXS_TAX_RATE

28 STX_TAX_RATE_CD Character(10) VARCHAR2(10) NOT NULL Sales Tax Calculation Code
Prompt Table: EXS_TAX_RATE

29 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: INV_ITEMS

30 ORG_SETID Character(5) VARCHAR2(5) NOT NULL Organization SetID.

31 ORG_CODE Character(6) VARCHAR2(6) NOT NULL Organization Code. This will be unique to an Organization.

32 ORG_TAX_LOC_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code. An Organization can have multiple Tax Location Codes.

33 EXD_CONVERSION_RT Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

34 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity

35 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

36 EXD_CUST_CATG_CD Character(10) VARCHAR2(10) NOT NULL Excise Customer Category Code
Prompt Table: EXS_TAX_CAT_VW2

37 STX_CUST_CATG_CD Character(10) VARCHAR2(10) NOT NULL Sales Customer Category Code
Prompt Table: EXS_TAX_CAT_VW2

38 EXD_ITM_CATG_CD Character(10) VARCHAR2(10) NOT NULL Excise Item Category Code
Prompt Table: EXS_TAX_CAT_VW1

39 STX_ITM_CATG_CD Character(10) VARCHAR2(10) NOT NULL Sales Item Category Code
Prompt Table: EXS_TAX_CAT_VW1

40 EXS_SERV_TAX_FLG Character(1) VARCHAR2(1) NOT NULL Service Tax Indicator
N=Not Service Tax
Y=Service Tax
Y/N Table Edit

41 EXD_ASSESS_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Assessable Value

42 EXD_UOM Character(3) VARCHAR2(3) NOT NULL Excise Unit Of Measure

43 EXD_USE_AV_FLG Character(1) VARCHAR2(1) NOT NULL Excise Use Av Flag

44 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

45 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

46 EXS_CURRENCY_RPTG Character(3) VARCHAR2(3) NOT NULL Excise Currency Reporting
Prompt Table: CURRENCY_CD_TBL

47 EXD_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Tax Amount

48 EXD_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty in Base Currency

49 EXD_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL Excise Duty Amt In Rpt Curr

50 STX_TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount

51 STX_TAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN BASE CURR

52 STX_TAX_AMT_RPT Signed Number(28,3) DECIMAL(26,3) NOT NULL SALES TAX IN REPORT CURR

53 STX_FORM_CD Character(8) VARCHAR2(8) NOT NULL Form Code
Prompt Table: STX_FORM_CD_VW

54 LOAD_STATUS_BI Character(3) VARCHAR2(3) NOT NULL Billing Interface Load Status
DON=Done (Complete)
ERR=Error
NEW=New
RDY=Ready
UPD=Updating

55 ERROR_STATUS_BI Character(4) VARCHAR2(4) NOT NULL Error Status

56 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

57 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TXN_SEQ_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Sequence number for TBP transactions
3	TRANS_TYPE_BI	Character(4)	VARCHAR2(4) NOT NULL	Transaction Type AE=Accounting Entry AHDR=Adjustment Header DDS=Deferred Discount/Surcharge DS=Discount/Surcharge EXSD=Indian Excise/Sales Tax Detail LINE=Chargeable Line NOTE=Note/Comment TAX=Sales/Use Tax Detail
4	TRANS_TYPE_BI_SEQ	Number(3,0)	SMALLINT NOT NULL	Transaction Type Seq 010=Invalid Transaction Type 020=Too many charge lines 030=No charge line for activity 040=Invalid Business Unit 050=Invalid bill-to customer 060=Invalid Billing Address 070=Invalid bill-to contact 080=No Bill Source provided 090=Invalid Bill Source 100=Invalid Bill Type 110=Invalid Bill Cycle 120=Invalid Payment Term 130=Invalid Tax Code 140=Invalid Unit of measure 200=Invalid Standard Note Code 210=No Note Code or Text exists 300=Both Amount & Percentage are 0
5	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
6	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
7	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
8	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
9	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit
10	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
11	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
12	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
13	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
14	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
15	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
16	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
17	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
18	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
19	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
20	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
21	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
22	EXD_INVOICE_NO	Character(10)	VARCHAR2(10) NOT NULL	Excise Invoice Number
23	EXD_INVOICE_LINE	Number(5,0)	INTEGER NOT NULL	Excise Invoice Line Number
24	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.
25	STX_APPL_FLG	Character(1)	VARCHAR2(1) NOT NULL	Sales Tax Applicability.
26	STX_TAX_AUTH_CD	Character(8)	VARCHAR2(8) NOT NULL	Tax Authority Code Prompt Table: STX_TAX_AUTH
27	EXD_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Tax Calculation Code Prompt Table: EXS_TAX_RATE
28	STX_TAX_RATE_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Tax Calculation Code Prompt Table: EXS_TAX_RATE
29	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: INV_ITEMS
30	ORG_SETID	Character(5)	VARCHAR2(5) NOT NULL	Organization SetID.
31	ORG_CODE	Character(6)	VARCHAR2(6) NOT NULL	Organization Code. This will be unique to an Organization.
32	ORG_TAX_LOC_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code. An Organization can have multiple Tax Location Codes.
33	EXD_CONVERSION_RT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
34	QTY_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity
35	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
36	EXD_CUST_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Customer Category Code Prompt Table: EXS_TAX_CAT_VW2
37	STX_CUST_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Customer Category Code Prompt Table: EXS_TAX_CAT_VW2
38	EXD_ITM_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Excise Item Category Code Prompt Table: EXS_TAX_CAT_VW1
39	STX_ITM_CATG_CD	Character(10)	VARCHAR2(10) NOT NULL	Sales Item Category Code Prompt Table: EXS_TAX_CAT_VW1
40	EXS_SERV_TAX_FLG	Character(1)	VARCHAR2(1) NOT NULL	Service Tax Indicator N=Not Service Tax Y=Service Tax Y/N Table Edit
41	EXD_ASSESS_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Assessable Value
42	EXD_UOM	Character(3)	VARCHAR2(3) NOT NULL	Excise Unit Of Measure
43	EXD_USE_AV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Excise Use Av Flag
44	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
45	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
46	EXS_CURRENCY_RPTG	Character(3)	VARCHAR2(3) NOT NULL	Excise Currency Reporting Prompt Table: CURRENCY_CD_TBL
47	EXD_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Tax Amount
48	EXD_TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Duty in Base Currency
49	EXD_TAX_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Excise Duty Amt In Rpt Curr
50	STX_TAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Sales Tax Amount
51	STX_TAX_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SALES TAX IN BASE CURR
52	STX_TAX_AMT_RPT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	SALES TAX IN REPORT CURR
53	STX_FORM_CD	Character(8)	VARCHAR2(8) NOT NULL	Form Code Prompt Table: STX_FORM_CD_VW
54	LOAD_STATUS_BI	Character(3)	VARCHAR2(3) NOT NULL	Billing Interface Load Status DON=Done (Complete) ERR=Error NEW=New RDY=Ready UPD=Updating
55	ERROR_STATUS_BI	Character(4)	VARCHAR2(4) NOT NULL	Error Status
56	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
57	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.