Table: Open Document Sched. Payments

Table: AROBS
View: AR0037
Record length: 255
Flags: A R

Keys: 12

Title	Flags	Fields

Customer/Doc. No.		IDCUST, IDINVC, CNTPAYM
Doc. No.	D M	IDINVC, CNTPAYM
Sales Order No.	D M	IDCUST, IDORDRNBR, IDINVC, CNTPAYM
Purchase Order No.	D M	IDCUST, IDCUSTPO, IDINVC, CNTPAYM
Due Date	D M	IDCUST, DATEDUE, IDINVC, CNTPAYM
Nat. Acct./Customer/Doc. No.	D M	IDNATACCT, IDCUST, IDINVC, CNTPAYM
Remaining Cust. Receipt Amount	D M	IDCUST, AMTPYMRMTC, DATEDUE, IDINVC, CNTPAYM
Paid/Doc. No.	D M	SWPAID, IDINVC, CNTPAYM
Document Date	D M	IDCUST, DATEINVC, IDINVC, CNTPAYM
Paid/Prepay. No.	D M	SWPAID, IDPREPAID
Paid/Customer/Doc. No.	D M	SWPAID, IDCUST, IDINVC, CNTPAYM
Paid/Nat. Acct./Doc. No.	D M	SWPAID, IDNATACCT, IDINVC, CNTPAYM

Fields: 28

Field

Type

Title

Presentation

IDCUST

String*12

Customer Number

Mask: %-12C

IDINVC

String*15

Document Number

Mask: %-15C

CNTPAYM

BCD*3.0

Payment Number

AUDTDATE

Date

AUDTTIME

Time

AUDTUSER

String*8

AUDTORG

String*6

IDRMIT

String*24

Receipt Number

Mask: %-24C

DATEDUE

Date

Due Date

DATEDISC

Date

Discount Date

SWPAID

Integer

Fully Paid Switch

List: 2 entries

0	=	No
1	=	Yes

DLNQSTTS

Integer

Reserved

AMTDUEHC

BCD*10.3

Original Amount (Func.)

AMTDISCHC

BCD*10.3

Original Discount (Func.)

AMTDCSRMHC

BCD*10.3

Remaining Discount (Func.)

AMTPYMRMHC

BCD*10.3

Remaining Amount (Func.)

AMTDUETC

BCD*10.3

Original Amount

AMTDISCTC

BCD*10.3

Original Discount

AMTDSCRMTC

BCD*10.3

Remaining Discount

AMTPYMRMTC

BCD*10.3

Remaining Amount

IDORDRNBR

String*22

Sales Order Number

IDCUSTPO

String*22

PO Number

IDNATACCT

String*12

National Account Number

Mask: %-12C

IDGRP

String*3

Group Code

Mask: %-3N

IDPREPAID

String*15

Prepayment Number

Mask: %-15C

IDTRXTYPE

Integer

Transaction Type

List: 16 entries

1	=	Unapplied Cash - Posted
11	=	Invoice - Item Issued
12	=	Invoice - Summary Entered
13	=	Invoice - Recurring Charge
14	=	Invoice - Summary Issued
15	=	Invoice - Item Entered
21	=	Debit Note - Item Issued
22	=	Debit Note - Summary Entered
24	=	Debit Note - Summary Issued
25	=	Debit Note - Item Entered
31	=	Credit Note - Item Issued
32	=	Credit Note - Summary Entered
34	=	Credit Note - Summary Issued
35	=	Credit Note - Item Entered
40	=	Interest Charge
50	=	Prepayment - Posted

TXTTRXTYPE

Integer

Document Type

List: 6 entries

1	=	Invoice
2	=	Debit Note
3	=	Credit Note
4	=	Interest
5	=	Unapplied Cash
10	=	Prepayment

DATEINVC

Date

Document Date

This page was generated on 2002-Oct-04