MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference and Help > Technical Support > Key Concepts and Procedures > Operation Procedures > Appendix B - Host Database Tables

Appendix B - Host Database Tables

 

cannot be used as internal variables on the local platform.

Customer Name and Address File (ARADDRP)

 

CNPRCD

Customer Backorder Priority Code

CNXMPT

Tax Exempt Certificate Number

CNANAL

Sales Analysis Number

CNYTQ5

Booked Orders - Sales Year to Date

CNLYQ5

Booked Orders - Last Sales Year

CNYTQ

Booked Order Lines - Sales Year to Date

CNLYQ

Booked Order Lines - Last Sales Year

CNYTBA

Booked Orders Amount - Sales YTD

CNLYBA

Booked Orders Amount - Last Sales Year

CNYTBC

Booked Orders Cost - Sales Year to Date

CNLYBC

Booked Orders Cost - Last Sales Year

CNYTSO

Shipped Orders - Sales Year-to-Date

CNLYSO

Shipped Orders - Last Sales Year

CNYTSL

Shipped Order Lines - Sales Year-to-Date

CNLYSL

Shipped Order Lines - Last Sales Year

CNLYCS

Cash Sales - Last Sales Year

CNNPSS

Noncash Sales - Next Sales Period

CNLYCO

Cost of Sales - Last Sales Year

CNLYOC

Other Charges - Last Sales Year

CNLSOY

Last Order Year

CNLSOM

Last Order Month

CNLSOD

Last Order Day

CNLSHY

Last Shipment Year

CNLSHM

Last Shipment Month

CNLSHD

Last Shipment Day

CNCROP

Creation Operator

CNCRWK

Creation Workstation

CNCRTM

Creation Time

CNLMOP

Last Maintenance Operator

CNLMWK

Last Maintenance Workstation

CNLMYR

Last Maintenance Year

CNLMMO

Last Maintenance Month

CNLMDY

Last Maintenance Day

CNLMTM

Last Maintenance Time

CNUPDT

File Update Counter

CNRTNM

Returns Contact Name

CNRFXN

Returns Contact FAX Num

CNRTPH

Returns Contact Phone Num

CNREXT

Returns Contact Extension

CNRTCC

Returns Contact Cntry Code

CNRFXC

Returns Contact FAX Cntry Cd

 

Customer Master File (ARCUSTP)

 

CMLCKF

Logical Record Lock Flag

CMCYCD

Cycle

CMPSYR

Previous Statement Year

CMPSMO

Previous Statement Month

CMPSDY

Previous Statement Day

CMCRFT

Credit Memo Forms Type Code

CMDRFT

Debit Memo Forms Type Code

CMCSFT

Cash Sale Forms Type Code

CMPDYR

Prev Dunning Notice Year

CMPDMO

Prev Dunning Notice Month

CMPDDY

Prev Dunning Notice Day

CMCDB

Customer Dunn & Bradstreet Rating

CMPLIM

Previous Credit Limit

CMARBF

Customer AR Balance Original Currency

CMORBF

Customer Open Order Balance - Orig Curr

CMLYRC

Last Year Cash Sales

CMLYRS

Last Year Sales

CMLYRD

Last Year Discounts

CMLYRW

Last Year Write Offs

CMLYRB

Last Year Charge back Amount

CMPTDB

Last Period Charge back Amount

CMLPDC

Last Period Cash Sales

CMLPDB

Last Period Charge back Amount

CMLPDS

Last Period Sales

CMLPDD

Last Period Discounts

CMLPDW

Last Period Write Offs

CMLTAY

Last Transaction Acctg Year

CMLTAM

Last Transaction Acctg Month

CMDLSP

Number Days in Last Statement Period

CMPMST

Payment on Statement Basis

CMSTDB

Statements with Debits Notes

CMSTCR

Statements with Credits Notes

CMBKDM

Bank Domiciliation

CMBKNM

Bank Name

CMBKNO

Bank Number

CMBANO

Bank Account Number

CMDUDF

Due Draft Original Currency

CMCROP

Creation Operator

CMCRWK

Creation Workstation

CMCRTM

Creation Time

CMLMOP

Last Maintenance Operator

CMLMWK

Last Maintenance Workstation

CMLMYR

Last Maintenance Year

CMLMMO

Last Maintenance Month

CMLMDY

Last Maintenance Day

CMLMTM

Last Maintenance Time

CMVER

Version Number - 5 Zoned

CMUPDT

File Update Counter

CMJOBN

Last Maintenance Job Number

CMLDDY

Last Dun Date Day

CMLDMO

Last Dun Date Month

CMLDYR

Last Dun Date Year

CMAUTN

Exoneration/Suspension Auth No.

CMACRF

Pending Invoice Bal - Orig

CMCDBN

Cust Dun & Brdst Number

 

Part Master File (DE100M)

 

IZRACN

Run Activity Control No.

IZNMRA

Next Part in Activity Chain

CMDES2

Part Description 2

PMWPAC

WIP Account Code

MUCSU

Setup Cost

AMSIRL

SIR Location

AMSKLC

Primary Location

AMVENN

Vendor No

AMPAS

Availability Code

MUCSM

Current Material - Total

MUCSL

Current Labor - Total

MUCO

Current Overhead - Total

MUCUM

Simulated Material - Total

MUCUL

Simulated Labor - Total

MUCUO

Simulated Overhead - Total

MLCSM

Current Material -This Level

MLCSL

Current Labor -This Level

MLCO

Current Overhead -This Level

MLCUM

Simulated Material - This Level

MLCUL

Simulated Labor - This Level

MLCUO

Simulated Overhead - This Level

MLMSM

Curr Misc Material - This Level

MLMSL

Curr Misc Labor - This Level

MLMSO

Curr Misc Overhead - This Level

MLMSF

Curr Misc Fixed Cost - This Level

MLMSV

Curr Misc Lead Time Zero - Variable

MLMUM

Sim Misc Material - This Level

MLMUL

Sim Misc Labor - This Level

MLMUO

Sim Misc Overhead - This Level

MLMUF

Sim Misc Fixed Cost - This Level

MLMUV

Sim Misc Lead Time Zero - Variable

PMCACQ

Curr Acq Cost

PMUACQ

Sim. Acq Cost

PMCW

Curr Cost Warning Flag

PMCW2

Sim Cost Warning Fla G

PAORDQ

Prev Per Average Order Qty

PMCE

Current Cost Error Flag

PMCE2

Simulation Cost Error Flag

AMUTMS

Prev Stockkeeping Unit of Measure

AMPACC

Prev. Inv. Accounting Code

AMPOHP

Prev. On Hand Qty.-Physical

AMPOHA

Prev. On Hand Qty.-Acctg.

AMPPL

Prev. Period Labor

AMPPM

Prev. Period Material

AMPPO

Prev. Period Overhead

AMPPMC

Prev. Period Misc

AMPPMF

Prev. Period Misc Fixed

AMPPMV

Prev. Period Misc Variable

AMPFTC

Prev. Standard Unit Cost

MPEGCD

Force Requirement Planning Print Option

OLFLG0

Byte One Current Cost Activity Flag

OLFLG1

Byte Two Current to Std Rollover Flag

OLFLG2

Byte Three Standard Cost Rollup Code

OLFLG4

Byte Five Routing Maint Flag

OLFLG5

Byte Six Product Struct Flag

OLFLG6

Byte Seven Simulation Cost Activity Flag

OLFLG7

Byte Eight Activity Flag

OLFLG8

Sim Cost Rollover Flag

CURPCS

Current Product Cost Sheet Flag

STDPCS

Standard Product Cost Sheet Flag

SIMPCS

Simulated Product Cost Sheet Flag

PMPTR2

Part Reference 2

PMTAXC

Tax-Commodity

PMPOMC

Purchase Order Message Code

PMPOMP

PO Message Print Code

PMGRTC

Group Technology Number

PMCOCD

Container Code

PMCOQY

Container Quantity

PMCON

Number of CON Cards

PMBON

Number of BON Cards

PMUPDT

P/M Update Counter

PMLRCP

Workcenter LRs in Cp

PMVLTF

Volume Time Fence

PMMXTF

Mix Time Fence

PMTGIN

Weeks of Target Inventory

PMMSFL

MS Bypass Generation Flag

PMGNFL

PO Automatic Generation Flag

PMISRQ

Inspection Required Code

PMPOD1

Purchasing Description 1

PMPOD2

Purchasing Description 2

PMRLFL

Item-Vendor Relationship Fl

PMRVGN

Auto Revision Level Gen Flag

PMCELL

Producing Cell

PMAUTQ

Authorized Production Qty

PMOUTQ

Days Stock in Outbound Queue

PMCBCC

CONBON Control Code

PMPLOC

Primary Producing Location

PMRLOC

Component Relief Location

PMFMDT

Firm Horizon Date

PMVOMF

Mfg Config Flag

PMMOGR

Conf Mfg Group

PMMSGR

Conf Mfg Subgrp

PMVRMF

Mfg Ver Num

PMSTBC

Std Routing Part

PMSTBH

Std BOM Part

PMFAMH

Ref Routing Part

PMRPSF

R/P Selection Flag

PMIASO

IA Scrap Proc Opt

PMIAVO

IA Var Proc Opt

PMSCFL

Serial Control Flag

PMSPUM

Supplementary UOM

PMSPMN

Supp UM/SKU Conv Fact - Num

PMSPMD

Supp UM/SKU Conv Fact - Den

PMCNOT

Country of Origin

PMWPAS

Saved WIP Acctg Code

PMWPAP

Prev Per WIP Acctg Code

 

Warehouse Balance File (IC140M)

 

WBCVC

Current Value Class

WBPVC

Previous ABC Class

WBDNCC

Date of Next Cycle Count

WBCCPS

Cycle Count Part Selection Flag

WBYTCC

Year-To-Date Cycle Counts

WBTAQ

Absolute Adjustment Quantity

WBAADY

Absolute Adjustment Dollar Value - YTD

WBHSFL

Shortage Horizon Flag

WBLBUC

LIFO Base Unit Cost

WBLFPL

LIFO Pool

WBCPSQ

Shipped Order Qty - Current Sales Period

WBNPSQ

Shipped Order Qty - Next Sales Period

WBYTSQ

Shipped Order Qty - Sales Year-To-Date

WBLYSQ

Shipped Order Qty - Last Sales Year

WBCPOC

Cost of Sales - Current Sales Period

WBCPNP

Cost of Sales - Next Sales Period

WBYDOC

Cost of Sales - Sales Year-To-Date

WBLYOC

Cost of Sales - Last Sales Year

WBCPOA

Shipped Sales Amt - Current Sales Period

WBNPOA

Shipped Sales Amt - Next Sales Period

WBYDOA

Shipped Sales Amt - Sales Year-To-Date

WBLYOA

Shipped Sales Amt - Last Sales Year

WBCPOL

Shipped Order Lines - Curr Sales Per

WBNPOL

Shipped Order Lines - Next Sales Period

WBYDOL

Shipped Order Lines - Sales Year-To-Date

WBLYOL

Shipped Order Lines - Last Sales Year

WBCPBO

Shipped Back Order Qty - Curr Sales Per

WBNPBO

Shipped Back Order Qty - Next Sls Per

WBYDBO

Shipped Back Order Qty - Sales YTD

WBLYBO

Shipped Back Order Qty - Last Sales Year

WBYTDU

YTD Activity

WBDTLI

Date of Last Issue

WBDTLT

Date of Last Transaction

WBLRDT

Date of Last Receipt

WBRCDT

Replacement Cost Date

WBDLS

Date of Last Shipment

WBPOHA

Prev Period End On Hand Qty - Accounting

WBPOHP

Prev Period End On Hand Qty - Posting

WBPVAL

Part Value - Posting

WBPVAA

Prev Period Part Value - Accounting

WBPVAP

Prev Period Part Value - Posting

WBPYOH

Previous Year OH Qty

WBPSUC

Prev Period End Standard Unit Cost

WBASUC

Accounting Standard Unit Cost

WBCCI

Cycle Count Interval

WBMSFL

Manual Selection Flag

WBTPCT

Tolerance Percentage

WBTVAL

Tolerance Value

WBDLCC

Date of Last Cycle Count

WBDA01

Activity Amount - 1

WBDA02

Activity Amount - 2

WBDA03

Activity Amount - 3

WBDA04

Activity Amount - 4

WBDA05

Activity Amount - 5

WBDA06

Activity Amount - 6

WBDA07

Activity Amount - 7

WBDA08

Activity Amount - 8

WBDA09

Activity Amount - 9

WBDA10

Activity Amount- 10

WBDA11

Activity Amount- 11

WBDA12

Activity Amount- 12

WBYTDD

YTD Activity Amount

WBYTDA

Year-To-Date Adjustments

WBCCFL

Cycle Count Adjustment Flag

WBUPDT

Intervening Update Counter

WBCRDT

Creation Date

WBCROP

Creation Operator

WBLMDT

Last Maintenance Date

WBLMOP

Last Maintenance Operator

WBRLFL

Item/Vendor Relation. Flag

WBFASQ

W/B Flow Auth Supply Qty

WBFRAQ

W/B Flow Rqmt Allocated Qty

WBLCTL

Location Control

WBPFLC

Preferred Location

WBAACQ

Accounting Acq Cost

WBPACQ

Previous Acq Cost

WBSACQ

Standard Acq Cost

WBTRPR

Transfer Price

WBRMSF

Allow Remote Source Flag

WBSIAQ

Synchro In-Process Alloc Qty

 

Warehouse Description File (IC170M)

 

WDCC01

Cycle Count Interval - A

WDCC02

Cycle Count Interval - B

WDCC03

Cycle Count Interval - C

WDCC04

Cycle Count Interval - D

WDCC05

Cycle Count Interval - E

WDTP01

Tolerance Percent - A

WDTP02

Tolerance Percent - B

WDTP03

Tolerance Percent - C

WDTP04

Tolerance Percent - D

WDTP05

Tolerance Percent - E

WDTD01

Tolerance Amount - A

WDTD02

Tolerance Amount - B

WDTD03

Tolerance Amount - C

WDTD04

Tolerance Amount - D

WDTD05

Tolerance Amount - E

WDTLDA

Total Leadtime Days - A

WDTLDB

Total Leadtime Days - B

WDTLDC

Total Leadtime Days - C

WDTLDD

Total Leadtime Days - D

WDTLDE

Total Leadtime Days - E

WDCUCA

Current Unit Cost - A

WDCUCB

Current Unit Cost - B

WDCUCC

Current Unit Cost - C

WDCUCD

Current Unit Cost - D

WDCUCE

Current Unit Cost - E

WDADUA

Activity Amount - A

WDADUB

Activity Amount - B

WDADUC

Activity Amount - C

WDADUD

Activity Amount - D

WDADUE

Activity Amount - E

WDCPUA

Cumulative Percent Usage Value - A

WDCPUB

Cumulative Percent Usage Value - B

WDCPUC

Cumulative Percent Usage Value - C

WDCPUD

Cumulative Percent Usage Value - D

WDCPUE

Cumulative Percent Usage Value - E

WDOHDA

On-Hand Value - A

WDOHDB

On-Hand Value - B

WDOHDC

On-Hand Value - C

WDOHDD

On-Hand Value - D

WDOHDE

On-Hand Value - E

WDPDVA

Cum Percent On-Hand Value -A

WDPDVB

Cum Percent On-Hand Value -B

WDPDVC

Cum Percent On-Hand Value -C

WDPDVD

Cum Percent On-Hand Value -D

WDPDVE

Cum Percent On-Hand Value -E

WDSCSQ

Schedule Sequence

WDPCCD

Previous Cycle Count Date

WDYSC

Scheduled Counts - YTD

WDACY

Actual Counts-YTD

WDDCY

Selected Counts - YTD

WDMSLC

Maximum Scheduled Location Counts

WDUPDT

Warehouse Description Update Counter

WDOUTQ

Warehouse Output Queue

WDSPDO

Shop Paperwork Default Opt

WDRLGD

Last Shortage Generation

WDWDST

Workday Start Time

WDSHPD

Standard Hours Per Day

WDNOSF

Number of Shifts

WDFTTO

From-To Time Opt

WDAUTO

Auto Move/Rec Flag

WDOPOP

Oper to Oper Recon File

WDBOAL

Reserve to Backorders First Option

WDIRF

Future Inventory Reservation Flag

WDSLF

Stock Location Reservation Option

WDIRW

Inventory Reservation Window

WDAVPL

Available for Planning Flag

WDRLDF

Relief Code Default

WDSOPL

S.O. Planning Default

 

Sales Order Header File (OP100M1)

 

SHPKSQ

Picker Sequence Number

SHRVCD

A/R Entity Code

SHARCD

Accounts Receivable Code

SHTOAF

Total Order Amt - Bkkpng Curr

SHSLAM

Sales Amount - Bookkeeping Currency

SHOCHG

Other Charges - Bookkeeping Currency

SHSBTX

Amt Subject to Tax - Bookkeeping Curr

SHTXAF

Tax Amount - Bookkeeping Currency

SHVATF

VAT Amount - Gross - Bookkeeping Curr

SHVTNF

VAT Amount - Net - Bookkeeping Currency

SHSBDF

Amt Sbj to Cash Disc  - Bookkeeping Curr

SHDAVF

Cash Disc Amount Bookkeeping Curr

SHCOGS

Cost of Sales Amt - Bookkeeping Curr

SHOAMF

Document Amount - Gross - Bkkpng Curr

SHOANF

Document Amount - Net - Bkkpg Curr

SHOAMO

Document Amount - Gross - Org Curr

SHOANO

Document Amount - Net - Org Curr

SHOOLN

Number of Open Order Lines

SHNOLN

Number of Order Lines

SHFPRC

Firm Price Flag

SHDNO

Last Document Number

SHSAN

Sales Analysis Number

SHALBO

Allow Backorder Flag

SHBOPR

Backorder Priority

SHEXNO

Tax-Exempt Certificate No

SHFRDT

First Blanket Release Date

SHSOPF

Sales Order Print Flag

SHSOPT

Num of Sales Orders Printed

SHPKPT

Number of Pickers Printed

SHINRS

Inventory Reserved Flag

SHCR05

Credit Exception - Reserved/Future

SHCR06

Credit Exception - Reserved/Future

SHCR07

Credit Exception - Reserved/Future

SHCR08

Credit Exception - Reserved/Future

SHCR09

Credit Exception - Reserved/Future

SHCR10

Credit Exception - Reserved/Future

SHUPDT

Update Counter

SHRUSE

Record In-Use Flag

SHSLSO

Sales Office

SHQONO

Quote/Sales Reference Number

SHRSNC

Quote Order Reason Code

SHCROP

Creation Operator

SHCRWK

Creation Workstation

SHCRTM

Creation Time

SHLMOP

Last Maintenance Operator

SHLMWK

Last Maintenance Workstation

SHLMDT

Last Maintenance Date

SHLMTM

Last Maintenance Time

SHVER

Sales Order Header Version Number

SHJOBN

Last Maintenance Job Number

SHORLN

No of Open Reserved Lines

SHAUTN

VAT Authorization Number

SHGSBB

GST Subject to Tax - Book

SHSNID

Dir Dst Cust Network ID

SHSLNG

Dir Dst Cust Lang Code

SHRMA

RMA Number

 

Sales Order Line File (OP100M2)

 

SLUMFN

SU/SKU Factor - Numerator

SLUMFD

SU/SKU Factor - Denominator

SLPRFN

PR/SKU Factor - Numerator

SLPRFD

PR/SKU Factor - Denominator

SLPUFN

PU/SKU Factor - Numerator

SLPUFD

PU/SKU Factor - Denominator

SLOFCQ

Original Forecast Quantity

SLUNCS

Unit Cost - Bookkeeping Currency

SLBSPO

Base Price - Original Currency

SLEXPO

Extended Price - Original Currency

SLUNCO

Unit Cost - Original Currency

SLFPRC

Firm Price Flag

SLKITP

Kit Part Number

SLICPC

Item Commission Percent

SLPLFG

Planning Flag

SLPLUN

Planned/Unplanned Flag

SLSTLC

Default Stock Location

SLDTC

Document Type

SLDNO

Document Number

SLDCLN

Document Line Number

SLPKPT

Number of Pickers Printed

SLPKSQ

Picker Sequence Number

SLPREX

Price Override Flag

SLRVLN

Revised Line Flag

SLPR07

Price Exception-Reservd/Futr

SLPR08

Price Exception-Reservd/Futr

SLPR09

Price Exception-Reservd/Futr

SLPR10

Price Exception-Reservd/Futr

SLAV04

Avail Exception-Reservd/Futr

SLAV05

Avail Exception-Reservd/Futr

SLAV06

Avail Exception-Reservd/Futr

SLAV07

Avail Exception-Reservd/Futr

SLAV08

Avail Exception-Reservd/Futr

SLAV09

Avail Exception-Reservd/Futr

SLAV10

Avail Exception-Reservd/Futr

SLSLSO

Sales Office

SLRSNC

Quote Order Reason Code

SLCROP

Creation Operator

SLCRWK

Creation Workstation

SLLMOP

Last Maintenance Operator

SLLMWK

Last Maintenance Workstation

SLVER

Sales Order Line Version No

SLBDPT

Bundle Component Part

SLBREL

Bundle Item Relation

SLVNDR

Vendor Code/Outsourced SO

SLOPON

PO Num Gen for Outsrc SO

SLOPOL

PO Line Num for Outsrc SO

SLRQNM

Requisition Number

SLRLNM

Requisition Line Number

SLRMA

RMA Number

SLCECO

Cfg Ext Cost - Original Cur.

 

Price List Header File (OP230M1)

 

PBCROP

Creation Operator

PBCRWK

Creation Workstation

PBCRDT

Creation Date

PBCRTM

Creation Time

PBLMOP

Last Maintenance Operator

PBLMDT

Last Maintenance Date

PBLMTM

Last Maintenance Time

PBLMWK

Last Maintenance Workstation

 

Price List Line File (OP230M2)

 

PJBSPR

Base Price

PJPUM

Price Unit of Measure

PJCMFL

Comments Flag

PJCROP

Creation Operator

PJCRWK

Creation Workstation

PJCRTM

Creation Time

PJCRDT

Creation Date

PJLMOP

Last Maintenance Operator

PJLMWK

Last Maintenance Workstation

PJLMDT

Last Maintenance Date

PJLMTM

Last Maintenance Time