BI_HDR_EC_TAO(SQL Table) |
Index Back |
|---|---|
Bill Header data in EDI |
| # | 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 | ECTRANSID |
Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 4 | ECTRANSINOUTSW |
Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
| 5 | ECQUEUEINSTANCE | Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 6 | ECPRIEVTCD | Character(6) | VARCHAR2(6) NOT NULL | Electronic Commerce Primary Event Codes (or Purpose codes) - specify the status of the transaction. New, Cancellation, duplicate, etc. Every transaction has a primary code assigned to it. Used in EDI Manager. |
| 7 | ECSECEVTCD | Character(10) | VARCHAR2(10) NOT NULL | Electronic Commerce Secondary Event Codes (or transaction codes) - specify the type of transaction in detail. Used in EDI Manager. This could indicate a rush order, catalog order, or request for a sample. Not all transaction types include secondary codes. |
| 8 | 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. |
| 9 | FROM_DT | Date(10) | DATE | From Date |
| 10 | TO_DT | Date(10) | DATE | To Date |
| 11 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 12 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 13 | BILL_INQUIRY_PHONE | Character(24) | VARCHAR2(24) NOT NULL | Bill Inquiry Phone |
| 14 | BILLING_SPECIALIST | Character(8) | VARCHAR2(8) NOT NULL | Billing Specialist |
| 15 | 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. |
| 16 | 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. |
| 17 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 18 | 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 |
| 19 | PAID_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Paid Amount |
| 20 | PAID_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Euro Paid Amount |
| 21 | FORWARD_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Forwarding Balance |
| 22 | FORWARD_BAL_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Forwarding Balance |
| 23 | INVOICE_AMT_PRETAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 24 | INVOICE_PRETAX_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pretax Invoice Amount |
| 25 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 26 | INVOICE_AMT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 27 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 28 | 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. |
| 29 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |
| 30 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL | Euro Currency |
| 31 | ECENTITYCD | Character(8) | VARCHAR2(8) NOT NULL | PeopleSoft Entity Code |
| 32 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 33 | 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 |
| 34 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 35 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 36 | 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 |
| 37 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 38 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL | Freight Terms Code |
| 39 | TOT_SU_TAX | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales/Use Tax |
| 40 | TOT_SU_TAX_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Sales/Use Tax |