GP Tables

CURNCYID

Currency ID

Module: Multicurrency · Found in 137 tables

Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions.

Tables containing CURNCYID

Table Description
AAG10001 aaGLWorkDist
AAG20001 aaSubLedgerDist
AAG20011 aaSubLedgerDistDUP
AAG2001T aa CM Deposit Diff TEMP
AAG30001 aaGLDist
AAG40001 aaGLHistDist
AAG50001 aaSubLedgerDistReport
AAG60001 aaGLWorkDistReport
AAG70001 aaGLDistReport
ASIEXP02 SmartList RM Customer MSTR
ASIEXP03 SmartList PM Vendor Master File
ASIEXP06 SmartList Sales Transaction
ASIEXP07 SmartList Purchase Order
ASIEXP08 SmartList Receivables Transaction
ASIEXP09 SmartList Payables Transactions
ASIEXP11 SmartList Item Quantity Master
ASIEXP12 ASI GL Transaction SmartList
ASIEXP15 ASI_RM_Customer_MSTR_ADDR_SmartList
ASIEXP16 ASI_PM_Address_MSTR_SmartList
ASIEXP20 ASI SOP Line Item SmartList
ASIEXP21 SmartList Purchasing Line Items
ASIEXP22 SmartList Bank Reconciliation Explorer
ASIEXP23 Item Vendor SmartList
ASIEXP24 SmartList Customer Items
ASIEXP25 SmartList Invoicing Transaction Work
ASIEXP27 SmartList Purchasing Receipts
ASIEXP28 SmartList Purchasing Receipt Lines
CM00001 CM_DepRcpt_RGLCash_LINE_TEMP
CM20200 CM Transaction
CM20300 CM Receipt
CM20501 CM Reconcile Adjustments
CN100201 Collections - Build Letter Invoices
CN20100 Collections - Invoice Notes Open
EDCEI002 Intrastat Setup
EDCEI005 Intrastat Return Master
EDCML002 ML Checks Language MSTR
EDCML003 ML Checks Language Line
EDCML005 ML Checks Payables Batch Language
ENCAA10210V Encumbrance AA Transactions
FA00700 Asset Retirement Master
FA00701 Asset Retirement Master WORK
GL10000 Transaction Work
GL20000 Open Year Posted Transactions
GL30000 Historical Year Transactions
GTM20001V GTM_aaUnpostedDistView
ICJC9000 ICJC RM Sales Work
ICJC9001 PM Transaction WORK File
IV00105 Item Currency Master
IV00107 Item Price List Options
IV00108 Item Price List
IVC10100 Invoicing Transaction Work
IVC10200 Invoicing Payments Work
IVC30101 Invoicing Transaction History
MC00200 Multicurrency Account Master
MC00500 Multicurrency Posting Definitions Master
MC020102 Multicurrency Receivables Transactions
MC020103 Multicurrency Payables Transactions
ME142807 ME Download Transactions
PA00001 Customer Vendor Master
PA00601 PA Employee MSTR
PA01001 PA Cost Category Master File
PA01403 PA Employee Rate Table LINE
PA01405 PA Job Title Rate Table Line
PA10000 PA Timesheet Header File
PA10100 PA Equipment Log Header File
PA10200 PA Miscellaneous Log Header File
PA10500 PA Employee Expense Header File
PA11800 PA Combined History Header file
PA13100 PA Billing Header WORK
PA23100 PA Billing Header OPEN
PA30100 PA Timesheet Header History File
PA30103 PA Timesheet Distribution History
PA30200 PA Equipment Log Header History File
PA30300 PA Miscellaneous Log History File
PA30500 PA Employee Expense Header History File
PA30901 PA Inventory Transfer History Detail
PA33100 PA Billing Header HIST
PA50103 Vendor PM Applied Work
PA50105 RMPMOpen
PDK10500 PDK Employee Expense HDR
PM00100 PM Class Master File
PM00200 PM Vendor Master File
PM10000 PM Transaction WORK File
PM10100 PM Distribution WORK OPEN
PM10200 PM Apply To WORK OPEN File
PM10201 PM Payment Apply To Work File
PM10300 PM Payment WORK
PM10400 PM Manual Payment WORK File
PM10600 PM Distribution Void WORK Temporary File
PM10801 PM Payment Stub Duplicate
PM10900 Void Payment WORK Temporary File
PM10901 PM Void Transaction WORK Temporary File
PM20000 PM Transaction OPEN File
PM20100 PM Apply To OPEN OPEN Temporary File
PM20200 PM Distribution OPEN OPEN Temporary File
PM30200 PM Paid Transaction History File
PM30300 PM Apply To History File
PM30600 PM Distribution History File
POP10100 Purchase Order Work
POP10110 Purchase Order Line
POP10300 Purchasing Receipt Work
POP30300 Purchasing Receipt History
RM00101 RM Customer MSTR
RM10201 RM Cash Receipts Work File
RM10301 RM Sales Work File
RM20101 RM Open File
RM20201 RM Apply Open File
RM30101 RM History File
RM50100 RM History Removal Tempoary File
RM50103 RM Email Statements Header Temporary File
RM50104 RM Email Statements Transactions Temporary File
RVLPD008 Sales Payment Document WORK
RVLPD009 Sales Payment Document OPEN
RVLPD010 Sales Payment Document HISTORY
RVLPD011 Sales Payment Document Remittances Header
RVLPD014 Sales Payment Document Remittance Distributions
SOP10100 Sales Transaction Work
SOP10103 Sales Payments (Work & History)
SOP30200 Sales Transaction History
gpPayWork PM Payment WORK Temp
JC00102 JC_Job_MSTR
JC01301 JC_Production_Batch_Headers
JC10301 JC_Job_TRX_HDR_WORK
JC10501 JC_Invoice_WORK
JC10511 JC_Invoice_Project_WORK
JC20004 JC_Vendor_TRX_OPEN
JC20301 JC_Job_TRX_HDR_OPEN
JC20501 JC_Invoice_OPEN
JC20511 JC_Invoice_Project_OPEN
JC30001 JC_Job_MSTR_HIST
JC30202 JC_Job_TRX_HDR_HIST
JC30501 JC_Invoice_HIST
JC30511 JC_Invoice_Project_HIST
JCRFP100 JC_RFP_Transaction_WORK_File
JCRFP300 JC_RFP_Transaction_HIST_File
SV00144 SV_Inventory_Markdown_MSTR
SV00702 SV_Invoice_MSTR_Report