ARXDDCTL_TAO(SQL Table) |
Index Back |
|---|---|
Direct Debit Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DD_BU | Character(5) | VARCHAR2(5) NOT NULL |
Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDS_NONVW |
| 3 | DD_ID | Character(15) | VARCHAR2(15) NOT NULL |
Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
Prompt Table: DD_CONTROL |
| 4 | DD_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process.
A=Accepted C=Complete E=Rejected N=No Action P=Pending R=Remitted Z=All |
| 5 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 6 | DD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process. |
| 7 | DD_CNT | Number(5,0) | INTEGER NOT NULL | Total Number of Direct Debits |
| 8 | DD_DUE_DT | Date(10) | DATE | Direct Debit Due Date |
| 9 | CREATE_DATE | Date(10) | DATE | Creation Date |
| 10 | DD_AS_OF_DT | Date(10) | DATE | Pending Item As of Date |
| 11 | DD_REMIT_POST_DT | Date(10) | DATE | Remittance Post Date |
| 12 | DD_REMIT_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Remittance Group Id |
| 13 | TRANSIT_POST_DT | Date(10) | DATE | Cash-in-Transit Post Date |
| 14 | TRANSIT_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Cash-in-Transit Group ID |
| 15 | CASH_POST_DT | Date(10) | DATE | Cash Posted Date |
| 16 | CASH_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Cash Group ID |
| 17 | DD_CANCEL_POST_DT | Date(10) | DATE | Cancellation Post Date |
| 18 | DD_CANCEL_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Cancellation Group Id |
| 19 | VAT_POST_DT | Date(10) | DATE | VAT Post Date |
| 20 | VAT_GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | VAT Group ID |
| 21 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 22 | DD_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Specifies the currency in which a direct debit is created. This field is maintained by the Direct Debit generation process. |
| 23 | ENTRY_USE_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the System Function or type of processing associated with an entry type. |
| 24 | ENTRY_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction. |
| 25 | ENTRY_REASON | Character(5) | VARCHAR2(5) NOT NULL | "Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""." |
| 26 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 27 | POST_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post B=Balance Only Now D=Delete This Group Now E=Delete ALL Accounting Entries G=Generate GL Distribution I=Balance and Post Later L=Batch Standard N=Batch Priority V=View |
| 28 | GROUP_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system. |
| 29 | ITM_MULTIPLIER | Signed Number(2,0) | DECIMAL(1) NOT NULL | Posting Item Multiplier |
| 30 | CREATE_PEND_ITEMS | Character(1) | VARCHAR2(1) NOT NULL |
Create Pending Items
A=Do Not Post L=Batch Standard N=Batch Priority |
| 31 | HOLD_SW | Character(1) | VARCHAR2(1) NOT NULL |
Hold Switch
N=No Hold Y=On Hold |
| 32 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 33 | DD_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a direct debit in the base currency of the business unit to which it is posted. This field is maintained by the Direct debit generation process. |
| 34 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 35 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 36 | BANK_ACCT_KEY | Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 37 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 38 | DEPOSIT_ACCT_NUM | Character(35) | VARCHAR2(35) NOT NULL | Deposit Bank Account # |
| 39 | DEPOSIT_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Deposit Currency |
| 40 | DD_NOTICE_PERIOD | Number(3,0) | SMALLINT NOT NULL | Direct Debit Notice Period |
| 41 | DD_CLEARING_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Clearing Method
B=Bank Recon D=Due Date N=None |
| 42 | RECON_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled B=Balance System(s) to BankTran F=Forced to Reconcile M=Manually Reconciled S=Semi Manual U=Unreconciled |
| 43 | RECONCILE_DT | Date(10) | DATE | The transaction reconciliation date. |
| 44 | RECON_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Reconciliation Status
ALG=Alignment Check AMB=Ambiguous Match AMT=Amounts Not Equal CUR=Currency not Defined DAT=Tran Date <> Value Date DPI=Duplicate Input Transactions DUP=Duplicate Transaction MSC=Miscellaneous Transaction NAM=Payee Names Not Equal NTB=Not Found in Statement NTF=Not Found In System NTP=Not Found in POS Data NUL=Null Transaction ID Ref OVR=Overflow PND=Pending Reconciliation REC=Reconciled RPR=Reprinted Check RR=Requires Review - BSAC STP=Stop Payment TYP=Wrong Transaction Type UNR=Unreconciled VOI=Voided Check |
| 45 | RECON_CYCLE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | The bank statement ID. |
| 46 | RECONCILE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The user ID that performed the reconciliation for a given transaction. |
| 47 | STTLMNT_DT_EST | Date(10) | DATE | Date in which a deal transaction is estimated to be settled with a counterparty. |
| 48 | STTLMNT_DT_ACTUAL | Date(10) | DATE | Date in which a deal transaction is actually settled with a counterparty. |
| 49 | DISCOUNT_PROCESSED | Character(1) | VARCHAR2(1) NOT NULL |
Discount Processed Switch
Y/N Table Edit |
| 50 | MICR_ID | Character(30) | VARCHAR2(30) NOT NULL |
MICR ID
Prompt Table:
DD_MICR_WS_VW
|
| 51 | DD_WORKSHEET_ID | Number(10,0) | DECIMAL(10) NOT NULL | DD Worksheet Id |
| 52 | DD_RQST_SEQUENCE | Number(5,0) | INTEGER NOT NULL | Request Sequence Number |
| 53 | DD_APPROVAL_CR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Credit Approval Limit |
| 54 | DD_APPROVAL_DR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Debit Approval Limit |
| 55 | DD_APPROV_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Approval Currency |
| 56 | DD_CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Exchange Rate Type |
| 57 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 58 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 59 | LAST_RUN_DTM | DateTime(26) | TIMESTAMP | Last Run On |
| 60 | DD_CANCEL_REASON | Character(60) | VARCHAR2(60) NOT NULL | Cancel Reason |
| 61 | DD_PROFILE_ID | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Profile ID for a Direct Debit |
| 62 | 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. |
| 63 | DOC_SEQ_NBR | Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
| 64 | DOC_SEQ_DATE | Date(10) | DATE | Specifies the date that a document sequence number is assigned to a document or the date the document was created. |
| 65 | DOC_SEQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status |
| 66 | ACCOUNTING_DT | Date(10) | DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date |
| 67 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 68 | EFT_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | EFT Process Instance |
| 69 | DD_EXCP_C_IND | Character(1) | VARCHAR2(1) NOT NULL |
Exceeds Credit Approval Limit
Y/N Table Edit Default Value: N |
| 70 | DD_EXCP_D_IND | Character(1) | VARCHAR2(1) NOT NULL |
Exceeds Debit Approval Limit
Y/N Table Edit Default Value: N |
| 71 | DD_EXCP_F_IND | Character(1) | VARCHAR2(1) NOT NULL |
Foreign Currency
Y/N Table Edit Default Value: N |
| 72 | DD_EXCP_N_IND | Character(1) | VARCHAR2(1) NOT NULL |
Due Date within Notice Period
Y/N Table Edit Default Value: N |
| 73 | DD_EXCP_P_IND | Character(1) | VARCHAR2(1) NOT NULL |
Missing Customer Bank Details
Y/N Table Edit Default Value: N |
| 74 | BANK_ACCT_RVL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Field used to store the amount on a transaction revalued in the base currency of the transactions bank account. |
| 75 | MAX_RESUBMIT_CNT | Number(3,0) | SMALLINT NOT NULL | Max Number of Resubmissions |
| 76 | RECON_RUN_ID | Character(15) | VARCHAR2(15) NOT NULL | Recon Run ID |
| 77 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |