Table: Adjustment Audit List Details

Table: ICADJD
View: IC0130
Record length: 633
Flags: A R 

Keys: 1

Title  Flags  Fields

Day End Number   DAYENDSEQ, TRANSSEQ, LINENO

Fields: 26

Field  Type  Title  Presentation 

DAYENDSEQ  Long  Day End Number   
TRANSSEQ  Long  Transaction Number   
LINENO  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRANSTYPE  Integer  Transaction Type  List: 6 entries
1=Quantity Increase
2=Quantity Decrease
3=Cost Increase
4=Cost Decrease
5=Both Increase
6=Both Decrease
FMTITEMNO  String*24  Item Number  Mask: %-24C
ITEMDESC  String*60  Item Description   
CATEGORY  String*6  Category  Mask: %-6N
LOCATION  String*6  Location  Mask: %-6N
QTY  BCD*10.4  Quantity   
UNIT  String*10  Unit of Measure  Mask: %-10w
COST  BCD*10.3  Extended Cost   
COMMENTS  String*250  Comments   
ADJACCT  String*45  Adjustment/Write-Off Account  Mask: %-45C
ICACCT  String*45  Inventory Control Account  Mask: %-45C
RECPNUM  String*22  Document Number   
BUCKETTYPE  Integer  Bucket Type  List: 3 entries
1=Offset Bucket
2=Specific Bucket
3=Prorate
PMCONTRACT  String*16  P/M Contract   
PMPROJECT  String*16  P/M Project   
PMCATEGORY  String*16  P/M Category   
PMOHACCT  String*45  P/M Overhead Account  Mask: %-45C
PMOHAMT  BCD*10.3  P/M Overhead Amount   
VALUES  Long  Optional Fields   

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.