ITA_BU_LIST(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | 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 |
|
2 | Character(4) | VARCHAR2(4) NOT NULL |
Product
AR=Receivables BILL=Billing VCHR=Payables |
|
3 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: ITA_BU_GL_VW |
|
4 | ITA_TOURISM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Tourism
N=No Y=Yes Default Value: N |
5 | ITA_UTILITY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Utility
N=No Y=Yes Default Value: N |