BI_HDR2_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BI_HDR |
| # | 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
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_BI_NONVW |
| 3 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL |
Invoice
Default Value: NEXT Prompt Table: BI_HDR |
| 4 | 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 Default Value: REG |
| 5 | CONSOL_HDR | Character(1) | VARCHAR2(1) NOT NULL |
Consolidated Hdr?
N=No Y=Yes Y/N Table Edit Default Value: N |
| 6 | CONSOL_KEY | Character(22) | VARCHAR2(22) NOT NULL |
Invoice Consolidation Key
Default Value: CUST_OPTION.CONSOL_KEY |
| 7 | CONSOL_SETID | Character(5) | VARCHAR2(5) NOT NULL | Consolidation Customer SetID |
| 8 | CONSOL_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Consolidation Customer ID |
| 9 | CONSOL_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Billing business unit associated with a consolidated bill. |
| 10 | CONSOL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Specifies the invoice identifier associated with a consolidated bill. |
| 11 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 12 | PRIOR_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Adjusted Invoice |
| 13 | NEXT_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Adjusting Invoice |
| 14 | LATEST_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Latest Invoice |
| 15 | ADJUSTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Adjusted Flag
H=Header Level Adjustment L=Line Level Adjustment N=No Adjustments Default Value: N |
| 16 | BILL_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Bill Type Identifier
Prompt Table: BI_TYPE_EF_VW |
| 17 | BILL_SOURCE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Bill Source
Prompt Table: BI_SRC_EF_VW |
| 18 | BILL_CYCLE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Billing Cycle Identifier
Prompt Table: BI_CYCLE_VW |
| 19 | BILL_BY_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill By Identifier |
| 20 | HDR_FIELDS_KEY | Character(30) | VARCHAR2(30) NOT NULL | Header Fields Key |
| 21 | BILLING_FREQUENCY | Character(3) | VARCHAR2(3) NOT NULL |
Billing Frequency
INS=Installment ONC=Once REC=Recurring Default Value: ONC |
| 22 | TEMPLATE_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Template Invoice Flag
I=Installment Bill N=No R=Recurring Bill Y/N Table Edit Default Value: N |
| 23 | TEMPLATE_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Template Invoice ID |
| 24 | RECURRING_START_DT | Date(10) | DATE | Starting Date |
| 25 | RECURRING_END_DT | Date(10) | DATE | Ending Date |
| 26 | AUTO_GEN_IVC_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Pre-Assign Invoice Numbers
Y/N Table Edit Default Value: N |
| 27 | FROM_DT | Date(10) | DATE | From Date |
| 28 | TO_DT | Date(10) | DATE | To Date |
| 29 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: %EDITTABLE3 |
| 30 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: CUST_ADDR_BI_VW |
| 31 | BILL_TO_COPIES | Number(3,0) | SMALLINT NOT NULL |
Number of Copies
Default Value: 1 |
| 32 | BILL_TO_MEDIA | Character(1) | VARCHAR2(1) NOT NULL |
Bill To Media
A=Email Invoice as Attachment E=EDI H=Federal Highway File N=Email Notification P=Print Copy X=Electronic Invoice File Default Value: P |
| 33 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Contact Sequence Number
Prompt Table: CUST_CNCT_EF_VW |
| 34 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 35 | BUSINESS_UNIT_TO | Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
| 36 | CR_CARD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Flag
Y/N Table Edit Default Value: N |
| 37 | 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.
Prompt Table: SUBCUST_Q1_TBL |
| 38 | 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.
Prompt Table: SUBCUST_Q2_TBL |
| 39 | BILL_INQUIRY_PHONE | Character(24) | VARCHAR2(24) NOT NULL |
Bill Inquiry Phone
Prompt Table: BI_INQPHONE_VW |
| 40 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL |
Billing Specialist
Prompt Table: BI_SPECIALST_VW |
| 41 | BILLING_AUTHORITY | Character(8) | VARCHAR2(8) NOT NULL | Billing Authority |
| 42 | COLLECTOR | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to collect overdue payments.
Default Value: CUST_OPTION.COLLECTOR Prompt Table: COLLECTOR_TBL |
| 43 | SALES_PERSON | Character(8) | VARCHAR2(8) NOT NULL | Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer. |
| 44 | CR_ANALYST | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
Default Value: CUST_OPTION.CR_ANALYST Prompt Table: CR_ANALYST_TBL |
| 45 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
Prompt Table: AR_TRMS_VW |
| 46 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_BI_BR_VW |
| 47 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table: BI_BANK_R_VW |
| 48 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 49 | 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. " |
| 50 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL | Euro Currency |
| 51 | FINAL_CURCNV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Final Currency Conversion Flag
Y/N Table Edit Default Value: N |
| 52 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 53 | CUR_RT_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Exchange Rate Source
T=Use Exchange Rate Tables U=User Specified Default Value: T |
| 54 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 55 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
| 56 | RATE_MULT_XEU | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 57 | RATE_DIV_XEU | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
| 58 | RATE_MULT_IU | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 59 | RATE_DIV_IU | Number(16,8) | DECIMAL(15,8) NOT NULL |
Rate Divisor
Default Value: 1 |
| 60 | RATE_DATE | Date(10) | DATE | Exchange Rate Date |
| 61 | BI_PAID_AT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Bill Paid at Source Indicator
0=Unpaid 1=Customer Deposit Applied 2=Partially Paid 9=Fully Paid |
| 62 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 63 | FORWARD_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Forwarding Balance |
| 64 | INVOICE_AMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 65 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 66 | PAID_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Paid Amount |
| 67 | FORWARD_BAL_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Forwarding Balance |
| 68 | INVOICE_PRETAX_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 69 | INVOICE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 70 | FORWARD_BAL_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Forwarding Balance |
| 71 | INVOICE_PRETAX_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 72 | INVOICE_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 73 | PAID_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Euro Paid Amount |
| 74 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 75 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 76 | DT_INVOICED | Date(10) | DATE | Date Invoiced |
| 77 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 78 | INVOICE_FORM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Invoice Form
Prompt Table: BI_IVC_FORM_VW |
| 79 | IVC_PRINTED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Printed
N=Not Printed R=Printed as Rebill Y=Printed Y/N Table Edit Default Value: N |
| 80 | IVC_PRINTED_DT | Date(10) | DATE | Invoice Printed Date |
| 81 | EDI_SENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
EDI Sent Flag
Y/N Table Edit Default Value: N |
| 82 | CF_ACTION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Chartfield Action Flag
Y/N Table Edit Default Value: N |
| 83 | PRELOAD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Billing: Used to indicate the status of the invoice with regard to the PreLoad Process (BIPRELD).
1=Pending - Invoices ready to be processed
2=Done - Invoices processed with no errors
3=ComboEdit Error - Invoices contain combo edit error
1=Pending 2=Done 3=ComboEdit Error Default Value: 1 |
| 84 | 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: %EDITTABLE12 |
| 85 | 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: %EDITTABLE13 |
| 86 | AR_LVL | Character(1) | VARCHAR2(1) NOT NULL |
AR Level
H=Header is AR Open Item L=Bill Line is AR Open Item N=No AR Open Items |
| 87 | AR_DST_OPT | Character(1) | VARCHAR2(1) NOT NULL |
AR Distribution Option
H=Use Header for Distribution L=Use Line for Distribution |
| 88 | AR_ENTRY_CREATED | Character(1) | VARCHAR2(1) NOT NULL |
AR Accounting Entry Created
Y/N Table Edit Default Value: N |
| 89 | GEN_AR_ITEM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Generate AR Open Item |
| 90 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: BUS_UNIT_TBL_BI.BUSINESS_UNIT_GL |
| 91 | GL_LVL | Character(1) | VARCHAR2(1) NOT NULL |
GL Level
A=AR Creates GL Acct Entries B=BI Creates GL Acct Entries N=No GL Accounting Entries |
| 92 | GL_ENTRY_CREATED | Character(1) | VARCHAR2(1) NOT NULL |
GL Accounting Entry Created
Y/N Table Edit Default Value: N |
| 93 | ENABLE_DFR_REV_FLG | Character(1) | VARCHAR2(1) NOT NULL | Enable Deferred Revenues |
| 94 | DFR_ACCTG_DT_CD | Character(1) | VARCHAR2(1) NOT NULL |
Future Period Accounting Dates
F=First Day in Accounting Period L=Last Day in Accounting Period U=User Defined |
| 95 | DFR_REV_PRORATION | Character(1) | VARCHAR2(1) NOT NULL |
Proration Method
1=By Days Within Range 2=Evenly Using All Pds 3=Evenly Using Mid-period Rule 4=Evenly/Partial by Days 5=User Defined Proration Method |
| 96 | DFR_MID_PERIOD_DAY | Number(2,0) | SMALLINT NOT NULL | Mid-Period # of Days |
| 97 | DST_ID_DFR | Character(10) | VARCHAR2(10) NOT NULL | Deferred Distribution Code |
| 98 | BILL_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Bill Status
CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill Default Value: NEW |
| 99 | BILL_STATUS_TEXT | Character(12) | VARCHAR2(12) NOT NULL | Bill Status Text |
| 100 | MANUAL_LIN_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Enable Manual Line Numbering |
| 101 | LAST_LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Last Line Sequence Number
Default Value: 1 |
| 102 | LAST_LINE_AAUX_SEQ | Number(5,0) | INTEGER NOT NULL | Last Line Seq Num in Adj Aux |
| 103 | LAST_NOTE_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Last note sequence number
Default Value: 1 |
| 104 | ACCRUE_UNBILLED | Character(1) | VARCHAR2(1) NOT NULL |
Accrue Bills of This Level
Y/N Table Edit Default Value: N |
| 105 | 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.
Prompt Table: BI_DOC_TYPE_VW |
| 106 | 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. |
| 107 | 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. |
| 108 | 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 |
| 109 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 110 | BUSINESS_UNIT_CA | Character(5) | VARCHAR2(5) NOT NULL | Contracts Business Unit |
| 111 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 112 | CONTRACT_LINE_NUM | Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 113 | CONTRACT_DT | Date(10) | DATE | Contract Date |
| 114 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 115 | DIRECT_INVOICING | Character(1) | VARCHAR2(1) NOT NULL |
Direct Invoicing
Default Value: N |
| 116 | BUSINESS_UNIT_OM | Character(5) | VARCHAR2(5) NOT NULL |
Order Management Business Unit
Prompt Table: SP_BU_OM_NONVW |
| 117 | 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
Prompt Table: BI_ORD_HDR_VW |
| 118 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL |
RMA Number
Prompt Table: BI_RMA_HDR_VW |
| 119 | ORDER_DATE | Date(10) | DATE | Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 120 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Prompt Table: %EDITTABLE10 |
| 121 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 122 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: %EDITTABLE2 |
| 123 | SHIP_TO_ADDR_NUM | Number(5,0) | INTEGER NOT NULL |
Ship To Address Sequence Num
Prompt Table: BI_SHP_ADDR_VW |
| 124 | SHIP_ID | Character(10) | VARCHAR2(10) NOT NULL | Shipping ID |
| 125 | SHIP_TYPE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship Via Code
Prompt Table: %EDITTABLE11 |
| 126 | SHIP_FROM_BU | Character(5) | VARCHAR2(5) NOT NULL | Ship from INV BU |
| 127 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Sold To Customer
Prompt Table: BI_SOLD_TO_VW |
| 128 | SOLD_TO_ADDR_NUM | Number(5,0) | INTEGER NOT NULL |
Sold To Address Sequence Num
Prompt Table: BI_SLD_ADDR_VW |
| 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 |
| 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 | RANGE_SELECTION_ID | Character(30) | VARCHAR2(30) NOT NULL | Range Selection ID |
| 132 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 133 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 134 | SERVICE_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Service Customer ID
Prompt Table: CUSTOMER |
| 135 | SERVICE_ADDR_NUM | Number(5,0) | INTEGER NOT NULL |
Service Address Num
Prompt Table: BI_SVC_ADDR_VW |
| 136 | START_DT | Date(10) | DATE | Start Date |
| 137 | END_DT | Date(10) | DATE | End Date |
| 138 | ERROR_STATUS_BI | Character(4) | VARCHAR2(4) NOT NULL | Error Status |
| 139 | COUNTRY_SHIP_TO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country to which the invoice contents were shipped (for VAT processing only). |
| 140 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
Prompt Table: COUNTRY_TBL |
| 141 | GEN_AP_VCHR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Generate AP Voucher
Y/N Table Edit Default Value: N |
| 142 | AP_CREATED_DT | Date(10) | DATE | AP Voucher Created Date |
| 143 | DOC_SEQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status |
| 144 | EARLY_PY_DSCNT_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Early Pymnt Dscnt Percentage |
| 145 | DS_PY_TRMS_TIME_ID | Character(3) | VARCHAR2(3) NOT NULL | Discount Timing |
| 146 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 147 | MAX_TAX_FLG | Character(1) | VARCHAR2(1) NOT NULL |
max_tax_flg = 'Y' implies that max taxes were applied
Y/N Table Edit Default Value: N |
| 148 | TOT_SU_TAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales/Use Tax |
| 149 | TOT_SU_TAX_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales/Use Tax |
| 150 | TOT_SU_TAX_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales/Use Tax |
| 151 | TOT_VAT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 152 | TOT_VAT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 153 | TOT_VAT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 154 | TOT_VAT_BASIS | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Basis Amount |
| 155 | TOT_VAT_BASIS_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Basis Amount |
| 156 | TOT_VAT_BASIS_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Basis Amount |
| 157 | PAYMENT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |
| 158 | PACKSLIP_NO | Character(22) | VARCHAR2(22) NOT NULL | Packing Slip Number |
| 159 | LC_ID | Character(12) | VARCHAR2(12) NOT NULL | Treasury Letter of Credit Number Assigned by the System |
| 160 | LOC_DOC_ID | Character(30) | VARCHAR2(30) NOT NULL | Letter of Credit Document ID |
| 161 | PAID_REFERENCE | Character(30) | VARCHAR2(30) NOT NULL | Pre-payment Reference |
| 162 | PPRC_PROMO_CD | Character(20) | VARCHAR2(20) NOT NULL | Price Promotion Code |
| 163 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 164 | FAX | Character(24) | VARCHAR2(24) NOT NULL | Fax Number |
| 165 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 166 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table: EE_AR_CODE1_VW |
| 167 | REIMB_AGREEMENT | Character(25) | VARCHAR2(25) NOT NULL | Date Init. Issue # Description 09/25/01 JJM DI-EDWONG-17 Created field to replace CONTRACT_NUM in certain records |
| 168 | EXD_INVOICE_NO | Character(10) | VARCHAR2(10) NOT NULL | Excise Invoice Number |
| 169 | BI_BU_TAX_IND | Character(1) | VARCHAR2(1) NOT NULL |
Billing Business Unit Tax Flag
0=PS standard taxes/VAT 1=Third-party tax supplier 2=India taxes |
| 170 | STX_TAX_AUTH_CD | Character(8) | VARCHAR2(8) NOT NULL | Tax Authority Code |
| 171 | TOT_EXD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Excise Amount |
| 172 | TOT_EXD_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Excise Amount Base |
| 173 | TOT_STX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total ST/VAT Amount |
| 174 | TOT_STX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales Tax Amount Base |
| 175 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 176 | VAT_TREATMENT_GRP | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment Group |
| 177 | COUNTRY_VAT_BILLFR | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is generated (for VAT processing only). |
| 178 | COUNTRY_VAT_BILLTO | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country where an invoice is sent (for VAT processing only). |
| 179 | STATE_SHIP_TO | Character(6) | VARCHAR2(6) NOT NULL | Ship To State |
| 180 | STATE_SHIP_FROM | Character(6) | VARCHAR2(6) NOT NULL | Ship From State |
| 181 | REPRINT_GROUP_ID | Character(30) | VARCHAR2(30) NOT NULL | Reprint Group ID |
| 182 | MAST_CONTR_ID | Character(25) | VARCHAR2(25) NOT NULL | Master Contract # |
| 183 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 184 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 185 | BUSINESS_UNIT_RF | Character(5) | VARCHAR2(5) NOT NULL | Field Services Business Unit |
| 186 | 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 |
| 187 | SOURCE_REF_NO | Character(35) | VARCHAR2(35) NOT NULL | Generic reference number |
| 188 | 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. |
| 189 | ACCEPTGIRO_IND | Character(1) | VARCHAR2(1) NOT NULL | Field indicator that 'Invoice print will have Acceptgiro'. 'Y' indicates that Invoice has to be printed with Acceptgiro. 'N' indicates that Invoice has to be printed without Acceptgiro. |
| 190 | AG_REF_NBR | Number(16,0) | DECIMAL(16) NOT NULL | Payment Reference Number |
| 191 | IVC_DELIVERED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Delivered
Y/N Table Edit Default Value: N |
| 192 | IVC_DELIVERED_DT | Date(10) | DATE | Invoice Delivered Date |
| 193 | SUMMARIZE_IVC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Summarize Invoice Flag
Y/N Table Edit Default Value: N |
| 194 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: %EDIT_BU_PC |
| 195 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: %EDIT_PROJECT |
| 196 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: %EDIT_ACTIVITY |
| 197 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
|
| 198 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
|
| 199 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
|
| 200 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
|
| 201 | ATT_IVC_IMG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Attach Invoice Image
Y/N Table Edit |
| 202 | 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) |
| 203 | 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) |
| 204 | USER_AMT1_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 1 |
| 205 | USER_AMT2_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 2 |
| 206 | USER_AMT1_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 1 |
| 207 | USER_AMT2_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | User Amt 2 |
| 208 | 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). |
| 209 | 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). |
| 210 | 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). |
| 211 | 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). |
| 212 | 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). |
| 213 | 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). |
| 214 | 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). |
| 215 | 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). |
| 216 | 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). |
| 217 | 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). |
| 218 | 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). |
| 219 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 220 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 221 | 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. |
| 222 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 223 | BILL_FSS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Confirmed
B=Blocked C=Cleared R=Review V=Valid Default Value: V |
| 224 | OFAC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked C=Cleared R=Review V=Valid Default Value: V |
| 225 | SDN_PUBLISH_DATE | Date(10) | DATE | Publish date given on the loaded Financial Sanction list. |
| 226 | FSS_ACTIVITY_DT | Date(10) | DATE | EGS 03/02/06: Created |
| 227 | FSS_CLEAR_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Clearing Operator |
| 228 | 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 |
| 229 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL | Reason Code |
| 230 | REASON_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Reason Type |
| 231 | PUBLIC_VOUCHER_NBR | Number(6,0) | INTEGER NOT NULL | Public Voucher Number |
| 232 | PVN_GEN_LVL | Character(2) | VARCHAR2(2) NOT NULL |
PVN Generation Level field used to store the Level on which a Public Voucher needs to be generated for a contract
C=Contract Number CL=Contract Number/Contract Line CP=Contract Number/Project |
| 233 | FINAL_FF_EXT_IND | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether a Final run of the Federal Highway Extract File process has taken place for an invoice.
N=No Y=Yes Y/N Table Edit Default Value: N |
| 234 | EIVC_COPY_IND | Character(1) | VARCHAR2(1) NOT NULL |
E-Invoice Copy Indicator
N=Original Elec Invoice File O=Cannot Generate EIVC File Y=Copy Electronic Invoice File |
| 235 | TARGET_PYMT_DT | Date(10) | DATE | The Target Payment Date on the final run of the Federal Highway Extract File process for an invoice. |
| 236 | HOLD_UNTIL_DT | Date(10) | DATE | Hold Until Date |
| 237 | BI_APPROVAL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Status
0=Not Required 1=Initial 2=Pending 3=Approved 4=Denied 5=Canceled |
| 238 | TOT_VAT_RVC | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 239 | TOT_VAT_RVC_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Amount |
| 240 | TOT_VAT_RVC_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total VAT Reverse Charge Amt |
| 241 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 242 | CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 243 | BI_CREATE_PROC | Character(2) | VARCHAR2(2) NOT NULL |
Created By Process
00=Billing Interface 01=Worksheet Online 02=Worksheet Batch 20=Standard Billing 21=Express Billing 22=Consolidated Billing 23=Single Bill Copy 24=Adjust Entire Bill 25=Adjust Line 40=Installment Bill 41=Recurring Bill 42=Copy Bill Group |
| 244 | BI_AP_LVL | Character(1) | VARCHAR2(1) NOT NULL |
InterUnit AP Level
H=Header is AP Voucher L=Bill Line is AP Voucher N=No AP Voucher |