PAY_CYCLEPAY_CYCLE_SEQ_NUMNET_REF_IDPrompt Table: CURRENCY_CD_TBL
Prompt Table: CURRENCY_CD_TBL
PYCYCL_N06_DATA(SQL Table) |
Index Back |
|---|---|
PayCycle Netting Reset Stg HdrPay Cycle Netting Reset Tmp06 is used to store the original values from NET_STG_HDR before discount was applied. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_CYCLE |
Character(6) | VARCHAR2(6) NOT NULL | Pay Cycle |
| 2 | PAY_CYCLE_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Pay Cycle Sequence Number |
| 3 | NET_REF_ID |
Character(12) | VARCHAR2(12) NOT NULL | A reference identifier associated with a cash transaction subject to netting with a given bank/count |
| 4 | NETTING_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Netting Currency
Prompt Table: CURRENCY_CD_TBL |
| 5 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table: CURRENCY_CD_TBL |
| 6 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 7 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 8 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 9 | TOTAL_PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An internal work field in the settlements module that contains a summary of all outbound transact |
| 10 | TOTAL_PAY_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Payment Amount - Base |
| 11 | PAY_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Payable Discount Available Amount |
| 12 | PAY_DISC_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Payable Discount Available Amount Base |
| 13 | PAY_DISC_APPL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Payable Discount Paid Amount |
| 14 | PAY_DISC_APPL_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Payable Discount Paid Amount Base |
| 15 | TOTAL_RCV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | An internal work field in the settlements module that contains a summary of all inbound transacti |
| 16 | TOTAL_REC_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Receivable Amount - Base |
| 17 | RCV_DISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Receivable Discount Available Amount |
| 18 | RCV_DISC_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Receivable Discount Available Amount Base |
| 19 | RCV_DISC_APPL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Receivable Discount Paid Amount |
| 20 | RCV_DISC_APPL_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Receivable Discount Paid Amount Base |
| 21 | NET_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Netted Amount |
| 22 | NET_BAL_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Netting Balance Amount Base |
| 23 | BAL_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance Amount |
| 24 | BAL_BAL_AMT_BASE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance Amount Base |