PeopleSoft 9 Account Payables |
Table Name | BUS_UNIT_TBL_GL |
Table Description |
BUS_UNIT_TBL_GL |
Columns |
Name | Datatype | Is PK | Is FK |
BUSINESS_UNIT | VARCHAR(5) | Yes | No |
AS_OF_DATE | PSDATE | No | No |
BASE_CURRENCY | VARCHAR(3) | No | No |
ELIMS_ONLY | VARCHAR(1) | No | No |
JRNL_BALANCE_OPTN | VARCHAR(1) | No | No |
JRNL_EDIT_ERR_OPTN | VARCHAR(1) | No | No |
JRNL_AMT_ERR_OPTN | VARCHAR(1) | No | No |
JRNL_DT_ERR_OPTN | VARCHAR(1) | No | No |
JRNL_DT_ERR_OPTN2 | VARCHAR(1) | No | No |
CONTROL_TOTAL_OPTN | VARCHAR(1) | No | No |
CURRENCY_BAL_OPTN | VARCHAR(1) | No | No |
BASE_CUR_ADJ_OPTN | VARCHAR(1) | No | No |
JRNL_FOREIGN_OPTN | VARCHAR(1) | No | No |
ENABLE_UNPOST_DT | VARCHAR(1) | No | No |
JRNL_APPRVL_OPTN | VARCHAR(1) | No | No |
BD_JRNL_APPR_OPTN | VARCHAR(1) | No | No |
BUSPROCNAME | VARCHAR(30) | No | No |
APPR_RULE_SET | VARCHAR(30) | No | No |
BUSPROCNAME_BD | VARCHAR(30) | No | No |
APPR_RULE_SET_BD | VARCHAR(30) | No | No |
TR_RVL_RATE_INDEX | VARCHAR(10) | No | No |
TR_RVL_RT_TYPE | VARCHAR(5) | No | No |
INT_ENTITYCD | VARCHAR(4) | No | No |
EXT_ENTITYCD | VARCHAR(4) | No | No |
PYMNT_METHOD | VARCHAR(3) | No | No |
DOC_SEQ | VARCHAR(1) | No | No |
DOC_TYPE | VARCHAR(8) | No | No |
VAT_NRCVR_PRO_FLG | VARCHAR(1) | No | No |
VAT_NRCVR_ALL_FLG | VARCHAR(1) | No | No |
HOLIDAY_LIST_ID | VARCHAR(10) | No | No |
POST_DATE_OPTN | VARCHAR(1) | No | No |
PROCESS_DATE | PSDATE | No | No |
IU_INTER_TMPLT_CD | VARCHAR(5) | No | No |
IU_INTRA_TMPLT_CD | VARCHAR(5) | No | No |
IU_LEGAL_ENT_BU | VARCHAR(5) | No | No |
BUSINESS_UNIT_AP | VARCHAR(5) | No | No |
VENDOR_SETID | VARCHAR(5) | No | No |
VENDOR_ID | VARCHAR(10) | No | No |
LOCATION | VARCHAR(10) | No | No |
BUSINESS_UNIT_BI | VARCHAR(5) | No | No |
CUST_ID | VARCHAR(15) | No | No |
OPERATING_UNIT | VARCHAR(8) | No | No |
PRODUCT | VARCHAR(6) | No | No |
FUND_CODE | VARCHAR(5) | No | No |
CLASS_FLD | VARCHAR(5) | No | No |
PROGRAM_CODE | VARCHAR(5) | No | No |
BUDGET_REF | VARCHAR(8) | No | No |
AFFILIATE | VARCHAR(5) | No | No |
AFFILIATE_INTRA1 | VARCHAR(10) | No | No |
AFFILIATE_INTRA2 | VARCHAR(10) | No | No |
CHARTFIELD1 | VARCHAR(10) | No | No |
CHARTFIELD2 | VARCHAR(10) | No | No |
CHARTFIELD3 | VARCHAR(10) | No | No |
PROJECT_ID | VARCHAR(15) | No | No |
DEPTID | VARCHAR(10) | No | No |
CUST_VNDR_AFFILIAT | VARCHAR(1) | No | No |
LED_GRP_DEFAULT | VARCHAR(10) | No | No |
PHYSICAL_NATURE | VARCHAR(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 June 06, 2007 |