PeopleSoft 9 Asset Management |
Table Name | BUS_UNIT_TBL_GL |
Table Description |
BUS_UNIT_TBL_GL |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | char(5) | Yes | No |
AS_OF_DATE | PSDATE | No | No |
BASE_CURRENCY | char(3) | No | No |
ELIMS_ONLY | char(1) | No | No |
JRNL_BALANCE_OPTN | char(1) | No | No |
JRNL_EDIT_ERR_OPTN | char(1) | No | No |
JRNL_AMT_ERR_OPTN | char(1) | No | No |
JRNL_DT_ERR_OPTN | char(1) | No | No |
JRNL_DT_ERR_OPTN2 | char(1) | No | No |
CONTROL_TOTAL_OPTN | char(1) | No | No |
CURRENCY_BAL_OPTN | char(1) | No | No |
BASE_CUR_ADJ_OPTN | char(1) | No | No |
JRNL_FOREIGN_OPTN | char(1) | No | No |
ENABLE_UNPOST_DT | char(1) | No | No |
JRNL_APPRVL_OPTN | char(1) | No | No |
BD_JRNL_APPR_OPTN | char(1) | No | No |
BUSPROCNAME | char(30) | No | No |
APPR_RULE_SET | char(30) | No | No |
BUSPROCNAME_BD | char(30) | No | No |
APPR_RULE_SET_BD | char(30) | No | No |
TR_RVL_RATE_INDEX | char(10) | No | No |
TR_RVL_RT_TYPE | char(5) | No | No |
INT_ENTITYCD | char(4) | No | No |
EXT_ENTITYCD | char(4) | No | No |
PYMNT_METHOD | char(3) | No | No |
DOC_SEQ | char(1) | No | No |
DOC_TYPE | char(8) | No | No |
VAT_NRCVR_PRO_FLG | char(1) | No | No |
VAT_NRCVR_ALL_FLG | char(1) | No | No |
HOLIDAY_LIST_ID | char(10) | No | No |
POST_DATE_OPTN | char(1) | No | No |
PROCESS_DATE | PSDATE | No | No |
IU_INTER_TMPLT_CD | char(5) | No | No |
IU_INTRA_TMPLT_CD | char(5) | No | No |
IU_LEGAL_ENT_BU | char(5) | No | No |
BUSINESS_UNIT_AP | char(5) | No | No |
VENDOR_SETID | char(5) | No | No |
VENDOR_ID | char(10) | No | No |
LOCATION | char(10) | No | No |
BUSINESS_UNIT_BI | char(5) | No | No |
CUST_ID | char(15) | No | No |
OPERATING_UNIT | char(8) | No | No |
PRODUCT | char(6) | No | No |
FUND_CODE | char(5) | No | No |
CLASS_FLD | char(5) | No | No |
PROGRAM_CODE | char(5) | No | No |
BUDGET_REF | char(8) | No | No |
AFFILIATE | char(5) | No | No |
AFFILIATE_INTRA1 | char(10) | No | No |
AFFILIATE_INTRA2 | char(10) | No | No |
CHARTFIELD1 | char(10) | No | No |
CHARTFIELD2 | char(10) | No | No |
CHARTFIELD3 | char(10) | No | No |
PROJECT_ID | char(15) | No | No |
DEPTID | char(10) | No | No |
CUST_VNDR_AFFILIAT | char(1) | No | No |
LED_GRP_DEFAULT | char(10) | No | No |
PHYSICAL_NATURE | char(1) | No | No |
SYNCID | int | No | No |
SYNCDTTM | PSDATETIME | No | No |
Index |
Name | Type | Unique | Member |
PS_BUS_UNIT_TBL_GL | PK | Yes |
![]() |
PSABUS_UNIT_TBL_GL | IE1 | No |
![]() |
Member(s) of "PS_BUS_UNIT_TBL_GL" Index |
BUSINESS_UNIT |
Member(s) of "PSABUS_UNIT_TBL_GL" Index |
SYNCID |
Published December 16, 2006 |