This appendix contains the following topics:
Tables from other JD Edwards EnterpriseOne systems are the source tables for many of the JD Edwards EnterpriseOne FMCC tables.
This table lists the Sales Order Fact table (F80D010) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
DOCO | Order Number | Y | Sales Order Detail File (F4211) | DOCO | N/A |
DCTO | Order Type | Y | Sales Order Detail File (F4211) | DCTO | N/A |
KCOO | Order Company | Y | Sales Order Detail File (F4211) | KCOO | N/A |
LNID | Line Number | Y | Sales Order Detail File (F4211) | LNID | N/A |
AN8 | Address Number | N/A | Sales Order Detail File (F4211) | AN8 | N/A |
ITM | Short Item Number | N/A | Sales Order Detail File (F4211) | ITM | N/A |
MCU | Business Unit | N/A | Sales Order Detail File (F4211) | MCU | N/A |
EMCU | Header Business Unit | N/A | Sales Order Detail File (F4211) | EMCU | N/A |
CO | Company | N/A | N/A | N/A | Lookup to the Business Unit Master table (F0006) for DD Item EMCU, and then get associated company. |
SHAN | Ship To Number | N/A | Sales Order Detail File (F4211) | SHAN | N/A |
AEXP | Extended Price | N/A | Sales Order Detail File (F4211) | AEXP | N/A |
CAEXP | Extended Amount | N/A | N/A | N/A | Calculated field that will be converted to the default data currency code. Will include additional charges such as detached adjustments. |
CBACK | Backorder Amount | N/A | N/A | N/A | Calculated field that will be converted to the default data currency code. Will not include additional charges. |
CADTC | Additional Charge | N/A | N/A | N/A | Calculated field that will be converted to the default data currency code. Will include additional charges.
CADTC is informational only. |
SOQS | Quantity Shipped | N/A | Sales Order Detail File (F4211) | SOQS | N/A |
SOBK | Quantity Backordered | N/A | Sales Order Detail File (F4211) | SOBK | N/A |
UOM | Transaction Unit of Measure | N/A | Sales Order Detail File (F4211) | UOM | N/A |
UOM1 | Primary Unit of Measure | N/A | Sales Order Detail File (F4211) | UOM1 | N/A |
TRDJ | Order Date | N/A | Sales Order Detail File (F4211) | TRDJ | N/A |
DRQJ | Request Date | N/A | Sales Order Detail File (F4211) | DRQJ | N/A |
PDDJ | Scheduled Pick Date | N/A | Sales Order Detail File (F4211) | PDDJ | N/A |
RSDJ | Promised Delivery Date | N/A | Sales Order Detail File (F4211) | RSDJ | N/A |
IVD | Invoice Date | N/A | Sales Order Detail File (F4211) | IVD | N/A |
PPDJ | Promised Ship Date | N/A | Sales Order Detail File (F4211) | PPDJ | N/A |
ADDJ | Actual Ship Date | N/A | Sales Order Detail File (F4211) | ADDJ | N/A |
CNDJ | Cancel Date | N/A | Sales Order Detail File (F4211) | CNDJ | N/A |
DGL | GL Date | N/A | Sales Order Detail File (F4211) | DGL | N/A |
LTTR | Last Status | N/A | Sales Order Detail File (F4211) | LTTR | N/A |
NXTR | Next Status | N/A | Sales Order Detail File (F4211) | NXTR | N/A |
CRCD | Currency Code | N/A | Sales Order Detail File (F4211) | CRCD | Calculated field that will be converted to the default data currency code. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the GL Account Balances Fact table (F80D020) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Date Fiscal Patterns (F0008) | D01J - D12J | The period ending date on the fiscal date pattern periods will be used as the processing date for each period balance. |
LT | Ledger Type | Y | Account Balances (F0902) | LT | N/A |
MCU | Business Unit | Y | Account Balances (F0902) | MCU | N/A |
OBJ | Object Account | Y | Account Balances (F0902) | LNID | N/A |
AMPBAL | Amount - Fiscal Period Balance | N/A | Account Balances (F0902) | AN01 - AN14 | Calculated field that will be converted to the default data currency code. Will include additional charges such as detached adjustments. |
FAAI | Financial Ratio AAI Code | N/A | Automatic Accounting Instructions Master (F0012) | N/A | N/A |
LTFLG | Ledger Type Flag - Actual Or Budget | N/A | N/A | EV01 | N/A |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the Forecasted Cash Flow Aggregate table (F80D203) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Cash Forecast Data (F09522) | DDJ | N/A |
MCU | Business Unit | Y | Cash Forecast Data (F09522) | MCU | N/A |
AMSB | Amount - Starting Balance | N/A | N/A | N/A | Calculated field that will be converted to the default data currency code. |
AMOF | Amount - Outflow | N/A | N/A | N/A | Calculated field that will be converted to the default data currency code. |
AMIF | Amount - Inflow | N/A | N/A | N/A | Calculated field that will be converted to the default data currency code. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the Shipped Orders Aggregate table (F80D241) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Sales Order Facts (F80D010) | ADDJ | N/A |
EMCU | Header Business Unit | Y | Sales Order Facts (F80D010) | EMCU | N/A |
AN8 | Address Number | Y | Sales Order Facts (F80D010) | AN8 | N/A |
ITM | Item Number | Y | Sales Order Facts (F80D010) | ITM | N/A |
SHRV | Shipped Order Revenue | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
CCPE | Count - Payments Entered | N/A | N/A | N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AP Daily Counts and Amounts Aggregate table (F80D253) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Accounts Payable Ledger (F0411)
Accounts Payable - Matching Document (F0413) |
DGJ
DMTJ |
The system writes records by separate processes; therefore, the source table might be different. |
MCU | Business Unit | Y | Accounts Payable Ledger (F0411)
Account Ledger (F0901) |
MCU | The system writes records by separate processes; therefore, the source table might be different. |
AVE | Amount - Vouchers Entered | N/A | Accounts Payable Ledger (F0411) | AG | Calculated field that is converted to the analytics data store currency. |
CVE | Count - Vouchers Entered | N/A | N/A | N/A | Calculated field. |
APE | Amount - Payments Entered | N/A | Accounts Payable - Matching Document (F0413) | PAAP | Calculated field that is converted to the analytics data store currency. |
CCPE | Count - Payments Entered | N/A | N/A | N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AP Discount Information Aggregate table (F80D254) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Accounts Payable Ledger (F0411) | DGJ | N/A |
MCU | Business Unit | Y | Accounts Payable Ledger (F0411) | MCU | N/A |
AADSC | Amount - Aggregate Discount Available | N/A | Accounts Payable Ledger (F0411) | ADSC | Calculated field that is converted to the analytics data store currency. |
AADSA | Amount - Aggregate Discount Taken | N/A | Accounts Payable Ledger (F0411) | ADSA | Calculated field that is converted to the analytics data store currency. |
AADL | Amount - Aggregate Discount Not Taken | N/A | Accounts Payable Ledger (F0411) | ADL | Calculated field. |
ATPV | Amount - Total Paid Voucher | N/A | Accounts Payable Ledger (F0411) | AG | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AP Open Payables Aggregate table (F80D255) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | N/A | N/A | Current date |
MCU | Business Unit | Y | Accounts Payable Ledger (F0411) | MCU | N/A |
AAOV | Amount - Open Vouchers | N/A | Accounts Payable Ledger (F0411) | AAP | Calculated field that is converted to the analytics data store currency. |
AAOVPD | Amount - Open Vouchers Past Due | N/A | Accounts Payable Ledger (F0411) | AAP | Calculated field that is converted to the analytics data store currency. |
ACOV | Count - Open Vouchers | N/A | N/A | N/A | Calculated field. |
ACOVPD | Count - Open Vouchers Past Due | N/A | N/A | N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AP Vouchers Paid Late Aggregate table (F80D256) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Accounts Payable - Matching Document (F0413) | DMTJ | N/A |
MCU | Business Unit | Y | Accounts Payable Ledger (F0411) | MCU | N/A |
AVPL | Amount - Vouchers Paid Late | N/A | Accounts Payable Matching Document Detail (F0414) | AAP | Calculated field that is converted to the analytics data store currency. |
CVPL | Count - Vouchers Paid Late | N/A | N/A | N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the Most Profitable Customer Aggregate table (F80D272) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Cost Analyzer View Structure (F1603) | N/A | N/A |
CO | Company | Y | Cost Analyzer Balances (F1602) | N/A | N/A |
AN8 | Customer | Y | Cost Analyzer Balances (F1602) | N/A | N/A |
AMPRF | Amount Profit | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the Most Profitable Product Aggregate table (F80D273) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Cost Analyzer View Structure (F1603) | N/A | N/A |
CO | Company | Y | Cost Analyzer Balances (F1602) | N/A | N/A |
ITM | Item | Y | Cost Analyzer Balances (F1602) | N/A | N/A |
AMPRF | Amount Profit | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the Most Profitable Brand Aggregate table (F80D274) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Cost Analyzer View Structure (F1603) | N/A | N/A |
CO | Company | Y | Cost Analyzer Balances (F1602) | N/A | N/A |
CABRND | Brand | Y | Cost Analyzer Balances (F1602) | N/A | N/A |
AMPRF | Amount Profit | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AR Daily Counts and Amounts Aggregate table (F80D280) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Customer Ledger (F03B11)
Receipt Detail (F03B14) Receipts Header (F03B13) |
DMTJ | N/A |
MCU | Business Unit | Y | Account Master (F0901) | MCU | N/A |
AMTIN | Amount - Invoiced | N/A | Customer Ledger (F03B11) | AG | Calculated field that is converted to the analytics data store currency. |
AMTRV | Amount - Received | N/A | Receipt Detail (F03B14)
Receipts Header (F03B13) |
N/A | Calculated field that is converted to the analytics data store currency. |
CNTIN | Count - Invoices | N/A | Customer Ledger (F03B11) | N/A | Calculated field. |
CNTRC | Count - Receipts | N/A | Receipt Detail (F03B14)
Receipts Header (F03B13) |
N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AR Delinquency Information Aggregate table (F80D281) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | N/A | N/A | Current date |
MCU | Business Unit | Y | Customer Ledger (F03B11) | MCU | N/A |
AOPDI | Amount - Open Past Due Invoice | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
CPDI | Count - Open Past Due Invoice | N/A | N/A | N/A | Calculated field. |
AODF | Amount - Open Delinquency Fees | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
CCPDI | Count - Open Delinquency Fees | N/A | N/A | N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AR Discount Information Aggregate table (F80D282) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Receipt Detail (F03B14) | DGJ | N/A |
MCU | Business Unit | Y | Receipt Detail (F03B14) | MCU | N/A |
AADSC | Amount - Aggregate Discount Available | N/A | Receipt Detail (F03B14) | ADSC | Calculated field that is converted to the analytics data store currency. |
ADSE | Amount - Discount Earned | N/A | Receipt Detail (F03B14) | ADSA | Calculated field that is converted to the analytics data store currency. |
ADSU | Amount - Discount Unearned | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
ACDSA | Count - Invoices w/ Discount Available | N/A | N/A | N/A | Calculated field. |
ACDSE | Count - Invoices w/ Earned Discount Taken | N/A | N/A | N/A | Calculated field. |
ACDSU | Count - Invoices w/ Unearned Discount Taken | N/A | N/A | N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AR Open Chargeback Amounts Aggregate table (F80D283) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | N/A | N/A | Current date |
MCU | Business Unit | Y | Customer Ledger (F03B11) | MCU | N/A |
ECBR | Chargeback Reason | Y | Receipt Detail (F03B14) | ECBR | Calculated field. |
AOCHBK | Amount - Open Chargeback | N/A | Customer Ledger (F03B11) | AAP | Calculated field that is converted to the analytics data store currency. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AR Open Receivables Aggregate table (F80D284) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | N/A | N/A | Current date |
MCU | Business Unit | Y | Customer Ledger (F03B11) | MCU | N/A |
ROC | Amount - Revenue Open for Collection | N/A | Customer Ledger (F03B11) | AAP | Calculated field that is converted to the analytics data store currency. |
OIC | Count - Open Invoices | N/A | N/A | N/A | Calculated field. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the AR Total Chargeback Aggregate table (F80D285) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Receipt Detail (F03B14) | DGJ | N/A |
MCU | Business Unit | Y | Receipt Detail (F03B14) | MCU | N/A |
ECBR | Chargeback Reason | Y | Receipt Detail (F03B14) | ECBR | Calculated field. |
ATCHBK | Amount - Total Chargeback | N/A | Receipt Detail (F03B14) | ECBA | Calculated field that is converted to the analytics data store currency. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |
This table lists the Metric ID Time Dimension Cross Reference table (F80D302) Data Dictionary (DD) items and information about DD items:
DD Item | DD Item Description | Key | Additional Information |
---|---|---|---|
METRIC | Metric ID | Y | Numeric |
TIDEN | Time Dimension | Y | Numeric |
TIDESC | Time Description | N/A | String |
METIDDESC | Metric ID Description | N/A | String |
USER | User ID | N/A | N/A |
PID | Program ID | N/A | N/A |
MKEY | Machine Key | N/A | N/A |
UUPMJ | Universal Date Updated | N/A | N/A |
URCD | User Reserve Code | N/A | N/A |
URDT | User Reserve Date | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A |
URAB | User Reserve Number | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A |
This table lists the Unposted Transaction Aggregate table (F80D701) Data Dictionary (DD) items, the source tables and fields, and information about DD items:
DD Item | DD Item Description | Key | Source Table | Source Table DD Item | Additional Information |
---|---|---|---|---|---|
PRDJ | Processing Date | Y | Customer Ledger (F03B11) | DGJ | N/A |
MCU | Business Unit | Y | Customer Ledger (F03B11) | MCU | N/A |
UARP | Amount - Unposted AR | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
UAPAG | Amount - Unposted AP | N/A | N/A | N/A | Calculated field that is converted to the analytics data store currency. |
USER | User ID | N/A | N/A | N/A | Calculated field for audit information. |
PID | Program ID | N/A | N/A | N/A | Calculated field for audit information. |
MKEY | Machine Key | N/A | N/A | N/A | Calculated field for audit information. |
UTIME | Update Date and Time | N/A | N/A | N/A | Calculated field for audit information. |
URCD | User Reserve Code | N/A | N/A | N/A | N/A |
URDT | User Reserve Date | N/A | N/A | N/A | N/A |
URAT | User Reserve Amount | N/A | N/A | N/A | N/A |
URAB | User Reserve Number | N/A | N/A | N/A | N/A |
URRF | User Reserve Reference | N/A | N/A | N/A | N/A |