PROCESS_INSTANCEB=Business Unit
O=Bill Source
S=System
T=Bill Type
U=User Defined
BI_CPYGRP_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BILL_CPY_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Bill Copy Group ID |
| 3 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | BI_HDR_FROM_DT | Date(10) | DATE | Bill Header From Date |
| 5 | BI_HDR_TO_DT | Date(10) | DATE | Bill Header To Date |
| 6 | BI_LINE_FROM_DT | Date(10) | DATE | Bill Line From Date |
| 7 | BI_LINE_TO_DT | Date(10) | DATE | Bill Line To Date |
| 8 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 9 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 10 | INVOICE_NUMBERING | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Numbering Option
B=Business Unit O=Bill Source S=System T=Bill Type U=User Defined |
| 11 | IVC_NUM_ID | Character(8) | VARCHAR2(8) NOT NULL | Invoice Number ID |
| 12 | MANUAL_LIN_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL | Enable Manual Line Numbering |
| 13 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 14 | TEMPLATE_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Template Invoice ID |
| 15 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 16 | 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. " |
| 17 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 18 | ERROR_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | Error Count |
| 19 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 20 | BI_APPROVAL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Enable Invoice Approvals |
| 21 | ONLY_APPR_CREDITS | Character(1) | VARCHAR2(1) NOT NULL | Only Submit Credits |
| 22 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 23 | HOLD_NBR_DAYS | Number(3,0) | SMALLINT NOT NULL | Hold Number of Days |
| 24 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 25 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL | Identifier |
| 26 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Billing Currency Code |