CA_BP_TXNXF_TAO

(SQL Table)
Index Back

CA/BI xref TAO

This table used during the Billing Interface to create new entries to CA_BP_XREF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID

Prompt Table: CA_BILL_PLAN

4 XREF_SEQ_NUM Number(5,0) INTEGER NOT NULL Cross Reference Sequence No.
5 XREF_STATUS Character(3) VARCHAR2(3) NOT NULL Cross Reference Status
ACP=Accepted
DEL=Deleted
FIN=Finalized
NEW=New
RCV=Received
REC=Received
REJ=Rejected
REV=Reversed
RVS=Reversed
6 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
7 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.

Prompt Table: CA_BP_EVENTS

8 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num
9 CA_TXN_ID Number(12,0) DECIMAL(12) NOT NULL Transaction ID
10 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
11 NET_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The resulting net amount related to settlement cash flows subject to counterparty netting agreements.
12 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
13 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code

Prompt Table: CURRENCY_CD_TBL

14 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

Prompt Table: SP_BU_BI_NONVW

15 TEMP_INVOICE Character(22) VARCHAR2(22) NOT NULL Temporary Invoice
16 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
17 INVOICE_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill
18 INVOICE_DT Date(10) DATE Invoice Date
19 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
20 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
21 LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL 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.
22 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
23 DELETE_ME Character(1) VARCHAR2(1) NOT NULL Delete Record

Default Value: N