PeopleSoft 9.0 Cash 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 |
XPKBUS_UNIT_TBL_GL | PK | Yes |
![]() |
PS_BUS_UNIT_TBL_GL | AK1 | Yes |
![]() |
PSABUS_UNIT_TBL_GL | IE1 | No |
![]() |
Member(s) of "XPKBUS_UNIT_TBL_GL" Index |
BUSINESS_UNIT |
Member(s) of "PS_BUS_UNIT_TBL_GL" Index |
BUSINESS_UNIT |
Member(s) of "PSABUS_UNIT_TBL_GL" Index |
SYNCID |
Published April 30, 2007 |