BO_IDROLE_TYPE_IDSETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CUST_IDPrompt Table: CUSTOMER
COUNTRYDefault Value: COUNTRY_TBL.COUNTRY_2CHAR
Y/N Table Edit
Default Value: N
BO_VAT_REG(SQL Table) |
Index Back |
|---|---|
Customer VAT RegistrationVAT Registration Record for Business Object |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID |
| 2 | ROLE_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL | Role Type ID |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 4 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Customer ID
Prompt Table: CUSTOMER |
| 5 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | VAT_RGSTRN_ID | Character(12) | VARCHAR2(12) NOT NULL | VAT Registration ID, this field is brought from FSCM database for the VAT Integration of Customer Details |
| 7 | COUNTRY_2CHAR | Character(2) | VARCHAR2(2) NOT NULL |
2-Char Country Code
Default Value: COUNTRY_TBL.COUNTRY_2CHAR |
| 8 | HOME_COUNTRY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Home Country, this field is brought from FSCM database for the VAT Integration of Customer
Y/N Table Edit Default Value: N |
| 9 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | This field determines the last user or operator that last changed this item. |
| 10 | DATE_LAST_MAINT | Date(10) | DATE | This field determines the date of last maintenance. |