BILL_TO_CUST_IDPrompt Table: CUST_BI_A2_VW
VAT_ENTITYPrompt Table: VAT_ENTITY
Default Value: BI_HDR.BI_CURRENCY_CD
BI_VAT_RPL2_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT BILL_TO_CUST_ID ,PROCESS_INSTANCE ,VAT_ENTITY ,BI_PROGRESSIVE_ID , INVOICE , BI_TIPO_DOC ,BI_CURRENCY_CD ,INVOICE_DT ,BI_REF_NUM ,BI_NUM_ITEM FROM PS_BI_VAT_RPT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BILL_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Customer
Prompt Table: CUST_BI_A2_VW |
| 2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | 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.
Prompt Table: VAT_ENTITY |
| 4 | BI_PROGRESSIVE_ID | Character(5) | VARCHAR2(5) NOT NULL | Progressive ID |
| 5 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 6 | BI_TIPO_DOC | Character(4) | VARCHAR2(4) NOT NULL | TipoDocumento |
| 7 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD |
| 8 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 9 | BI_REF_NUM | Character(4) | VARCHAR2(4) NOT NULL | Reference Number |
| 10 | BI_NUM_ITEM | Character(20) | VARCHAR2(20) NOT NULL | NumItem |