AR_BI_ITEM_VW(SQL View) |
Index Back |
|---|---|
View to map item to invoice |
| SELECT U.BUSINESS_UNIT_AR , A.BILL_TO_CUST_ID , A.INVOICE , C.INVOICE_LINE , A.AR_LVL , A.GL_LVL , A.GL_ENTRY_CREATED , A.BILLING_FREQUENCY , A.TEMPLATE_INVOICE , A.BUSINESS_UNIT FROM PS_BI_HDR A , PS_BI_LINE C , PS_BUS_UNIT_TBL_BI U WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.INVOICE = C.INVOICE AND A.BUSINESS_UNIT = U.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARDS_NONVW |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: AR_CCTRAN_C_VW |
| 3 | ITEM |
Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. |
| 4 | ITEM_LINE |
Number(6,0) | INTEGER NOT NULL | Item Line |
| 5 | 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 |
| 6 | 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 |
| 7 | GL_ENTRY_CREATED | Character(1) | VARCHAR2(1) NOT NULL | GL Accounting Entry Created |
| 8 | BILLING_FREQUENCY | Character(3) | VARCHAR2(3) NOT NULL |
Billing Frequency
INS=Installment ONC=Once REC=Recurring |
| 9 | TEMPLATE_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Template Invoice ID |
| 10 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |