PeopleSoft 9
Account Payables

Table Name GRP_AP

Table Description
GRP_AP
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
GRP_AP_ID VARCHAR(10) Yes No
GROUP_TYPE_AP VARCHAR(1) No No
GROUP_DT PSDATE No No
GRP_AP_STATUS VARCHAR(1) No No
CTL_GROSS_AMT decimal(26,3) No No
CTL_VOUCHERS int No No
GRP_AP_TAPE_FLG VARCHAR(1) No No
ASSIGNED_BY_OPRID VARCHAR(30) No No
ASSIGNED_TO_OPRID VARCHAR(30) No No
DTTM_ASSIGNED PSDATETIME No No
DTTM_DUE PSDATETIME No No
DTTM_COMPLETE PSDATETIME No No
DUP_INVOICE_IND VARCHAR(1) No No
DUP_INVOICE_ACTION VARCHAR(1) No No
DUP_INV_NUM_FLG VARCHAR(1) No No
DUP_INV_DT VARCHAR(1) No No
DUP_INV_VENDOR_NUM VARCHAR(1) No No
DUP_INV_GROSS_AMT VARCHAR(1) No No
DUP_INV_BUS_UNIT VARCHAR(1) No No
DUP_INV_COMB_CODE SMALLINT No No
ACCOUNTING_DT_IND VARCHAR(1) No No
ACCOUNTING_DT PSDATE No No
CURRENCY_CD VARCHAR(3) No No
CUR_RT_TYPE VARCHAR(5) No No
DST_CNTRL_ID VARCHAR(10) No No
POST_TIMING VARCHAR(1) No No
POST_ACTION_AP VARCHAR(1) No No
VCHR_BALANCE_OPT VARCHAR(1) No No
CHART_EDIT_OPTION VARCHAR(1) No No
COMBO_EDIT_FLG VARCHAR(1) No No
VOUCHER_NUM_OPTION VARCHAR(1) No No
VCHR_NUM_BEGIN int No No
VCHR_NUM_END int No No
VCHR_NUM_LAST_USED int No No
PROCESS_INSTANCE decimal(10) No No
VCHR_APPRVL_FLG VARCHAR(1) No No
BUSPROCNAME VARCHAR(30) No No
APPR_RULE_SET VARCHAR(30) No No
PYMNT_TIMING VARCHAR(1) No No
PAY_VERIFIED_FLG VARCHAR(1) No No
SHIPTO_ID VARCHAR(10) No No
SUT_BASE_ID VARCHAR(10) No No
SHIP_LOC_FLG VARCHAR(1) No No
SALETX_TOL_FLG VARCHAR(1) No No
SALETX_TOL_PCT decimal(5,2) No No
SALETX_TOL_AMT decimal(26,3) No No
SALETX_TOL_CUR_CD VARCHAR(3) No No
SALETX_TOL_RT_TYPE VARCHAR(5) No No
DOC_TYPE_FLG VARCHAR(1) No No
DOC_TYPE VARCHAR(8) No No
PHYSICAL_NATURE VARCHAR(1) No No
VAT_SVC_PERFRM_FLG VARCHAR(1) No No
ULTIMATE_USE_CD VARCHAR(8) No No
ULT_USE_CD_FLG VARCHAR(1) No No
MATCH_DELAY_FLG VARCHAR(1) No No
MATCH_DELAY_DAYS SMALLINT No No
Index
Name Type Unique Member
PS_GRP_AP PK Yes
Member(s) of "PS_GRP_AP" Index
BUSINESS_UNIT
GRP_AP_ID

Published June 06, 2007