Table: Posting Journal Generated AP Entries

Table: APPJAIH
View: AP0516
Record Length: 701

Flags: A R 

Keys: 1

Title Flags Fields

Posted Entry/Generated AP Entry TYPEBTCHPOSTSEQNCECNTBTCHCNTITEM

Fields: 77

Field Type Title Presentation

TYPEBTCH String*2 Batch Type Mask: %-2N
POSTSEQNCE BCD*5.0 Posting Sequence No.
CNTBTCH BCD*5.0 Batch No.
CNTITEM BCD*4.0 Entry No.
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
COMPID String*6 Generated Company Mask: %-6N
GCNTBTCH BCD*5.0 Generated Batch No.
GCNTITEM BCD*4.0 Generated Entry No.
TEXTTRX Integer Document Type List:4 entries
1 = Invoice
2 = Debit Note
3 = Credit Note
4 = Interest
IDTRX Integer Transaction Type List:5 entries
12 = Invoice - Summary Entered
13 = Invoice - Recurring Charge
22 = Debit Note - Summary Entered
32 = Credit Note - Summary Entered
40 = Interest Charge
INVCDESC String*60 Invoice Description
IDVEND String*12 Vendor Number Mask: %-12C
CODEVNDGRP String*6 Vendor Group Code Mask: %-6N
IDACCTSET String*6 Account Set Mask: %-6N
IDRMITTO String*6 Remit-To Location Mask: %-6N
IDINVC String*22 Document Number Mask: %-22C
INVCAPPLTO String*22 Apply-to Document Mask: %-22C
ORDRNBR String*22 Order Number Mask: %-22C
PONBR String*22 PO Number Mask: %-22C
SWJOB Integer Job Related List:2 entries
0 = No
1 = Yes
DATEINVC Date Invoice Date
FISCYR String*4 Fiscal Year Mask: %04D
FISCPER String*2 Fiscal Period Mask: %02D
HCODECURN String*3 Currency Code (Functional) Mask: %-3N
CODECURN String*3 Currency Code (Source) Mask: %-3N
RATETYPE String*2 Rate Type Mask: %-2N
CODEOPER Integer Rate Operator List:2 entries
1 = Multiply
2 = Divide
EXCHRATEHC BCD*8.7 Exchange Rate
DATERATE Date Rate Date
TERMCODE String*6 Terms Mask: %-6N
DATEDUE Date Due Date
DATEDISC Date Discount Date
PCTDISC BCD*5.5 Discount Percentage
AMTDSCBASE BCD*10.3 Discount Base
AMTDISCAVL BCD*10.3 Discount Amount Available
AMTDSBWTAX BCD*10.3 Discount Base With Tax
AMTDSBNTAX BCD*10.3 Discount Base Without Tax
CODETAXGRP String*12 Tax Group Mask: %-12N
SWTAXBL Integer Taxable List:2 entries
0 = No
1 = Yes
SWCALCTX Integer Tax Amount Control List:3 entries
0 = Enter
1 = Calculate
2 = Distribute
AMTINVCTOT BCD*10.3 Document Total Before Taxes
AMTGROSTOT BCD*10.3 Document Total Including Tax
AMTTAXTOT BCD*10.3 Total Tax Amount
AMTRECTAX BCD*10.3 Recoverable Taxes
AMTEXPTAX BCD*10.3 Expensed Separately Taxes
AMTAXTOBE BCD*10.3 Tax Amount to be Allocated
ID1099CLAS String*6 1099/CPRS Code Mask: %-6N
AMT1099 BCD*10.3 1099/CPRS Amount
IDDISTSET String*6 Distribution Set Mask: %-6N
AMTDISTSET BCD*10.3 Distribution Set Amount
VALUES Long Optional Fields
DATEBUS Date Posting Date
CODETAX1 String*12 Tax Authority 1
CODETAX2 String*12 Tax Authority 2
CODETAX3 String*12 Tax Authority 3
CODETAX4 String*12 Tax Authority 4
CODETAX5 String*12 Tax Authority 5
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
SWTAXINCL1 Integer Tax Inclusive 1 List:2 entries
0 = No
1 = Yes
SWTAXINCL2 Integer Tax Inclusive 2 List:2 entries
0 = No
1 = Yes
SWTAXINCL3 Integer Tax Inclusive 3 List:2 entries
0 = No
1 = Yes
SWTAXINCL4 Integer Tax Inclusive 4 List:2 entries
0 = No
1 = Yes
SWTAXINCL5 Integer Tax Inclusive 5 List:2 entries
0 = No
1 = Yes
AMTTAX1 BCD*10.3 Tax Amount 1
AMTTAX2 BCD*10.3 Tax Amount 2
AMTTAX3 BCD*10.3 Tax Amount 3
AMTTAX4 BCD*10.3 Tax Amount 4
AMTTAX5 BCD*10.3 Tax Amount 5
VENDNAME String*60 Vendor Name
RMITNAME String*60 Remit-To Name