PROJ_BILL_INFO(SQL Table) |
Index Back |
|---|---|
Project Billing InformationProject Billing Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL |
Billing Business Unit
Prompt Table: SP_BUPCBI_NONVW |
| 5 | SHIP_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Ship To Customer
Prompt Table: BI_SHIP_TO_VW |
| 6 | SHIP_TO_ADDR_NUM | Number(5,0) | INTEGER NOT NULL |
Ship To Address Sequence Num
Prompt Table: BI_SHP_ADDR_VW |
| 7 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: TAX_SU_HDR_VW |
| 8 | TAX_EXEMPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit Default Value: N |
| 9 | TAX_EXEMPT_CERT | Character(30) | VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table: CUST_EXEMPT_VW |
| 10 | TAX_EXEMPT_RC | Character(2) | VARCHAR2(2) NOT NULL |
Exempt Reason Code
01=Certificat |
| 11 | TAX_JOB_NUM | Character(10) | VARCHAR2(10) NOT NULL | Job Number |