GRP_AP_TEO1(SQL Table) |
Index Back |
|---|---|
AP Control Group Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 3 | GRP_AP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Control Group ID
Default Value: NEXT Prompt Table: GRP_AP |
| 4 | GROUP_TYPE_AP | Character(1) | VARCHAR2(1) NOT NULL |
Group Type
S=System Defined U=User Defined |
| 5 | GROUP_DT | Date(10) | DATE |
Group Control Date
Default Value: %date |
| 6 | GRP_AP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of Control Group
A=Assigned E=Entry Set Aside O=Open R=Ready for Review S=Supervisor Set Aside V=Verified Default Value: O |
| 7 | CTL_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Control Gross Amount |
| 8 | CTL_VOUCHERS | Number(6,0) | INTEGER NOT NULL | Control Voucher Number |
| 9 | GRP_AP_TAPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Run a Tape
Y/N Table Edit Default Value: N |
| 10 | ASSIGNED_BY_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Group Assigned by |
| 11 | ASSIGNED_TO_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Assigned to
Prompt Table: OPR_AP_VW |
| 12 | DTTM_ASSIGNED | DateTime(26) | TIMESTAMP | Date/Time Assigned |
| 13 | DTTM_DUE | DateTime(26) | TIMESTAMP | Date/Time Due |
| 14 | DTTM_COMPLETE | DateTime(26) | TIMESTAMP | Date/Time Completed |
| 15 | DUP_INVOICE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Indicator
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 16 | DUP_INVOICE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Invoice Severity
K=Reject R=Recycle W=Warning Default Value: K |
| 17 | DUP_INV_NUM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Number
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 18 | DUP_INV_DT | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Date
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 19 | DUP_INV_VENDOR_NUM | Character(1) | VARCHAR2(1) NOT NULL |
Vendor ID
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 20 | DUP_INV_GROSS_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Gross Amount
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 21 | DUP_INV_BUS_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit
N=No Y=Yes Y/N Table Edit Default Value: Y |
| 22 | DUP_INV_COMB_CODE | Number(3,0) | SMALLINT NOT NULL | Dupl Invoice Combination Code |
| 23 | ACCOUNTING_DT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Date Indicator
C=Use Current Date D=Business Unit Default P=Use Payment Date S=Use Specific Date Default Value: D |
| 24 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 25 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 26 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL |
| 27 | DST_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table: DST_CNTRL_VW |
| 28 | POST_TIMING | Character(1) | VARCHAR2(1) NOT NULL |
Posting Timing
G=Post Only when Group Balanced V=Post Vouchers Individually Default Value: V |
| 29 | POST_ACTION_AP | Character(1) | VARCHAR2(1) NOT NULL |
Post Group
D=Post on a Deferred basis N=Do Not Post P=Post Immediately Default Value: N |
| 30 | VCHR_BALANCE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Balance Option
D=Default from Higher Level K=Reject Unbalanced Vouchers R=Recycle Unbalanced Vouchers Default Value: D |
| 31 | CHART_EDIT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Chartfield Edit Option
D=Default from Higher Level K=Reject w/ edit error N=No Edits R=Recycle S=Use suspense account W=Warning Default Value: D |
| 32 | COMBO_EDIT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Edit Combinations
Y/N Table Edit Default Value: N |
| 33 | VOUCHER_NUM_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Numbering
Y/N Table Edit Default Value: N |
| 34 | VCHR_NUM_BEGIN | Number(8,0) | INTEGER NOT NULL | Starting From |
| 35 | VCHR_NUM_END | Number(8,0) | INTEGER NOT NULL | Ending |
| 36 | VCHR_NUM_LAST_USED | Number(8,0) | INTEGER NOT NULL | Last Voucher Number |
| 37 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 38 | VCHR_APPRVL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Voucher Approval Flag
D=Default from Higher Level P=Pre-Approved S=Virtual Approver W=Approval Framework Default Value: D |
| 39 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 40 | APPR_RULE_SET | Character(30) | VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table: APPR_RULE_HDR |
| 41 | PYMNT_TIMING | Character(1) | VARCHAR2(1) NOT NULL |
Payment Timing
G=Pay Only when Group Balanced V=Pay Vouchers Individually Default Value: V |
| 42 | PAY_VERIFIED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Only Pay Verified Groups
Y/N Table Edit Default Value: Y |
| 43 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIPTO_TBL |
| 44 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Sales/Use Tax Destination
Prompt Table: SHIPTO_TBL |
| 45 | SHIP_LOC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship To/End Location Flag
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 46 | SALETX_TOL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Tax Tolerance Flag
D=Default from Higher Level S=Specify at this Level Default Value: D |
| 47 | SALETX_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Sales Tax Tolerance Percent |
| 48 | SALETX_TOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Tolerance Amount |
| 49 | SALETX_TOL_CUR_CD | Character(3) | VARCHAR2(3) NOT NULL | Sales Tax Tolerance Curr Code |
| 50 | SALETX_TOL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Sales Tax Tolerance Rate Type |
| 51 | DOC_TYPE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Document Type Flag
D=Default from Higher Level S=Specify at This level Default Value: D |
| 52 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
Prompt Table: DOC_TYPE_TBL |
| 53 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 54 | VAT_SVC_PERFRM_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Where VAT Services Physically Performed Flag
1=Ship To Location 2=Ship From Location 3=Buyer's Location 4=Supplier's Location |
| 55 | ULTIMATE_USE_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ultimate Use Code
Prompt Table: SUT_USE_CD |
| 56 | ULT_USE_CD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ultimate Use Code
D=Default from higher S=Specified Default Value: D |
| 57 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 58 | MATCH_DELAY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
To indicate whether Match Delay Days is specified at this level or to be defaulted from higher level in the AP defaulting hierarchy.
D=Default from Higher Level S=Specified at This Level |
| 59 | MATCH_DELAY_DAYS | Number(3,0) | SMALLINT NOT NULL | Match Delay Days |