Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SBT - Pro Series 5 question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
00112643
Message ID:
00112950
Vues:
29
Uh-oh... We don't have APTRAN and APYTRN tables. Why do I get the feeling this is NOT good?

>Hello Gerry,
>
>This is Don, formerly from Info Resource Assoc.
>The table structures for SBT are
>APMAST - Current A/P invoice header information
> APTRAN - Detail posting information per account per invoice in APMAST
>
>APYMST - History (period closing) information invoice headers
> APYTRN - Detail posting information
>
>These tables have parallel structures... Once you look at the tables, you should see the direct relations for invoice, vendors. Also, there are two field in the APTRAN and APYTRN tables: GLFPER and GLFYEAR for the fiscal period and fiscal year. These can be tied back to the GL table for actual dates that the given fiscal period/year relate to. Don't remember this one off hand.
>
>Don
** Gerry White / Hagerstown, MD, USA --
** Developing since 1986 in Foxpro, VFP, Oracle, and Java.
** http://GerrysPlace.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform