AR_MRL_HTRAN_VW(SQL View) |
Index Back |
|---|---|
MRL distributed amountsfrom ARCC_HLDTRN_TBL |
| SELECT T.BUSINESS_UNIT , T.CUST_ID , T.ITEM , T.ITEM_LINE , T.ITEM_SEQ_NUM , T.CC_GROUP_SEQ_NUM , T.CC_SEQ_NUM , %DecMult(-1, T.FOREIGN_AMOUNT) , T.REV_SOURCE , T.REV_BUSINESS_UNIT , T.REV_CUST_ID , T.REV_ITEM_SEQ_NUM , T.DST_SEQ_NUM , T.LEDGER_GROUP , T.LEDGER , T.BUSINESS_UNIT_BI , T.INVOICE , T.LINE_SEQ_NUM , T.ACCOUNTING_DT_BI , T.ACCT_ENTRY_TYPE , T.DISC_SUR_LVL , T.DISC_SUR_ID , T.TAX_AUTHORITY_CD FROM PS_ARCC_HLDTRN_HDR H , PS_ARCC_HLDTRN_TBL T WHERE %Join(COMMON_KEYS, ARCC_HLDTRN_TBL T, ARCC_HLDTRN_HDR H) AND H.ARRE_STATUS IN (' ', 'P', 'C') AND T.CC_ACCT_LINE = 'I' AND T.CC_REV_BUCKET IN ('B', 'C') AND T.SYS_TRAN_TYPE = 'A' AND T.CC_DM_TRAN_TYPE = 'G' AND NOT EXISTS ( SELECT 'X' FROM PS_ARRE_DMHIST_VW HIST WHERE HIST.BUSINESS_UNIT = H.BUSINESS_UNIT AND HIST.CUST_ID = H.CUST_ID AND HIST.ITEM = H.ITEM AND HIST.ITEM_LINE = H.ITEM_LINE AND HIST.ITEM_SEQ_NUM < H.ITEM_SEQ_NUM AND HIST.DRAFT_BU = H.DRAFT_BU AND HIST.DRAFT_ID = H.DRAFT_ID AND HIST.CC_DM_TRAN_TYPE = 'R') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUARDS_NONVW |
| 2 | 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.
Prompt Table: AR_CCTRAN_C_VW |
| 3 | ITEM |
Character(30) | VARCHAR2(30) NOT NULL | Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number. |
| 4 | ITEM_LINE |
Number(6,0) | INTEGER NOT NULL | Item Line |
| 5 | ITEM_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 6 | CC_GROUP_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Group Sequency |
| 7 | CC_SEQ_NUM |
Number(6,0) | INTEGER NOT NULL | Sequence number |
| 8 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 9 | REV_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Indicate where the revenue line is from.
A=Account Receivables B=Billing C=CC Transactions O=Online Panel R=Account Receivables |
| 10 | REV_BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | REV_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer ID |
| 12 | REV_ITEM_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Item Sequence Number |
| 13 | DST_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Distribution Sequence |
| 14 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 15 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 16 | BUSINESS_UNIT_BI | Character(5) | VARCHAR2(5) NOT NULL | Billing Business Unit |
| 17 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 18 | LINE_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Sequence |
| 19 | ACCOUNTING_DT_BI | Date(10) | DATE | Billing Accounting Date |
| 20 | ACCT_ENTRY_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Account Entry Type |
| 21 | DISC_SUR_LVL | Number(2,0) | SMALLINT NOT NULL | Discount/Surcharge Level |
| 22 | DISC_SUR_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifier |
| 23 | TAX_AUTHORITY_CD | Character(3) | VARCHAR2(3) NOT NULL | Tax Authority |