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 |