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