BI_LINE_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BI_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 4 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 5 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 6 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 7 | ORIGINAL_LINE_SEQ | Number(5,0) | INTEGER NOT NULL |
Original Line Sequence 5
Default Value: BI_LINE.LINE_SEQ_NUM |
| 8 | NEXT_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Adjusting Invoice |
| 9 | NEXT_ADJ_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Next Adjustment Line Sequence |
| 10 | PRIOR_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Adjusted Invoice |
| 11 | PRIOR_ADJ_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Prior Adjustment Line Seq |
| 12 | LATEST_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Latest Invoice |
| 13 | LATEST_LINE_SEQ | Number(5,0) | INTEGER NOT NULL |
Latest Line Sequence
Default Value: BI_LINE.LINE_SEQ_NUM |
| 14 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
| 15 | SUBCUST_QUAL1 | Character(15) | VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Default Value: BI_HDR.SUBCUST_QUAL1 Prompt Table: SUBCUST_Q1_TBL |
| 16 | SUBCUST_QUAL2 | Character(15) | VARCHAR2(15) NOT NULL |
Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.
Default Value: BI_HDR.SUBCUST_QUAL2 Prompt Table: SUBCUST_Q2_TBL |
| 17 | ADJ_LINE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Adjustment Line Type
ACR=Adjustment Credit Line ADJ=Adjustment ARB=Adjustment Rebill Line REG=Regular bill line (not adjust) |
| 18 | ADJUSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Adjusted Flag
H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments Default Value: N |
| 19 | LINE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing BAE=Billed Amount in Excess BRT=Billing Retainage DAPP=Cust Deposit Applied DEP=Customer Deposit DISC=Discount Line DREF=Cust Deposit Refunded DRFF=Cust Deposit Refund Fee FRGT=Freight (Surcharge) MISC=Miscellaneous Charge PYCV=Payment with Corporate Voucher RAE=Reclaimed Amount in Excess REV=Revenue Line RSTK=Restock (Surcharge) SUR=Surcharge Line UTL=Utilization Line Default Value: REV |
| 20 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD |
| 21 | 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. "
Default Value: BI_HDR.BASE_CURRENCY |
| 22 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL |
Euro Currency
Default Value: BI_HDR.CURRENCY_CD_XEU |
| 23 | RT_EFFDT | Date(10) | DATE | The effective date for a given item of market rate data. |
| 24 | CHARGE_FROM_DT | Date(10) | DATE |
From Date for line charges
Default Value: BI_HDR.FROM_DT |
| 25 | CHARGE_TO_DT | Date(10) | DATE |
Through date for charges
Default Value: BI_HDR.TO_DT |
| 26 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL |
Identifier
Prompt Table: %EDITTABLE4 |
| 27 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 28 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 29 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 30 | ORIG_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Original Quantity |
| 31 | UNIT_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Unit Price |
| 32 | PRICE_RECALC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Recalculate Price
Y/N Table Edit Default Value: N |
| 33 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: TAX_SU_HDR_VW |
| 34 | TAX_EXEMPT_CERT | Character(30) | VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table: CUST_EXEMPT |
| 35 | TAX_EXEMPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit Default Value: N |
| 36 | GROSS_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 37 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 38 | ORIG_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Original Amount |
| 39 | GROSS_EXTENDED_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 40 | NET_EXTENDED_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amount |
| 41 | GROSS_EXTENDED_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 42 | NET_EXTENDED_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amount |
| 43 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 44 | TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount (base) |
| 45 | TAX_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount - Euro |
| 46 | TAX_PCT | Number(7,4) | DECIMAL(6,4) NOT NULL | Tax Percent |
| 47 | FINAL_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Final Tax Flag
Y/N Table Edit Default Value: N |
| 48 | MAX_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL | max_tax_flg = 'Y' implies that max taxes were applied |
| 49 | BI_TAX_TIMING | Character(1) | VARCHAR2(1) NOT NULL |
BI Tax Timing
S=Tax on Services Rendered |
| 50 | VAT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges. |
| 51 | VAT_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt in Base Curr |
| 52 | VAT_BASIS_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amount in Euro Curr |
| 53 | VAT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice. |
| 54 | VAT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amount in Base Curr |
| 55 | VAT_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amount - Euro Currency |
| 56 | VAT_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 57 | VAT_TRANS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount in base currency against which the VAT is applicable |
| 58 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
Prompt Table: VAT_TXN_CD |
| 59 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL |
Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
Prompt Table: VAT_HEADER_VW |
| 60 | TAX_CD_VAT_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage. |
| 61 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated Default Value: N |
| 62 | PROD_GRP_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Product Group SetID
Prompt Table: SP_SETID_NONVW |
| 63 | VAT_PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 64 | PRODUCT_KIT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product Kit Number |
| 65 | VAT_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
VAT Distribution Status
D=Distributed E=Error Flag I=Ignored M=Archival Entry N=Not Distributed P=Processed R=Reversal Entry U=Undefined Default Value: U |
| 66 | TAX_VAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include VAT
N=No Y=Yes Y/N Table Edit Default Value: N |
| 67 | REV_RECOG_BASIS | Character(3) | VARCHAR2(3) NOT NULL |
Revenue Recognition Basis
CHG=From/To Date Range CON=Contract Date INV=Invoice Date ORD=Order Date SHP=Ship Date STE=Start/End Date Range UD1=User Date 1 UD2=User Date 2 Default Value: BI_TYPE.REV_RECOG_BASIS |
| 68 | DEFERRED_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Subject to Deferred Booking
Y/N Table Edit Default Value: N |
| 69 | ACCRUE_DT | Date(10) | DATE | Accrual Date |
| 70 | TOT_LINE_DST_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Total Revenue Percent |
| 71 | TOT_LINE_DFR_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Total Deferred Percent |
| 72 | TOT_LINE_UAR_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Total Unbilled AR Percent |
| 73 | TOT_LINE_DST_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Dist Amount |
| 74 | TOT_LINE_DFR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Deferred Amount |
| 75 | TOT_LINE_UAR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Unbilled AR Amount |
| 76 | TOT_LINE_DST_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Dist Amount |
| 77 | TOT_LINE_DFR_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Contract Liability Amt |
| 78 | TOT_LINE_UAR_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Contract Asset Amount |
| 79 | TOT_LINE_DST_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Dist Amount |
| 80 | TOT_LINE_DFR_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Contract Liability Amt |
| 81 | TOT_LINE_UAR_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Contract Asset Amount |
| 82 | TOT_DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amt |
| 83 | TOT_SURCHARGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amt |
| 84 | TOT_DISCOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Discount Amount |
| 85 | TOT_SURCHARGE_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amount |
| 86 | TOT_DISCOUNT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Discount Amount |
| 87 | TOT_SURCHARGE_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amount |
| 88 | LINE_DST_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Revenue Sequence Number
Default Value: 1 |
| 89 | LINE_DFR_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Deferred Sequence Number
Default Value: 1 |
| 90 | LINE_UAR_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Unbilled AR Sequence Number
Default Value: 1 |
| 91 | LAST_NOTE_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Last note sequence number
Default Value: 1 |
| 92 | ENTRY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
Prompt Table: %EDITTABLE14 |
| 93 | ENTRY_REASON | Character(5) | VARCHAR2(5) NOT NULL |
"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
Prompt Table: %EDITTABLE15 |
| 94 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged |
| 95 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL |
Specifies the purchase order number associated with a receivables item.
Default Value: BI_HDR.PO_REF |
| 96 | PO_LINE | Number(3,0) | SMALLINT NOT NULL | Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF. |
| 97 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
| 98 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL |
Contract
Default Value: BI_HDR.CONTRACT_NUM |
| 99 | CONTRACT_DT | Date(10) | DATE |
Contract Date
Default Value: BI_HDR.CONTRACT_DT |
| 100 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Contract Type
Default Value: BI_HDR.CONTRACT_TYPE |
| 101 | BILL_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Billing Plan ID |
| 102 | BPLAN_LN_NBR | Number(3,0) | SMALLINT NOT NULL | Bill Plan Line Number |
| 103 | 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. |
| 104 | XREF_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Cross Reference Sequence No. |
| 105 | CONTRACT_PPD_SEQ | Number(5,0) | INTEGER NOT NULL | Prepaid Add Sequence |
| 106 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL |
Order Management Business Unit
Default Value: BI_HDR.BUSINESS_UNIT_OM Prompt Table: SP_BU_OM_NONVW |
| 107 | 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
Default Value: BI_HDR.ORDER_NO Prompt Table: BI_ORD_HDR_VW |
| 108 | ORDER_DATE | Date(10) | DATE |
Date Initials Issue Description
022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Default Value: BI_HDR.ORDER_DATE |
| 109 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 110 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 111 | BUSINESS_UNIT_RMA | Character(5) | VARCHAR2(5) NOT NULL |
RMA Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 112 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table: BI_RMA_HDR_VW |
| 113 | RMA_LINE_NBR | Number(5,0) | INTEGER NOT NULL | RMA Line Number |
| 114 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL |
Product ID
Prompt Table: BI_PROD_ITEM_VW |
| 115 | DIST_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Configuration
Default Value: N |
| 116 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Default Value: BI_HDR.FREIGHT_TERMS Prompt Table: %EDITTABLE10 |
| 117 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL |
Specifies a bill of lading number associated with a Receivables item.
Default Value: BI_HDR.BILL_OF_LADING |
| 118 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Default Value: BI_HDR.SHIP_TO_CUST_ID Prompt Table: %EDITTABLE7 |
| 119 | SHIP_TO_ADDR_NUM | Number(5,0) | INTEGER NOT NULL |
Ship To Address Sequence Num
Prompt Table: BI_SHP_ADDR_VW |
| 120 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shipping ID
Default Value: BI_HDR.SHIP_ID |
| 121 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Default Value: BI_HDR.SHIP_TYPE_ID Prompt Table: %EDITTABLE11 |
| 122 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL |
Ship from INV BU
Default Value: BI_HDR.SHIP_FROM_BU |
| 123 | SHIP_DATE | Date(10) | DATE | Item Shipping Date |
| 124 | SHIP_TIME | Time(15) | TIMESTAMP | Ship Time |
| 125 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 126 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Default Value: BI_HDR.SOLD_TO_CUST_ID Prompt Table: BI_SOLD_TO_VW |
| 127 | SOLD_TO_ADDR_NUM | Number(5,0) | INTEGER NOT NULL |
Sold To Address Sequence Num
Prompt Table: BI_SLD_ADDR_VW |
| 128 | RESOURCE_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction ID |
| 129 | ACTIVITY_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason Default Value: BI_HDR.ACTIVITY_TYPE |
| 130 | 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. |
| 131 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: BI_HDR.EMPLID |
| 132 | SSN | Character(9) | VARCHAR2(9) NOT NULL |
Social Security #
Default Value: BI_HDR.SSN |
| 133 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 134 | SERVICE_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Service Customer ID
Default Value: BI_HDR.SERVICE_CUST_ID Prompt Table: CUSTOMER |
| 135 | SERVICE_ADDR_NUM | Number(5,0) | INTEGER NOT NULL |
Service Address Num
Default Value: BI_HDR.SERVICE_ADDR_NUM Prompt Table: BI_SVC_ADDR_VW |
| 136 | START_DT | Date(10) | DATE |
Start Date
Default Value: BI_HDR.START_DT |
| 137 | END_DT | Date(10) | DATE |
End Date
Default Value: BI_HDR.END_DT |
| 138 | ACCUMULATE | Character(1) | VARCHAR2(1) NOT NULL |
Include in Cumulative Balance
Y/N Table Edit Default Value: Y |
| 139 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
| 140 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 141 | BUSINESS_UNIT_TO | Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
| 142 | IST_TXN_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Transaction Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 143 | IST_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Distribution Status
A=Awaiting Arrival Processing D=Distributed I=Ignored M=Archival Entry N=Not Distributed R=Reversal Entry S=Awaiting Dispatch Processing U=Undefined Default Value: U |
| 144 | INVENTORY_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Inventory Item
N=No Y=Yes |
| 145 | FISCAL_REGIME | Character(6) | VARCHAR2(6) NOT NULL | Fiscal Regime |
| 146 | NATURE_OF_TXN1 | Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 1 |
| 147 | NATURE_OF_TXN2 | Character(1) | VARCHAR2(1) NOT NULL | Nature of Transaction 2 |
| 148 | IDENTIFIER_TBL | Character(3) | VARCHAR2(3) NOT NULL |
Table Identifier
A=Asset ID CON=Contracts D=Discount Table G=Generic Identifier ID=PS/Billing Charge Id ITM=PS/Inventory Item ID LAB=Labor type PDA=Product Alias PRD=PS/Product Id PRM=PS/Promotion Code S=Surcharge Table SVC=Service UPC=UPC UPN=Universal Item ID |
| 149 | PACKSLIP_NO | Character(22) | VARCHAR2(22) NOT NULL | Packing Slip Number |
| 150 | DEFER_DT | Date(10) | DATE | Defer Date |
| 151 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL | Price Promotion Code |
| 152 | MERCH_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Merchandising Type |
| 153 | LIST_PRICE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | List Price |
| 154 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table: EE_AR_CODE1_VW |
| 155 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 156 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL |
VAT Treatment
Prompt Table: BI_VT_TREAT_VW |
| 157 | VAT_SVC_SUPPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries 2=Buyer's Countries 3=Where Physically Performed |
| 158 | VAT_SERVICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport 2=Other 3=Electronics/Communication |
| 159 | VAT_DST_ACCT_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Specifies the accounting code associated with a VAT account type and with a VAT transaction. The accounting code determines when and how the transaction is distributed (posted) to the general ledger. |
| 160 | VAT_ADVPAY_FLG | Character(1) | VARCHAR2(1) NOT NULL | VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments |
| 161 | VOUCHER_STYLE | Character(4) | VARCHAR2(4) NOT NULL |
Voucher Style
ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher TMPL=Template Voucher |
| 162 | COUNTRY_LOC_BUYER | Character(3) | VARCHAR2(3) NOT NULL | Buyer's Location Country - May be either the VAT Entity or the Trading Partner |
| 163 | STATE_LOC_BUYER | Character(6) | VARCHAR2(6) NOT NULL | Buyer's Location State - May be either the VAT Entity or the Trading Partner |
| 164 | COUNTRY_LOC_SELLER | Character(3) | VARCHAR2(3) NOT NULL | Seller's Location Country - May be either the VAT Entity or the Trading Partner |
| 165 | STATE_LOC_SELLER | Character(6) | VARCHAR2(6) NOT NULL | Seller's Location State - May be either the VAT Entity or the Trading Partner |
| 166 | COUNTRY_VAT_SUPPLY | Character(3) | VARCHAR2(3) NOT NULL | VAT Place of Supply Country |
| 167 | STATE_VAT_SUPPLY | Character(6) | VARCHAR2(6) NOT NULL | VAT Place of Supply State |
| 168 | COUNTRY_VAT_PERFRM | Character(3) | VARCHAR2(3) NOT NULL | Country Where Service Physically Performed |
| 169 | STATE_VAT_PERFRM | Character(6) | VARCHAR2(6) NOT NULL | State Where Service Physically Performed |
| 170 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 171 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 172 | EXD_CUST_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Customer Category Code |
| 173 | STX_CUST_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Customer Category Code |
| 174 | VAT_DFLT_DONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Defaulting Done
N=Awaiting Defaulting X=Do not default Y=Defaulting Done |
| 175 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 176 | QTY_BASE | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Base Quantity |
| 177 | EXD_INVOICE_NO | Character(10) | VARCHAR2(10) NOT NULL | Excise Invoice Number |
| 178 | EXD_INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Excise Invoice Line Number |
| 179 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 180 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL | Organization Code. This will be unique to an Organization. |
| 181 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code. An Organization can have multiple Tax Location Codes. |
| 182 | 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. |
| 183 | STX_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sales Tax Applicability. |
| 184 | EXS_DFLTS_APPLIED | Character(1) | VARCHAR2(1) NOT NULL |
Excise Defaults Applied Flag
N=Defaults have not been applied X=Non-India Bill-Not Applicable Y=Defaults have been applied |
| 185 | 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 |
| 186 | STX_TAX_AUTH_CD | Character(8) | VARCHAR2(8) NOT NULL | Tax Authority Code |
| 187 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 188 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 189 | EXD_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Item Category Code |
| 190 | STX_ITM_CATG_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Item Category Code |
| 191 | EXS_SERV_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Service Tax Indicator
N=Not Service Tax Y=Service Tax |
| 192 | STX_FORM_CD | Character(8) | VARCHAR2(8) NOT NULL | Form Code |
| 193 | FORM_DISTRIB_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Used for Sales Tax Forms tracking
D=Distributed I=Ignore N=Not Distributed U=Undefined |
| 194 | EXD_ASSESS_VALUE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Assessable Value |
| 195 | EXD_UOM | Character(3) | VARCHAR2(3) NOT NULL | Excise Unit Of Measure |
| 196 | EXD_CONVERSION_RT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |
| 197 | EXD_USE_AV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Excise Use Av Flag |
| 198 | EXD_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Excise Tax Calculation Code |
| 199 | EXD_TAX_RATE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Excise Tax Rate Source
1=System Defined 2=Manually Entered |
| 200 | EXD_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Tax Amount |
| 201 | EXD_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty in Base Currency |
| 202 | EXD_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Duty Amt In Rpt Curr |
| 203 | STX_TAX_RATE_CD | Character(10) | VARCHAR2(10) NOT NULL | Sales Tax Calculation Code |
| 204 | STX_TAX_RATE_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Tax Rate Source
1=System Defined 2=Manually Entered |
| 205 | STX_TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 206 | STX_TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN BASE CURR |
| 207 | STX_TAX_AMT_RPT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SALES TAX IN REPORT CURR |
| 208 | EXS_CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Excise Currency Reporting |
| 209 | BUSINESS_UNIT_AMTO | Character(5) | VARCHAR2(5) NOT NULL | Asset Business Unit To |
| 210 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 211 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 212 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 213 | COUNTRY_VAT_BILLFR | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). |
| 214 | COUNTRY_VAT_BILLTO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). |
| 215 | STATE_VAT_DEFAULT | Character(6) | VARCHAR2(6) NOT NULL | VAT Defaulting State |
| 216 | LANG_DESCR_OVR | Character(3) | VARCHAR2(3) NOT NULL | Language of Descr Override |
| 217 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 218 | BUSINESS_UNIT_RF | Character(5) | VARCHAR2(5) NOT NULL | Field Services Business Unit |
| 219 | SOURCE_REF_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Generice reference type
001=CRM Agreement 002=CRM Case 003=CRM Order 004=CRM Service Order 005=Accounts Receivable 006=Billing 007=Order Management |
| 220 | SOURCE_REF_NO | Character(35) | VARCHAR2(35) NOT NULL | Generic reference number |
| 221 | SOURCE_REF_KEY | Character(5) | VARCHAR2(5) NOT NULL | Additional key for generic reference. May be populated with business unit, setid, or other key value. |
| 222 | CA_PGP_SEQ | Number(3,0) | SMALLINT NOT NULL | Progress Payment Sequence |
| 223 | SUM_TEMPLATE_ID | Character(16) | VARCHAR2(16) NOT NULL | Summarization Template ID |
| 224 | SUM_GROUP_ID | Character(16) | VARCHAR2(16) NOT NULL | This field is used to provide additional grouping criteria for billing summarization. It is to be used with SUM_GROUP_TYPE. User defines a set of Summarization Group IDs per Summarization Group Type. |
| 225 | SUM_GROUP_TYPE | Character(4) | VARCHAR2(4) NOT NULL | This field is used to provide additional grouping criteria for billing summarization. It is related to SUM_GROUP_ID. User defines a list of valid SUM_GROUP_IDs per SUM_GROUP_TYPE value. |
| 226 | CUST_DEPOSIT_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer Deposit ID |
| 227 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: %EDIT_BU_PC |
| 228 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDIT_PROJECT |
| 229 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: %EDIT_ACTIVITY |
| 230 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
|
| 231 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
| 232 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
| 233 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
|
| 234 | USER_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 235 | USER_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies an additional amount associated with a pending item. This field is customizable and user-defined and is one of eight user amount fields. (USER_AMT1 through USER_AMT8) |
| 236 | USER_AMT1_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 1 |
| 237 | USER_AMT2_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 2 |
| 238 | USER_AMT1_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 1 |
| 239 | USER_AMT2_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 2 |
| 240 | USER_DT1 | Date(10) | DATE | Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4). |
| 241 | USER_DT2 | Date(10) | DATE | Specifies an additional date associated with a pending receivables item. This field is customizable and user-defined and is one of four user date fields (USER_DT1 through USER_DT4). |
| 242 | 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). |
| 243 | 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). |
| 244 | 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). |
| 245 | 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). |
| 246 | 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). |
| 247 | USER6 | 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). |
| 248 | USER7 | 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). |
| 249 | USER8 | 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). |
| 250 | USER9 | 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). |
| 251 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 252 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 253 | 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. |
| 254 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 255 | OFAC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked C=Cleared R=Review V=Valid Default Value: V |
| 256 | SDN_PUBLISH_DATE | Date(10) | DATE | Publish date given on the loaded Financial Sanction list. |
| 257 | FSS_ACTIVITY_DT | Date(10) | DATE | EGS 03/02/06: Created |
| 258 | FSS_USER_OVR | Character(1) | VARCHAR2(1) NOT NULL |
User Override
A=Customer Name has Overriden N=No Customer Information Change Y=Customer Information Changed Default Value: N |
| 259 | CUSTOMER_PO_LINE | Character(11) | VARCHAR2(11) NOT NULL | Customer PO Line |
| 260 | CUSTOMER_PO_SCHED | Character(11) | VARCHAR2(11) NOT NULL | Customer PO Schedule |
| 261 | PC_CF_CHANGE_FLG | Character(1) | VARCHAR2(1) NOT NULL | An indicator to flag whether the Project chartfields were updated on a billing line. |
| 262 | CREDIT_REASON | Character(10) | VARCHAR2(10) NOT NULL | Adjustment Reason |
| 263 | VAT_RVRSE_CHG_GDS | Character(1) | VARCHAR2(1) NOT NULL |
VAT Reverse Charge goods flag
Y/N Table Edit |
| 264 | TAX_CD_VAT_RVC | Character(8) | VARCHAR2(8) NOT NULL | Reverse Charge VAT Code |
| 265 | TAX_CD_VAT_RVC_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Customer VAT Rate |
| 266 | VAT_AMT_RVC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Reverse Charge VAT Amount |
| 267 | VAT_AMT_RVC_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Reverse Charge Amount in Base Currency |
| 268 | VAT_AMT_RVC_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Customer Amount |
| 269 | TEMP_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Temporary Invoice |
| 270 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |