ORG_BU_TAX_APPL(SQL Table) |
Index Back |
|---|---|
Applicability against BU |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ORG_BU_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Business Unit Type. This field will have six translate values representing the various BUs
AP=Payables AR=Receivables BI=Billing IN=Inventory OM=Order Management PO=Purchasing |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: %RECNAME_EDIT |
| 3 | ORG_SETID | Character(5) | VARCHAR2(5) NOT NULL | Organization SetID. |
| 4 | ORG_CODE | Character(6) | VARCHAR2(6) NOT NULL |
Organization Code. This will be unique to an Organization.
Prompt Table:
ORG_BU_VW
|
| 5 | ORG_TAX_LOC_CD | Character(10) | VARCHAR2(10) NOT NULL |
Tax Location Code. An Organization can have multiple Tax Location Codes.
Prompt Table:
ORG_BU_LOC_VW
|
| 6 | STX_OTC_APPL | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax (Sales) Applicable
Y/N Table Edit Default Value: N |
| 7 | STX_PTP_APPL | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax (Purchase) Applicable
Y/N Table Edit Default Value: N |
| 8 | EXD_OTC_APPL | Character(1) | VARCHAR2(1) NOT NULL |
Excise (Sales). This field is used in the Business Tax Applicability
Y/N Table Edit Default Value: N |
| 9 | EXD_PTP_APPL | Character(1) | VARCHAR2(1) NOT NULL |
Excise (Purchase).This field is used in the Business Tax Applicability
Y/N Table Edit Default Value: N |
| 10 | CSD_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Customs Duty applicable flag
Y/N Table Edit Default Value: N |
| 11 | EINV_EXCLUDE | Character(1) | VARCHAR2(1) NOT NULL |
Exclude from E-Invoicing
Y/N Table Edit Default Value: N |