BI_ACCT_LN_STG2

(SQL Table)
Index Back

Billing Acct Entry -Line STG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
5 ACCT_ENTRY_TYPE Character(3) VARCHAR2(3) NOT NULL Account Entry Type
6 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
7 DISC_SUR_ID Character(15) VARCHAR2(15) NOT NULL Identifier
8 LINE_DST_SEQ_NUM Number(3,0) SMALLINT NOT NULL Revenue Sequence Number
9 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
10 DST_SEQ_NUM Number(6,0) INTEGER NOT NULL Distribution Sequence
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 DISC_SUR_INDICATOR Character(1) VARCHAR2(1) NOT NULL Discount/Surcharge
D=Discount
I=Installment Surcharge
S=Surcharge
13 CF_BAL_LINE_NUM Number(10,0) DECIMAL(10) NOT NULL Chart Field Balancing Line Num
14 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
15 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
16 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
17 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
18 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
19 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
20 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account
21 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
22 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

23 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

24 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

25 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

26 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

27 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

28 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

29 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

30 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

31 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

32 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

33 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

34 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: %EDIT_BU_PC

35 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

36 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: %EDIT_ACTIVITY

37 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type

Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

38 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category

Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

39 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory

Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

40 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type

Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

41 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code
42 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
43 STATISTIC_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT.
44 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key
45 JRNL_LN_REF Character(10) VARCHAR2(10) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction.
46 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
47 USER1 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
48 USER2 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
49 USER3 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
50 USER4 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
51 USER5 Character(1) VARCHAR2(1) NOT NULL Describes additional information about a pending receivables item. This field is customizable and user-defined and is one of ten text fields (USER1 through USER10).
52 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
53 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
54 JOURNAL_LINE Number(9,0) DECIMAL(9) NOT NULL Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header.
55 BUDGET_DT Date(10) DATE Budget Date
56 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
57 BUDGET_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL -> SL - 15-AUG-2002 MISC_CRITERIA label has been added <-
B=Bypass
E=Error
N=Not Chk'd
V=Valid
W=Warning
58 KK_TRAN_OVER_FLAG Character(1) VARCHAR2(1) NOT NULL Commitment Control source transaction override flag
N=No
Y=Yes
59 KK_TRAN_OVER_OPRID Character(30) VARCHAR2(30) NOT NULL Commitment Control source transaction override operator
60 KK_TRAN_OVER_DTTM DateTime(26) TIMESTAMP Commitment Control source transaction override datetime
61 GL_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
62 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
63 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
64 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
65 FOREIGN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
66 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
67 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
68 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
69 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.
70 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
71 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
72 FROM_ACCRUAL Character(1) VARCHAR2(1) NOT NULL From Accrual Process

Y/N Table Edit

Default Value: N

73 ENTRY_EVENT Character(10) VARCHAR2(10) NOT NULL Entry Event
74 IU_ANCHOR_FLG Character(1) VARCHAR2(1) NOT NULL Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields).
75 IU_SYS_TRAN_CD Character(8) VARCHAR2(8) NOT NULL System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries.
76 IU_TRAN_CD Character(8) VARCHAR2(8) NOT NULL Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction.
77 BI_PRELD_STAT Character(1) VARCHAR2(1) NOT NULL Pre Load GL process status
0=In Process
1=Complete CF Inheritance
2=Complete Inter/Intra Proc
3=Complete Combo Edit Proc
4=Complete Preld Process
78 ERROR_STATUS_BI Character(4) VARCHAR2(4) NOT NULL Error Status
79 CF_ACTION_FLG Character(1) VARCHAR2(1) NOT NULL Chartfield Action Flag