MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Technical Library > Distribution > Order Processing > Programs > Consolidated Billing Update - Purpose > Consolidated Billing Update - Files

Consolidated Billing Update - Files

OP640E


Number


Description

Record Format

Built
Over

File
Access

ARCMTSL1

Open Item Comments by Sales Order Number

AR008

ARCMTSP

Update

ARCUSTL1

Customer File

AR001
AR002

ARCUSTP
ARADDRP

Update

ARDSCP

Open Item Discount Detail File

AR046

 

Output

ARLOGP

Activity Log

AR012

 

Output

ARLOTL1

Invoice Lot Master Logical File

AR023

ARLOTP

Update

AROPENL7

Open Item File with Open Item Comments

AR003
AR004
AR008

AROPENP
ARDISTP
ARCMTSP

Output

ARPNDDP

Pending Invoice Detail File

AR040

 

Update

ARPNDOP

Pending Invoice Header File

AR039

 

Update

ARPNDSP

Pending Open Item Discount Detail File

AR047

 

Update

AR510AP

Accounting Transactions File

AR009

 

Output

CF170AP

Financial Installments Generation Workfile

T1900

 

Input

DE100M

Part Master File

M0001

 

Input

DMDRFP

Draft Master File

M1286

 

Output

GLFILEL5

Account/Center Descriptive Master File by Account

GL013

GLFILEP1

Input

IC140M

Warehouse Balance

M0530

 

Update

IC170M

Warehouse Description File

M0550

 

Input

IC180BP1

Customer Order Header Audit Trail

R0525

 

Output

IC180CP1

Customer Order Header Transaction Record

R0528

 

Output

IC505AP

Maintenance Error File

R0524

 

Output

OP100M1

Sales Order Header File

M1501

 

Update

OP100M2

Sales Order Line File

M1502

 

Update

OP120AP1

Shipping/Billing Header Workfile

T1507

 

Update

OP120AP2

Shipping/Billing Line Workfile

T1508

 

Input

OP120ML8

Sales Order History by Sales Order

M1504

OP120M

Update

OP120ML9

Sales History Discount Detail Logical File

M1538

OP120M2

Update

OP290AP1

Invoice Request Header File

T1542

 

Update

OP290AP2

Invoice Request Detail File

T1543

 

Update

OP510M1

Order Shipment Master File

M1534

 

Update

OP535AP

Open Item Print Request File

T1506

 

Output

TC120BP1

Transfer Order Shipping/Receiving Audit Trail File

R1004

 

Update

REFERL1

Reference File Logical

CF002

REFERPS

Update

REFERP

Reference File

CF002M
CF002

REFERPM
REFERPS

Input

CT120M

MAC-PAC Error Message File

M1120

 

Input

 

OP640E Program Menu